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.
_______________________________________________
Gfoss@lists.gfoss.it
http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss
Questa e' una lista di discussione pubblica aperta a tutti.
I messaggi di questa lista non hanno relazione diretta con le posizioni
dell'Associazione GFOSS.it.
666 iscritti al 22.7.2013
