Geospatial Analysis with SQL: A hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL
- Length: 234 pages
- Edition: 1
- Language: English
- Publisher: Packt Publishing
- Publication Date: 2023-01-27
- ISBN-10: 180461646X
- ISBN-13: 9781804616468
- Sales Rank: #445911 (See Top 100 Books)
Leverage the power of SQL to perform geospatial analysis and increase your speed and efficiency working with a variety of spatial applications such as PostGIS and QGIS
Key Features
- Follow along with actionable instructions with this practical guide
- Become well-versed in advanced spatial modeling and machine learning techniques
- Learn best practices for performing spatial analysis from an expert spatial data analyst
Book Description
Geospatial analysis is used in almost every industry to answer location-related questions. Combined with the power of SQL, which is becoming a popular choice for developers and analysts worldwide, this technology will help you to solve real-world spatial problems easily. This book shows you how to detect and quantify patterns in datasets through data exploration, data visualization, data engineering, and the application of analysis and spatial techniques.
You’ll begin by exploring the fundamentals of geospatial analysis and understand its importance along with vector and raster models, among other things. You’ll then look at the framework for geospatial analysis using SQL and progress through the chapters to create a spatial database and analyze it. In the next part, you’ll advance to learning about using SQL functions and building SQL queries.
By the end of this book, you’ll be able to make the most of open source libraries and frameworks such as PostGIS and QGIS for analyzing spatial information.
What you will learn
- Understand geospatial fundamentals as a basis for learning spatial SQL
- Generate point, line, and polygon data with SQL
- Create geometry objects with WKT, WKB, and GeoJSON
- Use spatial data types to abstract and encapsulate spatial structures
- Work with open source GIS combined with plug-ins
- Visualize spatial data and expand QGIS functionality with Postgres
- Apply location data to leverage spatial analytics
- Perform single-layer and multiple-layer spatial analyses
Who this book is for
This book is for anyone looking to leverage their SQL knowledge to perform geospatial analysis. GIS analysts, data analysts, and data scientists with a basic understanding of both geospatial analysis and SQL will find this book useful.
Cover Title Page Copyright and Credits Dedication Contributors Table of Contents Preface Section 1: Getting Started with Geospatial Analytics Chapter 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 Chapter 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 Chapter 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 Chapter 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 Chapter 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 Chapter 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 Chapter 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 Chapter 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 About Packt Other Books You May Enjoy
Donate to keep this site alive
How to download source code?
1. Go to: https://github.com/PacktPublishing
2. In the Find a repository… box, search the book title: Geospatial Analysis with SQL: A hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL
, sometime you may not get the results, please search the main title.
3. Click the book title in the search results.
3. Click Code to download.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.