PostGIS - Geographic Objects In PostgreSQL

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.

2 minute read

June 17, 2004, 4:30 PM PDT

By Abhijeet Chavan @legalaidtech


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

Abhijeet Chavan is the co-founder and former co-editor-in-chief of Planetizen and the executive producer of Planetizen Courses. He was also the chief technology officer of Urban Insight, Inc., the technology consulting firm that operates Planetizen. Abhijeet Chavan has over 20 years of technology consulting experience working with government, higher education, legal services, and non-profit clients.

portrait of professional woman

I love the variety of courses, many practical, and all richly illustrated. They have inspired many ideas that I've applied in practice, and in my own teaching. Mary G., Urban Planner

I love the variety of courses, many practical, and all richly illustrated. They have inspired many ideas that I've applied in practice, and in my own teaching.

Mary G., Urban Planner

Cover CM Credits, Earn Certificates, Push Your Career Forward

Logo for Planetizen Federal Action Tracker with black and white image of U.S. Capitol with water ripple overlay.

Planetizen Federal Action Tracker

A weekly monitor of how Trump’s orders and actions are impacting planners and planning in America.

July 16, 2025 - Diana Ionescu

Green vintage Chicago streetcar from the 1940s parked at the Illinois Railroad Museum in 1988.

Chicago’s Ghost Rails

Just beneath the surface of the modern city lie the remnants of its expansive early 20th-century streetcar system.

July 13, 2025 - WTTV

Blue and silver Amtrak train with vibrant green and yellow foliage in background.

Amtrak Cutting Jobs, Funding to High-Speed Rail

The agency plans to cut 10 percent of its workforce and has confirmed it will not fund new high-speed rail projects.

July 14, 2025 - Smart Cities Dive

Worker in yellow safety vest and hard hat looks up at servers in data center.

Ohio Forces Data Centers to Prepay for Power

Utilities are calling on states to hold data center operators responsible for new energy demands to prevent leaving consumers on the hook for their bills.

July 18 - Inside Climate News

Former MARTA CEO Collie Greenwood standing in front of MARTA HQ with blurred MARTA sign visible in background.

MARTA CEO Steps Down Amid Citizenship Concerns

MARTA’s board announced Thursday that its chief, who is from Canada, is resigning due to questions about his immigration status.

July 18 - WABE

Rendering of proposed protected bikeway in Santa Clara, California.

Silicon Valley ‘Bike Superhighway’ Awarded $14M State Grant

A Caltrans grant brings the 10-mile Central Bikeway project connecting Santa Clara and East San Jose closer to fruition.

July 17 - San José Spotlight