Skip to Content
Mastering Geospatial Analysis with Python
book

Mastering Geospatial Analysis with Python

by Silas Toms, Paul Crickard, Eric van Rees
April 2018
Beginner to intermediate content levelBeginner to intermediate
440 pages
11h 36m
English
Packt Publishing
Content preview from Mastering Geospatial Analysis with Python

Drawing polygons from PostGIS

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 3Introduction to Geospatial Databases, and Chapter 7Geoprocessing 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learning Geospatial Analysis with Python

Learning Geospatial Analysis with Python

Joel Lawhead

Publisher Resources

ISBN: 9781788293334Supplemental Content