Greetings, I am working on creating 10m buffers around roads: SELECT 10 AS score, ST_Difference( ST_Union(ST_Buffer(roads.the_geom, 10)), ST_Union(ST_Buffer(roads.the_geom, 0)) ) AS the_geom FROM geodata.roads2012_ca roads GROUP BY score So far I have the roads in dd (EPSG 4326) and was wondering how I could pass the distances in meters into the buffer function (without necessarily creating a new column with projected geometries). I guess could use some geography data type function .. but how ? Thanks Karsten
Karsten Vennemann Principal Terra GIS LTD 2119 Boyer Ave E Seattle, WA 98112 USA <http://www.terragis.net/> www.terragis.net Phone ++1 206 905 1711 Fax ++1 925 905 1711
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
