PostGIS Essentials

Learn how to build powerful spatial database solutions with PostGIS quickly and efficiently
Preview in Mapt

PostGIS Essentials

Angel Marquez

2 customer reviews
Learn how to build powerful spatial database solutions with PostGIS quickly and efficiently
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $35.99
Save 72%
Print + eBook
$44.99
RRP $44.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$44.99
$29.99 p/m after trial
RRP $35.99
RRP $44.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


PostGIS Essentials Book Cover
PostGIS Essentials
$ 35.99
$ 10.00
PostGIS Cookbook - Second Edition Book Cover
PostGIS Cookbook - Second Edition
$ 39.99
$ 10.00
Buy 2 for $20.00
Save $55.98
Add to Cart

Book Details

ISBN 139781784395292
Paperback196 pages

Book Description

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.

Table of Contents

Chapter 1: Introducing PostGIS and Setting it Up
What is PostGIS?
Why PostGIS?
Installing PostgreSQL
Installing PostGIS
Installing QGIS
Summary
Chapter 2: Creating Your First Spatial Database
The development of spatial databases
Creating our first database using a command line
Creating a spatial database using GUI
Summary
Chapter 3: Inserting GIS Objects
Developing insertion queries with GIS objects
What is a spatial reference system?
Summary
Chapter 4: Selecting and Filtering GIS Queries
Grouping data
Nonspatial queries
Spatial functions
Queries that use data from two databases
Developing spatial queries with our own data
Summary
Chapter 5: Displaying GIS Data Graphically
Introducing QGIS
The QGIS application
Hands-on with QGIS
Developing a spatial query from QGIS
Summary
Chapter 6: Management of Vectorial and Raster Data with PostGIS
The GDAL/OGR library
Working with GDAL/OGR commands
Working with raster files
Summary
Chapter 7: Performance Tuning
Spatial indexes in PostGIS
Tuning spatial queries
Tuning PostgreSQL's configuration file for our spatial database
Summary
Chapter 8: Developing a GIS Web Application
Developing a web application
Summary
Chapter 9: Developing a Desktop GIS Application
What is World Wind?
Coding our first application
Developing a management application
Summary

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

Authors

Table of Contents

Chapter 1: Introducing PostGIS and Setting it Up
What is PostGIS?
Why PostGIS?
Installing PostgreSQL
Installing PostGIS
Installing QGIS
Summary
Chapter 2: Creating Your First Spatial Database
The development of spatial databases
Creating our first database using a command line
Creating a spatial database using GUI
Summary
Chapter 3: Inserting GIS Objects
Developing insertion queries with GIS objects
What is a spatial reference system?
Summary
Chapter 4: Selecting and Filtering GIS Queries
Grouping data
Nonspatial queries
Spatial functions
Queries that use data from two databases
Developing spatial queries with our own data
Summary
Chapter 5: Displaying GIS Data Graphically
Introducing QGIS
The QGIS application
Hands-on with QGIS
Developing a spatial query from QGIS
Summary
Chapter 6: Management of Vectorial and Raster Data with PostGIS
The GDAL/OGR library
Working with GDAL/OGR commands
Working with raster files
Summary
Chapter 7: Performance Tuning
Spatial indexes in PostGIS
Tuning spatial queries
Tuning PostgreSQL's configuration file for our spatial database
Summary
Chapter 8: Developing a GIS Web Application
Developing a web application
Summary
Chapter 9: Developing a Desktop GIS Application
What is World Wind?
Coding our first application
Developing a management application
Summary

Book Details

ISBN 139781784395292
Paperback196 pages
Read More
From 2 reviews

Read More Reviews

Recommended for You

PostGIS Cookbook Book Cover
PostGIS Cookbook
$ 29.99
$ 10.00
Mastering QGIS - Second Edition Book Cover
Mastering QGIS - Second Edition
$ 43.99
$ 10.00
GeoServer Beginner's Guide Book Cover
GeoServer Beginner's Guide
$ 29.99
$ 6.00
Learning QGIS - Third Edition Book Cover
Learning QGIS - Third Edition
$ 27.99
$ 10.00
Python Geospatial Development - Third Edition Book Cover
Python Geospatial Development - Third Edition
$ 39.99
$ 10.00
QGIS Python Programming Cookbook - Second Edition Book Cover
QGIS Python Programming Cookbook - Second Edition
$ 39.99
$ 10.00