Category Archives for database
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
Tips and Tricks for writing PostGIS Spatial Queries (bostongis.com)
The guys from bostongis.com gave a presentation at OSCON 2009 last week about writing PostGIS spatial queries. You can download the presentation here, but these are main points (please note that these tips & tricks are all meant for PostGIS … Continue reading
Geostack Workshop
Couple of days ago, Paul Ramsey and Steven Citron-Pousty gave a workshop at GeoWeb (@ Vancouver, BC) on installing, configuring and using a complete open source geospatial application stack (database, application server, web app & desktop. Except for the desktop … 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
MapServer gets a speedbump
A one day code sprint in Toronto, and MapServer gets the following improvements: Paul Ramsey: Sprint Day #3 Impressive!