User Tools

Site Tools


tecnica:gps_cartografia_gis:vmap0_update

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;
tecnica/gps_cartografia_gis/vmap0_update.txt · Last modified: 2006/12/06 12:12 by 127.0.0.1