[Gfoss] Spatialite cookbook r #14 - not st_disjoint

Beppe anardu.geol a yahoo.it
Dom 6 Apr 2014 19:56:35 CEST


Salve a tutti,
perdonate la mia esperienza ma sto scervellandomi  senza arrivare a capo
della funzione st_disjoint nel contesto della ricetta #14:

SELECT lc1.lc_name AS "Local Council",
  c.county_name AS County,
  r.region_name AS Region
FROM local_councils AS lc1
JOIN counties AS c ON (
  c.county_id = lc1.county_id)
JOIN regions AS r ON (
  r.region_id = c.region_id)
LEFT JOIN local_councils AS lc2 ON (
  lc1.lc_id <> lc2.lc_id
  *AND NOT ST_Disjoint(lc1.geometry, lc2.geometry)*
  AND lc2.ROWID IN (
    SELECT ROWID
    FROM SpatialIndex
    WHERE f_table_name = 'local_councils'
      AND search_frame = lc1.geometry))
GROUP BY lc1.lc_id
HAVING Count(lc2.lc_id) = 0
ORDER BY lc1.lc_name;

Io (sbagliando) al posto di 
NOT ST_Disjoint(lc1.geometry, lc2.geometry)
avrei messo
ST_Disjoint(lc1.geometry, lc2.geometry), 
qualcuno può spiegarmi perchè invece va aggiunto "NOT"?

Grazie
Beppe



--
View this message in context: http://gfoss-geographic-free-and-open-source-software-italian-mailing.3056002.n2.nabble.com/Spatialite-cookbook-r-14-not-st-disjoint-tp7587611.html
Sent from the Gfoss -- Geographic Free and Open Source Software - Italian mailing list mailing list archive at Nabble.com.


Maggiori informazioni sulla lista Gfoss