Carry out the following steps:
- 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 ...
