rigacci.org

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Miglioramenti a VMap0 ======

<code sql>
-- 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;
</code>