<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">It keeps everything that I need when I use it. Actually it keeps more then what I really want, hence my home rolled script. I will paste some of the output for you to decide if it works for you or not.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>Will<DIV><BR class="khtml-block-placeholder"></DIV><DIV style="text-align: justify;">Shapefile type: Point</DIV><DIV style="text-align: justify;"><DIV style="text-align: justify;">Postgis type: POINT[2]</DIV><DIV style="">BEGIN;</DIV><DIV style="">CREATE TABLE "5-11" (gid serial PRIMARY KEY,</DIV><DIV style="">"shapeid" int4,</DIV><DIV style="">"ele" float8,</DIV><DIV style="">"time" varchar(32),</DIV><DIV style="">"magvar" float8,</DIV><DIV style="">"geoidheigh" float8,</DIV><DIV style="">"name" varchar(32),</DIV><DIV style="">"cmt" varchar(255),</DIV><DIV style="">"desc" varchar(255),</DIV><DIV style="">"src" varchar(255),</DIV><DIV style="">"link" varchar(255),</DIV><DIV style="">"sym" varchar(32),</DIV><DIV style="">"type" varchar(32),</DIV><DIV style="">"sat" int4,</DIV><DIV style="">"hdop" float8,</DIV><DIV style="">"vdop" float8,</DIV><DIV style="">"ageofdgpsd" float8,</DIV><DIV style="">"dgpsid" float8);</DIV><DIV style="">SELECT AddGeometryColumn('','5-11','the_geom','-1','POINT',2);</DIV><DIV style="">INSERT INTO "5-11" ("shapeid","ele","time","magvar","geoidheigh","name","cmt","desc","src","link","sym","type","sat","hdop","vdop","ageofdgpsd","dgpsid",the_geom) VALUES ('0','2419.2651','2007-05-11T09:19:47Z','0.0000','0.0000','001','001','001',NULL,NULL,'Flag',NULL,'0','0.0000','0.0000','0.0000','0.0000','0000000001C05BBE7AFEAC76744045E47357A3DE75');</DIV><DIV style="text-align: center;"><BR class="khtml-block-placeholder"></DIV><DIV style="text-align: center;"><BR class="khtml-block-placeholder"></DIV><DIV style="text-align: center;"><BR class="khtml-block-placeholder"></DIV><BR><DIV><DIV>On May 13, 2007, at 7:20 PM, Roppola, Antti - BRS wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Matthew Perry wrote:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV> <BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">gpsbabel -> gpx2shp -> shp2pgsql works great for me. I just wrap it in</DIV> </BLOCKQUOTE><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV> <BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">a little shell/bat script so everytime I need to get data off my gps<SPAN class="Apple-converted-space"> </SPAN></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">into the database, its just a single command.</DIV> </BLOCKQUOTE><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Does that just do tracks, or does it also maintain attribute data for</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">each point (date/time, z-value, etc.)?</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I was thinking that keeping the points as points and having a line view</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">would be a neat way of presenting tidy lines and keeping attribute data.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Antti</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">------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.<SPAN class="Apple-converted-space"> </SPAN></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">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<SPAN class="Apple-converted-space"> </SPAN></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">------</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">postgis-users mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></DIV></BODY></HTML>