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

Data cursor

To execute the SQL commands (spatial or otherwise), we will create a data cursor. The cursor is part of the connection class and will be used to execute statements using the execute command. It is also used to access query results, which are converted into a list and iterated using a for loop:

from pymapd import connectconnection = connect(user="mapd", password= "{password}",      host="{my.host.com}", dbname="mapd")cursor = connection.cursor()sql_statement = """SELECT name FROM county;"""cursor.execute(sql_statement)results = list(cursor)for result in results:    print(result[0])

The result is a list of tuples, which contain (in this case) only the name of the county, accessed using a zero index to get it out of the tuple.

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