OpenStreetMap Support
Category Archives: PostGIS
Geospatial @ RailsConf Europe 2007
Some great news for those interested in the convergence between Ruby/Rails and Geospatial applications. Kashif and I will be giving a tutorial at RailsConf in Berlin. There is going to be 3 hr tutorial titled Rails GIS Hacks, where we will be going through some pretty nifty stuff such as RESTful geospatial applications development. [...]
Also posted in Mapserver, OGC, RubyOnRails, Spatial Analysis, WebGIS, event, interoperability, opensource Leave a comment
rotation in postgis
It appears the rotate function in PostGIS only rotates the geometry about the center of the co-ordinate systems. There was a neat little trick that was mentioned on the postgis-list by Bruce Rindhal to rotate a polygon about its center:
CREATE TABLE shapes (gid serial PRIMARY KEY, name varchar);
SELECT AddGeometryColumn('', 'shapes', 'the_geom', -1, 'POLYGON', 2);
INSERT [...]
Posted in PostGIS 4 Comments
Pakistan Wetlands and Ramsar listed sites
Wetlands are regarded by nature conservationist as unique ecosystems. They often exhibit delicately balanced environmental conditions and support a wide range of exotic plant and animal species. Wetlands are also often protected by various environmental laws and conventions. Last year when I was visiting Pakistan I learned about the Pakistan Wetlands Project that is under [...]
Also posted in Earth, RubyOnRails, WebGIS, opensource Leave a comment
postgis template database
Some might find this useful for creating PostGIS databases without having to be postgresql superusers. The idea is to create a template_postgis database, install plpgsql and postgis into it, and then use this database as a template when creating new PostGIS databases.
$ psql template1
\c template1
CREATE DATABASE template_postgis WITH template = template1;
-- set the 'datistemplate' record [...]
Posted in PostGIS 2 Comments
PostGIS & Oracle Spatial Price Comparison
Ken Lord emailing to the annual “Who’s using PostGIS and for What?” inquiry wrote in detail about his experienes with Oracle and also a justification for decision to chose PostGIS over Oracle Spatial. I thought it was quite insightfull for anyone who are doing a cost/benefit analysis of choosing a spatial database for their next [...]
Also posted in opensource Leave a comment
PostGIS for the python folks
Richard Taylor has release an update to GeoType — a python library that implements OGC Simple Features Specification and PostGIS geometry in Python. It has integration with Psycopg & python-postgresql interface. This ones for you gus ;)
GeoTypes
Also posted in OGC, Python, opensource 1 Comment
template-postgis database