Other News

Refractions' 10 Year Anniversary

April 11, 2008

Refractions Receives GSA Schedule

February 12, 2008

GEOS 3.0.0 Released

December 12, 2007

Refractions @ FOSS4G 2007

September 24, 2007

FOSS4G 2007 Coming to Victoria

January 10, 2007

Refractions joins Google's Summer of Code

April 16, 2006

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.