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 - Ebook - Paolo Corti, Stephen Vincent Mather, Thomas Kraft, Bborie Park - Modern learning platform

E-book details

Log in, If you're interested in the contents of the item.

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

Paolo Corti, Stephen Vincent Mather, Thomas Kraft, Bborie Park

Ebook

PostGIS Cookbook
- Table of Contents
- PostGIS Cookbook
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
  - Support files, eBooks, discount offers and more
    - Why Subscribe?
    - Free Access for Packt account holders
- Preface
  - What this book covers
  - What you need for this book
  - Who this book is for
  - Conventions
  - Reader feedback
  - Customer support
    - Downloading the example code
    - Errata
    - Piracy
    - Questions
- 1. Moving Data In and Out of PostGIS
  - Introduction
  - Importing nonspatial tabular data (CSV) using PostGIS functions
    - Getting ready
    - How to do it...
    - How it works...
  - Importing nonspatial tabular data (CSV) using GDAL
    - Getting ready
    - How to do it...
    - How it works...
  - Importing shapefiles with shp2pgsql
    - How to do it...
    - How it works...
    - Theres more...
  - Importing and exporting data with the ogr2ogr GDAL command
    - How to do it...
    - How it works...
    - See also
  - Handling batch importing and exporting of datasets
    - Getting ready
    - How to do it...
    - How it works...
  - Exporting data to the shapefile with the pgsql2shp PostGIS command
    - How to do it...
    - How it works...
  - Importing OpenStreetMap data with the osm2pgsql command
    - Getting ready
    - How to do it...
    - How it works...
  - Importing raster data with the raster2pgsql PostGIS command
    - Getting ready
    - How to do it...
    - How it works...
  - Importing multiple rasters at a time
    - Getting ready
    - How to do it...
    - How it works...
  - Exporting rasters with the gdal_translate and gdalwarp GDAL commands
    - Getting ready
    - How to do it...
    - How it works...
    - See also
- 2. Structures that Work
  - Introduction
  - Using geospatial views
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See also
  - Using triggers to populate a geometry column
    - Getting ready
    - How to do it...
    - There's more...
      - Extending further...
    - See also
  - Structuring spatial data with table inheritance
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Extending inheritance table partitioning
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Normalizing imports
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
  - Normalizing internal overlays
    - Getting ready
    - How to do it...
      - Converting polygons to linestrings
      - Converting linestrings back to polygons
      - Finding center points of resultant polygons
      - Using resultant points to query tabular relationships
    - How it works...
    - There's more...
  - Using polygon overlays for proportional census estimates
    - Getting ready
    - How to do it...
    - How it works...
- 3. Working with Vector Data The Basics
  - Introduction
  - Working with GPS data
    - Getting ready
    - How to do it...
    - How it works...
  - Fixing invalid geometries
    - Getting ready
    - How to do it...
    - How it works...
  - GIS analysis with spatial joins
    - Getting ready
    - How to do it...
    - How it works...
  - Simplifying geometries
    - How to do it...
    - How it works...
  - Measuring distances
    - Getting ready
    - How to do it...
    - How it works...
  - Merging polygons using a common attribute
    - Getting ready
    - How to do it...
    - How it works...
  - Computing intersections
    - Getting ready
    - How to do it...
    - How it works...
  - Clipping geometries to deploy data
    - Getting ready
    - How to do it...
    - How it works...
  - Simplifying geometries with PostGIS topology
    - Getting ready
    - How to do it...
    - How it works...
- 4. Working with Vector Data Advanced Recipes
  - Introduction
  - Improving proximity filtering with KNN
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Improving proximity filtering with KNN advanced
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Rotating geometries
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Improving ST_Polygonize
    - Getting ready
    - How to do it...
    - See also
  - Translating, scaling, and rotating geometries advanced
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Generating detailed building footprints from LiDAR
    - Getting ready
    - How to do it...
    - How it works...
  - Using external scripts to embed new functionality in order to calculate a Voronoi diagram
    - Getting ready
    - How to do it...
    - See also
  - Using external scripts to embed other libraries in order to calculate a Voronoi diagram advanced
    - Getting ready
    - How to do it...
    - There's more...
      - Step zero preparing the test table
      - Step one preparing the input text
      - Step two returning results
      - Step three bundling as a function
      - Step four translating into geometry
- 5. Working with Raster Data
  - Introduction
  - Getting and loading rasters
    - Getting ready
    - How to do it...
    - How it works...
  - Working with basic raster information and analysis
    - Getting ready
    - How to do it...
    - How it works...
  - Performing simple map-algebra operations
    - Getting ready
    - How to do it...
    - How it works...
  - Combining geometries with rasters for analysis
    - Getting ready
    - How to do it...
    - How it works...
  - Converting between rasters and geometries
    - Getting ready
    - How to do it...
    - How it works...
  - Processing and loading rasters with GDAL VRT
    - Getting ready
    - How to do it...
    - How it works...
  - Warping and resampling rasters
    - Getting ready
    - How to do it...
    - How it works...
  - Performing advanced map-algebra operations
    - Getting ready
    - How to do it...
    - How it works...
  - Executing DEM operations
    - Getting ready
    - How to do it...
    - How it works...
  - Sharing and visualizing rasters through SQL
    - Getting ready
    - How to do it...
    - How it works...
- 6. Working with pgRouting
  - Introduction
  - Startup Dijkstra routing
    - Getting ready
    - How to do it...
  - Loading data from OpenStreetMap and finding the shortest path using A*
    - Getting ready
    - How to do it...
    - How it works...
  - Driving distance/service area calculation
    - Getting ready
    - How to do it...
    - See also
  - Calculating demographics using driving distance
    - Getting ready
    - How to do it...
  - Extracting the centerlines of polygons
    - Getting ready
    - How to do it...
    - There's more...
- 7. Into the Nth Dimension
  - Introduction
  - Importing LiDAR data
    - Getting ready
    - How to do it...
    - See also
  - Performing 3D queries on a LiDAR point cloud
    - How to do it...
  - Constructing and serving buildings 2.5 D
    - Getting ready
    - How to do it...
  - Using ST_Extrude to extrude building footprints
  - Creating arbitrary 3D objects for PostGIS
    - Getting ready
    - How to do it...
  - Exporting models as X3D for the Web
    - Getting ready
    - How to do it...
    - There's more...
  - Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D
    - Getting ready
    - How to do it...
  - UAV photogrammetry in PostGIS point cloud
    - Getting ready
    - How to do it...
  - UAV photogrammetry in PostGIS orthorectification
    - Getting ready
    - How to do it...
      - Converting the point cloud to Voronoi polygons
      - Attributing polygons with the color
      - Rendering polygons to raster
  - UAV photogrammetry in PostGIS DSM creation
    - Getting ready
    - How it works...
- 8. PostGIS Programming
  - Introduction
  - Writing PostGIS vector data with Psycopg
    - Getting ready
    - How to do it...
    - How it works...
  - Writing PostGIS vector data with OGR Python bindings
    - Getting ready
    - How to do it...
    - How it works...
  - Writing PostGIS functions with PL/Python
    - Getting ready
    - How to do it...
    - How it works...
  - Geocoding and reverse-geocoding using the GeoNames datasets
    - Getting ready
    - How to do it...
    - How it works...
  - Geocoding using the OSM datasets with trigrams
    - Getting ready
    - How to do it...
    - How it works...
  - Geocoding with geopy and PL/Python
    - Getting ready
    - How to do it...
    - How it works...
  - Importing netCDF datasets with Python and GDAL
    - Getting ready
    - How to do it...
    - How it works...
- 9. PostGIS and the Web
  - Introduction
  - Creating WMS and WFS services with MapServer
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Creating WMS and WFS services with GeoServer
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Creating a WMS Time with MapServer
    - Getting ready
    - How to do it...
    - How it works...
  - Consuming WMS services with OpenLayers
    - Getting ready
    - How to do it...
    - How it works...
  - Consuming WMS services with Leaflet
    - How to do it...
    - How it works...
  - Consuming WFS-T services with OpenLayers
    - Getting ready
    - How to do it...
    - How it works...
  - Developing web applications with GeoDjango part 1
    - Getting ready
    - How to do it...
    - How it works...
  - Developing web applications with GeoDjango part 2
    - Getting ready
    - How to do it...
    - How it works...
- 10. Maintenance, Optimization, and Performance Tuning
  - Introduction
  - Organizing the database
    - Getting ready
    - How to do it...
    - How it works...
  - Setting up the correct data privilege mechanism
    - Getting ready
    - How to do it...
    - How it works...
  - Backing up the database
    - Getting ready
    - How to do it...
    - How it works...
  - Using indexes
    - Getting ready
    - How to do it...
    - How it works...
  - Clustering for efficiency
    - Getting ready
    - How to do it...
    - How it works...
  - Optimizing SQL queries
    - Getting ready
    - How to do it...
    - How it works...
  - Migrating a PostGIS database to a different server
    - Getting ready
    - How to do it...
    - How it works...
  - Replicating a PostGIS database with streaming replication
    - Getting ready
    - How to do it...
    - How it works...
- 11. Using Desktop Clients
  - Introduction
  - Adding PostGIS layers QGIS
    - Getting ready
    - How to do it...
    - How it works...
  - Using the Database Manager plugin QGIS
    - Getting ready
    - How to do it...
    - How it works...
  - Adding PostGIS layers OpenJUMP GIS
    - Getting ready
    - How to do it...
    - How it works...
  - Running database queries OpenJUMP GIS
    - Getting ready
    - How to do it...
    - How it works...
  - Adding PostGIS layers gvSIG
    - Getting ready
    - How to do it...
    - How it works...
  - Adding PostGIS layers uDig
    - How to do it...
    - How it works...
- Index

Title: 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
Author: Paolo Corti, Stephen Vincent Mather, Thomas Kraft, Bborie Park
Original title: 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
ISBN: 9781849518673, 9781849518673
Date of issue: 2014-01-24
Format: Ebook
Item ID: e_3bj4
Publisher: Packt Publishing

select a language

Categories

E-book details