search

CartoDB / cartodb

Location Intelligence & Data Visualization tool
http://carto.com
BSD 3-Clause "New" or "Revised" License
2.76k stars 650 forks source link

US Geocoding Options should include City / State / Country ... Current just offers City / Country #2589

Closed LoganWinston closed 9 years ago

LoganWinston commented 9 years ago

In the US we have cities like Portland (city) Maine (state) and Portland (city) Oregon (state). The geocoder should include State as a parameter. screen shot 2015-03-03 at 11 37 46 am

LoganWinston commented 9 years ago

@saleiva

LoganWinston commented 9 years ago

@juanignaciosl

LoganWinston commented 9 years ago

@rafatower

iriberri commented 9 years ago

Basically, right now the SQL behind just searches for cities inside a country (by ISO2 code) and retrieves the one with more population.

We'd need to check if geonames includes all the info we need in order to filter by states or provinces or whatever.

iriberri commented 9 years ago

I checked: column admin01 includes the states (abbreviated to iso2) in the USA case. In other countries like Spain, this column is not so straightforward and includes numbers for the autonomous communities.

iriberri commented 9 years ago

Closing. We already do this :)