Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL
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 -- Understandi...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | UnknownFormat |
| Sprache: | eng |
| Veröffentlicht: |
Birmingham, Mumbai
Packt
2023
|
| Schlagworte: | |
| Online Zugang: | Inhaltsverzeichnis |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Tag hinzufügen | Zusammenfassung: | 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. |
|---|---|
| Beschreibung: | xv, 218 Seiten Illustrationen |
| ISBN: | 9781804616468 978-1-80461-646-8 |