Learn how to build powerful spatial database solutions with PostGIS quickly and efficiently
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.
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
Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.