Book Image

PostGIS Essentials

By : Angel Marquez
Book Image

PostGIS Essentials

By: Angel Marquez

Overview of this book

<p>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.</p> <p>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.</p>
Table of Contents (16 chapters)
PostGIS Essentials
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

About the Reviewers

Zeeshan Chawdhary has been experimenting with location-based technologies since 2007, having worked with industry leaders such as Foursquare, Google, and Yahoo! in the LBS space. He has been working with start-ups for the past few years. He has built and scaled up e-commerce, location-based services, and mobile apps for millions of users.

He is also an author and has written three books for Packt Publishing on iOS, Windows Phone, and iBooks Author, respectively. He is currently building the technical backbone for a self-drive car rental start-up in India.

Eric-Jan Groen started his GIS adventure when he started working at Automotive Navigation Data. They gave him the opportunity to experiment and explore the world of GIS. They gave him carte blanche and he worked on special products for them. While he worked there, Milo van der Linden was an inspiration to him from the beginning; later on, Milo left and he ventured forward on his own. With Bojan Sobocan acting as his supervisor, he initiated many projects and always found new tools and ways to complete the tasks he was given.

After proofreading a book on GeoServer and having had a good time doing it, reviewing this book was just as welcome.

Håvard Wahl Kongsgård is akin to a Swiss army knife when he's performing data exploration. He believes that he predicted events in small wars in a previous life. He's worked with everything from military projects and mine-clearing operations to epidemiology.

Currently, he's finishing a PhD in spatial epidemiology while working with a start-up.

Richard Zijlstra is a civil engineer with technical planning and GeoICT in general. He has used his engineering degree in The Netherlands to work on projects related to water management, infrastructure planning, and geographical information management as well as with earthquakes in Greece (Patras), all of which have an effect on environmental and social aspects. He collaborates system architecture, requirement management, and the development of geographical information technology.

At the moment, he is involved in developing an Enterprise Geo Data Architecture to store open data on earthquakes, safety, and gas exploration in the Groningen province of the northern part of The Netherlands. The project group is being set up together by University of Groningen with Geodienst at @CIT_RUG. Gas extraction in this area can often lead to earthquakes and also cause damage to buildings and infrastructure. The project group will set up an open geodata storage to collaborate all kinds of data, which will deal with the situation in this area.

His vision is, "Everybody uses and shares their own geographical information to share and update each other's knowledge about the physical and social environment." His mission is to find out what, where, when and why....

He is the founder and owner of Geoneer. Using his vision and point of view, he hopes that Geoneer will help and collaborate in all the aspects of geographical information technology worldwide. You can find them on Twitter at @Geoneer and LinkedIn at http://www.linkedin.com/in/geoneer/.

He has also written a lot of documents, system architectures, and about the usage of geographical information technology. The books OpenLayers Cookbook, Packt Publishing, and Mastering GeoServer, Pack Publishing, were also reviewed by him for their textual context .