Advertisement
Guest User

Untitled

a guest
Aug 8th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. CREATE TABLE myschema.mytable(
  2. fid serial NOT NULL,
  3. the_geom geometry(Point,4326),
  4. ele double precision,
  5. "time" timestamp with time zone,
  6. CONSTRAINT activities_pk PRIMARY KEY (fid)
  7. );
  8.  
  9. @echo off
  10. for %%I in (Tracks*.gpx*) do (
  11. echo Importing gpx file %%~nxI to myscheme.mytable PostGIS table...
  12. ogr2ogr -append -update -f PostgreSQL PG:"dbname='db' user='me' password='pw'" Tracks/%%~nxI -nln myscheme.mytable -sql "SELECT ele, time FROM track_points"
  13. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement