April 2018
Beginner to intermediate
440 pages
11h 36m
English
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 ...