If you have read this book, please leave a review on Amazon.com. Potential readers can then use your unbiased opinion to help them make purchase decisions. Thank you. The $5 campaign runs from December 15th 2020 to January 13th 2021.

This is the code repository for Mastering PostGIS, published by Packt. It contains all the supporting project files necessary to work through the book from start to finish.

PostGIS is open source extension onf PostgreSQL object-relational database system that allows GIS objects to be stored and allows querying for information and location services. The aim of this book is to help you master the functionalities offered by PostGIS- from data creation, analysis and output, to ETL and live edits.

All of the code is organized into folders. Each folder starts with a number followed by the application name. For example, Chapter03.

More data files: https://gitlab.sigmageosistemas.com.br/george-silva/mastering-postgis

The code will look like the following:

drop table if exists data_import.osgb_addresses;
create table data_import.osgb_addresses(
 uprn bigint,
 os_address_toid varchar,

Following is the list of software and the download link to work through this book:

• PostgreSQL 9.x (https://www.postgresql.org/download/)
• PostGIS 2.x (http://postgis.net/install/)
• QGIS 2.x (http://www.qgis.org/en/site/forusers/download.html)
• ogr2ogr / gdal (http://ogr2gui.ca/)
• Manifold 8 (http://manifold.net/updates/downloads.shtml)
• SQL SERVER 2016 (https://www.microsoft.com/en-us/sql-server/sql-server-downloads)
• pgAdmin 3 (Should be bundled with PostgreSQL, if not https://www.pgadmin.org/download/)
• OL3 (https://openlayers.org/download/)
• Leaflet (http://leafletjs.com/download.html)
• GeoServer 2.9 + with bundled jetty (http://geoserver.org/)
• ExtJs (https://www.sencha.com/products/evaluate/)
• Node.js (https://nodejs.org/en/download/)
• pgRouting (http://pgrouting.org/download.html)

• PostGIS Essentials

• PostGIS Cookbook

• Mastering PostgreSQL 9.6

If you have already purchased a print or Kindle version of this book, you can get a DRM-free PDF version at no cost.
Simply click on the link to claim your free PDF.

https://packt.link/free-ebook/9781784391645