Le blog de Mathieu Leplatre
Drape lines on a DEM with PostGIS
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.
Test your Leaflet applications with Mocha
Pretty much like n1k0, I feel like I had learned Javascript three or four times, from the alert() back in 1997 to this article about automatic testing.
Subtivals, ready for Cinelatino !
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 !
Django : Do not forget Do Not Track
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.
Subtivals 1.4 is out
Since the article introducing Subtivals was
published, a lot of exciting things happened !
Cheap debugging of PostgreSQL triggers in Django
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 :
Leaflet Tiles in Lambert 93 projection (2154)
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.
landez : tiles post-processing
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 ! :)
Serve your map layers with a usual Web hosting service
Someone asked me about serving map tiles from a basic Web host.
Simple and funky Web map printing
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 :)