Add lat/long to `locations`

helium / blockchain-etl

Blockchain follower that follows and stores the Helium blockchain

Apache License 2.0

64 stars 37 forks source link

Add lat/long to `locations` #106

Closed jamiew closed 3 years ago

jamiew commented 3 years ago

We store city, state, etc. as geocoded from Google Maps, but not a raw long/lat. blockchain-http adds these to API results dynamically, but it would be very useful for data analysts to have a lat/long attached to each h3 location.

This would allow for utilizing postgis geo-spatial queries, like "hotspots within given area" or "nearby hotspots." It would also enable building visualizations directly in data analysis tools like Metabase, which is used for https://etl.dewi.org

madninja commented 3 years ago

Would this be fixed by: https://github.com/helium/blockchain-etl/pull/137 and using the appropriate parameters, or is that not quite enough?

jamiew commented 3 years ago

Yep this is done and done