Tips for the PostGIS Power User

Presentation | Presented

  • Kevin Neufeld, Refractions Research

PostGIS, following the OpenGIS "Simple Features Specification for SQL", is a PostgreSQL database extension that "spatially enables" the server back-end to support the storage of geometric objects in an object-relational PostgreSQL database.

Storing spatial data is one thing - accessing spatial data is another. This talk will endeavor to bring insight to efficient spatial data access, getting the answers you need, perhaps even answers to questions you've never previously thought possible. Knowing when to use spatial indexes, choosing the right spatial operations, or using inherent PostgreSQL functionality like table partitioning all contribute to the effectiveness of your spatial storage medium. Additional topics include: defining custom spatial relate operations using the Dimensionally Extended 9 Intersection Model (DE-9IM), database tuning, and other performance guidelines.

Following a few such PostGIS tips for the power user, this discussion will put theory into practice and walk through several examples of PostGIS in action.

Supporting Files