Setup database for predictions

[tomschenkjr]

Need to setup a tablespace/database to place predictions. The analytics/model code will populate the database, which will be read by applications to display the predictions.

Right now, thinking about placing this with Hoa in ZDT schema. @geneorama - please reach out to Hoa when she returns tomorrow.

[tomschenkjr]

Table 1

• Trap ID
• Date
• Number of mosquitos
• Number of mosquitos positive for WNV

Table 2

• Trap ID
• Date
• Numeric prediction
• Binary prediction

[tomschenkjr]

Hoa is returning this week.

• [x] @geneorama will provide the file to Hoa to put into the database.

[geneorama]

Database is set up, example predictions for @hectorsalvador's first version are available.

The prediction format is not final.

This issue depends on #3

[geneorama]

The database has been set up, now I need to test writing to a table / set up a function to write:

• Predictions
• Data used to create predictions
• Table of IDs for traps

The data tables are important because they are correctly consolidated by trap / week identities.

[geneorama]

The database is set up and working. We might need to open another issue later about what the right data format will be, but I have a working format.

[tomschenkjr]

@geneorama - #3 is closed(?)

[geneorama]

@tomschenkjr Yes, I think we closed it during an Analytics meeting.

[tomschenkjr]

Is this completed?

[geneorama]

Not quite.

On Fri, May 26, 2017 at 4:01 PM Tom Schenk Jr notifications@github.com wrote:

Is this completed?

— You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub https://github.com/Chicago/WNV_model/issues/9#issuecomment-304387348, or mute the thread https://github.com/notifications/unsubscribe-auth/ABU9xEFw328wttVE-Hq7r8I0LkzDcjDEks5r9z2xgaJpZM4JfZAX .

[geneorama]

The predictions are uploaded.

I was thinking about it over the weekend, and I realized that I was making a mistake in the logic of my forecast calculation. I believe I've fixed that, and the predictions are now uploaded to the database. The predictions are stored in the same table that has the trap map data.