This chapter has introduced you to GIS and spatial data in PostgreSQL via a step-by-step project using the PostGIS extension. In this project, you first learned how to install PostGIS for RDS on AWS. Then, you learned how to declare and import spatial data files into PostGIS and how to show spatial data with the Geometry Viewer feature of PostGIS. After that, we also showed you another GIS open source variant named QGIS so that you can broaden your ideas about GIS, since QGIS is a wider tool that can also be applied to many other databases, such as Oracle, DB2, and MSSQL databases. Finally, we concluded the chapter with a couple of sample spatial queries for ATM locations in New York City.
In the next chapter, we will study PostgREST, a RESTful API for PostgreSQL databases.
