Learn how to build powerful spatial database solutions with PostGIS quickly and efficiently
***** About This Book *****
* Learn how to construct your own solutions using the most exciting Geographic Information System (GIS) tool on the market, PostGIS
* Use this book to develop a complete GIS application from scratch
* A practical, agile, and step-by-step guide for using PostGIS to create more » great GIS solutions
***** Who This Book Is For *****
This book is a quick guide for anyone who wants to get started with PostGIS and develop their very own GIS projects quickly.
***** What You Will Learn *****
* Install and configure PostGIS and other useful open source tools such as QGIS and GDAL for working with spatial data
* Create spatial databases and tables from scratch and develop spatial queries through practical examples
* Obtain useful spatial data from public and free sources and insert and manage this data to be useful with your data tables
* Familiarize yourself with the fundamental concepts in PostGIS and spatial databases
* Visualize the data stored in your tables and combine it with other data sources to create beautiful graphical solutions using QGIS
* Use the GDAL spatial library to transform and reproject from a wide range of data formats such as vectorial and raster geospatial data formats
* Develop a complete GIS application from scratch by implementing the concepts learned in the book
***** In Detail *****
PostGIS is one of the world's leading spatial databases, created as a geographic extension for PostgreSQL. With it, users are able to manipulate and visualize spatial data incredibly effectively and efficiently.
PostGIS Essentials introduces you to the fundamentals of PostGIS, giving you easy access to one of the most popular and powerful spatial databases available today. You will begin by learning how to install and successfully set up PostGIS before covering how to create your first spatial database. The book will then help you to develop your skills further as you will learn how to insert GIS objects as well as how to select and filter GIS queries with clear and practical information. You will then learn how to display GIS data graphically and create effective visualizations. The book concludes with tips, tricks, and techniques to help you optimize PostGIS and improve the performance of your database. « less
Over 80 task-based recipes to store, organize, manipulate, and analyze spatial data in a PostGIS database
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 one of the most popular open source spatial databases. more » If you want to explore the complete range of PostGIS techniques and expose its 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 the PostGIS tools and concepts that 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. « less
A Practical Guide to Creating a Data Management System with PostgreSQL/PostGIS and R
This book guides animal ecologists, biologists and wildlife and data managers through a step-by-step procedure to build their own advanced software platforms to manage and process wildlife tracking data. This unique, problem-solving-oriented guide focuses on how to extract the most from GPS animal tracking more » data, while preventing error propagation and optimizing analysis performance. Based on the open source PostgreSQL/PostGIS spatial database, the software platform will allow researchers and managers to integrate and harmonize GPS tracking data together with animal characteristics, environmental data sets, including remote sensing image time series, and other bio-logged data, such as acceleration data. Moreover, the book shows how the powerful R statistical environment can be integrated into the software platform, either connecting the database with R, or embedding the same tools in the database through the PostgreSQL extension Pl/R.
The client/server architecture allows users to remotely connect a number of software applications that can be used as a database front end, including GIS software and WebGIS. Each chapter offers a real-world data management and processing problem that is discussed in its biological context; solutions are proposed and exemplified through ad hoc SQL code, progressively exploring the potential of spatial database functions applied to the respective wildlife tracking case.
Finally, wildlife tracking management issues are discussed in the increasingly widespread framework of collaborative science and data sharing. GPS animal telemetry data from a real study, freely available online, are used to demonstrate the proposed examples. This book is also suitable for undergraduate and graduate students, if accompanied by the basics of databases. « less