You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 37 Current »

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




  • No labels