{"product_id":"spatial-sql-a-practical-approach-to-modern-gis-using-sql-paperback","title":"Spatial SQL: A Practical Approach to Modern GIS Using SQL - Paperback","description":"\u003cp\u003eby \u003cb\u003eMatthew Forrest\u003c\/b\u003e (Author), \u003cb\u003eTyler J. Mitchell\u003c\/b\u003e (Editor), \u003cb\u003eKeith Mitchell\u003c\/b\u003e (Editor)\u003c\/p\u003e\u003cp\u003eSpatial SQL: A Practical Approach to Modern GIS Using SQL\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eby Matthew Forrest\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eLearn to create, index and query spatial databases using SQL that applies to PostgreSQL\/PostGIS and more.\u003c\/p\u003e\u003cp\u003eLearn 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.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eOver 500 pages covers a comprehensive set of GIS topics.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhy SQL? - \u003c\/strong\u003eThe evolution to modern GIS, why spatial SQL matters, and the spatial SQL landscape today\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eSetting up - \u003c\/strong\u003eInstalling PostGIS with Docker on any operating system\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThinking in SQL - \u003c\/strong\u003eHow to move from desktop GIS to SQL and learn how to structure queries independently\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe basics of SQL - \u003c\/strong\u003eImport data to PostgreSQL and PostGIS, SQL data types, and core SQL operations\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAdvanced SQL - \u003c\/strong\u003eStatistical functions, joins, window functions, managing data, and user-defined functions\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eUsing the GEOMETRY - \u003c\/strong\u003eWorking with GEOMETRY and GEOGRAPHY data, data manipulation, and measurements\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eSpatial relationships - \u003c\/strong\u003eSpatial joins, distance relationships, clustering, and overlay functions\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eSpatial analysis - \u003c\/strong\u003eRecreate common spatial analysis \"toolbox\" tools all in spatial SQL\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAdvanced analysis - \u003c\/strong\u003eData enrichment, line of sight, kernel density estimation, and more\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eRaster data - \u003c\/strong\u003eImporting, analyzing, interpolating, and using H3 spatial indexes with raster data in PostGIS\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eSuitability analysis - \u003c\/strong\u003eImporting, analyzing, interpolating, and using H3 spatial indexes with raster data in PostGIS\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eRouting with pgRouting - \u003c\/strong\u003eRouting for cars and bikes, travel time isochrones, and traveling salesperson problem\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eSpatial data science - \u003c\/strong\u003eSpatial autocorrelation, location allocation, and create territories with PySAL in PostGIS\u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 530\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1.44 x 11 x 8.5 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e December 11, 2023\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42093430898823,"sku":"9781738767564","price":145.35,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0601\/2623\/2711\/files\/c87b8ad392242e762a1357acb51f095f.webp?v=1732311087","url":"https:\/\/booksby.splitshops.com\/products\/spatial-sql-a-practical-approach-to-modern-gis-using-sql-paperback","provider":"Books by splitShops","version":"1.0","type":"link"}