PostGIS - Geographic Objects In PostgreSQL

Abhijeet Chavan's picture
Staff
Five years ago, in an article titled "GRASS Is Now Greener" [Linuxpower, Oct 1999] , I had written about the significance of the GRASS GIS being released under the GPL and the potential of combining the newly "open-sourced" GIS with the open source MySQL database. A reader had commented that the open source PostgreSQL database was more commonly used with GRASS.

PostGIS Logo

PostGIS "spatially-enables" the open source PostgreSQL database. According to the PostGIS website, it is similar to the role played by ESRI's SDE or Oracle's Spatial extension. PostGIS 0.8.2 was released on May 27th, 2004. It is available under the GNU General Public License (GPL).

There are now several open source tools which work with PostGIS. For internet mapping, the University of Minnesota Mapserver can use PostGIS as a data source. The GeoTools Java GIS toolkit has PostGIS support, as does the GeoServer Web Feature Server. GRASS now supports PostGIS as a data source, through the PostGRASS driver. The JUMP Java desktop GIS viewer has a simple plugin for reading PostGIS data, and the QGIS desktop has good PostGIS support. PostGIS data can be exported to several output GIS formats using the OGR C++ library and commandline tools (and of cource with the bundled Shape file dumper). And of course any language which can work with PostgreSQL can work with PostGIS -- the list includes Perl, PHP, Python, TCL, C, C++, Java, and more.
Abhijeet Chavan is co-founder and co-editor-in-chief of Planetizen.

Comments

Prepare for the AICP Exam

Join the thousands of students who have utilized the Planetizen AICP* Exam Preparation Class to prepare for the American Planning Association's AICP* exam.
Starting at $199
Planetizen Courses image ad

Planetizen Courses

Advance your career with subscription-based online courses tailored to the urban planning professional.
Starting at $14.95 a month
Book cover of Insider's Guide to Careers in Urban Planning

So you want to be a planner...

Check out our behind the scenes look at 25 careers in the Urban Planning field
Starting at $14.95
Book cover of Unsprawl

Unsprawl: Remixing Spaces as Places

Explore visionary, controversial and ultimately successful strategies for building people-centered places.
Starting at $12.95