Other News

PostGIS 3.4.0 Released

Aug 16, 2023

SMART 7.5 Released

Apr 1, 2023

PostGIS 3.3 Released

Aug 27, 2022

PostGIS 3.2.2 Released

July 23, 2022

PostGIS 3.2.1 Released

Feb 12, 2022

SMART 7 Released

Nov 29th, 2021

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.