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.

Large blank mall building with only two cars in large parking lot.

Pennsylvania Mall Conversion Bill Passes House

If passed, the bill would promote the adaptive reuse of defunct commercial buildings.

April 18, 2024 - Central Penn Business Journal

Street scene in Greenwich Village, New York City with people walking through busy intersection and new WTC tower in background.

Planning for Accessibility: Proximity is More Important than Mobility

Accessibility-based planning minimizes the distance that people must travel to reach desired services and activities. Measured this way, increased density can provide more total benefits than increased speeds.

April 14, 2024 - Todd Litman

Rendering of wildlife crossing over 101 freeway in Los Angeles County.

World's Largest Wildlife Overpass In the Works in Los Angeles County

Caltrans will soon close half of the 101 Freeway in order to continue construction of the Wallis Annenberg Wildlife Crossing near Agoura Hills in Los Angeles County.

April 15, 2024 - LAist

Facade of brick multistory apartment buildings in New York City with fire scapes.

New York Passes Housing Package Focused on New Development and Adaptive Reuse

The FY 2025 budget includes a new tax incentive, funding for affordable housing on state land, and support for adaptive reuse and ADUs.

2 minutes ago - Governor Kathy Hochul

"No 710" lawn sign on green lawn.

LA Metro Board Approves New 710 Freeway Plan

The newest plan for the 710 corridor claims it will not displace any residents.

April 22 - Streetsblog LA

Close-up of row of electric cars plugged into chargers at outdoor station.

Austin’s Proposed EV Charging Rules Regulate Station Locations, Size

City planners say the new rules would ensure an efficient distribution of charging infrastructure across the city and prevent an overconcentration in residential areas.

April 22 - Austin Monitor

News from HUD User

HUD's Office of Policy Development and Research

Call for Speakers

Mpact Transit + Community

New Updates on PD&R Edge

HUD's Office of Policy Development and Research

Write for Planetizen

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.