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 as SQL, ST_Distance and ST_Intersects. In this chapter, we will build toward discovering patterns in our data. Traditional statistical methods do not account for spatial relationships such as patterns and clusters, so we will explore data and...
