Spatial SQL: A Practical Approach to Modern GIS Using SQL by Forrest, Matthew
Spatial SQL: A Practical Approach to Modern GIS Using SQL by Forrest, Matthew

Spatial SQL: A Practical Approach to Modern GIS Using SQL

Spatial SQL: A Practical Approach to Modern GIS Using SQLby Matthew ForrestLearn to create, index and query...
BD$160.39 BMD
BD$160.39 BMD
SKU: 9781738767564
Product Type: Books
Please hurry! Only 303 left in stock
Author: Matthew Forrest
Format: Paperback
Language: English
Subtotal: BD$160.39
10 customers are viewing this product
Spatial SQL: A Practical Approach to Modern GIS Using SQL by Forrest, Matthew

Spatial SQL: A Practical Approach to Modern GIS Using SQL

BD$160.39
Spatial SQL: A Practical Approach to Modern GIS Using SQL by Forrest, Matthew

Spatial SQL: A Practical Approach to Modern GIS Using SQL

BD$160.39
Author: Matthew Forrest
Format: Paperback
Language: English
Description
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



Author: Matthew Forrest
Publisher: Locate Press
Published: 12/11/2023
Pages: 530
Binding Type: Paperback
Weight: 3.61lbs
Size: 11.00h x 8.50w x 1.44d
ISBN: 9781738767564

This title is not returnable
Shipping & Return

Returns Policy

You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Review

Related Products

Example product title
BD$160.39 BMD
BD$160.39 BMD
Example product title
BD$160.39 BMD
BD$160.39 BMD
Example product title
BD$160.39 BMD
BD$160.39 BMD
Example product title
BD$160.39 BMD
BD$160.39 BMD
Example product title
BD$160.39 BMD
BD$160.39 BMD
Example product title
BD$160.39 BMD
BD$160.39 BMD
Example product title
BD$160.39 BMD
BD$160.39 BMD
Example product title
BD$160.39 BMD
BD$160.39 BMD
Example product title
BD$160.39 BMD
BD$160.39 BMD
Example product title
BD$160.39 BMD
BD$160.39 BMD

Recently Viewed Products