back to first page ![..][[BR]]
back to !["CookBook Eda"] [[BR]]

![[Image(source:data/Docs/trac/pourc_projette.jpg)]]

![[Image(source:data/Docs/trac/barrages_cutfrance.png,600px)]]

See the ticket !#45

![[Color(,#3849ce,source)]]

![[Freemind(htdocs://site/reunion7janv.mm)]]

!source:"data/Docs/trac/POSE/SWOT in Pose.mm"
or "Attach file" en bas de la page

Size limit to attach a file : 256KB --> give the name of the folder where we can find the file.[[BR]]
!source:"data/Docs/trac/POSE/"

!{{{
!#!html
!<h2 style="color: orange">This is raw HTML</h2>
!}}}
{{{
#!html
<h2 style="color: orange">This is raw HTML</h2>
}}}


http://trac.edgewall.org/wiki/WikiFormatting

== Eclipse ==
 * Problem with the port http://lists.r-forge.r-project.org/pipermail/statet-user/2010-September/000531.html
Window > Preferences > StatET > Run/Debug > R Interaction > Advanced Options  and change the port

== Postgre ==

New version with ST_HausdorffDistance see http://docs.postgresqlfr.org/8.1/migration.html [[BR]]
{{{
SELECT version();
select postgis_full_version(); 
select PostGIS_version();
}}}
SRID ["srid"]
{{{
#!sql
select * from spatial_ref_sys where srtext LIKE '%NTF%';
}}}

["Geometry functions"] [[BR]]
http://blogs.msdn.com/b/davidlean/archive/2008/10/24/sql-20008-spatial-samples-part-n-of-n-conditional-methods.aspx [[BR]]

{{{
#!sql
--- Nombre de colonnes dans une table
select relnatts from pg_class where relname='stationsp2'
}}}

Les données sont dans C:\Celine Jouanin\dataPostgreSQL\pg_log (pour les erreurs) [[BR]]

{{{
C:\Documents and Settings\cedric.briand>C:\"Program Files"\PostgreSQL\9.0\bin\pgsql2shp -f "F:\IAV\eda\oria\export shape" -h 192.168.1.104 -p 5432 -u postgres -P petromyzon*** -g the_geom -r -k eda2 oria.obstacles_biskaia
}}}

{{{
cd C:\Program Files\PostgreSQL\8.4\bin\
pg_restore.exe --host localhost --port 5432 --username postgres --dbname "ccm21" --verbose "C:\CelineJouanin\riversegments.backup"
}}}
{{{
--supprimer la table puis :
d:
--repertoire ou a été mis le fichier
cd D:\CelineJouanin\CCM21
C:\"Program Files"\PostgreSQL\8.4\bin\psql  -U postgres --dbname "eda2.0" -f "riversegments_backup_fulldistsource.sql"
}}}
How to save only a table - backup
{{{
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t ccm21.riversegments eda2.0> riversegments_backup.sql
}}}
How to save a schema
{{{
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 --schema clc --verbose eda2.0> eda2_clc.sql
}}}
How to save several schema
{{{
pg_dump -h 192.168.1.104 -U postgres --verbose  --schema barlbr --schema shp --schema result --schema public --schema geobs --schema archive --file "barrage_vilaine_partiel_9012012.sql" barrage_vilaine

pg_dump -h 192.168.1.104 -U postgres --verbose  --exclude-schema barlbr --exclude-schema shp --exclude-schema result --exclude-schema public --exclude-schema geobs --exclude-schema archive --file "barrage_vilaine_autres_9012012.sql" barrage_vilaine
}}}
 

 * Intégration d'une colonne géométrique
{{{
#!sql
SELECT AddGeometryColumn ( 'rht','attributs_rht_fev_2011_vs2','the_geom',3035,'MULTILINESTRING',2);
update rht.attributs_rht_fev_2011_vs2 set the_geom=rht.the_geom from rht.rht
 where rht.id_drain=attributs_rht_fev_2011_vs2.id_drain; 
}}}

 * Add a primary key
{{{
#!sql
ALTER TABLE ccm21.riversegments ADD CONSTRAINT riversegments_pkey PRIMARY KEY (gid);
}}}

 * Drop a primary key
{{{
#!sql
ALTER TABLE ccm21.riversegments DROP CONSTRAINT riversegments_pkey;
}}}
 * Change the srid into 3035 (ETRS1989 LAEA)
{{{
#!sql
ALTER TABLE uga2010.uga DROP CONSTRAINT enforce_srid_the_geom;
UPDATE uga2010.uga SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE uga2010.uga ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
}}}

 * Create view of a query
{{{
#!sql
CREATE VIEW results AS select * from ccm21.riversegments r inner join ccm21.resultmodel re on re.res_wso1_id=r.wso1_id
}}}


--- Riversegments

{{{
#!sql
DROP INDEX IF EXISTS ccm21.indexriversegments_wso1_id;
CREATE INDEX indexriversegments_wso1_id
ON ccm21.riversegments
USING btree (wso1_id);

-- ALTER TABLE ccm21.riversegments1 DROP CONSTRAINT enforce_dims_the_geom;
ALTER TABLE ccm21.riversegments ADD CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2);
-- ALTER TABLE ccm21.riversegments1 DROP CONSTRAINT enforce_geotype_the_geom;
ALTER TABLE ccm21.riversegments ADD CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);
-- ALTER TABLE ccm21.riversegments1 DROP CONSTRAINT enforce_srid_the_geom;
ALTER TABLE ccm21.riversegments ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
-- ALTER TABLE ccm21.riversegments DROP CONSTRAINT riversegments_pkey;
ALTER TABLE ccm21.riversegments ADD CONSTRAINT riversegments_pkey PRIMARY KEY(gid);
}}}

Sauvegarde tables CLC
{{{
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.clc00_v2_bretagne eda2.0> clc00_v2_bretagne_backup.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.clc00_v2_europe eda2.0> clc00_v2_europe_backup.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.clc06_fr_l2e eda2.0> clc06_fr_l2e_backup.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.clipped eda2.0> clipped.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.clipped1 eda2.0> clipped1.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.clipped_anglian eda2.0> clipped_anglian.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.clipped_anglian1 eda2.0> clipped_anglian1.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.clipped_bretagne eda2.0> clipped_bretagne.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.clipped_bretagne1 eda2.0> clipped_bretagne1.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.surf_area eda2.0> surface_area.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.surf_area1_bretagne eda2.0> surface_area1_bretagne.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.surf_area_analyse eda2.0> surface_area_analyse.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.surf_area_anglian eda2.0> surface_area_anglian.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.surf_area_anglian_final eda2.0> surface_area_anglian_final.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.surf_area_bretagne eda2.0> surface_area_bretagne.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.surf_area_final eda2.0> surface_area_final.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.surf_area_final2 eda2.0> surface_area_final2.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.surf_area_final_spain eda2.0> surface_area_final_spain.sql
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t clc.remaining_catchment eda2.0> remaining_catchment.sql

}}}
{{{
select wso_id, area from france.wso f where area='France' except (select wso_id, area from europe.wso where area='France') 
}}}

Permet connaitre id_drain qui n'a pas d'attribut
{{{
#!sql
  select * from rht.rht where id_drain not in (select id_drain from rht.rht right outer join rht.attributs_rht_fev_2011 on id_drain=id_drainattr)
}}}
= Liens =
https://quasare.cemagref.fr/ [[BR]]