舉報 
會員
PostGIS Cookbook
Paolo Corti Thomas J. Kraft Stephen Vincent Mather Bborie Park 著
更新時間：2021-07-19 18:30:12
開會員，本書免費讀 >
最新章節：
Index
Aneasytouseguide,fullofhandsonrecipesformanipulatingspatialdatainaPostGISdatabase.Eachtopicisexplainedandplacedincontext,andforthemoreinquisitive,therearemoredetailsoftheconceptsused.Ifyouareawebdeveloperorasoftwarearchitect,especiallyinlocationbasedcompanies,andwanttoexpandtherangeoftechniquesyouareusingwithPostGIS,thenthisbookisforyou.YoushouldhavesomepriorexperiencewithPostgreSQLdatabaseandspatialconcepts.
最新章節
- Index
- Adding PostGIS layers – uDig
- Adding PostGIS layers – gvSIG
- Running database queries – OpenJUMP GIS
- Adding PostGIS layers – OpenJUMP GIS
- Using the Database Manager plugin – QGIS
品牌：中圖公司
上架時間：2021-07-19 18:16:55
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-07-19 18:30:12
- Adding PostGIS layers – uDig
- Adding PostGIS layers – gvSIG
- Running database queries – OpenJUMP GIS
- Adding PostGIS layers – OpenJUMP GIS
- Using the Database Manager plugin – QGIS
- Adding PostGIS layers – QGIS
- Introduction
- Chapter 11. Using Desktop Clients
- Replicating a PostGIS database with streaming replication
- Migrating a PostGIS database to a different server
- Optimizing SQL queries
- Clustering for efficiency
- Using indexes
- Backing up the database
- Setting up the correct data privilege mechanism
- Organizing the database
- Introduction
- Chapter 10. Maintenance Optimization and Performance Tuning
- Developing web applications with GeoDjango – part 2
- Developing web applications with GeoDjango – part 1
- Consuming WFS-T services with OpenLayers
- Consuming WMS services with Leaflet
- Consuming WMS services with OpenLayers
- Creating a WMS Time with MapServer
- Creating WMS and WFS services with GeoServer
- Creating WMS and WFS services with MapServer
- Introduction
- Chapter 9. PostGIS and the Web
- Importing netCDF datasets with Python and GDAL
- Geocoding with geopy and PL/Python
- Geocoding using the OSM datasets with trigrams
- Geocoding and reverse-geocoding using the GeoNames datasets
- Writing PostGIS functions with PL/Python
- Writing PostGIS vector data with OGR Python bindings
- Writing PostGIS vector data with Psycopg
- Introduction
- Chapter 8. PostGIS Programming
- UAV photogrammetry in PostGIS – DSM creation
- UAV photogrammetry in PostGIS – orthorectification
- UAV photogrammetry in PostGIS – point cloud
- Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D
- Exporting models as X3D for the Web
- Creating arbitrary 3D objects for PostGIS
- Using ST_Extrude to extrude building footprints
- Constructing and serving buildings 2.5 D
- Performing 3D queries on a LiDAR point cloud
- Importing LiDAR data
- Introduction
- Chapter 7. Into the Nth Dimension
- Extracting the centerlines of polygons
- Calculating demographics using driving distance
- Driving distance/service area calculation
- Loading data from OpenStreetMap and finding the shortest path using A*
- Startup – Dijkstra routing
- Introduction
- Chapter 6. Working with pgRouting
- Sharing and visualizing rasters through SQL
- Executing DEM operations
- Performing advanced map-algebra operations
- Warping and resampling rasters
- Processing and loading rasters with GDAL VRT
- Converting between rasters and geometries
- Combining geometries with rasters for analysis
- Performing simple map-algebra operations
- Working with basic raster information and analysis
- Getting and loading rasters
- Introduction
- Chapter 5. Working with Raster Data
- Using external scripts to embed other libraries in order to calculate a Voronoi diagram – advanced
- Using external scripts to embed new functionality in order to calculate a Voronoi diagram
- Generating detailed building footprints from LiDAR
- Translating scaling and rotating geometries – advanced
- Improving ST_Polygonize
- Rotating geometries
- Improving proximity filtering with KNN – advanced
- Improving proximity filtering with KNN
- Introduction
- Chapter 4. Working with Vector Data – Advanced Recipes
- Simplifying geometries with PostGIS topology
- Clipping geometries to deploy data
- Computing intersections
- Merging polygons using a common attribute
- Measuring distances
- Simplifying geometries
- GIS analysis with spatial joins
- Fixing invalid geometries
- Working with GPS data
- Introduction
- Chapter 3. Working with Vector Data – The Basics
- Using polygon overlays for proportional census estimates
- Normalizing internal overlays
- Normalizing imports
- Extending inheritance – table partitioning
- Structuring spatial data with table inheritance
- Using triggers to populate a geometry column
- Using geospatial views
- Introduction
- Chapter 2. Structures that Work
- Exporting rasters with the gdal_translate and gdalwarp GDAL commands
- Importing multiple rasters at a time
- Importing raster data with the raster2pgsql PostGIS command
- Importing OpenStreetMap data with the osm2pgsql command
- Exporting data to the shapefile with the pgsql2shp PostGIS command
- Handling batch importing and exporting of datasets
- Importing and exporting data with the ogr2ogr GDAL command
- Importing shapefiles with shp2pgsql
- Importing nonspatial tabular data (CSV) using GDAL
- Importing nonspatial tabular data (CSV) using PostGIS functions
- Introduction
- Chapter 1. Moving Data In and Out of PostGIS
- Customer support
- Reader feedback
- Conventions
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Support files eBooks discount offers and more
- www.PacktPub.com
- About the Reviewers
- About the Authors
- Credits
- PostGIS Cookbook
- coverpage
- coverpage
- PostGIS Cookbook
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- 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 command
- Importing 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 joins
- Simplifying 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
- Generating detailed building footprints from LiDAR
- Using external scripts to embed new functionality in order to calculate a Voronoi diagram
- Using 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 SQL
- Chapter 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 demographics using driving distance
- 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
- Exporting models as X3D for the Web
- Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D
- UAV photogrammetry in PostGIS – point cloud
- UAV photogrammetry in PostGIS – orthorectification
- UAV photogrammetry in PostGIS – DSM creation
- Chapter 8. PostGIS Programming
- Introduction
- Writing PostGIS vector data with Psycopg
- Writing PostGIS vector data with OGR Python bindings
- Writing PostGIS functions with PL/Python
- Geocoding and reverse-geocoding using the GeoNames datasets
- Geocoding using the OSM datasets with trigrams
- Geocoding with geopy and PL/Python
- Importing netCDF datasets with Python and GDAL
- Chapter 9. PostGIS and the Web
- Introduction
- Creating WMS and WFS services with MapServer
- Creating WMS and WFS services with GeoServer
- Creating a WMS Time with MapServer
- Consuming WMS services with OpenLayers
- Consuming WMS services with Leaflet
- Consuming WFS-T services with OpenLayers
- Developing web applications with GeoDjango – part 1
- Developing web applications with GeoDjango – part 2
- Chapter 10. Maintenance Optimization and Performance Tuning
- Introduction
- Organizing the database
- Setting up the correct data privilege mechanism
- Backing up the database
- Using indexes
- Clustering for efficiency
- Optimizing SQL queries
- Migrating a PostGIS database to a different server
- Replicating a PostGIS database with streaming replication
- Chapter 11. Using Desktop Clients
- Introduction
- Adding PostGIS layers – QGIS
- Using the Database Manager plugin – QGIS
- Adding PostGIS layers – OpenJUMP GIS
- Running database queries – OpenJUMP GIS
- Adding PostGIS layers – gvSIG
- Adding PostGIS layers – uDig
- Index 更新時間：2021-07-19 18:30:12
