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.
The state-sanctioned urbicide of Austin
People don’t kill cities. Freeways do.
Colorado’s Largest Data Center Could Rise Next to Homes — Without a Public Hearing
The proposed campus would consume 11 times the power of Denver International Airport; as it has across the country, opposition mounts.
Judges permit Denver to divert 77,000 acre feet from the Colorado River for reservoir expansion
Overuse and climate change have caused the Colorado River’s water levels to plummet.
Amtrak, CN end decades-long dispute with eight-year agreement
The new operating agreement establishes an updated framework for the companies to work together, including processes to resolve disputes.
Raised interest rates may kill financially vulnerable construction projects
The chief economist at ConstructConnect warns that if construction project owners are negatively impacted by the raised rates, it could result in delayed payments to contractors.
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.
KFH Group Inc.
Greater Baltimore Committee
Eagle County Government
The Architects Foundation
University of Cincinnati Online
The Pocatello Development Authority
The Urban Renewal Agency of the City of Pocatello
