Changes between Version 27 and Version 28 of CLC Join


Ignore:
Timestamp:
Jun 1, 2010 12:00:12 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • CLC Join

    v27 v28  
    44We 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. 
    55== 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. 
     6After 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. 
    77{{{ 
    88#!sql 
     
    3131== Cutting the surface according to the catchments area == 
    3232Note 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. 
     33It uses ''' ST_Intersects ''' to reduce the search list and ''' ST_Multi(ST_Intersection()) ''' to cut along the primary catchments borders. 
    3434{{{ 
    3535--------------------------------------