Geospatial Analysis with SQL: A hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL

Geospatial Analysis with SQL
Contributors
About the author
About the reviewers
Preface
   Who is this book for?
   What this book covers
   To get the most out of this book
   Download the example code files
   Conventions used
   Get in touch
   Share Your Thoughts
   Download a free PDF copy of this book
Section 1: Getting Started with Geospatial Analytics
1
Introducing the Fundamentals of Geospatial Analytics
   Technical requirements
   Spatial databases
   SRIDs
   Understanding geospatial data types
      Raster models
   Exploring SQL
      SELECT statements
      WHERE statements
      CREATE statements
   Summary
2
Conceptual Framework for SQL Spatial Data Science – Geometry Versus Geography
   Technical requirements
   Creating a spatial database
      Options for databases with spatial functions
      Exploring databases with psql
   Importing data
   Fundamentals of a query-based syntax
      Changing column names
      Identifying tables
      Introducing query-based syntax
   Analyzing spatial relationships
   Detecting patterns, anomalies, and testing hypotheses
   Summary
3
Analyzing and Understanding Spatial Algorithms
   Technical Requirements
   Developing knowledge about geographic space
   Connecting to databases and executing SQL queries
      Reasoning and key decisions about spatial concepts
   Exploring pattern detection tools
      Executing SQL queries in QGIS
   Summary
4
An Overview of Spatial Statistics
   Technical requirements
   Creating spatial vectors with SQL
   Renaming table columns – US census
      What do the census table codes mean?
   Running queries in QGIS
   Building prediction models
   Summary
Section 2: SQL for Spatial Analytics
5
Using SQL Functions – Spatial and Non-Spatial
   Technical requirements
   Preparing data
      Creating a dataset using the Open Street Map plugin
   Null values in PostgreSQL
   Spatial concepts
      ST_Within
      CREATE VIEW
      ST_Buffer
   Creating functions in SQL
      Mining areas in Brazil
   Summary
6
Building SQL Queries Visually in a Graphical Query Builder
   Technical requirements
      Conditional queries
   SQL data queries using the graphical query builder
   Aggregation and sorting queries
      Understanding census-designated places
      The SQL Query Builder
   Exploring census data in the SQL Query Builder
   Summary
7
Exploring PostGIS for Geographic Analysis
   Technical requirements
   Configuring and authenticating PostGIS in QGIS
      Loading data into PostGIS
      Importing data into PostGIS
      Discovering the PgAdmin dashboard
      Executing SQL queries in pgAdmin
   Importing additional data – power plants
   Additional data queries – IS NOT NULL
   Differentiating polygons in OSM data
      Spatial queries
      Exploring ST_Contains and multi-table joins
   Summary
8
Integrating SQL with QGIS
   Technical Requirements
   Understanding the SQL query builder in QGIS
      Comparing polygons between two large datasets
   Raster data
      Installing plugins
      The GEE data catalog plugin
   Landscape Change Monitoring System
      raster2pgsql
      Terminal raster import
   Summary
Index
   Why subscribe?
Other Books You May Enjoy
   Packt is searching for authors like you
   Share Your Thoughts
   Download a free PDF copy of this book