Datasets TODO

[tibbben]

• public housing layer for GDSC ... http://flhousingdata.shimberg.ufl.edu then blended with RER of miami dade county https://www.miamidade.gov/global/economy/home.page
• Miami-Dade WaterP layer
• Miami-Dade Street layer
• Subset of street layer with only highways and main roads (consider a dissolve on name and type?)
• Protected areas (perhaps all of Florida, NPS, or the Florida Natural Areas Inventory)
• all the 5 categories of the slosh models (add vector capability)
• Miami Dade building footprints
• Miami-Dade Stormwater Line
• Miami-Dade DOH septic system (look at DOH website as well)
• Miami-Dade Storm Surge Planning Zones
• humidity
• Pump Stations
• UV or solar irradiance layer?? Landsat API https://www.usgs.gov/landsat-missions/landsat-data-access
• IQ air API https://www.iqair.com/us/commercial-air-quality-monitors/api
• howloud.com API https://api.howloud.com/docs/
• water quality from MDC?
• Electric Lines
• Sewer Mains
• manhole covers
• hurricane tracks
• rainfall
• can we calculate albedo from something?
• building violations - EPA ECHO - https://echo.epa.gov
• look at HIFLD: https://hifld-geoplatform.hub.arcgis.com/pages/hifld-open

[tibbben]

make temporary parcels_camp layer with three dependencies

• protected areas
• streets
• water

join parameters as:
within; -- type of join (stay the same)
mdc_county_zoning; -- join layer
zone; -- source column in join layer
mdc_county_zone; -- destination column in base layer
varchar; -- column type
zone_desc; -- source column in join layer
mdc_county_zone_desc; -- destination column in base layer
varchar -- column type

[tibbben]

QC after load is complete:

• check landing page for data
• check analytic functions working (change url as below)
  https://gdsc.idsc.miami.edu/functions/ ---> http://localhost:3000/
• check etl documentation

[tibbben]

See notes for Azizi and Sade ....

https://healthcare.rti.org/insights/choosing-sdoh-indices
HowLoud.com
IQ Air Map
ECHO dataset
rainfall, humidity, uv (??)

[tibbben]

Update Structure and geometry in ACS layer to (respectively):
vector, polygon