Spatial SQL

A Practical Approach to Modern GIS Using SQL

Matthew Forrest, Tyler J Mitchell, Keith Mitchell

$125.95 $100.80

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Locate Press
11 December 2023

"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"

By: Matthew Forrest
Edited by: Tyler J Mitchell, Keith Mitchell
Imprint: Locate Press
Dimensions: Height: 279mm, Width: 216mm, Spine: 37mm
Weight: 1.637kg
ISBN: 9781738767564
ISBN 10: 1738767566
Pages: 530
Publication Date: 11 December 2023
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active

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.

Reviews for Spatial SQL: A Practical Approach to Modern GIS Using SQL

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