No guarantee that everything is updated 


Tables

ColumnsData DetailsExternal DependenciesNotes
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.htmlCan this be automated?

epi_week

date | epi_year | epi_week


python lib 

daylight_hours

state | region_name | id | epi_week | daylight_hours


apiDo 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


apihttp://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

both in raw dataclimate div in raw datacounty in raw dataUse late long and check in regionsGeocode lookup











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