Packt Publishing PostGIS Cookbook (2014).pdf

PostGIS Cookbook

Over 80 task-based recipes to store, organize, manipulate,

and analyze spatial data in a PostGIS database

Paolo Corti

Thomas J Kraft

Stephen Vincent Mather

Bborie Park

BIRMINGHAM - MUMBAI

PostGIS Cookbook

transmitted in any form or by any means, without the prior written permission of the publisher,

except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the

information presented. However, the information contained in this book is sold without

warranty, either express or implied. Neither the authors, nor Packt Publishing, and its dealers

and distributors will be held liable for any damages caused or alleged to be caused directly or

indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies

and products mentioned in this book by the appropriate use of capitals. However, Packt

Publishing cannot guarantee the accuracy of this information.

First published: January 2014

Production Reference: 1200114

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-84951-866-6

www.packtpub.com

Cover Image by Charles E. Mather ( matherc@yahoo.com )

Credits

Authors

Paolo Corti

Thomas J Kraft

Copy Editors

Shambhavi Pai

Kirti Pai

Stephen Vincent Mather

Tanvi Gaitonde

Bborie Park

Dipti Kapadia

Reviewers

Jorge Arévalo

Project Coordinator

Mary Alex

Andrea Flesca

Proofreaders

Lauren Harkins

Acquisition Editor

Mary Jasmine Nadar

Stephen Copestake

Lead Technical Editor

Azharuddin Shaikh

Indexers

Rekha Nair

Tejal Soni

Technical Editors

Vrinda Nitesh Bhosale

Rahul Nair

Production Coordinator

Shantanu Zagade

Anita Nayak

Cover Work

Shantanu Zagade

Humera Shaikh

About the Authors

Paolo Corti is based in Rome, Italy. He is an environmental engineer with more than

15 years of experience in the GIS sector. After working with proprietary solutions for some

years, he has proudly switched to open-source technologies and Python for almost a decade.

He has been working as a developer and analyst for organizations such as the EU Joint

Research Center, UN World Food Program, and the Italian Government.

Currently, he is working within the GeoNode project, for which he is a core developer, in the

context of emergency preparedness and response.

He is an OSGeo Charter member and writes a blog on open-source GIS at

http://www.paolocorti.net/ .

He is the author of the book's chapters 1, 3, 8, and 9.

I would like to thank the PostGIS Steering Committee and everyone else who

makes PostGIS such a beautiful project.

A special thanks must go to the co-authors of this book: they have been

brilliant mates always ready to give me suggestions and help.

A mention is needed here to some geospatial minds that are great source

of inspiration for me: Paul Ramsey, Sandro Santilli, Frank Warmerdam,and

Even Rouault.

Last, but not least, I would like to thank my wife Renata and my family for

their support and patience.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: