back to first page..
back to BDCarthage

BDCarthage description

​http://services.sandre.eaufrance.fr/data/zonage/Hydrographie2011/arcgis/DL_BDCARTHAGE_3_0_shp.pdf
​http://services.sandre.eaufrance.fr/data/zonage/Hydrographie2011/arcgis/DC_BDCARTHAGE_3_0.pdf

Download the new version BDCarthage 2011

New version from July 28th
​http://services.sandre.eaufrance.fr/data/zonage/Hydrographie2011/arcgis/FranceEntiere/
Unzip the file into D:\CelineJouanin\BDCarthage2011

Projecting data in Lambert 93 --> ETRS LAEA with ARCGIS

some problems with postgis (I can't see the layer into Qgis there is an error) so I use ArcGis

Integrate the files into Postgis

The database bd_carthage2011 will be created

---Céline
D:
cd D:\CelineJouanin\BDCarthage2011
---Creation de la base de données bd_carthage2011
C:\"Program Files"\PostgreSQL\8.4\bin\psql -p 5432 -U postgres -c "CREATE DATABASE bd_carthage2011  WITH OWNER = postgres  template=postgis;"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -p 5432 -U postgres -c "COMMENT ON DATABASE bd_carthage2011 IS 'database bd_carthage2011 en lambert 93 reprojettee en ETRS LAEA'"

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I COURS_D_EAU_2011 COURS_D_EAU> COURS_D_EAU.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f COURS_D_EAU.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I HYDROGRAPHIE_SURFACIQUE_2011 HYDROGRAPHIE_SURFACIQUE> HYDROGRAPHIE_SURFACIQUE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f HYDROGRAPHIE_SURFACIQUE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I LAISSE_2011 LAISSE> LAISSE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f LAISSE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I NOEUD_HYDROGRAPHIQUE_2011 NOEUD_HYDROGRAPHIQUE> NOEUD_HYDROGRAPHIQUE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f NOEUD_HYDROGRAPHIQUE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I POINT_EAU_ISOLE_2011 POINT_EAU_ISOLE> POINT_EAU_ISOLE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f POINT_EAU_ISOLE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I REGION_HYDROGRAPHIQUE_2011 REGION_HYDROGRAPHIQUE> REGION_HYDROGRAPHIQUE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f REGION_HYDROGRAPHIQUE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I SECTEUR_2011 SECTEUR> SECTEUR.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f SECTEUR.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I SOUS_SECTEUR_2011 SOUS_SECTEUR> SOUS_SECTEUR.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f SOUS_SECTEUR.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I TRONCON_HYDROGRAPHIQUE_2011 TRONCON_HYDROGRAPHIQUE> TRONCON_HYDROGRAPHIQUE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f TRONCON_HYDROGRAPHIQUE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I ZONE_HYDROGRAPHIQUE_2011 ZONE_HYDROGRAPHIQUE> ZONE_HYDROGRAPHIQUE.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d bd_carthage2011 -U postgres -p 5432 -f ZONE_HYDROGRAPHIQUE.sql 

select count(*) from troncon_hydrographique  --528422
select count(*) from troncon_hydrographique where largeur is not null --528422
select count(largeur), largeur from troncon_hydrographique group by largeur

select count(id_bdcarthage), id_bdcarthage from noeuds group by id_bdcarthage order by count(id_bdcarthage)  --ancienne version (Cédric) pas de doublons
select count(id_bdcarth), id_bdcarth from troncon_hydrographique group by id_bdcarth order by count(id_bdcarth)  ---527817-527212+1=606 segments avec un doublon
select count(gid), gid from troncon_hydrographique group by gid order by count(gid)

---example
select * from troncon_hydrographique where id_bdcarth in ('409000825','605000402','427000399') order by id_bdcarth