Automatically add boundary/jurisdiction metadata to feed

dathere / covid19-time-series-utilities

several utilities to help wrangle COVID-19 data into a time-series format

Creative Commons Attribution Share Alike 4.0 International

34 stars 8 forks source link

Automatically add boundary/jurisdiction metadata to feed #14

Closed jqnatividad closed 4 years ago

jqnatividad commented 4 years ago

We also need to enrich the feed by adding additional metadata:

[x] US boundary info (e.g. state, county, etc.), perhaps by leveraging this USGS National Boundaries standard at data.gov
[x] UN political boundary info by using these UN Map Resources
[x] Hyperlocal boundary info, starting with NYC, using GeoClient and datHere NYC boundary info (e.g. Community Board, Health Center District, nearest hospital, etc.)

jqnatividad commented 4 years ago

Since we only have lat/long in the JHU data, did reverse-geocoding with https://Geocode.earth to extract continent, and for the US - locality, county, and state.

Just in case, stored the geocode.earth JSON response in a JSONB column so folks can see more metadata, and extract other features from the JSON if required.