idem mais depuis un grille
CREATE SEQUENCE seq_police_isolines_id MINVALUE 1 START WITH 1 INCREMENT BY 1
CREATE TABLE police_isolines as
(SELECT nextval('seq_police_isolines_id') as id,
COUNT(*),
ST_UNION(the_geom),
FLOOR(mns_lidar) FROM l3d_grid1m_elevation
WHERE ST_Intersects(the_geom, (SELECT geom as gb from bati_pol where No_eca = '11330'))
--AND the_geom && (SELECT geom as gb from bati_pol where No_eca = '11330')
GROUP BY FLOOR(mns_lidar)
ORDER BY 3
)
;

Commentaires