search

CartoDB / data-services

CARTO internal geocoder PostgreSQL extension
25 stars 11 forks source link

Look through here for great Common Data datasets #63

Open andrewxhill opened 10 years ago

andrewxhill commented 10 years ago

https://github.com/openmundi

two I see are

https://github.com/openmundi/world-heritage

and

https://github.com/openmundi/wikipedia

iriberri commented 10 years ago

Doc: http://openmundi.github.io/

iriberri commented 10 years ago

Using this for adm0 checks (and probably synonyms) https://github.com/openmundi/world.csv/blob/master/countries(249)_alpha3.csv

An interesting thing here is that there's a json per country with the name in several languages, I think this will be easier to manipulate that the huge XML I got the other day in other issue, although this one contains a bigger amount of information.

iriberri commented 10 years ago

The complete table (by name) works like a charm with the new adm0 regions I added :-)

There are some conflicts with iso3 codes for ALA Åland Islands SSD South Sudan PSE Palestine ESH Western Sahara

Because we don't use column ISO3 in ne_admin0 for admin0_synonyms (https://github.com/CartoDB/data-services/blob/master/geocoder/admin0/sql/build_synonym_table.sql#L13=).

What about including also the column iso_a3 from ne_admin0 in the script? @andrewxhill