Le blog de Mathieu Leplatre
This article gives a few SQL commands to drape 2D geometries on a DEM (Digital Elevation Model), in order to obtain 3D geometries.
We use PostGIS 2, and its rasters support especially.
Load your DEM
Assuming you have a DEM compatible with GDAL, you can easily load the raster into the database using these commands.
The film festival CineLatino in Toulouse
opens its doors today ! And I've just delivered the source package of version Subtivals 1.5.0
to the building robots of Launchpad !
If you (fooly) Sail© on the Web® without Ghostery™,
this website is currently tracking you. Sad news, but there are indeed 3 widgets
(Disqus, Piwik and Twitter on the About page) that may collect data about your presence here.
Since the article introducing Subtivals was
published, a lot of exciting things happened !
Lately, we were hacking on PostgreSQL (PostGIS) triggers, and we quickly felt
like debugging our code... Here is a cheap and quick way of printing out
triggers variables and context through Django.
PostgreSQL server configuration
In postgresql.conf, adjust the minimum level of notice sent to the client :
What purpose ?
Ideally, unless living in Lapland, we should not be bothered that much about maps projections !
Unfortunately, in practice, there are a few contexts in which you simply
can't avoid braving them. For example, if you must show a raster layer with texts, and don't control its production.
Some weeks ago, I started to refactor landez (timidly).
But smart caching and post-processing of WMS maps were expected in my last project, so it gave me
a great boost : Landez 2.0 has landed ! :)
Someone asked me about serving map tiles from a basic Web host.
Strangely, users still insist in having Web page print capabilities, mostly to
share, export or archive what they see. Even if relevant permalinks are
often acceptable, we can't always dissuade them from printing :)