Changes between Version 19 and Version 20 of WRBD


Ignore:
Timestamp:
Dec 2, 2010 3:18:12 PM (14 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • WRBD

    v19 v20  
    275275C:\"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" 
    276276C:\"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);" 
     277C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Outline_of_ireland.sql 
     278C:\"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" 
     279C:\"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);" 
     280 
    277281C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f River_basin_districts.sql 
    278282C:\"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" 
     283C:\"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);" 
     284 
    279285C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Irish_catchments.sql 
    280286C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table irish_catchments set schema wrbd" 
     287C:\"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);" 
     288 
     289 
    281290C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Irish_lakes.sql 
    282291C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -c "alter table irish_lakes set schema wrbd" 
     292C:\"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);" 
     293 
     294 
    283295C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f Irish_water_bodies.sql 
    284296C:\"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" 
     297C:\"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);" 
     298 
    285299C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f WFD_LakeSegment_WE.sql 
    286300C:\"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" 
     301C:\"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);" 
     302 
    287303C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f WFD_RiverSegment_WE.sql 
    288304C:\"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" 
     305C:\"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);" 
     306 
    289307C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -h localhost -U postgres -f WFD_RiverSubBasins_WE.sql 
    290308C:\"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" 
     309C:\"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);" 
     310 
    291311-- Céline 
    292312C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Outline_of_ireland.sql 
    293313C:\"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" 
     314C:\"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);" 
     315C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Outline_of_ireland.sql 
     316C:\"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" 
     317C:\"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);" 
     318 
    294319C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f River_basin_districts.sql 
    295320C:\"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" 
     321C:\"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);" 
     322 
    296323C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Irish_catchments.sql 
    297324C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table irish_catchments set schema wrbd" 
     325C:\"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);" 
     326 
     327 
    298328C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Irish_lakes.sql 
    299329C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -c "alter table irish_lakes set schema wrbd" 
     330C:\"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);" 
     331 
     332 
    300333C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f Irish_water_bodies.sql 
    301334C:\"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" 
     335C:\"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);" 
     336 
    302337C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f WFD_LakeSegment_WE.sql 
    303338C:\"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" 
     339C:\"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);" 
     340 
    304341C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f WFD_RiverSegment_WE.sql 
    305342C:\"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" 
     343C:\"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);" 
     344 
    306345C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5432 -h localhost -U postgres -f WFD_RiverSubBasins_WE.sql 
    307346C:\"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" 
    308 }}} 
     347C:\"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);" 
     348}}}