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 |
epi_week
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 |
spatial_ref_sys
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
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 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|