Sign-In
Cart
Spatial SQL: A Practical Approach to Modern GIS Using SQL
Paperback
Technology & EngineeringDatabasesProgramming
ISBN13: 9781738767564
Publisher: Locate Pr
Published: Dec 11 2023
Pages: 530
Weight: 3.61
Height: 1.44 Width: 8.50 Depth: 11.00
Language: English
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
Also in
Databases
Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems
Kleppmann, Martin
Paperback
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Shields, Walter
Hardcover
Fundamentals of Data Engineering: Plan and Build Robust Data Systems
Housley, Matt
Reis, Joe
Paperback
Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Bruce, Peter
Bruce, Andrew
Gedeck, Peter
Paperback
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Kimball, Ralph
Ross, Margy
Paperback
Fusion Strategy: How Real-Time Data and AI Will Power the Industrial Future
Venkatraman, Venkat
Govindarajan, Vijay
Hardcover
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Shields, Walter
Paperback
The Definitive Guide to Dax: Business Intelligence for Microsoft Power Bi, SQL Server Analysis Services, and Excel
Ferrari, Alberto
Russo, Marco
Paperback
Trustworthy Online Controlled Experiments: A Practical Guide to A/B Testing
Xu, Ya
Kohavi, Ron
Tang, Diane
Paperback
Introduction to Statistics: An Intuitive Guide for Analyzing Data and Unlocking Discoveries
Frost, Jim
Paperback
Product Operations: How successful companies build better products at scale
Perri, Melissa
Tilles, Denise
Paperback
The Elements of Statistical Learning: Data Mining, Inference, and Prediction, Second Edition
Tibshirani, Robert
Hastie, Trevor
Friedman, Jerome
Hardcover
Hands-On Salesforce Data Cloud: Implementing and Managing a Real-Time Customer Data Platform
Avila, Joyce Kay
Paperback
Statistical Tableau: How to Use Statistical Models and Decision Science in Tableau
Lang, Ethan
Paperback
SQL Cookbook: Query Solutions and Techniques for All SQL Users
Molinaro, Anthony
Graaf, Robert de
Paperback
Data Analytics & Visualization All-In-One for Dummies
Massaron, Luca
Hyman, Jack A.
McFedries, Paul
Paperback
Apache Iceberg: The Definitive Guide: Data Lakehouse Functionality, Performance, and Scalability on the Data Lake
Hughes, Jason
Merced, Alex
Shiran, Tomer
Paperback
Becoming a Data Head: How to Think, Speak, and Understand Data Science, Statistics, and Machine Learning
Gutman, Alex J.
Goldmeier, Jordan
Paperback
Designing Data Governance from the Ground Up: Six Steps to Build a Data-Driven Culture
Maffeo, Lauren
Paperback
R in Action, Third Edition: Data Analysis and Graphics with R and Tidyverse
Kabacoff, Robert I.
Paperback
Mathletics: How Gamblers, Managers, and Fans Use Mathematics in Sports, Second Edition
Pelechrinis, Konstantinos
Winston, Wayne L.
Nestler, Scott
Paperback
SQL for Data Analysis: Advanced Techniques for Transforming Data Into Insights
Tanimura, Cathy
Paperback
Analytics the Right Way: A Business Leader's Guide to Putting Data to Productive Use
Wilson, Tim
Sutherland, Joe
Paperback
Non-Invasive Data Governance: The Path of Least Resistance and Greatest Success
Seiner, Robert
Paperback
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
Paperback
Databricks Certified Data Engineer Associate Study Guide: In-Depth Guidance and Practice
Alhussein, Derar
Paperback
Exam Ref Dp-600 Implementing Analytics Solutions Using Microsoft Fabric
Winter, Johnny
Resl, Stepan
Maslyuk, Daniil
Paperback
High Performance PostgreSQL for Rails: Reliable, Scalable, Maintainable Database Applications
Atkinson, Andrew
Paperback
Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema
Stagnitto, Jim
Corr, Lawrence
Paperback
Football Analytics with Python & R: Learning Data Science Through the Lens of Sports
Erickson, Richard a.
Eager, Eric A.
Paperback
Blockchain: The Comprehensive Guide to Blockchain Development, Ethereum, Solidity, and Smart Contracts
Schütz, Andreas
Fertig, Tobias
Paperback
Data and Reality: A Timeless Perspective on Perceiving and Managing Information in Our Imprecise World, 3rd Edition
Kent, William
Paperback
Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
Ehrenmueller-Jensen, Markus
Paperback
PostgreSQL 16 Administration Cookbook: Solve real-world Database Administration challenges with 180+ practical recipes and best practices
Angelakos, Jimmy
Ciolli, Gianni
Mejías, Boriss
Paperback
Collect, Combine, and Transform Data Using Power Query in Power Bi and Excel
Maslyuk, Daniil
Raviv, Gil
Paperback
Turning Data into Wisdom: How We Can Collaborate with Data to Change Ourselves, Our Organizations, and Even the World
Hanegan, Kevin
Paperback
Alteryx Designer: The Definitive Guide: Simplify and Automate Your Analytics
Burkhow, Joshua
Paperback
Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us about Who We Really Are
Stephens-Davidowitz, Seth
Paperback
Winning with Data Science: A Handbook for Business Leaders
Swaminathan, Akshay
Friedman, Howard Steven
Hardcover
Excel 2021: Everything you need to know about Excel to go from Beginner to Expert
Wright, Nora E.
Paperback
Aerospike: Up and Running: Developing on a Modern Operational Database for Globally Distributed Apps
Autin, Albert
Srinivasan, V.
Faulkes, Tim
Paperback
Observability Engineering: Achieving Production Excellence
Majors, Charity
Fong-Jones, Liz
Miranda, George
Paperback
Implementing Data Mesh: Design, Build, and Implement Data Contracts, Data Products, and Data Mesh
Perrin, Jean-Georges
Broda, Eric
Paperback
Streaming Databases: Unifying Batch and Stream Processing
Dulay, Hubert
Debusmann, Ralph Matthias
Paperback
Analytics Engineering with SQL and Dbt: Building Meaningful Data Models at Scale
Russa, Helder
Machado, Rui Pedro
Paperback
Data Governance: The Definitive Guide: People, Processes, and Tools to Operationalize Data Trustworthiness
Eryurek, Evren
Gilad, Uri
Lakshmanan, Valliappa
Paperback
Apache Airflow Best Practices: A practical guide to orchestrating data workflow with Apache Airflow
Doorn, Kendrick Van
Storey, Dylan
Intorf, Dylan
Paperback
Data Strategy: How to Profit from a World of Big Data, Analytics and Artificial Intelligence
Marr, Bernard
Paperback
Practical Time Series Analysis: Prediction with Statistics and Machine Learning
Nielsen, Aileen
Paperback
Hands-On MySQL Administration: Managing MySQL on Premises and in the Cloud
Ayyalusamy, Jeyaram
Aravindan, Arunjith
Paperback
High Performance Spark: Best Practices for Scaling and Optimizing Apache Spark
Warren, Rachel
Karau, Holden
Paperback
Databricks Data Intelligence Platform: Unlocking the Genai Revolution
Gupta, Nikhil
Yip, Jason
Paperback
Value-Driven Data: Identifying, Communicating and Delivering Effective Business Solutions with Data
Odaro, Edosa
Paperback
Cockroachdb: The Definitive Guide: Distributed Data at Scale
Harrison, Guy
Seldess, Jesse
Darnell, Ben
Paperback
Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services
Russo, Marco
Ferrari, Alberto
Paperback
The Data Storyteller's Handbook: How to create business impact using data storytelling
Greenbrook, Kat
Paperback
Data Analytics with Hadoop: An Introduction for Data Scientists
Bengfort, Benjamin
Kim, Jenny
Paperback
Build a Robo-Advisor with Python (from Scratch): Automate Your Financial and Investment Decisions
Michalka, Alex
Reider, Rob
Paperback
SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Fritchey, Grant
Paperback
Kafka: The Definitive Guide: Real-Time Data and Stream Processing at Scale
Palino, Todd
Sivaram, Rajini
Shapira, Gwen
Paperback
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
Schacht, Bradley
Ali, Arshad
Paperback
Big Data in Der Mobilität: Akteure, Geschäftsmodelle Und Nutzenpotenziale Für Die Welt Von Morgen
Müller-Peters, Horst
Gatzert, Nadine
Knorre, Susanne
Paperback
Applied Unsupervised Learning with Python
Johnston, Benjamin
Jones, Aaron
Kruger, Christopher
Paperback
Object-Role Modeling Fundamentals: A Practical Guide to Data Modeling with ORM
Halpin, Terry
Paperback
Blueprints for Text Analytics Using Python: Machine Learning-Based Solutions for Common Real World (Nlp) Applications
Albrecht, Jens
Ramachandran, Sidharth
Winkler, Christian
Paperback
Data Governance Handbook: A practical approach to building trust in data
Batchelder, Wendy S.
Paperback
Business 101 for the Data Professional: What You Need to Know to Succeed in Business
Morrow, Jordan
Paperback
Mongodb: The Definitive Guide: Powerful and Scalable Data Storage
Chodorow, Kristina
Bradshaw, Shannon
Brazil, Eoin
Paperback
The Enterprise Data Catalog: Improve Data Discovery, Ensure Data Governance, and Enable Innovation
Olesen-Bagneux, Ole
Paperback
Product Analytics: Applied Data Science Techniques for Actionable Consumer Insights
Rodrigues, Joanne
Paperback
SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis
Teate, Renee M. P.
Paperback
Text as Data: A New Framework for Machine Learning and the Social Sciences
Roberts, Margaret E.
Stewart, Brandon M.
Grimmer, Justin
Paperback
Practical Natural Language Processing: A Comprehensive Guide to Building Real-World Nlp Systems
Majumder, Bodhisattwa
Gupta, Anuj
Vajjala, Sowmya
Paperback
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Wentling, Tristen
Haines, Scott
Lee, Denny
Paperback
Azure Data Factory by Example: Practical Implementation for Data Engineers
Swinbank, Richard
Paperback
Snowflake: The Definitive Guide: Architecting, Designing, and Deploying on the Snowflake Data Cloud
Avila, Joyce Kay
Paperback
Data Engineering Best Practices: Architect robust and cost-effective data solutions in the cloud era
Schiller, Richard J.
Larochelle, David
Paperback
Text Data Management and Analysis: A Practical Introduction to Information Retrieval and Text Mining
Zhai, Chengxiang
Massung, Sean
Paperback
Predictive Analytics for the Modern Enterprise: A Practitioner's Guide to Designing and Implementing Solutions
Ali, Nooruddin Abbas
Paperback
Learn PostgreSQL - Second Edition: Use, manage and build secure and scalable databases with PostgreSQL 16
Pirozzi, Enrico
Ferrari, Luca
Paperback
Database Management for Business Leaders: Building and Using Data Solutions That Work for You
Ruddell, Larry
Paperback
SAP S/4hana Financial Accounting Certification Guide: Application Associate Exam
Pougkas, Stefanos
Paperback
Aprende SQL en un fin de semana: El curso definitivo para crear y consultar bases de datos
Padial Solier, Antonio
Paperback
Practical Lakehouse Architecture: Designing and Implementing Modern Data Platforms at Scale
Thalpati, Gaurav Ashok
Paperback
Data Engineering Design Patterns: Recipes for Solving the Most Common Data Engineering Problems
Konieczny, Bartosz
Paperback
The Decision Maker's Handbook to Data Science: AI and Data Science for Non-Technical Executives, Managers, and Founders
Kampakis, Stylianos
Paperback
Data Mining Techniques: For Marketing, Sales, and Customer Relationship Management
Linoff, Gordon S.
Berry, Michael J. a.
Paperback
Discriminating Data: Correlation, Neighborhoods, and the New Politics of Recognition
Chun, Wendy Hui Kyong
Paperback
Pandas Cookbook - Third Edition: Practical recipes for scientific computing, time series, and exploratory data analysis using Python
Harrison, Matthew
Ayd, William
Paperback
Data-Driven Talent Management: Using Analytics to Improve Employee Experience
Saling, Kristin
Paperback
Data Quality Fundamentals: A Practitioner's Guide to Building Trustworthy Data Pipelines
Vorwerck, Molly
Moses, Barr
Gavish, Lior
Paperback
MICROSOFT EXCEL & ACCESS For Beginners and Pros. 2024: A Complete Guide to Master Excel and Access 365 for All Users
Sherer, Charles
Paperback
Data and Analytics Strategy for Business: Unlock Data Assets and Increase Innovation with a Results-Driven Data Strategy
Asplen-Taylor, Simon
Paperback
Azure SQL Revealed: The Next-Generation Cloud Database with AI and Microsoft Fabric
Ward, Bob
Paperback
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Database Expert
Dombrovskaya, Henrietta
Bailliekova, Anna
Paperback
Principles of Data Science: Mathematical techniques and theory to succeed in data-driven industries
Ozdemir, Sinan
Paperback