[UNCLASSIFIED]RE: [postgis-users] Storing waypoints in Postgres

Antti.Roppola at brs.gov.au Antti.Roppola at brs.gov.au
Thu Mar 30 21:15:21 PST 2006

Hi all,
GPX has worked a treat, I use Perl XML libraries to step through the track objects.
At the moment I output .sql files, but next step is to insert directly into the DB.
I am interested to hear if anyone has put together database schemas for GPS data
or nicer looking GPX parsers than my rough and ready one :o).
There will be a website eventually...


From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Andreas Ritterbusch
Sent: Thursday, 30 March 2006 11:35 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Storing waypoints in Postgres

See if GPSBabel (gpsbabel.org <http://gpsbabel.org> ) could do the trick for you. It may take some time to figure out the sheer endless settings, but it may be your solution (it has yet to fail for me). Use gpsbabel to convert your text file into something QGIS or PostGIS understands, such as GML and see if that works. 
Maybe your GPS data collector exports GPX? Seems to be the GPS file format most widely supported by now. Then going from GPS to GML should be easier than custom-defining the parameters of your text file in GPSBabel. 
Good luck,

On 3/30/06, Marc Angelo <computrain at paradise.net.nz <mailto:computrain at paradise.net.nz> > wrote: 

Hi Everyone
I am curently working on a small application that writes/reads data on a Pocket PC to and from an rfid tag (RFID SD Card). The gps coordinates are captured and written to a text file - so far so good and most of that is finished. 
What I want to be able to do now is store the points in Postgres and be able to pull them out into QGIS to view. I can open a .Net connection with Postgres and should be able to fire the data into Postgres. I have two problems and severfal questions (and I'm sorry if this is the wrong place to ask) - I'm using all Windows versions by the way 
1)    a)    Can waypoint data be stored in a Postgres Database?
       b)    If it can be stored, can it then be viewed in QGIS?
       c)    What data fields are required in a Postgres table if the waypoints can be stored? Is the geom field required?
I'm as thick as a plank when it comes to GIS data so I apologise for the simple questions
2)    I have tried to use SPIT to import some shape files into Postgres. Unfortunately I have been 99% unsuccessful. The data I have been using is NZTM, NZMG, and NZGD2000 (which apparently is very close to wgs84). I have had only one successful import and that was with an NZMG shape file (all other NZMG files fail as well including an identical file to the successful import but it was in NZTM). All these shape files I have tried (probaly 2 dozen or so) can be imported as a layer into QGIS - they just fail when an attempt to import them into Postgres with the following error:= 
"Problem inserting features from file"
I have asked this question over on the QGIS mailing list and the guys were excellent but I felt I was out doing my welcome with all my questions so I thought I would try over here :) 
Any suggestions would greatly be appreciated


postgis-users mailing list
postgis-users at postgis.refractions.net <mailto:postgis-users at postgis.refractions.net> 
http://postgis.refractions.net/mailman/listinfo/postgis-users  <http://postgis.refractions.net/mailman/listinfo/postgis-users> 

IMPORTANT - This message has been issued by The Department of Agriculture, Fisheries and Forestry (DAFF).  The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material.  It is your responsibility to check any attachments for viruses and defects before opening or sending them on.  
Any reproduction, publication, communication, re-transmission, disclosure, dissemination or other use of the information contained in this e-mail by persons or entities other than the intended recipient is prohibited.  The taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.  If you have received this e-mail in error please notify the sender and delete all copies of this transmission together with any attachments.  If you have received this e-mail as part of a valid mailing list and no longer want to receive a message such as this one advise the sender by return e-mail accordingly.  Only e-mail correspondence which includes this footer, has been authorised by DAFF 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060331/4829cc50/attachment.html>

More information about the postgis-users mailing list