====== Miglioramenti a VMap0 ====== -- Cambiare SRID alla geometria di una tabella, riproiettando tutta la geometria: strade=> SELECT UpdateGeometrySRID('vmap0_polbnda', 'bnd', 4326); -- Sostituire i contorni di isola si Samothraki e isola d'Elba. strade=> SELECT id,id_vmap0,f_code,nam,na2,na3,tile_id,fac_id FROM vmap0_polbnda WHERE nam LIKE '%SAMOTHRA%'; -- id | id_vmap0 | f_code | nam | na2 | na3 | tile_id | fac_id -- -----+----------+--------+-------------------------+-----+-----+---------+-------- -- 137 | 5387 | FA00 | NISOS SAMOTHRAKI#THRAKI | G | | 25 | 180 strade=> \i samothraki_bnd.sql strade=> DELETE FROM vmap0_polbnda WHERE id = 137; strade=> SELECT id,id_vmap0,f_code,nam,na2,na3,tile_id,fac_id FROM vmap0_polbnda WHERE nam LIKE '%ELBA%'; -- id | id_vmap0 | f_code | nam | na2 | na3 | tile_id | fac_id -- ----+----------+--------+--------------+-----+-----+---------+-------- -- 61 | 5054 | FA00 | ELBA#TOSCANA | I | | 24 | 91 strade=> \i elba_bnd.sql strade=> DELETE FROM vmap0_polbnda WHERE id = 61;