<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2627" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=231030705-31032006><FONT face=Arial
color=#0000ff size=2>Hi all,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=231030705-31032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=231030705-31032006><FONT face=Arial
color=#0000ff size=2>GPX has worked a treat, I use Perl XML libraries to step
through the track objects.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=231030705-31032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=231030705-31032006><FONT face=Arial
color=#0000ff size=2>At the moment I output .sql files, but next step is to
insert directly into the DB.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=231030705-31032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=231030705-31032006><FONT face=Arial
color=#0000ff size=2>I am interested to hear if anyone has put together database
schemas for GPS data</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=231030705-31032006>or nicer looking GPX parsers than my rough and
ready one :o)</SPAN><SPAN
class=231030705-31032006><FONT>.</FONT></SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=231030705-31032006></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=231030705-31032006>There will be a website
eventually...</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=231030705-31032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=231030705-31032006><FONT face=Arial
color=#0000ff size=2>Antti</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Andreas Ritterbusch<BR><B>Sent:</B> Thursday, 30 March 2006 11:35
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users]
Storing waypoints in Postgres<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Marc:</DIV>
<DIV> </DIV>
<DIV>See if GPSBabel (<A href="http://gpsbabel.org">gpsbabel.org</A>) 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. </DIV>
<DIV>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. </DIV>
<DIV> </DIV>
<DIV>Good luck,</DIV>
<DIV> </DIV>
<DIV>Andreas.</DIV>
<DIV><BR><BR> </DIV>
<DIV><SPAN class=gmail_quote>On 3/30/06, <B class=gmail_sendername>Marc
Angelo</B> <<A
href="mailto:computrain@paradise.net.nz">computrain@paradise.net.nz</A>>
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV style="DIRECTION: ltr">
<DIV><FONT face=Arial size=2>Hi Everyone</FONT></DIV>
<DIV><FONT face=Arial size=2>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. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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
</FONT></DIV>
<DIV><FONT face=Arial size=2>1) a) Can
waypoint data be stored in a Postgres Database?</FONT></DIV>
<DIV><FONT face=Arial
size=2> b) If it
can be stored, can it then be viewed in QGIS?</FONT></DIV>
<DIV><FONT face=Arial
size=2> c) What
data fields are required in a Postgres table if the waypoints can be stored?
Is the geom field required?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm as thick as a plank when it comes to GIS data
so I apologise for the simple questions</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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:= </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>"Problem inserting features from
file"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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 :)</FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Any suggestions would greatly be
appreciated</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Cheers</FONT></DIV></DIV>
<DIV style="DIRECTION: ltr"><SPAN class=sg>
<DIV><FONT face=Arial
size=2>Marc</FONT></DIV></SPAN></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users
</A><BR><BR><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>
<BR>
<P><FONT SIZE=2 FACE="Arial">---------------------------------------------------------------------- </FONT></P>
<P><FONT SIZE=2 FACE="Arial">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. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">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 </FONT></P>
<P><FONT SIZE=2 FACE="Arial">----------------------------------------------------------------------</FONT></P>