Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
PostGIS Cookbook. - Second Edition

You're reading from  PostGIS Cookbook. - Second Edition

Product type Book
Published in Mar 2018
Publisher
ISBN-13 9781788299329
Pages 584 pages
Edition 2nd Edition
Languages
Authors (6):
Paolo Corti Paolo Corti
Profile icon Paolo Corti
Pedro Wightman Pedro Wightman
Profile icon Pedro Wightman
Bborie Park Bborie Park
Profile icon Bborie Park
Stephen Vincent Mather Stephen Vincent Mather
Profile icon Stephen Vincent Mather
Thomas Kraft Thomas Kraft
Profile icon Thomas Kraft
Mayra Zurbarán Mayra Zurbarán
Profile icon Mayra Zurbarán
View More author details

Table of Contents (18) Chapters

Title Page
Packt Upsell
Contributors
Preface
1. Moving Data In and Out of PostGIS 2. Structures That Work 3. Working with Vector Data – The Basics 4. Working with Vector Data – Advanced Recipes 5. Working with Raster Data 6. Working with pgRouting 7. Into the Nth Dimension 8. PostGIS Programming 9. PostGIS and the Web 10. Maintenance, Optimization, and Performance Tuning 11. Using Desktop Clients 12. Introduction to Location Privacy Protection Mechanisms 1. Other Books You May Enjoy Index

Index

A

  • administrative area archive
    • URL / Getting ready
  • advanced map-algebra operations
    • performing / Performing advanced map-algebra operations, How to do it...
  • arbitrary 3D objects
    • creating, for PostGIS / Creating arbitrary 3D objects for PostGIS, How to do it...
  • A star (A*)
    • shortest path, searching / Loading data from OpenStreetMap and finding the shortest path using A*, How to do it..., How it works...
    • about / How it works...
    • reference / How it works...
  • automatic administrative interface / How it works...

B

  • backups
    • reference / How it works...
  • Barman
    • URL / How it works...
  • batch import/export
    • handling, of datasets / Handling batch importing and exporting of datasets, How to do it..., How it works...
  • Bucardo
    • URL / How it works...
  • building footprints
    • extruding, with ST_Extrude / Using ST_Extrude to extrude building footprints, How to do it...
  • buildings 2.5 D
    • constructing / Constructing and serving buildings 2.5D, Getting ready, How to do it...
    • serving / Constructing and serving buildings 2.5D, Getting ready, How to do it...
  • Bundler
    • URL / Creating arbitrary 3D objects for PostGIS

C

  • California Albers (SRID 3310) / How to do it...
  • centerlines
    • extracting, of polygons / Extracting the centerlines of polygons, How to do it..., There's more...
  • cities shapefile
    • URL / Getting ready, Getting ready
  • clustering
    • for efficiency / Clustering for efficiency, How to do it..., How it works...
    • about / Clustering for efficiency
  • clusters
    • creating, from set of points / Creating a fixed number of clusters from a set of points, How to do it...
  • CMake
    • URL / Startup – Dijkstra routing, Getting ready
  • Colombian open data
    • URL / Getting ready
  • Comma Separated Values (CSV) file / Importing nonspatial tabular data (CSV) using PostGIS functions
  • common attribute
    • used, for merging polygons / Merging polygons using a common attribute, How to do it...
  • common table expressions (CTEs) / How to do it..., How to do it...
  • computer vision
    • about / Creating arbitrary 3D objects for PostGIS
    • reference / Creating arbitrary 3D objects for PostGIS
  • Coordinate Reference Systems (CRS) / How to do it...
  • correct data privilege mechanism
    • setting up / Setting up the correct data privilege mechanism, How to do it..., How it works...
  • Coverage / Introduction
  • CSV OGR driver
    • URL / How to do it...

D

  • 3D queries
    • performing, on LiDAR point cloud / Performing 3D queries on a LiDAR point cloud, How to do it...
  • 3D TIN
    • creating / UAV photogrammetry in PostGIS – DSM creation, How to do it...
  • data
    • importing/exporting, with ogr2ogr GDAL command / Importing and exporting data with the ogr2ogr GDAL command, How to do it..., See also
    • exporting to shapefile, with pgsql2shp PostGIS command / Exporting data to a shapefile with the pgsql2shp PostGIS command, How it works...
    • loading, from OpenStreetMap (OSM) / Loading data from OpenStreetMap and finding the shortest path using A*, How to do it..., How it works...
  • database
    • organizing / Organizing the database, How to do it...
    • backing up / Backing up the database, How to do it..., How it works...
  • Database Manager (DB Manager) plugin
    • about / Introduction
    • using, in QGIS / Using the Database Manager plugin – QGIS, Getting ready, How to do it..., How it works...
  • database queries
    • executing, in OpenJUMP GIS / Running database queries – OpenJUMP GIS, How to do it..., How it works...
  • datasets
    • batch import/export, handling / Handling batch importing and exporting of datasets, How to do it..., How it works...
  • demographics
    • driving distance, calculating / Calculating the driving distance with demographics, How to do it...
  • DEM operations
    • executing / Executing DEM operations, How to do it...
  • digital elevation model (DEM) / Executing DEM operations
  • Dijkstra's algorithm
    • used, for pgRouting / Startup – Dijkstra routing, Getting ready, How to do it...
    • reference / How to do it...
    • about / How to do it...
  • distances
    • measuring / Measuring distances, How to do it...
  • Django
    • about / Developing web applications with GeoDjango – part 1
    • URL / Getting ready
    • using / How it works...
  • Django template language
    • using / Developing web applications with GeoDjango – part 2
    • URL / How it works...
  • Django URL Dispatcher / How it works...
  • docker
    • URL / Getting ready
  • Docker Community Edition (CE) version / Getting ready
  • docker container / Getting ready
  • Douglas-Peucker algorithm
    • about / How to do it...
    • reference / How it works...
  • driving distance
    • calculating / Calculating the driving distance/service area, How to do it...
    • calculating, with demographics / Calculating the driving distance with demographics, How to do it...

E

  • Earth Observing System Data and Information System (EOSDIS) / Creating a WMS Time service with MapServer
  • Earth System Research Laboratory (ESRL) / Getting ready
  • Eclipse / Adding PostGIS layers – uDig
  • error tolerance / How to do it...
  • ESRL CPC Soil Moisture data repository
    • URL / Getting ready
  • European Forest Fire Information System (EFFIS)
    • URL / Getting ready
  • Exchangeable Image File Format (EXIF) / Getting ready
  • EXIF tags / Getting ready
  • exponential moving average (EMA) / Adding noise to protect location data
  • external functions
    • reference / Getting started

F

  • Fiona
    • about / Introduction
    • URL / Introduction
  • footprints
    • building, from LiDAR / Detailed building footprints from LiDAR, How to do it..., How it works...
  • functional index / How to do it...

G

  • GDAL/OGR Python bindings
    • reference / Writing PostGIS vector data with OGR Python bindings
  • GDAL Python bindings
    • reference / How it works...
  • GDAL VRT
    • rasters, loading / Processing and loading rasters with GDAL VRT, How to do it..., How it works...
    • rasters, processing / Processing and loading rasters with GDAL VRT, How to do it..., How it works...
  • gdalwarp GDAL command
    • used, for exporting rasters / Exporting rasters with the gdal_translate and gdalwarp GDAL commands, How to do it...
    • URL / See also
  • gdal_translate command
    • used, for exporting rasters / Exporting rasters with the gdal_translate and gdalwarp GDAL commands, How to do it...
    • URL / See also
  • Generalitat Valenciana (gv) / Adding PostGIS layers – gvSIG
  • geocoding
    • performing, with GeoNames datasets / Geocoding and reverse geocoding using the GeoNames datasets, How to do it..., How it works...
    • about / Geocoding and reverse geocoding using the GeoNames datasets
    • performing with trigram, OSM datasets used / Geocoding using the OSM datasets with trigrams, Getting ready, How to do it..., How it works...
    • with geopy and PL/Python language / Geocoding with geopy and PL/Python, How to do it...
  • GeoDjango
    • back office, developing for web application / Developing web applications with GeoDjango – part 1, How to do it..., How it works...
    • front office, developing for web application / Developing web applications with GeoDjango – part 2, How to do it..., How it works...
  • GeoDjango library / How it works...
  • geographical query results
    • redundancy, creating / Creating redundancy in geographical query results, How to do it..., How it works...
  • Geography Markup Language (GML) / How to do it...
  • geography spatial data type / How it works...
  • GeoJSON
    • URL / Getting ready
  • geometries
    • simplifying / Simplifying geometries, How to do it..., How it works...
    • clipping, for data deployment / Clipping geometries to deploy data
    • simplifying, with PostGIS topology / Simplifying geometries with PostGIS topology, How to do it..., How it works...
    • rotating / Rotating geometries, How it works..., Translating, scaling, and rotating geometries – advanced, How to do it..., How it works...
    • translating / Translating, scaling, and rotating geometries – advanced, How to do it..., How it works...
    • scaling / Translating, scaling, and rotating geometries – advanced, How to do it..., How it works...
    • combining, with rasters for analysis / Combining geometries with rasters for analysis, How to do it...
    • and rasters, converting between / Converting between rasters and geometries, How to do it...
  • geometry column
    • populating, with triggers / Using triggers to populate the geometry column, How to do it..., There's more..., Extending further...
  • GeoNames
    • URL / Writing PostGIS vector data with OGR Python bindings
  • GeoNames dataset
    • URL / Getting ready
  • geopy
    • reference / Introduction
    • URL / Geocoding with geopy and PL/Python
    • about / Geocoding with geopy and PL/Python
  • GeoServer
    • WMS service, creating / Creating WMS and WFS services with GeoServer, How to do it...
    • WFS service, creating / Creating WMS and WFS services with GeoServer, How to do it..., How it works...
    • URL / Getting ready, See also
  • Geospatial Data Abstraction Library (GDAL)
    • about / Importing nonspatial tabular data (CSV) using GDAL, Introduction
    • used, for importing nonspatial tabular data (CSV) / Importing nonspatial tabular data (CSV) using GDAL, How to do it..., How it works...
    • URL / See also
    • reference / Introduction
    • and Python, used for importing NetCDF datasets / Importing NetCDF datasets with Python and GDAL, How to do it..., How it works...
  • geospatial sharding
    • about / Geospatial sharding
    • performing / How to do it..., How it works...
  • geospatial views
    • using / Using geospatial views, How to do it...
    • ST_MakePoint function, wrapping / There's more...
  • GIS analysis
    • with spatial joins / GIS analysis with spatial joins, Getting ready, How to do it..., How it works...
  • global earthquakes dataset
    • URL / Getting ready
  • GPS data
    • working with / Working with GPS data, How to do it..., How it works...
  • GPX GDAL driver
    • using / How it works...
    • URL / How it works...
  • graph structure / How to do it...
  • GUI tools
    • used, for managing data / There's more...
  • gvSIG
    • PostGIS layers, adding / Adding PostGIS layers – gvSIG, How to do it..., How it works...
    • about / Adding PostGIS layers – gvSIG
    • URL / Getting ready

I

  • imports
    • normalizing / Normalizing imports, Getting ready, How to do it..., How it works..., There's more...
  • indexes
    • using / Using indexes, How to do it..., How it works...
    • reference / How it works...
  • internal overlays
    • normalizing / Normalizing internal overlays, How to do it..., How it works...
    • foreign key, using for referential integrity / There's more...
  • Internet Information Server (IIS) / How it works...
  • intersections
    • computing / Computing intersections, How to do it..., How it works...
  • invalid geometries
    • fixing / Fixing invalid geometries, How to do it..., How it works...

J

  • Java Unified Mapping Platform (JUMP) / Adding PostGIS layers – OpenJUMP GIS
  • Java Virtual Machine (JVM) / Getting ready
  • JSON format
    • reference / Writing PostGIS vector data with Psycopg
    • using / How it works...

K

  • k-Nearest Neighbor (KNN)
    • about / Improving proximity filtering with KNN
    • proximity filtering, improving / Improving proximity filtering with KNN, How to do it..., Improving proximity filtering with KNN – advanced, Getting ready, How it works...
    • reference / How it works..., How to do it...

L

  • LASer (LAS) format / Importing LiDAR data
  • Leaflet
    • WMS service, consuming / Consuming WMS services with Leaflet, How to do it..., How it works...
    • about / Consuming WMS services with Leaflet, Developing web applications with GeoDjango – part 1
  • LiDAR data
    • importing / Importing LiDAR data, Getting ready, How to do it...
  • LiDAR point cloud
    • 3D queries, performing / Performing 3D queries on a LiDAR point cloud, How to do it...
  • Light Detection And Ranging (LiDAR)
    • footprints, building / Detailed building footprints from LiDAR, How to do it..., How it works...
    • about / Importing LiDAR data
  • location data protection
    • with noise addition / Adding noise to protect location data, Getting ready, How to do it..., How it works...
  • location privacy / Definition of Location Privacy Protection Mechanisms – LPPMs
  • Location Privacy Protection Mechanisms (LPPMs)
    • about / Definition of Location Privacy Protection Mechanisms – LPPMs
    • classifying / Classifying LPPMs

M

  • map-algebra operations
    • performing / Performing simple map-algebra operations, How to do it...
  • Mapbox
    • web GPX viewer, developing / Developing a web GPX viewer with Mapbox, How to do it..., How it works...
    • URL / Developing a web GPX viewer with Mapbox
  • mapfile
    • URL / See also
  • MaPIR / How it works...
  • MapServer
    • WMS service, creating / Creating WMS and WFS services with MapServer, Getting ready, How to do it..., How it works...
    • WFS service, creating / Creating WMS and WFS services with MapServer, Getting ready, How to do it..., How it works...
    • URL / Getting ready, See also
    • WMS Time service, creating / Creating a WMS Time service with MapServer, How to do it..., How it works...
  • MeshLab
    • references / How to do it...
    • URL / How to do it...
  • models
    • exporting, as X3D for web / Exporting models as X3D for the web, How to do it..., There's more...
  • MODIS Sinusoidal projection / How to do it...
  • MS4W
    • URL / Getting ready
  • multiple rasters
    • importing / Importing multiple rasters at a time, How to do it...

N

  • NetCDF datasets
    • importing, with Python and GDAL / Importing NetCDF datasets with Python and GDAL, How to do it..., How it works...
    • about / Importing NetCDF datasets with Python and GDAL
  • NetCDF GDAL driver
    • URL / How to do it...
  • noise
    • adding, for location data protection / Adding noise to protect location data, Getting ready, How to do it..., How it works...
  • Nomenclature des Units Territoriales Statistiques (NUTS) / Merging polygons using a common attribute
  • nonspatial tabular data (CSV)
    • importing, with PostGIS functions / Importing nonspatial tabular data (CSV) using PostGIS functions, How to do it..., How it works...
    • importing, with GDAL / Importing nonspatial tabular data (CSV) using GDAL, How to do it..., How it works...
  • Normalized Difference Vegetation Index (NDVI) / Performing advanced map-algebra operations
  • NumPy
    • URL / Importing NetCDF datasets with Python and GDAL

O

  • ogr2ogr GDAL command
    • URL / How it works...
    • -where option / How it works...
    • -t_srs option / How it works...
    • -lco layer creation option / How it works...
    • used, for importing/exporting data / Importing and exporting data with the ogr2ogr GDAL command, How to do it..., See also
  • OGR dataset / How it works...
  • OGR OSM driver
    • URL / Getting ready
  • OGR PostGIS driver
    • URL / How it works...
  • OGR Python bindings
    • used, for writing PostGIS vector data / Writing PostGIS vector data with OGR Python bindings, How to do it..., How it works...
  • OGR virtual format
    • about / Importing nonspatial tabular data (CSV) using GDAL, How it works...
    • reference / How it works...
  • Open Database License (ODbL) / How it works...
  • Open Geospatial Consortium (OGC) / How it works...
  • OpenJUMP
    • URL / Adding PostGIS layers – OpenJUMP GIS
    • reference / Adding PostGIS layers – OpenJUMP GIS
  • OpenJUMP GIS
    • PostGIS layers, adding / Adding PostGIS layers – OpenJUMP GIS, How to do it..., How it works...
    • database queries, executing / Running database queries – OpenJUMP GIS, How to do it..., How it works...
  • OpenLayers
    • WMS service, consuming / Consuming WMS services with OpenLayers, How to do it..., How it works..
    • URL / How it works..
    • Transactional Web Feature Service (WFS-T) service, consuming / Consuming WFS-T services with OpenLayers, How to do it..., How it works...
  • OpenStreetMap (OSM)
    • data importing, with osm2pgsql command / Importing OpenStreetMap data with the osm2pgsql command, How to do it..., How it works...
    • URL, for dataset / How to do it...
    • about / How it works..., Loading data from OpenStreetMap and finding the shortest path using A*
    • data, loading / Loading data from OpenStreetMap and finding the shortest path using A*, How to do it..., How it works...
    • URL / Getting ready
  • OSGeo4W
    • installing / Getting ready
    • URL / Getting ready, Introduction, Getting ready
    • about / Introduction
  • osm2pgrouting
    • URL / Getting ready
    • URL, for Linux Ubuntu / Getting ready
    • about / How it works...
  • osm2pgsql command
    • URL / Getting ready
  • OSM datasets
    • used, for performing geocoding with trigram / Geocoding using the OSM datasets with trigrams, Getting ready, How to do it..., How it works...

P

  • PDAL library
    • references / Getting ready
  • pg-rman
    • URL / How it works...
  • pgAdminIII / Getting ready
  • Pgpool-II
    • URL / How it works...
  • pgRouting
    • about / Introduction
    • with Dijkstra's algorithm / Startup – Dijkstra routing, Getting ready, How to do it...
    • URL / Startup – Dijkstra routing
    • URL, for macOS / Startup – Dijkstra routing
    • URL, for Linux Ubuntu / Startup – Dijkstra routing
  • pgsql2shp PostGIS command
    • data, exporting to shapefile / Exporting data to a shapefile with the pgsql2shp PostGIS command, How it works...
  • photo series
    • reference / Getting ready
  • pip tool
    • URL / Introduction, Getting ready
  • PL/Python language
    • used, for writing PostGIS functions / Writing PostGIS functions with PL/Python, How to do it...
    • and geopy, used for geocoding / Geocoding with geopy and PL/Python, How to do it...
  • pointcloud extension
    • reference / Introduction
  • points
    • fixed number of clusters, creating / Creating a fixed number of clusters from a set of points, How to do it...
  • polygon overlays
    • using, for proportional census estimates / Using polygon overlays for proportional census estimates, Getting ready, How to do it...
  • polygons
    • merging, with common attribute / Merging polygons using a common attribute, How to do it...
    • centerlines, extracting / Extracting the centerlines of polygons, How to do it..., There's more...
  • PosgtreSQL
    • parallelizing / Paralellizing in PosgtreSQL, How to do it..., How it works...
  • PostGIS
    • arbitrary 3D objects, creating / Creating arbitrary 3D objects for PostGIS, How to do it...
  • PostGIS 3D
    • UAV image footprints, reconstructing / Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D, Getting started, How to do it...
  • PostGIS database
    • migrating, to different server / Migrating a PostGIS database to a different server, How to do it..., How it works...
    • replicating, with streaming replication / Replicating a PostGIS database with streaming replication, How to do it..., How it works...
  • PostGIS driver
    • reference / See also
  • PostGIS functions
    • used, for importing nonspatial tabular data (CSV) / Importing nonspatial tabular data (CSV) using PostGIS functions, How to do it..., How it works...
  • PostGIS layers
    • adding, in QGIS / Adding PostGIS layers – QGIS, How to do it..., How it works...
    • adding, in OpenJUMP GIS / Adding PostGIS layers – OpenJUMP GIS, How to do it..., How it works...
    • adding, in gvSIG / Adding PostGIS layers – gvSIG, How to do it..., How it works...
    • adding, in uDig / Adding PostGIS layers – uDig, How to do it..., How it works...
  • PostGIS topology
    • used, for simplifying geometries / Simplifying geometries with PostGIS topology, How to do it..., How it works...
  • PostGIS vector data
    • writing, with OGR Python bindings / Writing PostGIS vector data with OGR Python bindings, How to do it..., How it works...
  • Postgres-XC
    • URL / How it works...
  • PRISM average monthly minimum-temperature raster dataset
    • URL / How to do it...
  • Private Information Retrieval (PIR) / Creating redundancy in geographical query results
  • Prj2EPSG
    • URL / How it works...
  • proactive location-based services (PLBS) / Classifying LPPMs
  • PROJ.4
    • URL / Getting ready
  • proportional census estimates
    • with polygon overlays / Using polygon overlays for proportional census estimates, Getting ready, How to do it...
  • proximity filtering
    • improving, with k-Nearest Neighbor (KNN) / Improving proximity filtering with KNN, How to do it..., Improving proximity filtering with KNN – advanced, Getting ready, How it works...
  • psql / Getting ready
  • Psycopg
    • about / Introduction, How it works...
    • URL / Introduction
    • used, for writing PostGIS vector data / Writing PostGIS vector data with Psycopg, How to do it..., How it works...
  • public schema / Organizing the database
  • pyproj
    • about / Introduction
    • URL / Introduction
  • Python
    • reference / Introduction
    • and GDAL, used for importing NetCDF datasets / Importing NetCDF datasets with Python and GDAL, How to do it..., How it works...

Q

  • Quantum GIS (QGIS)
    • about / Adding PostGIS layers – QGIS
    • URL / Adding PostGIS layers – QGIS
    • PostGIS layers, adding / Adding PostGIS layers – QGIS, How to do it..., How it works...
    • Database Manager (DB Manager) plugin, using / Using the Database Manager plugin – QGIS, Getting ready, How to do it..., How it works...

R

  • R-tree
    • reference / How it works...
  • Raster / Introduction
  • raster data
    • importing, with raster2pgsql PostGIS command / Importing raster data with the raster2pgsql PostGIS command, How to do it..., How it works...
    • URL, for dataset / Getting ready
    • exporting, with gdalwarp GDAL command / Exporting rasters with the gdal_translate and gdalwarp GDAL commands, How to do it...
    • exporting, with gdal_translate command / Exporting rasters with the gdal_translate and gdalwarp GDAL commands, How to do it...
  • Rasterio
    • about / Introduction
    • URL / Introduction
  • rasters
    • loading / Getting and loading rasters, How to do it..., How it works...
    • obtaining / Getting and loading rasters, How to do it..., How it works...
    • basic information, exploring / Working with basic raster information and analysis, How to do it..., How it works...
    • analyzing / Working with basic raster information and analysis, How to do it..., How it works...
    • geometries, combining for analysis / Combining geometries with rasters for analysis, How to do it...
    • and geometries, converting between / Converting between rasters and geometries, How to do it...
    • processing, with GDAL VRT / Processing and loading rasters with GDAL VRT, How to do it..., How it works...
    • loading, with GDAL VRT / Processing and loading rasters with GDAL VRT, How to do it..., How it works...
    • warping / Warping and resampling rasters, How to do it..., How it works...
    • resampling / Warping and resampling rasters, How to do it..., How it works...
    • sharing, through SQL / Sharing and visualizing rasters through SQL, How to do it..., How it works...
    • visualizing, through SQL / Sharing and visualizing rasters through SQL, How to do it..., How it works...
  • reactive location-based services (RLBS) / Classifying LPPMs
  • redundancy
    • creating, in geographical query results / Creating redundancy in geographical query results, How to do it..., How it works...
  • requests / Introduction
  • resampling algorithm / How to do it...
  • reverse geocoding
    • performing, with GeoNames datasets / Geocoding and reverse geocoding using the GeoNames datasets, How to do it..., How it works...
    • about / Geocoding and reverse geocoding using the GeoNames datasets
  • rivers dataset
    • URL / Getting ready
  • roles / Setting up the correct data privilege mechanism
  • Rtree
    • about / Introduction
    • URL / Introduction
  • RunKeeper / Working with GPS data

S

  • San Francisco shapefile
    • URL / How to do it...
  • Secure Coprocessors (SCs) / Creating redundancy in geographical query results
  • service area
    • calculating / How to do it...
  • shapefile
    • importing, with shp2pgsql / Importing shapefiles with shp2pgsql, How to do it..., There's more...
    • data, exporting with pgsql2shp PostGIS command / Exporting data to a shapefile with the pgsql2shp PostGIS command, How it works...
    • about / Normalizing imports
  • Shapely
    • about / Introduction
    • URL / Introduction
  • shortest path
    • searching, with A star (A*) / Loading data from OpenStreetMap and finding the shortest path using A*, How to do it..., How it works...
  • shp2pgsql tool / Getting ready
  • Shuttle Radar Topography Mission (SRTM) raster
    • URL / How to do it...
  • simplejson / Introduction
  • simplification algorithms / Simplifying geometries
  • Slony-I
    • URL / How it works...
  • spatial data
    • structuring, with table inheritance / Structuring spatial data with table inheritance, Getting ready, How to do it..., How it works...
  • spatial indexes
    • URL / Improving proximity filtering with KNN
  • spatial joins
    • for GIS analysis / GIS analysis with spatial joins, Getting ready, How to do it..., How it works...
  • spatial reference system / How it works...
  • spatial reference system identifier (SRID)
    • about / How it works..., How it works...
    • URL, for tools / How it works...
  • SQL
    • rasters, sharing through / Sharing and visualizing rasters through SQL, How to do it..., How it works...
    • rasters, visualizing through / Sharing and visualizing rasters through SQL, How to do it..., How it works...
  • SQL query
    • ST_Transform() method / How to do it...
    • ST_Intersects() method / How to do it...
    • ST_Clip() method / How to do it...
    • ST_Union() method / How to do it...
    • optimizing / Optimizing SQL queries, How to do it..., How it works...
  • standard constraints, rules
    • width and height / How to do it...
    • scale X and Y / How to do it...
    • SRID / How to do it...
    • same alignment / How to do it...
    • maximum extent / How to do it...
    • number of bands / How to do it...
    • NODATA values / How to do it...
    • out-db / How to do it...
    • pixel type / How to do it...
  • states shapefile
    • URL / Getting ready
  • streaming replication
    • PostGIS database, replicating / Replicating a PostGIS database with streaming replication, How to do it..., How it works...
  • Structure from Motion (SfM) / Introduction, Creating arbitrary 3D objects for PostGIS
  • Styled Layer Descriptor (SLD) / How to do it...
  • ST_Extrude
    • used, for extruding building footprints / Using ST_Extrude to extrude building footprints, How to do it...
  • ST_MakeLine function
    • about / How it works...
    • URL / How it works...
  • ST_Polygonize
    • improving / Improving ST_Polygonize, How to do it...
  • Sublime Text / How to do it...

T

  • table inheritance
    • spatial data, structuring / Structuring spatial data with table inheritance, Getting ready, How to do it..., How it works...
  • table partitioning / Extending inheritance – table partitioning, How to do it..., How it works...
  • Tile / Introduction
  • Tis-Bad[8] / Adding noise to protect location data
  • Transactional Web Feature Service (WFS-T) service
    • consuming, with OpenLayers / Consuming WFS-T services with OpenLayers, How to do it..., How it works...
  • triangular irregular network (TIN) / Getting started
  • triggers
    • used, for populating geometry column / Using triggers to populate the geometry column, How to do it..., There's more...
    • for column updates / Extending further...
  • trigram
    • OSM datasets, used for performing geocoding / Geocoding using the OSM datasets with trigrams, Getting ready, How to do it..., How it works...
    • about / Geocoding using the OSM datasets with trigrams

U

  • U.S. Census Bureau data
    • URL / Getting ready
  • UAV image footprints
    • reconstructing, with PostGIS 3D / Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D, Getting started, How to do it...
  • UAV photogrammetry
    • UAV-derived point cloud, creating / UAV photogrammetry in PostGIS – point cloud, How to do it...
    • UAV-derived point cloud, importing / UAV photogrammetry in PostGIS – point cloud, How to do it...
    • 3D TIN, creating / UAV photogrammetry in PostGIS – DSM creation, How to do it...
  • Unmanned Aerial Systems (UAS) / Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D
  • Unmanned Aerial Vehicle (UAV) / Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D
  • USA counties shapefile
    • URL / Getting ready, Getting ready
  • User-friendly Desktop Internet GIS (uDig)
    • PostGIS layers, adding / Adding PostGIS layers – uDig, How to do it..., How it works...
  • US National Atlas Equal Area (SRID 2163) / How to do it...

V

  • virtualenv
    • URL / Introduction, Getting ready
    • reference / Getting ready
  • Virtual Reality Modeling Language (VRML) / Exporting models as X3D for the web
  • VisualSFM
    • URL / Creating arbitrary 3D objects for PostGIS, How to do it..., Getting ready
  • Voronoi diagrams
    • calculating / Calculating Voronoi diagrams, Getting ready, How to do it...
    • reference / Calculating Voronoi diagrams

W

  • WAR (web archive) / Getting ready
  • weather data
    • URL / Writing PostGIS vector data with Psycopg
  • web
    • models, exporting as X3D / Exporting models as X3D for the web, How to do it..., There's more...
  • web application
    • back office, developing with GeoDjango / Developing web applications with GeoDjango – part 1, How to do it..., How it works...
    • front office, developing with GeoDjango / Developing web applications with GeoDjango – part 2, How to do it..., How it works...
  • Web Feature Service (WFS) service
    • creating, with MapServer / Creating WMS and WFS services with MapServer, Getting ready, How to do it..., How it works...
    • reference / See also
    • creating, with GeoServer / Creating WMS and WFS services with GeoServer, How to do it..., How it works...
  • web GPX viewer
    • developing, with Mapbox / Developing a web GPX viewer with Mapbox, How to do it..., How it works...
  • Web Graphics Library (WebGL)
    • about / Exporting models as X3D for the web
    • reference / Exporting models as X3D for the web
  • Web Map Service (WMS) service
    • creating, with MapServer / Creating WMS and WFS services with MapServer, Getting ready, How to do it..., How it works...
    • reference / See also
    • creating, with GeoServer / Creating WMS and WFS services with GeoServer, How to do it..., How it works...
    • consuming, with OpenLayers / Consuming WMS services with OpenLayers, How to do it..., How it works..
    • consuming, with Leaflet / Consuming WMS services with Leaflet, How to do it..., How it works...
  • WFS requests
    • GetCapabilities / How it works...
    • GetFeature / How it works...
  • Wikipedia Fulltext Search
    • URL / Writing PostGIS vector data with OGR Python bindings
  • WMS requests
    • GetCapabilities / How it works...
    • GetMap / How it works...
    • GetFeatureInfo / How it works...
  • WMS Time service
    • creating, with MapServer / Creating a WMS Time service with MapServer, How to do it..., How it works...
  • world countries shapefile
    • URL / Getting ready, Getting ready

X

  • X3D
    • models, exporting for web / Exporting models as X3D for the web, How to do it..., There's more...
    • about / Exporting models as X3D for the web
lock icon The rest of the chapter is locked
arrow left Previous Chapter
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}