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.
Seattle Legalizes Co-Living
A new state law requires all Washington cities to allow co-living facilities in areas zoned for multifamily housing.
NYC Officials Announce Broadway Pedestrianization Project
Two blocks of the marquee street will become mostly car-free public spaces.
The City of Broken Sidewalks
Can Los Angeles fix 4,000 miles of broken sidewalks before the city hosts the 2028 Olympic Games?
Study: Automobile Dependency Reduces Life Satisfaction
Automobile dependency has negative implications for wellbeing. This academic study finds that relying on a car for more than 50 percent of out-of-home travel is associated with significant reductions in life satisfaction.
San Diego School District Could Accelerate Workforce Housing Program
A proposal to build housing on five district-owned properties could yield 1,000 housing units for low- and moderate-income district employees.
Denver Transit Board Approves $1.2 Billion Budget
The 2025 budget for the Regional Transportation District is the largest in the agency’s 55-year history.
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.
Alamo Area Metropolitan Planning Organization
Village of Glen Ellyn
City of Laramie
American Planning Association, Sustainable Communities Division
HUDs Office of Policy Development and Research
City of Cambridge, Maryland
Newport County Development Council: Connect Greater Newport
Rockdale County Board of Commissioners
