April 2011
Beginner to intermediate
520 pages
18h 55m
English
Overview
PostGIS in Action teaches readers of all levels to write spatial queries that solve real-world problems. It first gives you a background in vector-based GIS and then quickly moves into analyzing, viewing, and mapping data. You'll learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions for your own applications. The book covers PostgreSQL 8.4, 9.0, and 9.1 features and shows you how to integrate with other GIS tools.
About the Technology
PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing you to create location-aware queries with just a few lines of SQL code, and provides a back-end for mapping applications with minimal effort.
About the Book
What's Inside
- An introduction to spatial databases
- Geometry types, functions, and queries
- Applying PostGIS to real-world problems
- Extending PostGIS to web and desktop applications
About the Reader
Familiarity with relational database concepts is helpful but not required.
About the Authors
Regina Obe and Leo Hsu are database consultants. Regina is a member of the PostGIS core development team and the Project Steering Committee. They are hosts of BostonGIS.com and PostgresOnLine.com.
Quotes
From the forward: A concise guide that's truly one of a kind.
- Paul Ramsey, Chair, PostGIS Steering Committee
An elegant introduction to a difficult domain.
- Mark Leslie, LISAsoft Pty Ltd
The ultimate PostGIS tour guide.
- Brent Wood, NIWA
Will give you the Aha! moment you've been waiting for.
- Jeff Addison, Southgate Software Ltd
Want to get the most out of PostGIS? This is required reading for you.
- James Fee, WeoGeo.com
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.