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.
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 "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.
Planetizen Federal Action Tracker
A weekly monitor of how Trump’s orders and actions are impacting planners and planning in America.
Canada vs. Kamala: Whose Liberal Housing Platform Comes Out on Top?
As Canada votes for a new Prime Minister, what can America learn from the leading liberal candidate of its neighbor to the north?
The Five Most-Changed American Cities
A ranking of population change, home values, and jobs highlights the nation’s most dynamic and most stagnant regions.
San Diego Adopts First Mobility Master Plan
The plan provides a comprehensive framework for making San Diego’s transportation network more multimodal, accessible, and sustainable.
Housing, Supportive Service Providers Brace for Federal Cuts
Organizations that provide housing assistance are tightening their purse strings and making plans for maintaining operations if federal funding dries up.
Op-Ed: Why an Effective Passenger Rail Network Needs Government Involvement
An outdated rail network that privileges freight won’t be fixed by privatizing Amtrak.
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.
New York City School Construction Authority
Village of Glen Ellyn
Central Transportation Planning Staff/Boston Region MPO
Institute for Housing and Urban Development Studies (IHS)
City of Grandview
Harvard GSD Executive Education
Regional Transportation Commission of Southern Nevada
Toledo-Lucas County Plan Commissions
