Chapter 3. Spatial Databases
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
psycopg2database adapter to allow you to access Postgres from your Python programs - Learn 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...
