Tag Archives for postgis
adding google srid (900913) to postgis
I was loading some openstreetmap data into my postgis, when I noticed that postgis doesn’t include the unofficial google projection (900913). The official one is 3785, but osm2pgsql still uses 900913. Searched around a bit, and found following working insert … Continue reading
PostgreSQL Tips and Tricks
Couple of weeks ago, I wrote an article about writing PostGIS Spatial Queries (here). Today I found the following post: PostgreSQL Tips & Tricks. There are a couple of tips for working with a PostgreSQL database. Here’s a summary: don’t … Continue reading
New version PostGIS 1.4
The new version of PostGIS has arrived! This release contains some big performance improvements, as well ass some restructuring under the hood! check this: http://www.postgis.org/pipermail/postgis-users/2009-July/024035.html Some of the new features: – ST_Union() uses high-speed cascaded union when compiled against GEOS … Continue reading
New Book: PostGIS in Action
Regina Obe and Leo Hsu have a new book coming out, and it’s called PostGIS in Action. When you look at the table of content, you can see all the relevant topics are covered, and even the new WKT Raster! … Continue reading