A while ago I’ve compiled PostGIS 1.5.2 for PostgreSQL 9.0. To install it on Ubuntu the following steps are required: apt-get install python-software-properties add-apt-repository ppa:ubuntugis/ubuntugis-unstable add-apt-repository ppa:pitti/postgresql add-apt-repository ppa:pi-deb/gis apt-get update apt-get install postgresql-9.0-postgis A basic template database can be created with the following commands: sudo su - postgres createdb template_postgis psql -q -d template_postgis -f /usr/share/postgresql/9.0/contrib/postgis-1.5/postgis.sql psql -q -d template_postgis -f /usr/share/postgresql/9.0/contrib/postgis-1.5/spatial_ref_sys.sql psql -q -d template_postgis -f /usr/share/postgresql/9.0/contrib/postgis_comments.sql cat <<EOS | psql -d template_postgis UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template_postgis'; REVOKE ALL ON SCHEMA public FROM public; GRANT USAGE ON SCHEMA public TO public; GRANT ALL ON SCHEMA public TO postgres; GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE public. Read on

A short visit and 7 hours train ride to the OpenLayers code sprint mainly for a presentation at the Swiss MapFish user group meeting in Lausanne, resulted in a new release of the QGIS OpenLayers plugin. The OpenLayers plugin adds WebKit based layers to QGIS and ships with OpenStreetMap-, Google- and Yahoo-Layers. Changes in this release: Update to OpenLayers trunk Google Layers using API V3 (no API key necessary) Code refactoring for adding new layer types with one line of code (and some HTML…) The next planned step is integrating this plugin with the very nice Openlayers Overview plugin from Luiz Motta. Read on

QGIS server is already known as a full featured, WMS 1.3 compliant map server (see e.g. ETHZ, Linfiniti or 3LIZ). For the city of Uster, Switzerland, Sourcepole recently extended QGIS server with the possibility to use the print composer via WMS in order to offer printing functionality for web maps. A very nice GeoExt based client can be found at http://gis.uster.ch/webgis/. Andreas Neumann used and extended the GeoExt PrintProvider and PrintExtent classes which allows the user to intuitively select a layout, extent, scale, rotation and resolution for printing. Read on

(This article is part of the JMeter Series) Useful ways to debug JMeter as far as I know: insert a “Debug Sampler” the “Debug Sampler” will emit “everything that’s known” to JMeter. That output can be displayed in the “View Results Tree Listener”: have a look at the JMeter log file (which is usually dumped from where you’ve started JMeter) check the output of one of the listeners such as the “View Results Tree Listener”. Read on

(This article is part of the JMeter Series) In the following we’ll do these things: we go to a form submit page we order something we get that something we ordered In more detail: We use a “Cookie Manager” to carry forward cookies between calls We set up our variables The idea here being that we predefine the variables, so they would show up in the “Debug Sampler” which makes debugging easier, because you see at each step, whether the variable has the correct value or not. Read on