In this chapter, we will look at how you can use a database to store, analyze, and manipulate geospatial data. While spatial databases can be quite complex, and the process of optimizing spatial queries can be challenging, they can be used in a straightforward way without too much fuss and are an important part of the geospatial analyst's toolkit.
In this chapter, we will:
Learn the important concepts you'll need to know before using a spatial database
Install the PostgreSQL relational database system onto your computer
Install the PostGIS extension to PostgreSQL to support spatial databases
Install the
psycopg2
database adapter to allow you to access Postgres from your Python programsLearn how to create a spatial database using PostGIS
Discover how to import data into your spatial database using Python
Learn how to query your spatial database using Python code
See how you can manipulate your spatial data from Python
Learn how to export data out of a spatial database
Let...