27 Jun
2011
27 Jun
'11
9:40 p.m.
Hi Beni
2011/6/27 Beni Buess beni@benel.net: (...)
I still have to come up with a query to calculate the forest/wood area. Any hints?
Paste the following SQL query into the Query box of the PostGIS Terminal:
SELECT ST_Area(ST_Collect(way))::int8||' m2' FROM osm_polygon WHERE ("natural"='wood' OR landuse='forest')
It's based on a nightly update from the Geofabrik OSM extract of Switzerland.
Yours, Stefan