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

Posts les plus consultés de ce blog

Comment extraire les fichiers disques en raw d'un backup proxmox vma

Find the lists of disks of your Proxmox VM stored in a ceph cluster

Comment copier une machine virtuelle kvm en raw sur un Volume Group LVM2 se trouvant sur un disque en DRBD