debuts of the month make the most of Lovereading
Search our site
Persons Unknown by Susie Steiner Read the opening extract of the brand new Susie Steiner book before its publication on 05/04/2018

Mastering PostGIS by Dominik Mikiewicz, Michal Mackiewicz, Tomasz Nycz


Mastering PostGIS by Dominik Mikiewicz, Michal Mackiewicz, Tomasz Nycz

Write efficient GIS applications using PostGIS - from data creation to data consumption About This Book * Learn how you can use PostGIS for spatial data analysis and manipulation * Optimize your queries and build custom functionalities for your GIS application * A comprehensive guide with hands-on examples to help you master PostGIS with ease Who This Book Is For If you are a GIS developer or analyst who wants to master PostGIS to build efficient, scalable GIS applications, this book is for you. If you want to conduct advanced analysis of spatial data, this book will also help you. The book assumes that you have a working installation of PostGIS in place, and have working experience with PostgreSQL. What You Will Learn * Refresh your knowledge of the PostGIS concepts and spatial databases * Solve spatial problems with the use of SQL in real-world scenarios * Practical walkthroughs of application development examples using Postgis, GeoServer and OpenLayers. * Extract, transform and load your spatial data * Expose data directly or through web services. * Consume your data in both desktop and web clients In Detail 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. The book begins with an overview of the key concepts related to spatial database systems and how it applies to Spatial RMDS. You will learn to load different formats into your Postgres instance, investigate the spatial nature of your raster data, and finally export it using built-in functionalities or 3th party tools for backup or representational purposes. Through the course of this book, you will be presented with many examples on how to interact with the database using JavaScript and Node.js. Sample web-based applications interacting with backend PostGIS will also be presented throughout the book, so you can get comfortable with the modern ways of consuming and modifying your spatial data. Style and approach This book is a comprehensive guide covering all the concepts you need to master PostGIS. Packed with hands-on examples, tips and tricks, even the most advanced concepts are explained in a very easy-to-follow manner. Every chapter in the book does not only focus on how each task is performed, but also why.

About the Author

Dominik Mikiewicz is a senior GIS consultant and the owner of one-person software shop Cartomatic. When not coding, he spends time with wife and kids, trying to make the little ones enjoy mountain trekking. He is also a long-distance cycling and running enthusiast. Michal Mackiewicz has been working as a software engineer at GIS Support for five years. His main job is to orchestrate various open source geospatial components and creating application-specific GIS systems. PostgreSQL and PostGIS are among his favorite tools, and are used in almost every project. Apart from developing, he also runs PostGIS training courses. When not at work, he volunteers for OpenStreetMap and a local railway preservation society. Tomasz Nycz is a geographer and cartographer. He initiated the implementation of GIS in the State Fire Service units in Poland. He works with recognized GIS companies in the emergency management industry. In practice, he uses QGIS and PostGIS. He has been an OpenStreetMap contributor for years. He also develops his scientific interests in the use of new technologies in geomorphology and remote sensing. He is also an avid drone pilot and mountain explorer.

More books by this author
Author 'Like for Like' recommendations

Loading other formats...

Book Info

Publication date

31st May 2017


Dominik Mikiewicz, Michal Mackiewicz, Tomasz Nycz

More books by Dominik Mikiewicz, Michal Mackiewicz, Tomasz Nycz
Author 'Like for Like'


Packt Publishing Limited


328 pages


Database software



It has enriched my leisure time by introducing me to a world of books which I would not have previously considered.

Val Rowe

It's information about new books so, for a book lover like me, what's not to like!

Joan Hill

You'll always find what you never knew you were looking for and you're always spoilt for choice.

Helen Jones

Lovereading has given me the opportunity to delve into new and exciting worlds of authors who I would never have tried before.

Glynis Elliott

My favourite thing about is the 'like for like' page this has really introduced me to some good reads! That and lots of honest reviews.

Sam Lewis

Lovereading always comes up with great suggestions and has introduced me to enjoyable books and new authors to discover.

Gaynor Passmore

Lovereading - a community of people passionate about reading and sharing their views. An incomparable website for book lovers.

Helen Clark

A well laid out site, I love the fact that is separates paranormal fiction from fantasy and horror, which other sites don't.

Jen Rainbow