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
• [x] Miami-Dade WaterP layer
• [x] Miami-Dade Street layer
• [x] Subset of street layer with only highways and main roads (consider a dissolve on name and type?)
• [x] Protected areas (perhaps all of Florida, NPS, or the Florida Natural Areas Inventory)
• [ ] all the 5 categories of the slosh models (add vector capability)
• [x] Miami Dade building footprints
• [x] Miami-Dade Stormwater Line
• [x] Miami-Dade DOH septic system (look at DOH website as well)
• [x] Miami-Dade Storm Surge Planning Zones
• [ ] humidity
• [ ] Pump Stations
• [x] 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
• [x] 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