Re: [Qgis-user] Using templates in QGIS when importing GPS-data to PostGIS

2011-07-05 Thread Pierre Chevalier Géologue
Hello, Le 04/07/2011 15:43, Pekka Hurskainen claviota: Hi Micha, thanks for the tip! I managed to do it with the following command from FWTools shell: ogr2ogr -update -append -f PostgreSQL PG:host=localhost user=postgres dbname=db password=xxx my_gps_points.gpx waypoints -sql SELECT name AS

[Qgis-user] Using templates in QGIS when importing GPS-data to PostGIS

2011-07-04 Thread Pekka Hurskainen
Hello list, Let's say I have a bunch of waypoints collected with a GPS device, and uploaded to QGIS with GPSBabel in GPX-format. I have only four fields in the GPX file which I want to keep (lat, lon, time, name). Then I have an empty template shapefile, which has more fields defined. Some of

Re: [Qgis-user] Using templates in QGIS when importing GPS-data to PostGIS

2011-07-04 Thread Micha Silver
On 04/07/2011 11:29, Pekka Hurskainen wrote: Hello list, Let's say I have a bunch of waypoints collected with a GPS device, and uploaded to QGIS with GPSBabel in GPX-format. I have only four fields in the GPX file which I want to keep (lat, lon, time, name).

Re: [Qgis-user] Using templates in QGIS when importing GPS-data to PostGIS

2011-07-04 Thread Pekka Hurskainen
Hi Micha, thanks for the tip! I managed to do it with the following command from FWTools shell: ogr2ogr -update -append -f PostgreSQL PG:host=localhost user=postgres dbname=db password=xxx my_gps_points.gpx waypoints -sql SELECT name AS gps_nimi, time AS gps_aika FROM waypoints -t_srs EPSG:3067

Re: [Qgis-user] Using templates in QGIS when importing GPS-data to PostGIS

2011-07-04 Thread Yves Jacolin
Hi, You need an ETL like Talend Open Studio with spatial extension for this or create some python script inside QGIS. see http://www.talendforge.org/wiki/doku.php?id=sdi:MainPage for more information about SDI. Y. Le lundi 04 juillet 2011 10:29:31, Pekka Hurskainen a écrit : Hello list,