Overview
"Spatial SQL: A Practical Approach to Modern GIS Using SQL by Matthew Forrest Learn to create, index and query spatial databases using SQL that applies to PostgreSQL/PostGIS and more. Learn how to use Spatial SQL to analyze and manipulate geographic data. This book covers everything from basic spatial queries to advanced spatial analysis techniques all using SQL. Even if you don't know how SQL, this book starts from the beginning all the way to advanced queries. Over 500 pages covers a comprehensive set of GIS topics. Why SQL? - The evolution to modern GIS, why spatial SQL matters, and the spatial SQL landscape today Setting up - Installing PostGIS with Docker on any operating system Thinking in SQL - How to move from desktop GIS to SQL and learn how to structure queries independently The basics of SQL - Import data to PostgreSQL and PostGIS, SQL data types, and core SQL operations Advanced SQL - Statistical functions, joins, window functions, managing data, and user-defined functions Using the GEOMETRY - Working with GEOMETRY and GEOGRAPHY data, data manipulation, and measurements Spatial relationships - Spatial joins, distance relationships, clustering, and overlay functions Spatial analysis - Recreate common spatial analysis ""toolbox"" tools all in spatial SQL Advanced analysis - Data enrichment, line of sight, kernel density estimation, and more Raster data - Importing, analyzing, interpolating, and using H3 spatial indexes with raster data in PostGIS Suitability analysis - Importing, analyzing, interpolating, and using H3 spatial indexes with raster data in PostGIS Routing with pgRouting - Routing for cars and bikes, travel time isochrones, and traveling salesperson problem Spatial data science - Spatial autocorrelation, location allocation, and create territories with PySAL in PostGIS"
Full Product Details
Author: Matthew Forrest ,
Tyler J Mitchell ,
Keith Mitchell
Publisher: Locate Press
Imprint: Locate Press
Dimensions:
Width: 21.60cm
, Height: 3.70cm
, Length: 27.90cm
Weight: 1.637kg
ISBN: 9781738767564
ISBN 10: 1738767566
Pages: 530
Publication Date: 11 December 2023
Audience:
General/trade
,
General
Format: Paperback
Publisher's Status: Active
Availability: Available To Order
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.
Reviews
Just downloaded Matt Forrest book on Spatial SQL. I'm looking forward to setting up the PostGIS instance and learning how to build spatial sql queries in PostgreSQL. I've been working with SpatialSQL in MSSQL for years but realize that the functionality is far more extensive in PostGIS than what Microsoft offers with it's geometry and geography datatypes. So far I'm impressed and if you're looking to get to a more open source gis implementation I recommend you learn all you can on spatial SQL. #spatialdata #gis #geospatial #sql #postgresql #postgis
Author Information
Matt (Matthew) Forrest is passionate about using and sharing ideas around modern GIS, helping others to use a variety of new tools in their geospatial workflows while learning new technologies and skills. Matthew graduated from the University of Wisconsin-Madison with a degree in Geography and has been working with GIS and in Geospatial for 13 years, the past 8 at CARTO, currently as the Field CTO. He has worked with businesses and governments of all sizes and scales, and enjoys helping others advance their GIS careers.
