infinite-industries / infinite

MIT License
5 stars 3 forks source link

Systematically fix bad location data #350

Closed rlmead closed 1 year ago

rlmead commented 1 year ago

Github gist Observable project

jswank commented 1 year ago

Create two SQL files:

  1. Update: lat / lon
  2. Add new fields: street, city, state, zip, neighborhood
jswank commented 1 year ago

Lon / Lat update sql: https://gist.github.com/jswank/559c86ee490f03c8f85840e1c8ed2477

jswank commented 1 year ago

Geo update SQL with updated address field : https://gist.githubusercontent.com/jswank/e3986c5ebe08812f9dfe2ee952251c90/raw/f8e0c7369602eeab8549ccb77b7779659e926af0/venues-geo.sql