rem This file is part of deegree, for copyright\license information, please visit http:\\www.deegree.org\license.
rem This script uses postgis tool 'shp2pgsql' to transfer shape data into postgis database table

rem SCRIPT BEGIN
shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID024_StateBoundary sgid024_stateboundary > ..\..\data\utah\sql\sgid024_stateboundary.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID100_CountyBoundaries_edited SGID100_CountyBoundaries_edited > ..\..\data\utah\sql\GID100_CountyBoundaries_edited.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID500_ZipCodes sgid500_zipcodes > ..\..\data\utah\sql\sgid500_zipcodes.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID500_Contours500Ft sgid500_contours500ft > ..\..\data\utah\sql\sgid500_contours500ft.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID500_Contours1000Ft sgid500_contours1000ft > ..\..\data\utah\sql\sgid500_contours1000ft.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID500_Contours2500Ft sgid500_contours2500ft > ..\..\data\utah\sql\sgid500_contours2500ft.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID500_EnergyResourcesPoly sgid500_energyresourcespoly > ..\..\data\utah\sql\sgid500_energyresourcespoly.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID024_Springs sgid024_springs > ..\..\data\utah\sql\sgid024_springs.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID100_LakesDLG100 sgid100_lakesdlg100 > ..\..\data\utah\sql\sgid100_lakesdlg100.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID100_Airports sgid100_airports > ..\..\data\utah\sql\sgid100_airports.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID100_RailroadsDLG100 sgid100_railroadsdlg100 > ..\..\data\utah\sql\sgid100_railroadsdlg100.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID100_RailroadsTIGER1990 sgid100_railroadstiger1990 > ..\..\data\utah\sql\sgid100_railroadstiger1990.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID100_RoadsDLG100 sgid100_roadsdlg100 > ..\..\data\utah\sql\sgid100_roadsdlg100.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID500_RoadsDLG500 sgid500_roadsdlg500 > ..\..\data\utah\sql\sgid500_roadsdlg500.sql
rem shp2pgsql -d -i -I -s 26912 ..\..\data\utah\vector\SGID500_DominantVegetation sgid500_dominantvegetation > ..\..\data\utah\sql\sgid500_dominantvegetation.sql

psql.exe -f ..\..\data\utah\sql\sgid024_stateboundary.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\GID100_CountyBoundaries_edited.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid500_zipcodes.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid500_contours500ft.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid500_contours1000ft.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid500_contours2500ft.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid500_energyresourcespoly.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid024_springs.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid100_lakesdlg100.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid100_airports.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid100_railroadsdlg100.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid100_railroadstiger1990.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid100_roadsdlg100.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid500_roadsdlg500.sql -U deegreetest -d deegreetest
rem psql.exe -f ..\..\data\utah\sql\sgid500_dominantvegetation.sql -U deegreetest -d deegreetest



rem SCRIPT END