Database Reference
In-Depth Information
4. Exporttheresultsofthisquerybyusingthe
pgsql2shp
PostGIScommand:
$ pgsql2shp -f subregions.shp -h
localhost -u me -P mypassword
postgis_cookbook "SELECT MIN(subregion)
AS subregion, ST_Union(the_geom) AS
the_geom, SUM(pop2005) AS pop2005 FROM
chp01.countries GROUP BY subregion;"
Initializing...
Done (postgis major version: 2).
Output shape: Polygon
Dumping: X [23 rows].
5. OpentheshapefileandinspectitwithyourfavoriteDesktopGIS.Thisishow
it looks in QGIS after applying a graduated classification symbology style
based on the aggregated population for each subregion.
