Esempio Aggregazione Geometrica

Per aggregare un numero di geometrie areali imprecisato (dipende dal raggruppamento di un campo) si utilizza la seguente funzione: SDO_AGGR_UNION(SDOAGGRTYPE(<campo geometia>, precisione)

select t.num_dist, SDO_AGGR_UNION(SDOAGGRTYPE(t.geometry,0.005)) GEOM from area_puc t WHERE T.NUM_DIST is not null group by t.num_dist

Leave a Reply

Your email address will not be published. Required fields are marked *

* Copy This Password *

* Type Or Paste Password Here *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This site is helping to EcoPlus with the captcha installed.