Changes between Version 49 and Version 50 of CLC Join

Timestamp:

Jun 1, 2010 12:52:45 PM (15 years ago)

Author:

cedric

Comment:

--

CLC Join

@@ -43 +43 @@
 
 
-Note this one took a long time to run on my computer, one hour for Britany...
+Note this one took a long time to run on my computer, one hour for Britany... [[BR]]
 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
+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 '' it seems to work.
 {{{
 #!sql