PostGIS in Action, Third Edition shows you how to solve real-world geodata problems. You'll go beyond basic mapping, and explore custom functions for your applications. SummaryIn PostGIS in Action, Third Edition you will learn: An introduction to spatial databasesGeometry, geography, raster, and topology spatial types, functions, and queriesApplying PostGIS to real-world problemsExtending PostGIS to web and desktop applicationsQuerying data from external sources using PostgreSQL Foreign Data WrappersOptimizing queries for maximum speedSimplifying geometries for greater efficiency PostGIS in Action, Third Edition teaches readers of all levels to write spatial queries for PostgreSQL. You'll start by exploring vector-, raster-, and topology-based GIS before quickly progressing to analyzing, viewing, and mapping data. This fully updated third edition covers key changes in PostGIS 3.1 and PostgreSQL 13, including parallelization support, partitioned tables, and new JSON functions that help
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in v
PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing the creations of location-aware queries with just a few lines of SQL code,