[Gfoss] SpatiaLite Cookbook: SQL error: no such function: RTreeIntersects

[Sieradz]

http://gfoss-geographic-free-and-open-source-software-italian-mailing.3056002.n2.nabble.com/SpatiaLite-Cookbook-SQL-error-no-such-function-RTreeIntersects-td7585692.html

============================

Riesumo questa vecchia discussione, per riportare la corretta sintassi per
l'estrazione dei soli comuni isolani (pag. 103 dell'obsoleto PDF di
A.Furieri):

*SELECT lc1.lc_name AS "Comune Istat",
c.county_name AS Provincia,
r.region_name AS Regione,
ST_Area(lc1.geometry)/1000000 as Area_KMQ
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='DB=main.local_councils' AND 
search_frame=lc1.geometry 
     ))
group by lc1.lc_id
having count(lc2.lc_id)=0
order by lc1.lc_name*



--
View this message in context: http://gfoss-geographic-free-and-open-source-software-italian-mailing.3056002.n2.nabble.com/SpatiaLite-Cookbook-SQL-error-no-such-function-RTreeIntersects-tp7585692p7596541.html
Sent from the Gfoss -- Geographic Free and Open Source Software - Italian mailing list mailing list archive at Nabble.com.