Changes between Version 51 and Version 52 of CLC Join

Timestamp:

Jun 1, 2010 12:55:09 PM (15 years ago)

Author:

cedric

Comment:

--

CLC Join

@@ -46 +46 @@
 It uses ''' ST_Intersects ''' to reduce the search list and ''' ST_Multi(ST_Intersection()) ''' to cut along the primary catchments borders.
 As a result of using the catchment database only for Britany, the layers that were outside from Britany geographic range are now discarded[[BR]]
-Note also that in postgres some lines apear as void of data even when using ''' CAST(ST_AsText() ''' but that those line provide answer FALSE using either ''' ST_IsValid () ''' or ''' ST_IsEmpty() ''' or ''' IS NULL '''. We had doubts at the beginning as the file was not displayed in Qgis, but the reason was probably not those apparent voids but '' probably changing ~~ST_Multi(ST_Intersection(clc.the_geom, c.the_geom)) AS the_geom~~ into ST_Multi(ST_Intersection(clc.the_geom, c.the_geom))  the_geom ''. 
+Note also that in postgres some lines apear as void of data even when using ''' CAST(ST_AsText() ''' but that those line provide answer FALSE using either ''' ST_IsValid () ''' or ''' ST_IsEmpty() ''' or ''' IS NULL '''. We had doubts at the beginning as the file was not displayed in Qgis, but the reason was probably not those apparent voids but '' probably changing ~~ST_Multi(ST_Intersection(clc.the_geom, c.the_geom)) AS the_geom~~ into ST_Multi(ST_Intersection(clc.the_geom, c.the_geom))  the_geom ''. Here we say probably as working with Gis still holds some mysteries.
 {{{
 #!sql