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 |
spatial_ref_sys
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
draw.io Diagram | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Creating a trap summary table in application
draw.io Diagram | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Loading trap summary into database
draw.io Diagram | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Run Model
draw.io Diagram | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Load Map
draw.io Diagram | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|