Guest User

Untitled

a guest
Feb 13th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. SET PGCLIENTENCODING=LATIN1
  2. set MAPSCHEMA=public
  3. set PSQLPATH="C:Program FilesPostgreSQL9.5bin"
  4. set OGR2OGRPATH="C:Program FilesQGIS 2.14bin"
  5. set ACDCONN="PG: host=localhost port=5432 dbname=test_mo user=postgres password=admin"
  6. set INPATH_SCHABLONE=C:UsersLiMDesktopbatch_ExtractedOceanschablone
  7. set INPATH="R:TomTomAfrica2015_12mn_inkl_POI
  8. set OUTPATH=C:UsersLiMDesktopbatch_ExtractedOceanExtracted_MapInfo
  9.  
  10. echo importing data into POSTGIS
  11.  
  12. set sIU=reu_oin_oi2
  13. %OGR2OGRPATH%ogr2ogr -f "PostgreSQL" %ACDCONN% %INPATH_SCHABLONE%CutAFROceanTT.TAB
  14. %OGR2OGRPATH%ogr2ogr -f "PostgreSQL" %ACDCONN% %INPATH%%sIU%Mapinfo%sIU%_area_orig.MIF
  15.  
  16. echo exporting to MapInfo files (tab/mif/mid)...
  17. %OGR2OGRPATH%ogr2ogr.exe -f "MapInfo File" %OUTPATH%%sIU%_area.tab %ACDCONN% -sql "SELECT * FROM CutAFROceanTT"
  18.  
  19. SELECT * FROM CutAFROceanTT;
  20.  
  21. SELECT * FROM cutafroceantt;
  22.  
  23. SELECT * FROM "CutAFROceanTT"
  24.  
  25. %OGR2OGRPATH%ogr2ogr.exe -f "MapInfo File" %OUTPATH%%sIU%_area.tab %ACDCONN% -sql "SELECT * FROM ""CutAFROceanTT"" "
Add Comment
Please, Sign In to add comment