How to do it...

Carry out the following steps:

  1. Unzip the IT.zip file to the working/chp08 directory. Two files will be extracted: the readme.txt file that contains information on the GeoNames database structure—you can read it to get some more information—and the IT.txt file, which is a .csv file containing all the GeoNames entities for Italy. As suggested in the readme.txt file, the content of the CSV file is composed of records with the following attributes:
      geonameid         : integer id of record in geonames  database 
      name              : name of geographical point (utf8) varchar(200) 
      asciiname         : name of geographical point in  plain  ascii characters, varchar(200) alternatenames : alternatenames, comma separated varchar(5000) latitude : latitude in decimal ...

Get PostGIS Cookbook - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.