back to first page..
back to WRBD

d:
cd D:\CelineJouanin\POSEProject\Ireland
cd C:\eda\ireland
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -I -W LATIN1 Outline_of_ireland.shp Outline_of_ireland > Outline_of_ireland.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326  -W LATIN1 -I River_basin_districts.shp River_basin_districts > River_basin_districts.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I Irish_catchments.shp Irish_catchments > Irish_catchments.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I Irish_lakes.shp Irish_lakes > Irish_lakes.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I Irish_water_bodies.shp Irish_water_bodies > Irish_water_bodies.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_LakeSegment_WE.shp WFD_LakeSegment_WE > WFD_LakeSegment_WE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_LakeWaterBodies_WE.shp WFD_LakeWaterBodies_WE > WFD_LakeWaterBodies_WE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_RiverSegment_WE.shp WFD_RiverSegment_WE > WFD_RiverSegment_WE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_RiverSubBasins_WE.shp WFD_RiverSubBasins_WE > WFD_RiverSubBasins_WE.sql
REM ne marche pas
REM C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_RiverWaterBodies_WE.shp WFD_RiverWaterBodies_WE > WFD_RiverWaterBodies_WE.sql

-- Cédric
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Outline_of_ireland.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table outline_of_ireland set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.outline_of_ireland ; alter table  wrbd.outline_of_ireland  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.outline_of_ireland set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.outline_of_ireland  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Outline_of_ireland.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table outline_of_ireland set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.outline_of_ireland ; alter table  wrbd.outline_of_ireland  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.outline_of_ireland set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.outline_of_ireland  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f River_basin_districts.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table river_basin_districts set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.river_basin_districts ; alter table  wrbd.river_basin_districts  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.river_basin_districts set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.river_basin_districts  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Irish_catchments.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table irish_catchments set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.irish_catchments ; alter table  wrbd.irish_catchments  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.irish_catchments set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.irish_catchments  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"


C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Irish_lakes.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table irish_lakes set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.irish_lakes ; alter table  wrbd.irish_lakes  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.irish_lakes set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.irish_lakes  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"


C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Irish_water_bodies.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table irish_water_bodies set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.irish_water_bodies ; alter table  wrbd.irish_water_bodies  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.irish_water_bodies set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.irish_water_bodies  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f WFD_LakeSegment_WE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table wfd_lakesegment_we set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.wfd_lakesegment_we ; alter table  wrbd.wfd_lakesegment_we  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.wfd_lakesegment_we set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.wfd_lakesegment_we  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f WFD_RiverSegment_WE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table wfd_riversegment_we set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.wfd_riversegment_we ; alter table  wrbd.wfd_riversegment_we  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.wfd_riversegment_we set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.wfd_riversegment_we  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f WFD_RiverSubBasins_WE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table wfd_riversubbasins_we set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.wfd_riversubbasins_we ; alter table  wrbd.wfd_riversubbasins_we  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.wfd_riversubbasins_we set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.wfd_riversubbasins_we  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

-- Céline
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Outline_of_ireland.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table outline_of_ireland set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.outline_of_ireland ; alter table  wrbd.outline_of_ireland  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.outline_of_ireland set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.outline_of_ireland  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Outline_of_ireland.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table outline_of_ireland set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.outline_of_ireland ; alter table  wrbd.outline_of_ireland  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.outline_of_ireland set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.outline_of_ireland  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f River_basin_districts.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table river_basin_districts set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.river_basin_districts ; alter table  wrbd.river_basin_districts  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.river_basin_districts set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.river_basin_districts  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Irish_catchments.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table irish_catchments set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.irish_catchments ; alter table  wrbd.irish_catchments  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.irish_catchments set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.irish_catchments  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"


C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Irish_lakes.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table irish_lakes set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.irish_lakes ; alter table  wrbd.irish_lakes  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.irish_lakes set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.irish_lakes  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"


C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Irish_water_bodies.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table irish_water_bodies set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.irish_water_bodies ; alter table  wrbd.irish_water_bodies  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.irish_water_bodies set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.irish_water_bodies  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f WFD_LakeSegment_WE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table wfd_lakesegment_we set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.wfd_lakesegment_we ; alter table  wrbd.wfd_lakesegment_we  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.wfd_lakesegment_we set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.wfd_lakesegment_we  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f WFD_RiverSegment_WE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table wfd_riversegment_we set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.wfd_riversegment_we ; alter table  wrbd.wfd_riversegment_we  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.wfd_riversegment_we set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.wfd_riversegment_we  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f WFD_RiverSubBasins_WE.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table wfd_riversubbasins_we set schema wrbd"
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "SELECT ST_SRID(the_geom) from wrbd.wfd_riversubbasins_we ; alter table  wrbd.wfd_riversubbasins_we  DROP CONSTRAINT enforce_srid_the_geom ;update wrbd.wfd_riversubbasins_we set the_geom=ST_Transform(the_geom,3035); alter table  wrbd.wfd_riversubbasins_we  add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);"