Summary

This chapter covered the installation of PostgreSQL and PostGIS as well as psycogp2 and Shapely. Then, we gave a brief overview of the major functions used when working with a spatial database. You should now be familiar with connecting to the database, executing queries to insert data, and how to get your data out. Furthermore, we covered functions that return new geometries, distances, and areas of geometry. Understanding how these functions work should allow you to read the PostGIS documents and be comfortable with forming the SQL statement for that function.

In the next chapter, you will learn about the major data types in GIS and how to use Python code libraries to read and write geospatial data. You will learn how to convert between data types, and how to upload and download data from geospatial databases and remote data sources.