Changes between Initial Version and Version 1 of Ireland layers


Ignore:
Timestamp:
Dec 3, 2010 5:00:38 PM (14 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Ireland layers

    v1 v1  
     1back to first page[..][[BR]] 
     2back to ["WRBD"][[BR]] 
     3 
     4 
     5 
     6{{{ 
     7d: 
     8cd D:\CelineJouanin\POSEProject\Ireland 
     9cd C:\eda\ireland 
     10C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -I -W LATIN1 Outline_of_ireland.shp Outline_of_ireland > Outline_of_ireland.sql 
     11C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326  -W LATIN1 -I River_basin_districts.shp River_basin_districts > River_basin_districts.sql 
     12C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I Irish_catchments.shp Irish_catchments > Irish_catchments.sql 
     13C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I Irish_lakes.shp Irish_lakes > Irish_lakes.sql 
     14C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I Irish_water_bodies.shp Irish_water_bodies > Irish_water_bodies.sql 
     15C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_LakeSegment_WE.shp WFD_LakeSegment_WE > WFD_LakeSegment_WE.sql 
     16C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_LakeWaterBodies_WE.shp WFD_LakeWaterBodies_WE > WFD_LakeWaterBodies_WE.sql 
     17C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_RiverSegment_WE.shp WFD_RiverSegment_WE > WFD_RiverSegment_WE.sql 
     18C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_RiverSubBasins_WE.shp WFD_RiverSubBasins_WE > WFD_RiverSubBasins_WE.sql 
     19REM ne marche pas 
     20REM C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 29903  -W LATIN1 -I WFD_RiverWaterBodies_WE.shp WFD_RiverWaterBodies_WE > WFD_RiverWaterBodies_WE.sql 
     21 
     22-- Cédric 
     23C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Outline_of_ireland.sql 
     24C:\"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" 
     25C:\"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);" 
     26C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Outline_of_ireland.sql 
     27C:\"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" 
     28C:\"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);" 
     29 
     30C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f River_basin_districts.sql 
     31C:\"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" 
     32C:\"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);" 
     33 
     34C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Irish_catchments.sql 
     35C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table irish_catchments set schema wrbd" 
     36C:\"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);" 
     37 
     38 
     39C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Irish_lakes.sql 
     40C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table irish_lakes set schema wrbd" 
     41C:\"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);" 
     42 
     43 
     44C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Irish_water_bodies.sql 
     45C:\"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" 
     46C:\"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);" 
     47 
     48C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f WFD_LakeSegment_WE.sql 
     49C:\"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" 
     50C:\"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);" 
     51 
     52C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f WFD_RiverSegment_WE.sql 
     53C:\"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" 
     54C:\"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);" 
     55 
     56C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f WFD_RiverSubBasins_WE.sql 
     57C:\"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" 
     58C:\"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);" 
     59 
     60-- Céline 
     61C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Outline_of_ireland.sql 
     62C:\"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" 
     63C:\"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);" 
     64C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Outline_of_ireland.sql 
     65C:\"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" 
     66C:\"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);" 
     67 
     68C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f River_basin_districts.sql 
     69C:\"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" 
     70C:\"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);" 
     71 
     72C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Irish_catchments.sql 
     73C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table irish_catchments set schema wrbd" 
     74C:\"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);" 
     75 
     76 
     77C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Irish_lakes.sql 
     78C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table irish_lakes set schema wrbd" 
     79C:\"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);" 
     80 
     81 
     82C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Irish_water_bodies.sql 
     83C:\"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" 
     84C:\"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);" 
     85 
     86C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f WFD_LakeSegment_WE.sql 
     87C:\"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" 
     88C:\"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);" 
     89 
     90C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f WFD_RiverSegment_WE.sql 
     91C:\"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" 
     92C:\"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);" 
     93 
     94C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f WFD_RiverSubBasins_WE.sql 
     95C:\"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" 
     96C:\"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);" 
     97}}}