Re: [postgis-users] Calculate area of raster/polygon intersections in PostGIS

2015-04-16 Thread Pierre Racine
1 - What's the best way to do raster/polygon intersections? I read about two different approaches, one using ST_Intersection and the other one using ST_Clip. The second one apparently is faster and more efficient, but i don't know about its precision. The precision depends on the sizes of

[postgis-users] Calculate area of raster/polygon intersections in PostGIS

2015-04-16 Thread Roberto Lazarte Kaqui
I have a raster with one band that represents the deforested area in the Amazon. This raster has 13 categories representing the deforested area in each year from 2001 to 2013. Beyond this raster data, i have a database with 800 polygons that represents 800 cities of the Amazon region. My