Tips and Tricks for Writing PostGIS Spatial Queries

Location: Ballroom A2
Average rating: ****.
(4.00, 1 rating)

PostGIS is an Open Source spatial extender for the PostgreSQL database. It is used as the backend for many small and large scale GIS applications. Its main strengths are its breath of functionality, ease of use, speed, and of course price which allows it to be deployed in cloud computing architectures without worrying about licensing costs.

PostGIS is very easy to get started with, but to get the most out of there are things you learn with experience.

In this session we will go into the top 10 things you need to know about PostGIS to help improve your queries and to write cleaner and more efficient spatial queries.

We will be targeting the PostGIS 1.4/GEOS 3.1.0 release and PostgreSQL 8.3/8.4


Paragon Corporation

Leo Hsu is a co-founder of Paragon Corporation. He is a database developer with extensive experience in web application development using PHP and ASP.NET and extensive database experience using PostgreSQL/PostGIS building business intelligence and automation applications

Regina Obe

Paragon Corporation

Regina Obe is a co-founder of Paragon Corporation. She is also a member of the PostGIS core development team.

She has over 15 years professional experience in various programming languages and database systems. She developed her love of programming as a young child and later fell in love with databases, data, data as code.

She especially loves spatial databases
and has been using PostGIS for government and commercial apps since its inception and recently SQL Server 2008 spatial features.

  • Intel
  • Microsoft
  • Google
  • Sun Microsystems
  • Facebook
  • Gear6
  • Kaltura
  • Liferay
  • MindTouch
  • Novell, Inc.
  • Open Invention Network
  • Rackspace Cloud
  • Schooner Information Technology
  • Silicon Mechanics
  • Symbian Foundation
  • Twilio
  • WSO2
  • Yabarana Corporation

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the OSCON Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

OSCON Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON newsletter (login required)

Contact Us

View a complete list of OSCON contacts