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.
California plans to bury El Niño’s downpour
If the state plays its cards right, it may be able to store a billion acre-feet of El Niño’s water in aquifers.
Desperate measures: Advocates weigh draining Lake Powell to fill Colorado River
Draining the reservoir could reduce evaporation losses by a couple hundred thousand acre-feet.
California appears to reject Prop. 45
The proposition would have expanded the projects that qualify for a streamlined environmental review, effectively paring down the California Environmental Quality Act.
Bay area voters pass ‘crucial lifeline’ for transit
Proposition RTM, which will fund Bay Area transit, has approval from 61% of voters as of 9:45 p.m. on Nov. 3.
Voters across the country reject data centers
Dozens of communities voted on measures to restrict the buildout of data centers.
FREE Course: Walkable City 1: Why Walkability?
After describing his path towards focusing on walkability as the essence of good planning, Jeff Speck marches through his five principal reasons for making more walkable places.
Reinventing Malls: Planning Alchemy—Turning Gray Fields Into Gold
The course focuses on the opportunities and imperatives that shape reinvention of mall sites.
City of Rosemead
Rutgers University, Edward J. Bloustein School of Planning and Public Policy
One Hundred Miles
Hunter College, City University of New York (CUNY)
The Architects Foundation
University of Cincinnati Online
City of Cambridge
Montrose County
The Pocatello Development Authority
