-
Book Overview & Buying
-
Table Of Contents
Geospatial Analysis with SQL
By :
For the remaining chapter, let’s explore the population dynamics in Los Angeles County—specifically, declines or increases in the Hispanic population. The folder download included a JSON file. We need to identify populations of interest from the dense JSON file you see in Figure 6.19:
Figure 6.19 – Demographic metadata JSON file Hispanic/non-Hispanic aged over 18
The area highlighted in Figure 6.19 is the percent change in population from the 2010 census to the 2020 census. In addition, I captured the total population and total population: Hispanic Latino for 2020, "P0040001_2020": "P4-1: Total (2020)", "P0040002_2020": "P4-2: Hispanic or Latino (2020)".
Renaming the columns in census tables is quite a task. The codes identify data products available from the census. For example, B in the column heading in Figure 6.20 is used for detailed estimates...