Technical requirements

I invite you to find your own data if you are comfortable or access the data recommended in this book’s GitHub repository at: https://github.com/PacktPublishing/Geospatial-Analysis-with-SQL.

First, here are the datasets we will access in this chapter.

Note

The files in this archive have been created from OpenStreetMap (OSM) data and are licensed under the Open Database 1.0 License.

• Fire Hazard Severity Zones: https://data.lacounty.gov/datasets/fire-hazard-severity-zones/explore?location=33.641879%2C-117.730373%2C7.79
• OSM data is refreshed daily, so the data you download may differ from what you see in the examples: http://download.geofabrik.de/north-america/us/california/socal-latest-free.shp.zip
• Los Angeles County, CA Neighborhoods: https://censusreporter.org/user_geo/12895e183b0c022d5a527c612ce72865/
• Aggregate Household Income in the Past 12 Months (in 2020 inflation-adjusted Dollars) by tenure and mortgage status: https...