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


= Join ROE - CCM =
== Puttin geobs into the CCM ==
Initially, the database was located in another table, below we just copy the table shema roe into the ccm21_eda database
{{{
REM pour Cédric
CD C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\Barrages
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump -U postgres -n geobs ROE> roe_schema.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -h localhost -p 5433 -U postgres -f roe_schema.sql
REM====================================
REM Pour Céline
CD D:\Celine Jouanin\ROE
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump -U postgres  -n geobs ROE> roe_schema.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -h localhost -p 5432 -U postgres -f roe_schema.sql
}}}
== We have to reproject our data ==
== Select only the dams within France ==
this is ticket #45
== Build a view allowing to know the score of the different dams ==
this is ticket #46
== Joining CCM and Dams ==
this is ticket #47