Database Reference
In-Depth Information
chasedthisbookelsewhere,youcanvisit
http://www.packtpub.com/sup-
port
and register to have the files e-mailed directly to you.
$ cd ~/postgis_cookbook/data/chp01/
$ head -n 5 firenews.csv
The output of the preceding command is as shown:
x,y,place,size,update,startdate,enddate,title,url-8.2499,42.37657,Avión,52,2011/
03/07,2011/03/05,2011/03/06,Dos incendios
calcinan 74 hectáreas el fin de
semana,http://www.laregion.es/noticia/
145578/incendios/calcinan/hectareas/
semana/
-8.1013,42.13924,Quintela de
Leirado,22,2011/03/07,2011/03/06,2011/03/
06,Dos incendios calcinan 74 hectáreas el
fin de semana,http://www.laregion.es/
noticia/145578/incendios/calcinan/
hectareas/semana/
3.48159,43.99156,Arrigas,4,2011/03/
06,2011/03/05,2011/03/05,"À Arrigas, la
forêt sous la menace d'un
feu",http://www.midilibre.com/articles/
2011/03/06/
NIMES-A-Arrigas-la-foret-sous-la-menace-d-39-un-feu-1557923.php5
6.1672,44.96038,Vénéon,9,2011/03/06,2011/
03/06,2011/03/06,Isère Spectaculaire
incendie dans la vallée du
Vénéon,http://www.ledauphine.com/
isere-sud/2011/03/06/
isere-spectaculaire-incendie-dans-la-vallee-du-veneon
2. Connect to PostgreSQL and create the following table:
