In the latest entry of our collection of case studies, read about how the Institut Géographique National is using PostGIS to manage over 100 million topographic features in PostGIS/PostgreSQL and provide read/write access to over 100 field researchers around the country.

The 1.1.5 maintenance release of PostGIS is now available. This is a very minor bugfix and compatibility release. The following changes have occurred:

• Java:
  • Removed obsolete synchronization from Jts code.
  • Fixed nullpointer Exception in Geometry.equals() method
  • Added EJB3Spatial.odt to fulfill the GPL requirement of distributing the "preferred form of modification"
• Added -S option for non-multi geometries to shp2pgsql
• Updated heavily outdated README files for shp2pgsql/pgsql2shp by merging them with the manpages.
• Fixed MingW link error that was causing pgsql2shp to segfault on Win32 when compiled for PostgreSQL 8.2

In the latest entry of our collection of case studies, read about how Orchard Park, New York is using PostGIS to manage their physical infrastructure inventory.

The 1.1.4 maintenance release of PostGIS is now available. This is a minor bugfix and compatibility release. The following changes have occurred:

• Fixed support for the upcoming PostgreSQL 8.2 release
• Fixed bug in collect() function discarding SRID of input
• Added SRID match check in MakeBox2d and MakeBox3d
• Fixed regress tests to pass with GEOS-3.0.0
• Improved pgsql2shp run concurrency
• Java:
  • Reworked JTS support to reflect new upstream JTS developers' attitude to SRID handling.
  • Simplified code and droped build dependency on GNU trove.
  • Added EJB2 support provided by the Geodetix s.r.l. Company.
  • Added EJB3 tutorial and examples provided by Norman Barker.
  • Reorganized java directory layout somewhat.

It is finally official! After several years of unofficial “conformance” we recently took the plunge and submitted our PostGIS 1.1 compliance tests to the OpenGIS Consortium for testing. Last week we received the news that we are compliant. That means our web site can proudly display the OpenGIS button badge, and… well not much more than that. It is still the same database after all. But it is still nice to get some external validation.

The fourth annual world gathering of open source geospatial developers and users this year is FOSS4G in Lausanne, Switzerland from September 12-16. From the PostGIS development team, Paul Ramsey and Sandro Santilli (better known as "strk") will be in attendance and giving talks, we hope to see you there!

In the third entry of our collection of case studies, read about how the UC Davis Soils lab is using PostGIS to support their research and provide public access to soil survey data.

In the second entry of our collection of case studies, read about how GlobeXplorer is using PostGIS to serve millions of image and map requests every day.

In the first entry of our collection of case studies, read about how the North Dakota State Water Commission is using PostGIS to provide better services to the citizens of North Dakota.

Do you want a cool case study about your PostGIS installation? Send an email to pramsey@cleverelephant.ca with 500-1000 words answering the questions: who are you? what was your problem? how has postgis helped solve your problem? how do you feel now? what are you going to do next?

The popularity of PostGIS continues to grow every year! While there is no such thing as "sales figures" for an open source project, there are at least statistics about web site use, code downloads, and so on.

Here are the current numbers!

• 1101 mailing list members
• 24117 hits per day on web site
• 3532 visits per day on web site
• 100 downloads per day of source code
• top search string references "postgis" and "shp2pgsql"
• 813000 google search results
• great google trends