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

Utiliser curl pour récupérer des logs sur un serveur Microsoft IIS avec l'authentification ntlm

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