GeoPlanet data with ancestor chain cache imported in 10 minutes
Yahoo! provides its GeoPlanet data as three separate TSV files, available for download here.
That's a database with some 17 million records:
- 5.7 million records: locations (aka places).
- 2.2 million records: alternative names for each place (aka aliases).
- 9.6 million records: matrix of neighbourhoods per place (aka adjacencies).