PostGIS Cookbook - Second Edition

Getting ready

If you didn't follow all the other recipes, be sure to import the hotspots (Global_24h.csv) and the countries dataset (countries.shp) in PostGIS. The following is how to do it with ogr2ogr (you should import both the datasets in their original SRID, 4326, to make spatial operations faster):

1. Import in PostGIS the Global_24h.csv file, using the global_24.vrt virtual driver you created in a previous recipe:

      $ ogr2ogr -f PostgreSQL PG:"dbname='postgis_cookbook'       user='me' password='mypassword'" -lco SCHEMA=chp01 global_24h.vrt       -lco OVERWRITE=YES -lco GEOMETRY_NAME=the_geom -nln hotspots

2. Import the countries shapefile using ogr2ogr:

      $ ogr2ogr -f PostgreSQL -sql "SELECT ISO2, NAME AS country_name  FROM wborders" -nlt MULTIPOLYGON ...