Home Home Archive Archive



MAR 25TH, 2011
Ubuntu PostGIS package for PostgreSQL 9.0

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


FEB 27TH, 2011
OpenLayers plugin visits code sprint

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


FEB 3RD, 2011
Web based printing with QGIS server

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


JAN 4TH, 2011
Debugging JMeter Tests

(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


JAN 4TH, 2011
Extracting text from a page and using it somewhere else in JMeter

(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
← Older Blog Archives Newer →

    Recent Posts

  • How to configure unattended-upgrades of packages from third party deb package repos
  • Updating company-wide and your own hosts with apt-dater
  • Executing Tasks in docker-compose Containers From ansible
  • Creating a quick PDF report from a DuckDB query

    Archive

  • 2025 4
  • 2024 5
  • 2023 7
  • 2022 6
  • 2021 8
  • 2020 6
  • 2019 10
  • 2018 3
  • 2017 3
  • 2016 4
  • 2015 7
  • 2014 9
  • 2013 17
  • 2012 13
  • 2011 29
  • 2010 26
  • 2009 17
  • 2008 9
  • 2007 4
  • 2006 18
  • 2005 2
  • 2004 8
  • 2003 22
  • 2002 5
  • 2001 6

    Categories

  • geo 105
  • linux 74
  • postgis 2
  • programming 36
  • qgis 69
  • qgiscloud 14

Copyright © 2001-2025 Sourcepole AG