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

Aerial view of town of Wailuku in Maui, Hawaii with mountains in background against cloudy sunset sky.

Maui's Vacation Rental Debate Turns Ugly

Verbal attacks, misinformation campaigns and fistfights plague a high-stakes debate to convert thousands of vacation rentals into long-term housing.

July 1, 2025 - Honolulu Civil Beat

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 9, 2025 - Diana Ionescu

Map of Haussmann's redesign of Paris in the 1850s through 1870s under Napoleon III.

In Urban Planning, AI Prompting Could be the New Design Thinking

Creativity has long been key to great urban design. What if we see AI as our new creative partner?

June 30, 2025 - Tom Sanchez

Red and white "Wildfire Evacuation Route" sign on signpost.

Cal Fire Chatbot Fails to Answer Basic Questions

An AI chatbot designed to provide information about wildfires can’t answer questions about evacuation orders, among other problems.

July 10 - The Markup

Protester at Echo Park Lake, Los Angeles holding sign that says "Housing is a human right"

What Happens if Trump Kills Section 8?

The Trump admin aims to slash federal rental aid by nearly half and shift distribution to states. Experts warn this could spike homelessness and destabilize communities nationwide.

July 10 - Shelterforce Magazine

Aerial of rainbow painted crosswalks at large intersection in Castro District, Sna Francisco, California.

Sean Duffy Targets Rainbow Crosswalks in Road Safety Efforts

Despite evidence that colorful crosswalks actually improve intersection safety — and the lack of almost any crosswalks at all on the nation’s most dangerous arterial roads — U.S. Transportation Secretary Duffy is calling on states to remove them.

July 10 - Streetsblog USA

Urban Design for Planners 1: Software Tools

This six-course series explores essential urban design concepts using open source software and equips planners with the tools they need to participate fully in the urban design process.

Planning for Universal Design

Learn the tools for implementing Universal Design in planning regulations.

Home and Land Services Coordinator

Appalachian Highlands Housing Partners

Associate/Senior Planner

Gallatin County Department of Planning & Community Development

Senior Planner

Heyer Gruel & Associates PA

Write for Planetizen