No guarantee that everything is updated
Tables | Columns | Data Details | External Dependencies | Notes | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| climate_divs | state | region_name | id | polygon |
| Can this be automated? | ||||||||||||||||
counties | state | county | climate_div | polygon | https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html | Can this be automated? | ||||||||||||||||
epi_week | date | epi_year | epi_week | python lib | |||||||||||||||||
daylight_hours | state | region_name | id | epi_week | daylight_hours | api | Do daylight hours need to be calculated by county or is climate division adequete? | ||||||||||||||||
forecast | state | climate_div | download_date | forecast_date | min_temp_f | max_temp_f | precip_in | api | |||||||||||||||||
weather | state | climate_div | county | measurement_date | min_temp_f | max_temp_f | precip_in | api | http://data.rcc-acis.org/GridData returns entry for 'today' and future days, but the dictionary is empty (data for a day is a list with date 1st and dictionary of locations 2nd. | ||||||||||||||||
| traps | state | climate_div | county | date | gender | city | epi_week | jurisdiction | location_id | owner | pool_size | result_type | sample_id | species | test_type | trap_type | geometry_method | geometry | Scenarios for assigning climate div and county to trap
| multiple agencies | ||||||||||||||||
| spatial_ref_sys |
Help with understanding input dependencies
Creating a trap summary table in application
Loading trap summary into database
Run Model
Load Map