PostGIS Cookbook : over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database, Paolo Corti, Thomas J. Kraft, Stephen Vincent Mather, Bborie Park

Resource Information

The instance PostGIS Cookbook : over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database, Paolo Corti, Thomas J. Kraft, Stephen Vincent Mather, Bborie Park represents a material embodiment of a distinct intellectual or artistic creation found in University of Missouri-St. Louis Libraries. This resource is a combination of several types including: Instance, Electronic.

Image

http://images.btol.com/ContentCafe/Jacket.aspx?UserID=ebsco-test&Password=ebsco-test&Return=T&Value=9781849518673&Type=L

Label

PostGIS Cookbook : over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database, Paolo Corti, Thomas J. Kraft, Stephen Vincent Mather, Bborie Park

Title remainder

over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database

Statement of responsibility

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

Instantiates

• PostGIS Cookbook : over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database

Publication

• Birmingham, Packt Publishing, 2014

Carrier category

online resource

Carrier category code

• cr

Carrier MARC source

rdacarrier

Content category

text

Content type code

• txt

Content type MARC source

rdacontent

Contents

• Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Moving Data In and Out of PostGIS; Introduction; Importing nonspatial tabular data (CSV) using PostGIS functions; Importing nonspatial tabular data (CSV) using GDAL; Importing shapefiles with shp2pgsql; Importing and exporting data with the ogr2ogr GDAL command; Handling batch importing and exporting of datasets; Exporting data to the shapefile with the pgsql2shp PostGIS command; Importing OpenStreetMap data with the osm2pgsql command
• Importing raster data with the raster2pgsql PostGIS commandImporting multiple rasters at a time; Exporting rasters with the gdal_translate and gdalwarp GDAL commands; Chapter 2: Structures that Work; Introduction; Using geospatial views; Using triggers to populate a geometry column; Structuring spatial data with table inheritance; Extending inheritance -- table partitioning; Normalizing imports; Normalizing internal overlays; Using polygon overlays for proportional census estimates; Chapter 3: Working with Vector Data -- The Basics; Introduction; Working with GPS data; Fixing invalid geometries
• GIS analysis with spatial joinsSimplifying geometries; Measuring distances; Merging polygons using a common attribute; Computing intersections; Clipping geometries to deploy data; Simplifying geometries with PostGIS topology; Chapter 4: Working with Vector Data -- Advanced Recipes; Introduction; Improving proximity filtering with KNN; Improving proximity filtering with KNN -- advanced; Rotating geometries; Improving ST_Polygonize; Translating, scaling, and rotating geometries -- advanced; Detailed building footprints from LiDAR; Using external scripts to embed new
• Functionality in order to calculate a Voronoi diagramUsing external scripts to embed other; libraries in order to calculate a Voronoi; diagram -- advanced; Chapter 5: Working with Raster Data; Introduction; Getting and loading rasters; Working with basic raster information and analysis; Performing simple map-algebra operations; Combining geometries with rasters for analysis; Converting between rasters and geometries; Processing and loading rasters with GDAL VRT; Warping and resampling rasters; Performing advanced map-algebra operations; Executing DEM operations
• Sharing and visualizing rasters through SQLChapter 6: Working with pgRouting; Introduction; Startup -- Dijkstra routing; Loading data from OpenStreetMap and finding the shortest path using A*; Driving distance/service area calculation; Calculating the driving distance with demographics; Extracting the centerlines of polygons; Chapter 7: Into the Nth Dimension; Introduction; Importing LiDAR Data; Performing 3D queries on a LiDAR point cloud; Constructing and serving buildings 2.5 D; Using ST_Extrude to extrude building footprints; Creating arbitrary 3D objects for PostGIS

Control code

900419022

Dimensions

unknown

Extent

1 online resource (iv, 468 pages).

Form of item

online

Isbn

9781849518673

Media category

computer

Media MARC source

rdamedia

Media type code

• c

http://library.link/vocab/ext/overdrive/overdriveId

cl0500000390

Record ID

.b123910274

Specific material designation

remote

System control number

(OCoLC)900419022