Site Contents

• Register

• About FOSS4G
• Important Dates
• Sponsors
• Contacts

• Program Overview
• Plenaries
• Presentations
• Labs
• Workshops
• Exhibition
• Events

• Travel Information
• Accommodations
• Special Activities

• About Victoria
• Dining & Shopping
• Nanaimo & Vancouver Island
• The Gulf Islands

Home > Presentations

PostGIS Spatial Database: Introduction and Case Studies

Presentation | Presented

• Paul Ramsey, Refractions Research

A set of three case studies, showing how PostGIS is used in high-performance production situations by private companies and government.

PostGIS is an open source spatial data extension to the PostgreSQL relational database management system. Like Oracle Spatial, PostGIS provides extra spatial objects, functions and indexes to the underlying RDBMS, allowing powerful GIS storage, analysis and retrieval to be carried out at the server tier of enterprise IT infrastructures.

The PostGIS spatial database has been publicly available for over five years, and global uptake of the software has been tremendous. In addition to near-universal support from open source tools, PostGIS is increasingly supported by proprietary tools as well.

All this interconnectivity means that PostGIS is being built into more and more operational data centres, serving large volumes of data for clients with high performance and reliability requirements. This session will review three case-studies showing PostGIS being used in the government and private sector as an operational spatial database: GlobeXplorer, the Institut Geographic National, and the North Dakota State Water Commission.

Supporting Files

• PostGIS Case Studies.ppt