7
Exploring PostGIS for Geographic Analysis
We have been working with PostGIS to support geographic analysis (geometry and geography). Being open source and using additional spatial functions allows us to store geometric information. In this chapter, you will continue to learn how to work with the spatial reference identifier (SRID), as well as a few non-spatial functions. Information and instructions will be formatted as case studies that highlight open source data. These vignettes will correlate with how questions are formulated and encourage creativity and curiosity.
As a brief refresher, when referring to PostGIS, we mean the open source Postgres spatial extension for working with spatial databases. The main reason I rely on PostgreSQL is ...
Get Geospatial Analysis with SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.