Title: Spatial SQL : A Practical Approach to Modern GIS Using SQL
Publisher: Locate Press Dez 2023
Publication Date: 2023
Language: English
ISBN 10: 1738767566
ISBN 13: 9781738767564
Binding: Taschenbuch
Condition: Neu
Dimensions: 274 millimeters width by 213 millimeters height by 38 millimeters depth
Weight: 1664 grams

About this title

Synopsis

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

About the Author

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.

"About this title" may belong to another edition of this title.

Store Description

Das Unternehmen AHA-BUCH GmbH: Seit der Gr�ndung von AHA-BUCH im Juli 2005 ist unser Hauptziel, zufriedenen Kunden so schnell und so preisg�nstig wie m�glich ihren B�cherwunsch zu erf�llen. Unsere Firma besch�ftigt 16 Mitarbeiter, die nur ein Ziel kennen: den Kunden und seine W�nsche! Auf �ber 3700 m2 Fl�che haben wir �ber 100.000 B�cher, Modernes Antiquariat und Spiele auf Lager.

Visit Seller's Storefront

Seller's business information

AHA-BUCH GmbH
Garlebsen 48, Einbeck, 37574, Germany

Sale & Shipping Terms

Terms of Sale

General Terms and Conditions and Customer Information / Privacy Policy

I. General Terms and Conditions

� 1 Basic provisions

(1) The following terms and conditions apply to all contracts that you conclude with us as a provider (AHA-BUCH GmbH) via the Internet platforms AbeBooks and/or ZVAB. Unless otherwise agreed, the inclusion of any of your own terms and conditions used by you will be objected to

(2) A consumer within the meaning of the following regulations is any natural person who concludes...

More Information

Shipping Terms

We ship your order after we received them
for articles on hand latest 24 hours,
for articles with overnight supply latest 48 hours.
In case we need to order an article from our supplier our dispatch time depends on the reception date of the articles, but the articles will be shipped on the same day.

Our goal is to send the ordered articles in the fastest, but also most efficient and secure way to our customers.

Shipping rates from Germany to U.S.A.

Shipping rates from Germany to U.S.A.
Order quantity	30 to 40 business days	7 to 14 business days
First item	US$ 79.94	US$ 91.65

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.