Borrow it
Coverart for item
The Resource 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

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

Creator
Contributor
Summary
An easy-to-use guide, full of hands-on recipes for manipulating spatial data in a PostGIS database. Each topic is explained and placed in context, and for the more inquisitive, there are more details of the concepts used. If you are a web developer or a software architect, especially in location-based companies, and want to expand the range of techniques you are using with PostGIS, then this book is for you. You should have some prior experience with PostgreSQL database and spatial concepts
Language
eng
Work
Publication
Extent
1 online resource (iv, 468 pages).
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
Isbn
9781849518666
Instance
Label
PostGIS Cookbook : over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database
Title
PostGIS Cookbook
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
Creator
Contributor
Subject
Language
eng
Summary
An easy-to-use guide, full of hands-on recipes for manipulating spatial data in a PostGIS database. Each topic is explained and placed in context, and for the more inquisitive, there are more details of the concepts used. If you are a web developer or a software architect, especially in location-based companies, and want to expand the range of techniques you are using with PostGIS, then this book is for you. You should have some prior experience with PostgreSQL database and spatial concepts
Member of
Cataloging source
YDXCP
http://library.link/vocab/creatorName
Corti, Paolo
Dewey number
910.285
Index
no index present
LC call number
G70.212
LC item number
.C67 2014
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
  • Mather, Stephen Vincent
  • Kraft, Thomas J
  • Park, Bborie
Series statement
Quick answers to common problems
http://library.link/vocab/subjectName
  • Geographic information systems
  • Database management
  • Spatial data infrastructures
  • SCIENCE
  • TRAVEL
  • TRAVEL
  • TRAVEL
  • TRAVEL
  • Database management
  • Geographic information systems
  • Spatial data infrastructures
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
Instantiates
Publication
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
9781849518666
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000390
Specific material designation
remote
System control number
(OCoLC)900419022
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
Publication
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
9781849518666
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000390
Specific material designation
remote
System control number
(OCoLC)900419022

Subject

Genre

Member of

Library Locations

    • Thomas Jefferson LibraryBorrow it
      1 University Blvd, St. Louis, MO, 63121, US
      38.710138 -90.311107

Library Links

Structured data from the Bibframe namespace is licensed under the Creative Commons Attribution 4.0 International License by University of Missouri-St. Louis Libraries. Additional terms may apply to data associated with third party namespaces.
Processing Feedback ...