PostGIS Cookbook - Second Edition

Getting ready

1. First, download one week's worth of active fire data (hotspots) from the EOSDIS website. For example, Firedata from EOSDIS can be found in this link: https://earthdata.nasa.gov/earth-observation-data/near-real-time/firms/active-fire-data. A copy of this shapefile is included in the book code bundle. Use that if you want to use the SQL and WMS parameters that have been used in the following steps.
2. Extract the shapefile from the Global_7d.zip archive to the working/chp09 directory and import this shapefile in PostGIS using the shp2pgsql command, as follows:

      $ shp2pgsql -s 4326 -g the_geom -I       MODIS_C6_Global_7d.shp chp09.hotspots > hotspots.sql
      $ psql -U me -d postgis_cookbook -f hotspots.sql

3. When the import is completed, ...