I'm implementing a recipe from Paolo Corti's PostGIS Cookbook (by the way, a great help!) in order to import track points from multiple GPX files into a PostGIS table in two steps (pages 87-88):
1 Creating table by a query file
CREATE TABLE myschema.mytable( fid serial NOT NULL, the_geom geometry(Point,4326), ele double precision, "time" timestamp with time zone, CONSTRAINT activities_pk PRIMARY KEY (fid) );
2 Importing multiple files with a
@echo off for %%I in (Tracks\*.gpx*) do ( echo Importing gpx file %%~nxI to myschema.mytable PostGIS table... ogr2ogr -append -update -f PostgreSQL PG:"dbname='db' user='me' password='pw'" Tracks/%%~nxI -nln myscheme.mytable -sql "SELECT ele, time FROM track_points" )
My question is maybe a really beginner's question but I would like to include one column in the PostGIS table indicating the file's name, where each track points come from.
As far as I know, I may first consider a column for the file's name in the Query file (for instance using
varchar(20)) but I don't know how to fill it in the second step.