Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET PGCLIENTENCODING=LATIN1
- set MAPSCHEMA=public
- set PSQLPATH="C:Program FilesPostgreSQL9.5bin"
- set OGR2OGRPATH="C:Program FilesQGIS 2.14bin"
- set ACDCONN="PG: host=localhost port=5432 dbname=test_mo user=postgres password=admin"
- set INPATH_SCHABLONE=C:UsersLiMDesktopbatch_ExtractedOceanschablone
- set INPATH="R:TomTomAfrica2015_12mn_inkl_POI
- set OUTPATH=C:UsersLiMDesktopbatch_ExtractedOceanExtracted_MapInfo
- echo importing data into POSTGIS
- set sIU=reu_oin_oi2
- %OGR2OGRPATH%ogr2ogr -f "PostgreSQL" %ACDCONN% %INPATH_SCHABLONE%CutAFROceanTT.TAB
- %OGR2OGRPATH%ogr2ogr -f "PostgreSQL" %ACDCONN% %INPATH%%sIU%Mapinfo%sIU%_area_orig.MIF
- echo exporting to MapInfo files (tab/mif/mid)...
- %OGR2OGRPATH%ogr2ogr.exe -f "MapInfo File" %OUTPATH%%sIU%_area.tab %ACDCONN% -sql "SELECT * FROM CutAFROceanTT"
- SELECT * FROM CutAFROceanTT;
- SELECT * FROM cutafroceantt;
- SELECT * FROM "CutAFROceanTT"
- %OGR2OGRPATH%ogr2ogr.exe -f "MapInfo File" %OUTPATH%%sIU%_area.tab %ACDCONN% -sql "SELECT * FROM ""CutAFROceanTT"" "
Add Comment
Please, Sign In to add comment