PostGIS Cookbook :: over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database /
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-bas...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Weitere Verfasser: | , , |
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham :
Packt Publishing,
2014.
|
| Schriftenreihe: | Quick answers to common problems.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | 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. |
| Beschreibung: | 1 online resource (iv, 468 pages) |
| ISBN: | 9781849518673 184951867X 1849518661 9781849518666 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn900419022 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr |n||||||||| | ||
| 008 | 140201s2014 enk o 000 0 eng d | ||
| 040 | |a YDXCP |b eng |e pn |c YDXCP |d OCLCO |d EBLCP |d N$T |d UMI |d COO |d DEBBG |d DEBSZ |d OCLCF |d OCLCO |d OCLCQ |d AGLDB |d ICA |d ZCU |d MERUC |d OCLCQ |d D6H |d OCL |d VNS |d VTS |d CEF |d ICG |d NLE |d OCLCQ |d OCLCO |d STF |d UAB |d DKC |d AU@ |d OCLCQ |d M8D |d UKAHL |d OCLCO |d OCLCQ |d OCLCO |d UEJ |d OCLCQ | ||
| 019 | |a 869640102 |a 870676032 |a 960416857 |a 1008845401 |a 1360447513 |a 1419009526 | ||
| 020 | |a 9781849518673 | ||
| 020 | |a 184951867X | ||
| 020 | |a 1849518661 | ||
| 020 | |a 9781849518666 | ||
| 035 | |a (OCoLC)900419022 |z (OCoLC)869640102 |z (OCoLC)870676032 |z (OCoLC)960416857 |z (OCoLC)1008845401 |z (OCoLC)1360447513 |z (OCoLC)1419009526 | ||
| 037 | |a CL0500000390 |b Safari Books Online | ||
| 050 | 4 | |a G70.212 |b .C67 2014 | |
| 072 | 7 | |a SCI |x 030000 |2 bisacsh | |
| 072 | 7 | |a TRV |x 033000 |2 bisacsh | |
| 072 | 7 | |a TRV |x 034000 |2 bisacsh | |
| 072 | 7 | |a TRV |x 016000 |2 bisacsh | |
| 072 | 7 | |a TRV |x 018000 |2 bisacsh | |
| 082 | 7 | |a 910.285 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Corti, Paolo. | |
| 245 | 1 | 0 | |a PostGIS Cookbook : |b over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database / |c Paolo Corti, Thomas J. Kraft, Stephen Vincent Mather, Bborie Park. |
| 260 | |a Birmingham : |b Packt Publishing, |c 2014. | ||
| 300 | |a 1 online resource (iv, 468 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Quick answers to common problems | |
| 505 | 0 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 520 | |a 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. | ||
| 630 | 0 | 0 | |a PostGIS. |
| 630 | 0 | 7 | |a PostgreSQL. |2 blmlsh |
| 650 | 0 | |a Geographic information systems. |0 http://id.loc.gov/authorities/subjects/sh90001880 | |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 0 | |a Spatial data infrastructures. |0 http://id.loc.gov/authorities/subjects/sh2005004425 | |
| 650 | 2 | |a Geographic Information Systems |0 https://id.nlm.nih.gov/mesh/D040362 | |
| 650 | 6 | |a Systèmes d'information géographique. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Infrastructures de données géospatiales. | |
| 650 | 7 | |a geographic information systems. |2 aat | |
| 650 | 7 | |a SCIENCE |x Earth Sciences |x Geography. |2 bisacsh | |
| 650 | 7 | |a TRAVEL |x Budget. |2 bisacsh | |
| 650 | 7 | |a TRAVEL |x Hikes & Walks. |2 bisacsh | |
| 650 | 7 | |a TRAVEL |x Museums, Tours, Points of Interest. |2 bisacsh | |
| 650 | 7 | |a TRAVEL |x Parks & Campgrounds. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Geographic information systems |2 fast | |
| 650 | 7 | |a Spatial data infrastructures |2 fast | |
| 700 | 1 | |a Mather, Stephen Vincent. | |
| 700 | 1 | |a Kraft, Thomas J. | |
| 700 | 1 | |a Park, Bborie. | |
| 776 | 0 | 8 | |i Print version: |a Corti, Paolo. |t PostGIS Cookbook. |d Birmingham : Packt Publishing, ©2014 |z 9781849518666 |
| 830 | 0 | |a Quick answers to common problems. |0 http://id.loc.gov/authorities/names/no2015091434 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=691843 |3 Volltext |
| 936 | |a BATCHLOAD | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26850778 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1572945 | ||
| 938 | |a EBSCOhost |b EBSC |n 691843 | ||
| 938 | |a YBP Library Services |b YANK |n 11612409 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn900419022 |
|---|---|
| _version_ | 1816882300967714816 |
| adam_text | |
| any_adam_object | |
| author | Corti, Paolo |
| author2 | Mather, Stephen Vincent Kraft, Thomas J. Park, Bborie |
| author2_role | |
| author2_variant | s v m sv svm t j k tj tjk b p bp |
| author_facet | Corti, Paolo Mather, Stephen Vincent Kraft, Thomas J. Park, Bborie |
| author_role | |
| author_sort | Corti, Paolo |
| author_variant | p c pc |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | G - Geography, Anthropology, Recreation |
| callnumber-label | G70 |
| callnumber-raw | G70.212 .C67 2014 |
| callnumber-search | G70.212 .C67 2014 |
| callnumber-sort | G 270.212 C67 42014 |
| callnumber-subject | G - General Geography |
| collection | ZDB-4-EBA |
| 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. |
| ctrlnum | (OCoLC)900419022 |
| dewey-full | 910.285 |
| dewey-hundreds | 900 - History & geography |
| dewey-ones | 910 - Geography and travel |
| dewey-raw | 910.285 |
| dewey-search | 910.285 |
| dewey-sort | 3910.285 |
| dewey-tens | 910 - Geography and travel |
| discipline | Geographie |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06878cam a2200817 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn900419022</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr |n|||||||||</controlfield><controlfield tag="008">140201s2014 enk o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">YDXCP</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">YDXCP</subfield><subfield code="d">OCLCO</subfield><subfield code="d">EBLCP</subfield><subfield code="d">N$T</subfield><subfield code="d">UMI</subfield><subfield code="d">COO</subfield><subfield code="d">DEBBG</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">ICA</subfield><subfield code="d">ZCU</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">D6H</subfield><subfield code="d">OCL</subfield><subfield code="d">VNS</subfield><subfield code="d">VTS</subfield><subfield code="d">CEF</subfield><subfield code="d">ICG</subfield><subfield code="d">NLE</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">STF</subfield><subfield code="d">UAB</subfield><subfield code="d">DKC</subfield><subfield code="d">AU@</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">M8D</subfield><subfield code="d">UKAHL</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">UEJ</subfield><subfield code="d">OCLCQ</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">869640102</subfield><subfield code="a">870676032</subfield><subfield code="a">960416857</subfield><subfield code="a">1008845401</subfield><subfield code="a">1360447513</subfield><subfield code="a">1419009526</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849518673</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">184951867X</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849518661</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849518666</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)900419022</subfield><subfield code="z">(OCoLC)869640102</subfield><subfield code="z">(OCoLC)870676032</subfield><subfield code="z">(OCoLC)960416857</subfield><subfield code="z">(OCoLC)1008845401</subfield><subfield code="z">(OCoLC)1360447513</subfield><subfield code="z">(OCoLC)1419009526</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000390</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">G70.212</subfield><subfield code="b">.C67 2014</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">SCI</subfield><subfield code="x">030000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">TRV</subfield><subfield code="x">033000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">TRV</subfield><subfield code="x">034000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">TRV</subfield><subfield code="x">016000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">TRV</subfield><subfield code="x">018000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">910.285</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Corti, Paolo.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">PostGIS Cookbook :</subfield><subfield code="b">over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database /</subfield><subfield code="c">Paolo Corti, Thomas J. Kraft, Stephen Vincent Mather, Bborie Park.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2014.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (iv, 468 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Quick answers to common problems</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">PostGIS.</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">PostgreSQL.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Geographic information systems.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh90001880</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Spatial data infrastructures.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh2005004425</subfield></datafield><datafield tag="650" ind1=" " ind2="2"><subfield code="a">Geographic Information Systems</subfield><subfield code="0">https://id.nlm.nih.gov/mesh/D040362</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Systèmes d'information géographique.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Infrastructures de données géospatiales.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">geographic information systems.</subfield><subfield code="2">aat</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SCIENCE</subfield><subfield code="x">Earth Sciences</subfield><subfield code="x">Geography.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">TRAVEL</subfield><subfield code="x">Budget.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">TRAVEL</subfield><subfield code="x">Hikes & Walks.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">TRAVEL</subfield><subfield code="x">Museums, Tours, Points of Interest.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">TRAVEL</subfield><subfield code="x">Parks & Campgrounds.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Geographic information systems</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Spatial data infrastructures</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Mather, Stephen Vincent.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kraft, Thomas J.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Park, Bborie.</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Corti, Paolo.</subfield><subfield code="t">PostGIS Cookbook.</subfield><subfield code="d">Birmingham : Packt Publishing, ©2014</subfield><subfield code="z">9781849518666</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Quick answers to common problems.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2015091434</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=691843</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="936" ind1=" " ind2=" "><subfield code="a">BATCHLOAD</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26850778</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL1572945</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">691843</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">11612409</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn900419022 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-27T13:26:26Z |
| institution | BVB |
| isbn | 9781849518673 184951867X 1849518661 9781849518666 |
| language | English |
| oclc_num | 900419022 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (iv, 468 pages) |
| psigel | ZDB-4-EBA |
| publishDate | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Quick answers to common problems. |
| series2 | Quick answers to common problems |
| spelling | Corti, Paolo. 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. Birmingham : Packt Publishing, 2014. 1 online resource (iv, 468 pages) text txt rdacontent computer c rdamedia online resource cr rdacarrier Quick answers to common problems 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. 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. PostGIS. PostgreSQL. blmlsh Geographic information systems. http://id.loc.gov/authorities/subjects/sh90001880 Database management. http://id.loc.gov/authorities/subjects/sh85035848 Spatial data infrastructures. http://id.loc.gov/authorities/subjects/sh2005004425 Geographic Information Systems https://id.nlm.nih.gov/mesh/D040362 Systèmes d'information géographique. Bases de données Gestion. Infrastructures de données géospatiales. geographic information systems. aat SCIENCE Earth Sciences Geography. bisacsh TRAVEL Budget. bisacsh TRAVEL Hikes & Walks. bisacsh TRAVEL Museums, Tours, Points of Interest. bisacsh TRAVEL Parks & Campgrounds. bisacsh Database management fast Geographic information systems fast Spatial data infrastructures fast Mather, Stephen Vincent. Kraft, Thomas J. Park, Bborie. Print version: Corti, Paolo. PostGIS Cookbook. Birmingham : Packt Publishing, ©2014 9781849518666 Quick answers to common problems. http://id.loc.gov/authorities/names/no2015091434 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=691843 Volltext |
| spellingShingle | Corti, Paolo PostGIS Cookbook : over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database / Quick answers to common problems. 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. PostGIS. PostgreSQL. blmlsh Geographic information systems. http://id.loc.gov/authorities/subjects/sh90001880 Database management. http://id.loc.gov/authorities/subjects/sh85035848 Spatial data infrastructures. http://id.loc.gov/authorities/subjects/sh2005004425 Geographic Information Systems https://id.nlm.nih.gov/mesh/D040362 Systèmes d'information géographique. Bases de données Gestion. Infrastructures de données géospatiales. geographic information systems. aat SCIENCE Earth Sciences Geography. bisacsh TRAVEL Budget. bisacsh TRAVEL Hikes & Walks. bisacsh TRAVEL Museums, Tours, Points of Interest. bisacsh TRAVEL Parks & Campgrounds. bisacsh Database management fast Geographic information systems fast Spatial data infrastructures fast |
| subject_GND | http://id.loc.gov/authorities/subjects/sh90001880 http://id.loc.gov/authorities/subjects/sh85035848 http://id.loc.gov/authorities/subjects/sh2005004425 https://id.nlm.nih.gov/mesh/D040362 |
| title | PostGIS Cookbook : over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database / |
| title_auth | PostGIS Cookbook : over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database / |
| title_exact_search | PostGIS Cookbook : over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database / |
| title_full | 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_fullStr | 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_full_unstemmed | 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_short | PostGIS Cookbook : |
| title_sort | postgis cookbook over 80 task based recipes to store organize manipulate and analyze spatial data in a postgis database |
| title_sub | over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database / |
| topic | PostGIS. PostgreSQL. blmlsh Geographic information systems. http://id.loc.gov/authorities/subjects/sh90001880 Database management. http://id.loc.gov/authorities/subjects/sh85035848 Spatial data infrastructures. http://id.loc.gov/authorities/subjects/sh2005004425 Geographic Information Systems https://id.nlm.nih.gov/mesh/D040362 Systèmes d'information géographique. Bases de données Gestion. Infrastructures de données géospatiales. geographic information systems. aat SCIENCE Earth Sciences Geography. bisacsh TRAVEL Budget. bisacsh TRAVEL Hikes & Walks. bisacsh TRAVEL Museums, Tours, Points of Interest. bisacsh TRAVEL Parks & Campgrounds. bisacsh Database management fast Geographic information systems fast Spatial data infrastructures fast |
| topic_facet | PostGIS. PostgreSQL. Geographic information systems. Database management. Spatial data infrastructures. Geographic Information Systems Systèmes d'information géographique. Bases de données Gestion. Infrastructures de données géospatiales. geographic information systems. SCIENCE Earth Sciences Geography. TRAVEL Budget. TRAVEL Hikes & Walks. TRAVEL Museums, Tours, Points of Interest. TRAVEL Parks & Campgrounds. Database management Geographic information systems Spatial data infrastructures |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=691843 |
| work_keys_str_mv | AT cortipaolo postgiscookbookover80taskbasedrecipestostoreorganizemanipulateandanalyzespatialdatainapostgisdatabase AT matherstephenvincent postgiscookbookover80taskbasedrecipestostoreorganizemanipulateandanalyzespatialdatainapostgisdatabase AT kraftthomasj postgiscookbookover80taskbasedrecipestostoreorganizemanipulateandanalyzespatialdatainapostgisdatabase AT parkbborie postgiscookbookover80taskbasedrecipestostoreorganizemanipulateandanalyzespatialdatainapostgisdatabase |