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

Performing queries on rasters using PostgreSQL

With a raster loaded into PostgreSQL, you can query it using Python. The Python library for working with PostgreSQL is psycopg2. The following code will connect to the database where you loaded the TIF:

import psycopg2connection = psycopg2.connect(database="pythonspatial",user="postgres", password="postgres")cursor = connection.cursor()

The previous code imports psycopg2. It then makes a connection passing the database name, username, and password. Lastly, it gets a cursor object so that you can execute queries.

To see the raster in PostgreSQL, you can execute a select all, as shown in the following code:

cursor.execute("SELECT * from bigi") #Big I is the name of the intersection where I-25 and ...
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