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)