PostGIS is a spatial database that integrates advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. PostGIS provides support for geographic objects to the PostgreSQL object-relational database and is currently the most popular open source spatial databases. If you want to explore the complete range of PostGIS techniques and expose the related extensions, this book is a must-have.
This book is a deep-dive into the full range of PostGIS topics, with practical applications of the concepts and code. It is a comprehensive guide on PostGIS tools and concepts which are required to manage, manipulate, and analyse spatial data in PostGIS. This book is packed with systematic instructions of hands-on examples and in-depth explanations. Even for experienced users, this book will serve as a great source of reference by providing new ways of working with PostGIS through the book's easy-to-follow approach.
This hands-on guide looks at key spatial data manipulation tasks, explaining not only how each task is performed, but also why. It provides practical guidance allowing you to safely take advantage of the advanced technology in PostGIS in order to simplify your spatial database administration tasks.
This practical book will help you take advantage of basic and advanced vector, raster, and routing approaches. You will learn to use the concepts of data maintenance, optimization, and performance, which will help you to integrate these into a large ecosystem of desktop and web tools.
With this comprehensive guide, you will be armed with all the tools and instructions you need to both manage the spatial database system and make better decisions as your project's requirements evolve.
|Course Length||14 hours 31 minutes|
|Date Of Publication||24 Jan 2014|
|Improving proximity filtering with KNN|
|Improving proximity filtering with KNN – advanced|
|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|
|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|
|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|
|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|