April 2018
Beginner to intermediate
440 pages
11h 36m
English
In this example, you will draw the Albuquerque Police Department Area Commands polygons from a PostGIS database. You will use the following code with an added PostGIS query, a loop to add all of the features, and a WKT function to draw the geometry instead of hard-coding the coordinates.
The first step is to connect to the PostGIS database. The following code is the same as you used in Chapter 3, Introduction to Geospatial Databases, and Chapter 7, Geoprocessing With Geodatabases:
import psycopg2 connection = psycopg2.connect(database="pythonspatial",user="postgres", password="postgres") cursor = connection.cursor() cursor.execute("SELECT name, ST_AsTexT(geom) from areacommand") c=cursor.fetchall()
The previous ...