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

Contains queries

This code will test the speed of a data query against the county database table, using ST_Contains, a spatial SQL point in polygon analysis tool. The geometry column of the county table (called geom) is the first input into ST_Contains, and the well-known text (WKT) point is added second. Once the SQL statement is executed, the point will be compared against all of the rows in the table to find if one of the county geometries contains the point described by the WKT point:

import pymapdfrom pymapd import connectconnection = connect(user="mapd", password= "{password}",      host="{my.host.com}", dbname="mapd")import timepoint = "POINT(-80.896146 27.438610)"cursor = connection.cursor()print(time.time())sql_statement = """SELECT ...
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