An easy to use guide, full of handson recipes for manipulating spatial data in a PostGIS database. Each topic is explained and placed in context, and for the more inquisitive, there are more details of the concepts used. If you are a web developer or a software architect, especially in locationbased companies, and want to expand the range of techniques you are using with PostGIS, then this book is for you. You should have some prior experience with PostgreSQL database and spatial concepts.
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 opensource 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 opensource GIS at http://www.paolocorti.net/. He is the author of the book's chapters 1, 3, 8, and 9. Thomas J. Kraft is currently a Planning Technician at Cleveland Metroparks after beginning as a GIS intern in 2011. He graduated with Honors from Cleveland State University in 2012, majoring in Environmental Science with an emphasis on GIS. When not in front of a computer, he enjoys his weekends landscaping and the outdoors in general. Stephen Vincent Mather has worked in the geospatial industry for 15 years, having always had a flair for geospatial analyses in general, especially those at the intersection of Geography and Ecology. His work in opensource geospatial databases started 5 years ago with PostGIS and he immediately began using PostGIS as an analytic tool, attempting a range of innovative and sometimes bleedingedge techniques (although he admittedly prefers the cutting edge). His geospatial career has spanned a variety of interesting and novel naturalresource projects, everything from the movement of ice sheets in Antarctica to hiking viewsheds and mobile trail applications to help park users find trails, picnic areas, and restrooms. Stephen is currently the GIS manager for Cleveland Metroparks in Cleveland, Ohio. He manages a small geospatial shop that specializes in highend cartography, crating and generating data, geospatial web development, and analyses for naturalresource management, largely with opensource software. Stephen is also a Mennonite technologist, aka a strawhat hacker, interested in creating fair and open data and infrastructure for better governance and humanitarian purposes. Stephen is heavily involved in the Cleveland Civic Hacking movement as he works with the public to help them get engaged with geospatial data. In his spare time, he builds guitars really, really slowly. Bborie Park has been breaking (and subsequently fixing) computers for most of his life. His primary interests involve developing endtoend pipelines for spatial datasets. He is an active contributor to the PostGIS project and is a member of the PostGIS Steering Committee. He happily resides with his wife Nicole in the San Francisco Bay Area.
Bborie Park, Paolo Corti, Stephen Vincent Mather, Thomas J. Kraft