Changes between Version 27 and Version 28 of CLC Join
- Timestamp:
- Jun 1, 2010 12:00:12 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CLC Join
v27 v28 4 4 We chose to work on a reduced scale to build the queries as the clc is just damn too big for us, and raster approches are not yet avalaible in postgis, though we fancy using the functions displayed in the developpement page http://trac.osgeo.org/postgis/wiki/WKTRaster. 5 5 == building a table of clc only for Britany == 6 After several trial neither ---ST_Crosses--- nor ---ST_Contains---did work, the example with ST_Intersects provides a surface that is larger than britany, but ST_Crosses missed the area near the coasts as the geom had to be fully within Britany.6 After several trial neither ''' ST_Crosses ''' nor ''' ST_Contains ''' did work, the example with ST_Intersects provides a surface that is larger than britany, but ST_Crosses missed the area near the coasts as the geom had to be fully within Britany. 7 7 {{{ 8 8 #!sql … … 31 31 == Cutting the surface according to the catchments area == 32 32 Note this one took a long time to run on my computer, one hour for Britany... 33 It uses --- ST_Intersects --- to reduce the search list and -- ST_Multi(ST_Intersection())to cut along the primary catchments borders.33 It uses ''' ST_Intersects ''' to reduce the search list and ''' ST_Multi(ST_Intersection()) ''' to cut along the primary catchments borders. 34 34 {{{ 35 35 --------------------------------------