back to first page ..
back to CookBook Eda
back to BDMAP
back to CookBook join BDMAP_CCM

Some station must be reproject and the gid (or wso1_id) must be changed:

DROP table if exists bd_map.bdmap_ccm_gid;
CREATE TABLE bd_map.bdmap_ccm_gid as (
select distinct on (st_codecsp) * from bd_map.bdmap_ccm_final
);
update bd_map.bdmap_ccm_gid SET gid='256428' where st_codecsp='06210010';
update bd_map.bdmap_ccm_gid SET gid='307291' where st_codecsp='05405071';
update bd_map.bdmap_ccm_gid SET gid='316023' where st_codecsp='05645242';
update bd_map.bdmap_ccm_gid SET gid='237651' where st_codecsp='05471015';
update bd_map.bdmap_ccm_gid SET gid='299119' where st_codecsp='05245023';
update bd_map.bdmap_ccm_gid SET gid='255384' where st_codecsp='03580002';
update bd_map.bdmap_ccm_gid SET gid='264627' where st_codecsp='03760112';
update bd_map.bdmap_ccm_gid SET gid='296658' where st_codecsp='05332023';
update bd_map.bdmap_ccm_gid SET gid='296658' where st_codecsp='05330018';
update bd_map.bdmap_ccm_gid SET gid='324566' where st_codecsp='06250227';
update bd_map.bdmap_ccm_gid SET gid='322161' where st_codecsp='05630038';
update bd_map.bdmap_ccm_gid SET gid='237651' where st_codecsp='05470066';
update bd_map.bdmap_ccm_gid SET gid='247847' where st_codecsp='03500175';
update bd_map.bdmap_ccm_gid SET gid='310676' where st_codecsp='06250317';
update bd_map.bdmap_ccm_gid SET gid='255384' where st_codecsp='03580002';

New update

update bd_map.bdmap_ccm_gid SET gid='262623' where st_codecsp='06690101';
update bd_map.bdmap_ccm_gid SET gid='216980' where st_codecsp='03760112';

Sauvegarde de hylcov_arc dans bdmap

d:
cd d:\CelineJouanin\backup
--- Sauvegarde de la table
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t public.hylcov_arc bd_carthage> hylcov_arc_backup.sql
---Importation de la table dans la base de données eda2.0
C:\"Program Files"\PostgreSQL\8.4\bin\psql  -U postgres --dbname "eda2.0" -f "hylcov_arc_backup.sql"
---Changement de schéma
alter table hylcov_arc set schema bd_map

Vérification pour connaître les points de pêches situés dans un cours d'eau artificielle (nature=3)

select * from bd_map.bdmap_ccm_final b inner join bd_map.hylcov_arc as h on h.id_trhyd=b.id_trhyd where nature = '3'  ---115 lines
select * from bd_map.bdmap_ccm_final b inner join bd_map.hylcov_arc as h on h.id_trhyd=b.id_trhyd where etat = '3' 464 --- lines