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

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

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