Synopsis "Spatial SQL: A Practical Approach to Modern GIS Using SQL (in English)"
Spatial SQL: A Practical Approach to Modern GIS Using SQLby Matthew ForrestLearn 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 todaySetting up - Installing PostGIS with Docker on any operating systemThinking in SQL - How to move from desktop GIS to SQL and learn how to structure queries independentlyThe basics of SQL - Import data to PostgreSQL and PostGIS, SQL data types, and core SQL operationsAdvanced SQL - Statistical functions, joins, window functions, managing data, and user-defined functionsUsing the GEOMETRY - Working with GEOMETRY and GEOGRAPHY data, data manipulation, and measurementsSpatial relationships - Spatial joins, distance relationships, clustering, and overlay functionsSpatial analysis - Recreate common spatial analysis "toolbox" tools all in spatial SQLAdvanced analysis - Data enrichment, line of sight, kernel density estimation, and moreRaster data - Importing, analyzing, interpolating, and using H3 spatial indexes with raster data in PostGISSuitability analysis - Importing, analyzing, interpolating, and using H3 spatial indexes with raster data in PostGISRouting with pgRouting - Routing for cars and bikes, travel time isochrones, and traveling salesperson problemSpatial data science - Spatial autocorrelation, location allocation, and create territories with PySAL in PostGIS
