Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Arrow up icon
GO TO TOP
PostGIS Cookbook

You're reading from   PostGIS Cookbook For web developers and software architects this book will provide a vital guide to the tools and capabilities available to PostGIS spatial databases. Packed with hands-on recipes and powerful concepts

Arrow left icon
Product type Paperback
Published in Jan 2014
Publisher
ISBN-13 9781849518666
Length 484 pages
Edition Edition
Languages
Tools
Arrow right icon
Toc

Table of Contents (18) Chapters Close

PostGIS Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
1. Moving Data In and Out of PostGIS FREE CHAPTER 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 Index

Index

A

  • A*
    • about / How it works...
  • AddGeometryColumn function / How it works...
  • Add PostGIS Layers icon / How to do it...
  • Add sighting button / How to do it...
  • AddWeatherStation method / How it works...
  • advanced map-algebra operations
    • performing / Performing advanced map-algebra operations, How to do it..., How it works...
  • alphashape function / How to do it...
  • ampersand (&) / Getting ready
  • analysis
    • working with / Getting ready, How to do it..., How it works...
  • arbitrary 3D objects
    • creating, for PostGIS / Creating arbitrary 3D objects for PostGIS
  • automatic administrative interface / How it works...

B

  • Barman
    • URL / How it works...
  • basic raster information
    • working with / Working with basic raster information and analysis, How to do it..., How it works...
  • batch dataset export
    • handling / Handling batch importing and exporting of datasets, Getting ready, How to do it..., How it works...
  • batch dataset import
    • handling / Handling batch importing and exporting of datasets, Getting ready, How to do it..., How it works...
  • Bucardo / How it works...

C

  • clustering
    • about / Clustering for efficiency, How to do it...
  • Comma Separated Values (CSVs) / How to do it...
  • common attribute
    • used, for merging polygons / Merging polygons using a common attribute, How to do it..., How it works...
  • Common Table Expression (CTE)
    • about / How to do it...
  • Common Table Expressions (CTEs) / How to do it...
  • correct data privilege mechanism
    • about / Setting up the correct data privilege mechanism
    • setting up / How to do it...
    • working / How it works...
  • coverage / Introduction
  • CreateFeature method / How it works...
  • CreateGeometryFromWkt method / How it works...
  • CreateLayer method / How it works...
  • CRS (Coordinate Reference Systems) / How to do it...
  • CRUD GIS web application / Introduction
  • CSV
    • about / Importing nonspatial tabular data (CSV) using PostGIS functions
  • Cuyahoga Country Road Network
    • diagram / How to do it...

D

  • 2D polygons of building footprints
    • extruding, as 3D / Constructing and serving buildings 2.5 D, Getting ready, How to do it...
  • 3D queries
    • performing, on LiDAR point cloud / How to do it...
  • 3D TIN
    • creating / UAV photogrammetry in PostGIS – DSM creation
  • data
    • exporting, to shapefile with pgsql2shp PostGIS command / Exporting data to the shapefile with the pgsql2shp PostGIS command, How to do it..., How it works...
    • loading, from OSM / Loading data from OpenStreetMap and finding the shortest path using A*
  • database
    • organizing / Organizing the database, How to do it..., How it works...
    • backing up / Backing up the database, How to do it..., How it works...
  • database index
    • about / Using indexes, How to do it...
    • working / How it works...
  • database queries
    • running / How to do it..., How it works...
  • data deployment
    • geometries, clipping for / Clipping geometries to deploy data, How to do it..., How it works...
  • DataType property / How it works...
  • DB Manager plugin
    • using / Using the Database Manager plugin – QGIS, Getting ready, How to do it...
    • working / How it works...
  • demographics
    • used, for driving distance calculation / Calculating demographics using driving distance, How to do it...
  • DEM operations
    • executing / Executing DEM operations, How to do it..., How it works...
  • Dijkstra
    • routing / Startup – Dijkstra routing, Getting ready, How to do it...
    • using / How to do it...
  • distance/service area calculation
    • driving / Driving distance/service area calculation, How to do it...
  • distances
    • measuring / Measuring distances, How to do it..., How it works...
  • django-admin command / How to do it...
  • Django template language
    • about / Developing web applications with GeoDjango – part 2
  • Django Template language
    • URL / How it works...
  • Django URL Dispatcher / How it works...
  • Django web framework / Introduction
  • driving distance
    • calculating, with demographics / Calculating demographics using driving distance, How to do it...

E

  • Editing Toolbox button / How to do it...
  • Enhanced Vegetation Index (EVI) / Performing advanced map-algebra operations
  • EOSDIS (Earth Observing System Data and Information System) / Getting ready
  • error tolerance / How to do it...
  • European Forest Fire Information System (EFFIS) / Getting ready
  • European Petroleum Survey Group (EPSG) / How it works...
  • EVI / Getting ready
  • Exchangeable Image File format (EXIF) / Getting ready
  • external scripts
    • used, for functionality embedding / Using external scripts to embed new functionality in order to calculate a Voronoi diagram, Getting ready, How to do it...
    • used, for other library embedding / Using external scripts to embed other libraries in order to calculate a Voronoi diagram – advanced, How to do it..., There's more...
    • test table, preparing / Step zero – preparing the test table
    • input text, preparing / Step one – preparing the input text
    • results, returning / Step two – returning results
    • bundling, as function / Step three – bundling as a function
    • translating, into geometry / Step four – translating into geometry

F

  • Fence tool / How it works...
  • Find_PlaceNames function / How it works...
  • functional index / How to do it...

G

  • .gpx file
    • about / Working with GPS data
  • GDAL
    • used, for nonspatial tabular data (CSV) import / Importing nonspatial tabular data (CSV) using GDAL, Getting ready, How to do it..., How it works...
    • about / Importing nonspatial tabular data (CSV) using GDAL
    • used, for netCDF datasets import / Getting ready, How to do it..., How it works...
  • gdalbuildvrt command / Importing multiple rasters at a time
  • gdalbuildvrt utility / How it works...
  • gdalinfo command / How to do it...
  • gdalinfo command-line utility / Importing raster data with the raster2pgsql PostGIS command
  • GDAL OGR virtual format / Importing nonspatial tabular data (CSV) using GDAL
  • GDAL Python bindings / Introduction
  • GDAL utilities
    • gdalinfo / Introduction
    • gdalbuildvrt / Introduction
    • gdal_translate / Introduction
  • GDAL VRT format / Getting ready
  • gdalwarp GDAL command
    • used, for raster exporting / Exporting rasters with the gdal_translate and gdalwarp GDAL commands, How to do it..., See also
  • gdal_translate command
    • used, for raster exporting / Exporting rasters with the gdal_translate and gdalwarp GDAL commands, How to do it..., See also
  • geocode method / How it works...
  • geocoding
    • GeoNames datasets, using / Geocoding and reverse-geocoding using the GeoNames datasets, Getting ready, How to do it..., How it works...
    • OSM datasets, using with trigrams / Geocoding using the OSM datasets with trigrams, How to do it..., How it works...
    • with geopy / Geocoding with geopy and PL/Python, How to do it..., How it works...
  • GeoDB tab / How to do it...
  • GeoDjang
    • used, for web applications development / Developing web applications with GeoDjango – part 1, Getting ready, How to do it..., How it works..., Getting ready, How to do it..., How it works...
  • GeoDjango library / Introduction, How it works...
  • geography spatial data type
    • about / How it works...
  • geometries
    • simplifying / Simplifying geometries, How to do it..., How it works...
    • clipping, for data deployment / Clipping geometries to deploy data, How to do it..., How it works...
    • simplifying, with PostGIS topology / Simplifying geometries with PostGIS topology, How to do it..., How it works...
    • rotating / Rotating geometries, Getting ready, How it works..., Translating, scaling, and rotating geometries – advanced, Getting ready, How to do it..., How it works...
    • translating / Translating, scaling, and rotating geometries – advanced, Getting ready, How to do it..., How it works...
    • scaling / Translating, scaling, and rotating geometries – advanced, Getting ready, How to do it..., How it works...
    • combining, with rasters for analysis / Combining geometries with rasters for analysis, How to do it...
    • using / Getting ready
    • rasters, converting to / Converting between rasters and geometries, How to do it...
  • geometry column
    • populating, with triggers / Using triggers to populate a geometry column, How to do it..., Extending further...
  • GeoNames
    • URL / Writing PostGIS vector data with OGR Python bindings
    • accessing / Getting ready
  • GeoNames datasets
    • used, for geocoding / Geocoding and reverse-geocoding using the GeoNames datasets, Getting ready, How to do it..., How it works...
    • used, for reverse geocoding / Geocoding and reverse-geocoding using the GeoNames datasets, Getting ready, How to do it..., How it works...
  • geopy
    • about / Geocoding with geopy and PL/Python
    • used, for geocoding / Geocoding with geopy and PL/Python, Getting ready, How to do it...
  • GeoServer
    • about / Introduction
    • used, for WFS services creating / Creating WMS and WFS services with GeoServer, Getting ready, How to do it..., How it works...
    • used, for WMS creating / Creating WMS and WFS services with GeoServer, Getting ready, How to do it..., How it works...
  • geospatial views
    • about / Using geospatial views
    • using / How to do it..., There's more...
  • GeoTIFF format / Introduction
  • GetGeoTransform method / How it works...
  • GetRasterBand method / How it works...
  • GetSubDatasets method / How it works...
  • GetWeatherData method / How it works...
  • Get_Closest_PlaceNames function / How it works...
  • GIS analysis
    • with spatial joins / Getting ready, How to do it..., How it works...
  • GML (Geography Markup Language / How to do it...
  • GPS data
    • about / Introduction
    • working with / Working with GPS data, How to do it..., How it works...
  • GPX GDAL driver
    • about / How it works...
  • graph structure / How to do it...
  • gvSIG
    • PostGIS layers, adding to / Adding PostGIS layers – gvSIG, Getting ready, How to do it..., How it works...
    • about / Adding PostGIS layers – gvSIG
    • downloading / Adding PostGIS layers – gvSIG

H

  • -hstore option / How it works...
  • HDF5 format / Introduction

I

  • -I flag / Getting ready
  • -I option / How it works...
  • IIS / How it works...
  • imports
    • normalizing / Normalizing imports, Getting ready, How to do it..., How it works...
  • internal overlays
    • normalizing / Normalizing internal overlays, How to do it..., How it works...
    • polygons, converting to linestrings / Converting polygons to linestrings
    • linestrings, reconverting to polygons / Converting linestrings back to polygons
    • resultant polygon center points, searching / Finding center points of resultant polygons
    • tabular relationships querying, resultant points used / Using resultant points to query tabular relationships
  • intersections
    • computing / Computing intersections, How to do it..., How it works...
  • invalid geometries
    • about / Fixing invalid geometries
    • fixing / How to do it..., How it works...
  • isBaseLayer property / How to do it...

J

  • Java Virtual Machine (JVM) / Getting ready
  • JPEG format / Introduction
  • JSON format / How it works...
  • JUMP
    • about / Adding PostGIS layers – OpenJUMP GIS

K

  • .kmz file
    • about / Getting ready
  • KNN
    • about / Improving proximity filtering with KNN
    • used, for proximity filtering improvement / Improving proximity filtering with KNN, Getting ready, How to do it..., How it works..., Improving proximity filtering with KNN – advanced, Getting ready, How to do it..., How it works...

L

  • -lco layer creation option / How it works...
  • LAS / Importing LiDAR data
  • LASer / Importing LiDAR data
  • leaflet
    • about / Introduction, Consuming WMS services with Leaflet
    • used, for WMS services consuming / Consuming WMS services with Leaflet, How to do it..., How it works...
  • Leaflet JavaScript library / Developing web applications with GeoDjango – part 1
  • LiDAR
    • building footprints / Generating detailed building footprints from LiDAR, How to do it..., How it works...
    • about / Generating detailed building footprints from LiDAR, Importing LiDAR data
    • data, importing / Importing LiDAR data, Getting ready, How to do it...
  • LiDAR data
    • importing / Importing LiDAR data
  • LiDAR point cloud
    • 3D queries, performing on / Performing 3D queries on a LiDAR point cloud, How to do it...
  • linestrings
    • converting, to polygons / Converting linestrings back to polygons

M

  • Manage and Install Plugins / Getting ready
  • mapfile / How to do it...
  • MapServer
    • about / Introduction
    • used, for WFS services creating / Creating WMS and WFS services with MapServer, Getting ready, How to do it..., How it works...
    • used, for WMS creating / Creating WMS and WFS services with MapServer, Getting ready, How to do it..., How it works...
    • used, for WMS Time creating / Creating a WMS Time with MapServer, Getting ready, How to do it..., How it works...
  • models
    • exporting, as X3D / Exporting models as X3D for the Web, How to do it..., There's more...
  • Moderate Resolution Imaging Spectroradiometer (MODIS) / Getting ready
  • multiple rasters
    • importing, simultaneously / Importing multiple rasters at a time, How to do it..., How it works...

N

  • Nested Loop utility / How to do it...
  • netcdf2postgis method / How to do it...
  • netCDF datasets
    • importing, Python used / Importing netCDF datasets with Python and GDAL, How to do it..., How it works...
    • importing, GDAL used / Importing netCDF datasets with Python and GDAL, How to do it..., How it works...
  • NetCDF format / Introduction
  • New Vector Data Source page / How to do it...
  • 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, Getting ready, How to do it..., How it works...
  • Normalized Difference Vegetation Index (NDVI) / Performing advanced map-algebra operations

O

  • ogr2ogr
    • about / Introduction
  • ogr2ogr command / How to do it...
  • ogr2ogr GDAL command
    • used, for data exporting / Importing and exporting data with the ogr2ogr GDAL command, How to do it..., How it works...
    • used, for data importing / Importing and exporting data with the ogr2ogr GDAL command, How to do it..., How it works...
  • OGR dataset / How it works...
  • ogrinfo command / How to do it...
  • OGR Python bindings
    • used, for writing PostGIS vector data / Writing PostGIS vector data with OGR Python bindings, How to do it..., How it works...
  • Oil & Gas Producers (OGP) / How it works...
  • Open Data Commons Open Database License (ODbL) / How it works...
  • Open Geospatial Consortium (OGC) / How it works...
  • OpenJUMP
    • database queries, running / Running database queries – OpenJUMP GIS
  • OpenJUMP GIS
    • used, for PostGIS connecting / Adding PostGIS layers – OpenJUMP GIS, How to do it..., How it works...
  • OpenLayers / Introduction
    • used, for WMS services consuming / Consuming WMS services with OpenLayers, How to do it..., How it works...
    • used, for WFS-T consuming / Consuming WFS-T services with OpenLayers, How to do it..., How it works...
  • OpenLayers Javascript library / How to do it...
  • OpenStreetMap / Geocoding using the OSM datasets with trigrams
  • OpenStreetMap data
    • importing, osm2pgsql command used / Importing OpenStreetMap data with the osm2pgsql command, Getting ready, How to do it...
  • orthorectification
    • about / UAV photogrammetry in PostGIS – orthorectification
    • point cloud, converting to voronoi polygons / Converting the point cloud to Voronoi polygons
    • polygons, attributing with color / Attributing polygons with the color
    • polygons, rendering to raster / Rendering polygons to raster
  • OSGeo4W / Introduction
  • OSM
    • about / Loading data from OpenStreetMap and finding the shortest path using A*
    • loading from / Loading data from OpenStreetMap and finding the shortest path using A*, How it works...
    • data, loading from / Getting ready
  • osm2pgrouting / Loading data from OpenStreetMap and finding the shortest path using A*
  • osm2pgrouting command / How to do it...
  • osm2pgsql command
    • used, for OpenStreetMap data import / Importing OpenStreetMap data with the osm2pgsql command, Getting ready, How to do it..., How it works...
  • OSM datasets
    • with trigrams, used for geocoding / Geocoding using the OSM datasets with trigrams, How to do it..., How it works...
  • overview / How to do it...

P

  • @property definitions / How to do it...
  • pg-rman / How it works...
  • pgAdminIII / Getting ready
  • Pgpool-II / How it works...
  • pgRouting
    • about / Introduction
    • downloading / Startup – Dijkstra routing
  • pgr_alphaShape function / How to do it...
  • pgr_drivingdistance polygon / How to do it...
  • pgsql2shp command / How it works...
  • pgsql2shp PostGIS command
    • used, for data exporting to shapefile / Exporting data to the shapefile with the pgsql2shp PostGIS command, How to do it..., How it works...
  • pg_dump utility / How it works...
  • PL/Python
    • used, for writing PostGIS functions / Writing PostGIS functions with PL/Python, How to do it..., How it works...
    • used, for geocoding / Geocoding with geopy and PL/Python, Getting ready, How to do it...
  • PNG format / Introduction
  • point-in-polygon query
    • performing / Finding center points of resultant polygons
  • polygon centerlines
    • extracting / Extracting the centerlines of polygons, How to do it..., There's more...
  • polygonize_to_multi function / How to do it...
  • polygon overlays
    • used, for proportional census estimating / Using polygon overlays for proportional census estimates, Getting ready, How to do it...
  • polygons
    • converting, to linestrings / Converting polygons to linestrings
    • merging, common attribute used / Merging polygons using a common attribute, How to do it..., How it works...
  • polygon_to_line function / Converting polygons to linestrings
  • PostGIS / Executing DEM operations
    • 3D capabilities / Introduction
    • arbitrary 3D objects, creating for / Creating arbitrary 3D objects for PostGIS, How to do it...
    • layers, adding / Adding PostGIS layers – QGIS
  • PostGIS 3D
    • used, for UAV image footprint reconstruction / Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D, Getting ready, How to do it...
  • PostGIS database
    • migrating, to different server / Migrating a PostGIS database to a different server, How to do it...
    • replicating, streaming replication used / Replicating a PostGIS database with streaming replication, How to do it...
  • PostGIS functions
    • used, for nonspatial tabular data (CSV) import / Getting ready, How to do it..., How it works...
    • writing, with PL/Python / Writing PostGIS functions with PL/Python, How to do it..., How it works...
  • PostGIS layers
    • adding, to QGIS / Adding PostGIS layers – QGIS, How to do it..., How it works...
    • adding, to OpenJUMP GIS / Adding PostGIS layers – OpenJUMP GIS, Getting ready, How to do it..., How it works...
    • adding, to gvSIG / Adding PostGIS layers – gvSIG, How to do it..., How it works...
    • adding, to uDig / Adding PostGIS layers – uDig, How to do it...
  • PostGIS programs
    • writing / Introduction
    • writing, Linux used / Introduction
    • writing, Windows used / Introduction
  • PostGIS topology
    • about / Introduction
    • geometries, simplifying with / Simplifying geometries with PostGIS topology, How to do it..., How it works...
  • PostGIS vector data
    • writing, with Psycopg / Writing PostGIS vector data with Psycopg, How to do it..., How it works...
    • writing, with OGR Python bindings / Writing PostGIS vector data with OGR Python bindings, How to do it..., How it works...
  • postgis_full_version() function / How to do it...
  • Postgres-XC / How it works...
  • PostgreSQL planner
    • changing, points / Optimizing SQL queries
  • proportionalsum function / Getting ready
  • proportional_sum function / Getting ready
  • proximity filtering
    • improving, with KNN / Improving proximity filtering with KNN, How to do it..., How it works..., Improving proximity filtering with KNN – advanced, Getting ready, How to do it...
  • psql / Getting ready
  • psql utility / Getting ready
  • Psycopg / Introduction
    • used, for writing PostGIS vector data / Writing PostGIS vector data with Psycopg, How to do it..., How it works...
    • about / How it works...
  • pyramidMaker function / How to do it...
  • Python
    • references / Introduction
    • libraries / Introduction
    • used, for netCDF datasets import / Importing netCDF datasets with Python and GDAL, How to do it..., How it works...
  • Python libraries
    • Psycopg / Introduction
    • GDAL Python bindings / Introduction
    • urllib2 / Introduction
    • simplejson / Introduction
    • Shapely / Introduction
    • Fiona / Introduction
    • Rasterio / Introduction
    • Rtree / Introduction

Q

  • QGIS
    • about / Adding PostGIS layers – QGIS
    • PostGIS layers, adding to / Adding PostGIS layers – QGIS, How to do it..., How it works...
  • QGIS layers
    • adding / Getting ready, How to do it..., How it works...
  • Quantum GIS (QGIS) / How to do it...

R

  • raster2pgsql command / How it works...
  • raster2pgsql option / How it works...
  • raster2pgsql PostGIS command
    • used, for raster data importing / Importing raster data with the raster2pgsql PostGIS command, Getting ready
  • raster data
    • imorting, with raster2pgsql PostGIS command / Importing raster data with the raster2pgsql PostGIS command, Getting ready, How to do it..., How it works...
  • Rasterio / Introduction
  • rasters / Introduction
    • exporting, with gdal_translate command / Exporting rasters with the gdal_translate and gdalwarp GDAL commands, How to do it..., See also
    • exporting, with gdalwarp GDAL command / Getting ready, How to do it..., See also
    • about / Introduction
    • formats / Introduction
    • obtaining / Getting ready, How to do it...
    • loading / Getting ready, How to do it...
    • converting, to geometries / Converting between rasters and geometries, How to do it...
    • processing, with GDAL VRT / Processing and loading rasters with GDAL VRT
    • loading, with GDAL VRT / Processing and loading rasters with GDAL VRT, Getting ready, How to do it...
    • warping / Warping and resampling rasters, How to do it...
    • resampling / Warping and resampling rasters, How to do it...
    • sharing, through SQL / Sharing and visualizing rasters through SQL, How to do it...
  • ReadAsArray method / How it works...
  • resampling algorithm / How to do it...
  • restore method / How to do it...
  • reverse geocoding
    • GeoNames datasets, using / Geocoding and reverse-geocoding using the GeoNames datasets, Getting ready, How to do it..., How it works...
  • Rtree / Introduction
  • RunKeeper
    • about / Working with GPS data

S

  • -sql option / How it works...
  • schema / Organizing the database
  • search_path method / How to do it...
  • search_path parameter / How to do it...
  • Select Features Tool / How to do it...
  • SetField feature method / How it works...
  • shapefile
    • data exporting, with pgsql2shp PostGIS command / How to do it..., How it works...
    / Normalizing imports
  • shapefiles
    • importing, with shp2pgsql / Importing shapefiles with shp2pgsql, How to do it..., How it works..., There's more...
  • Shapely / Introduction
  • shp2pgsql
    • used, for shapefile import / Importing shapefiles with shp2pgsql, How to do it..., How it works..., There's more...
  • shp2pgsql command / How it works...
  • shp2pgsql tool / Getting ready
  • Shuttle Radar Topography Mission (SRTM) / How to do it...
  • Sightings page / How to do it...
  • simplejson / Introduction
  • simple map-algebra operations
    • performing / Performing simple map-algebra operations, Getting ready, How to do it...
    • working / How it works...
  • simple_building method / Getting ready
  • simplification algorithms
    • about / Simplifying geometries
  • SLD / How to do it..., How it works...
  • Slony-I / How it works...
  • spatial index
    • creating / How to do it...
  • spatial indexes / Improving proximity filtering with KNN
  • spatial joins, GIS analysis / Getting ready, How to do it..., How it works...
  • Spatial Reference ID (SRID) / How it works...
  • spatial reference system
    • about / How it works...
  • spatial reference system identifier (SRID) / How it works...
  • SQL file
    • CREATE TABLE section / How it works...
    • INSERT INTO section / How it works...
    • CREATE INDEX section / How it works...
  • SQL queries
    • optimizing / Optimizing SQL queries, How to do it..., How it works...
  • SQL window button / How to do it...
  • standard constraints, raster
    • rules / How to do it...
  • startapp option / How to do it...
  • startproject option / How to do it...
  • STRING_AGG function / Step three – bundling as a function
  • Structure from Motion (SfM) / Introduction, Creating arbitrary 3D objects for PostGIS
  • ST_Affine method / UAV photogrammetry in PostGIS – point cloud
  • ST_AsRaster() function / How to do it...
  • ST_AsRaster method / Rendering polygons to raster
  • ST_BandMetadata() function / How to do it...
  • ST_Buffer function / Getting ready, How to do it...
  • ST_Clip() method / How to do it...
  • ST_ColorMap() function / How to do it..., How it works...
  • ST_Contains function
    • about / Introduction
  • ST_Covers function
    • about / Introduction
  • ST_Crosses function / How to do it...
    • about / Introduction
  • ST_Distance() function / How it works...
  • ST_Distance function
    • about / Introduction, How to do it...
  • ST_DistanceSphere function
    • about / Introduction
  • ST_DistanceSpheroid function
    • about / Introduction
  • ST_DumpAsPolygons() function / How to do it...
  • ST_DWithin function
    • about / Introduction
  • ST_DWithin method / How to do it...
  • ST_Extent command / How to do it...
  • ST_Extrude
    • used, for building footprints extruding / Using ST_Extrude to extrude building footprints
  • ST_Extrude method / Using ST_Extrude to extrude building footprints
  • ST_Intersection function
    • about / How it works...
  • ST_Intersects() method / How to do it...
  • ST_Intersects function
    • about / Introduction, Working with GPS data, How it works...
  • ST_IsValidDetails function
    • about / Introduction, Fixing invalid geometries
  • ST_IsValid function
    • about / Introduction, Fixing invalid geometries
  • ST_IsValidReason function
    • about / Introduction, Fixing invalid geometries, How to do it...
  • ST_Length function
    • about / Working with GPS data, How to do it...
  • ST_MakeLine function
    • about / Introduction, Working with GPS data, How to do it...
  • ST_MakePoint function / How it works...
  • ST_MakeValid function
    • about / Introduction, Fixing invalid geometries
  • ST_MapAlgebra() function / How to do it..., How to do it...
  • ST_MapAlgebra() method / Performing advanced map-algebra operations
  • ST_MapAlgebraExpr() function / Getting ready
  • ST_MapAlgebraFct() / How to do it...
  • ST_MetaData function / How to do it...
  • ST_PixelsAsPolygons() function / How to do it...
  • ST_PixelsAsPolygons() functions / Getting ready
  • ST_Polygonize
    • improving / Improving ST_Polygonize, How to do it...
  • ST_Polygonize function / Converting linestrings back to polygons
    • about / Improving ST_Polygonize
    • About / How to do it...
  • ST_Rotate function / Getting ready
  • ST_RotateXYZ function / Getting ready
  • ST_Segmentize function / How to do it...
  • ST_Simplify function
    • about / Introduction
  • ST_SimplifyPreserveTopology function
    • about / How to do it...
  • ST_SimplifyPreverveTopology function
    • about / Introduction
  • ST_Simplify_PreserveTopology function / How to do it...
  • ST_Transform() function / Getting ready
  • ST_Transform() method / How to do it...
  • ST_Union() method / How to do it...
  • ST_Union function
    • about / Merging polygons using a common attribute
  • ST_Union function function
    • about / Introduction

T

  • -t_srs option / How it works...
  • table
    • clustering / How to do it...
  • table inheritance
    • used, for data structuring / Structuring spatial data with table inheritance, Getting ready, How to do it..., How it works...
  • table partitioning
    • about / Extending inheritance – table partitioning
    • building / How to do it...
    • CHECK constraint / How it works...
  • temporary fences / Running database queries – OpenJUMP GIS
  • Test Connect button / How to do it...
  • tile / Introduction
  • TIME parameter / How to do it...
  • transactional WFS / Introduction
  • Triangular Irregular Network (TIN) / Getting ready
  • triggers
    • used, for geometry column populating / Using triggers to populate a geometry column, How to do it..., Extending further...

U

  • UAS
    • about / Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D
  • UAV-derived point cloud
    • importing / UAV photogrammetry in PostGIS – point cloud, Getting ready
    • creating / UAV photogrammetry in PostGIS – point cloud
  • UAV image footprints
    • reconstructing, with PostGIS 3D / Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D, Getting ready, How to do it...
  • uDig
    • about / Adding PostGIS layers – uDig
    • PostGIS layers, adding to / Adding PostGIS layers – uDig, How to do it..., How it works...
  • UNION ALL function / How to do it...
  • United States Geological Survey (USGS) / Improving proximity filtering with KNN – advanced
  • urllib2 / Introduction

V

  • virtualenv / Introduction
  • Virtual Reality Modeling Language (VRML) / Exporting models as X3D for the Web
  • Voronoi diagram / How to do it...
  • Voronoi diagrams
    • about / Using external scripts to embed new functionality in order to calculate a Voronoi diagram
    • diagram / Using external scripts to embed new functionality in order to calculate a Voronoi diagram
    • calculating / Getting ready, How to do it...
  • VoronoiTess function / There's more...

W

  • -where option / How it works...
  • WAR (Web archive) file / Getting ready
  • web applications
    • developing, with GeoDjango / Developing web applications with GeoDjango – part 1, How to do it..., How it works..., Developing web applications with GeoDjango – part 2
  • WFS
    • about / Introduction
  • WFS-T
    • about / Consuming WFS-T services with OpenLayers
    • consuming, with OpenLayers / Consuming WFS-T services with OpenLayers, How to do it..., How it works...
  • WFS requests
    • GetMap / How it works...
    • GetFeatureInfo / How it works...
    • GetCapabilities / How it works...
    • GetFeature / How it works...
  • WFS services
    • creating, MapServer used / Getting ready, How to do it..., How it works...
    • creating, GeoServer used / Getting ready, How to do it..., How it works..., See also
  • WMS
    • about / Introduction
    • creating, MapServer used / Creating WMS and WFS services with MapServer, Getting ready, How to do it..., How it works...
    • creating, GeoServer used / Creating WMS and WFS services with GeoServer, Getting ready, How to do it..., How it works..., See also
  • WMS services
    • consuming, with OpenLayers / Consuming WMS services with OpenLayers, Getting ready, How to do it..., How it works...
    • consuming, with leaflet / Consuming WMS services with Leaflet, How to do it..., How it works...
  • WMS Time
    • creating, MapServer used / Creating a WMS Time with MapServer, Getting ready, How to do it..., How it works...
  • WMS Time service / Introduction

X

  • X3D
    • about / Exporting models as X3D for the Web
lock icon The rest of the chapter is locked
arrow left Previous Section
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 $19.99/month. Cancel anytime