4

An Overview of Spatial Statistics

In this chapter, we are going to build a story by adding new spatial queries. pgAdmin is a great resource for exploring our data, executing queries, and using advanced database tools (as covered in more detail in Chapter 7, Exploring PostGIS for Geographic Analysis), but I usually work with QGIS when it comes to using spatial analysis and data visualization.

Census data is notoriously complex but it is worth understanding a few straightforward tasks to render the available files, as this is informative and critical to understanding the impacts of urbanization, changing population demographics, and resource scarcity (to name just a few).

In the last chapter, you were introduced to a few spatial methods such ...

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.