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

Distance and near

In the previous section, you had the database buffer a point and return the polygon. In this section, you will learn how to query the database for the distance between two points, and you will query the database and have it return records based on the distance from a specified point.

The PostGIS function for distance is ST_Distance(a,b). You can pass a and b as geometry or geography. As geography, the result will be returned in meters. The following code will get the distance between two points in the database:

cursor.execute("SELECT ST_Distance(a.location::geography,b.location::geography) FROM art_pieces a, art_pieces b where a.name='101' AND b.name='102'")dist=cursor.fetchall()dist

The previous code executes the SQL query ...

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