Other News

20 Year Anniversary!

Sept 1, 2017

PostGIS 2.3.3 Release

July 1, 2017

PostGIS 2.3.0 Release

Sept 26, 2016

SMART Update

Apr 20, 2016

PostGIS 2.2.2 Release

Mar 22, 2016

PostGIS Presented at Open Source Database Summit

Dave Blasby, lead developer of the PostGIS/PostgreSQL open-source spatial database, will be giving a presentation on "Building a Spatial Database in PostgreSQL" at the Open Source Database Summit in Providence, Rhode Island, on September 25, 2001.

The Open Source Database Summit is an annual gathering of the top developers and companies involved in open source databases. Topics covered at the summit include:

  • Database Internals
  • Real World Database Applications
  • MySQL/PostgreSQL/Interbase
  • Writing Database Applications (front-ends, etc.)
  • Database Programming Concerns
  • Kernel And File System Concerns
  • Writing Efficient SQL
  • Database Administration
  • Database Hardware Interaction

Blasby's presentation will detail the importance of spatial data to many organizations, and the database support necessary to efficiently store and manipulate spatial data.

  1. What is a Spatial Database?
  2. What is spatial data?
  3. What are spatial relationships?
  4. Why put spatial data in a DB?
  5. Advantages and uses of spatial databases
  6. Disadvantages of spatial databases
  7. What is the OpenGIS consortium and what does it do?
  8. Why make PostgreSQL into an OpenGIS compliant DB?
  9. Implementing the OpenGIS specification
  10. Indexing geometric types using the GiST index
  11. Client software
  12. Open Standards in a Proprietary World
  13. Project Status

For more information about PostGIS, see the main PostGIS project page at http://postgis.refractions.net.