PostGIS Cookbook - Second Edition

How to do it...

The steps you need to follow to complete this recipe are as follows:

1. Create a shapefile from the virtual driver created in the previous recipe using the ogr2ogr command (note that in this case, you do not need to specify the -f option as the shapefile is the default output format for the ogr2ogr command):

      $ ogr2ogr global_24h.shp global_24h.vrt

2. Generate the SQL dump file for the shapefile using the shp2pgsql command. You are going to use the -G option to generate a PostGIS spatial table using the geography type, and the -I option to generate the spatial index on the geometric column:

      $ shp2pgsql -G -I global_24h.shp        chp01.global_24h_geographic > global_24h.sql

3. Analyze the global_24h.sql file (in Windows, use a text ...