عنوان
پدید آورنده
موضوع
رده
G70.212 .C67 2014
G70
.
212
.
C67
2014
کتابخانه
محل استقرار
INTERNATIONAL STANDARD BOOK NUMBER
(Number (ISBN
184951867X (electronic bk.)
(Number (ISBN
9781849518673 (electronic bk.)
Erroneous ISBN
9781849518666
NATIONAL BIBLIOGRAPHY NUMBER
Number
dltt
TITLE AND STATEMENT OF RESPONSIBILITY
Title Proper
PostGIS cookbook :
General Material Designation
[Book]
Other Title Information
over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database /
First Statement of Responsibility
Paolo Corti ... [et al.].
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
1 online resource (484 pages).
SERIES
Series Title
Quick answers to common problems
GENERAL NOTES
Text of Note
Exporting models as X3D for the Web
CONTENTS NOTE
Text of Note
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
Text of Note
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
Text of Note
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
Text of Note
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
Text of Note
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
0
8
8
8
8
SUMMARY OR ABSTRACT
Text of Note
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
ACQUISITION INFORMATION NOTE
Source for Acquisition/Subscription Address
Safari Books Online
Stock Number
CL0500000390
OTHER EDITION IN ANOTHER MEDIUM
Title
PostGIS Cookbook.
International Standard Book Number
9781849518666
PIECE
Title
Safari books online
TOPICAL NAME USED AS SUBJECT
Database management.
Geographic information systems.
Spatial data infrastructures.
(SUBJECT CATEGORY (Provisional
SCI-- 030000
TRV-- 016000
TRV-- 018000
TRV-- 033000
TRV-- 034000
DEWEY DECIMAL CLASSIFICATION
Number
910
.
285
Edition
23
LIBRARY OF CONGRESS CLASSIFICATION
Class number
G70
.
212
Book number
.
C67
2014
PERSONAL NAME - ALTERNATIVE RESPONSIBILITY
Corti, Paolo.
Kraft, Thomas J.
Mather, Stephen Vincent.
Park, Bborie.
ORIGINATING SOURCE
Date of Transaction
20140303012156.0
Cataloguing Rules (Descriptive Conventions))
rda
ELECTRONIC LOCATION AND ACCESS
Electronic name
مطالعه متن کتاب [Book]
Y
