[postgis-users] What are people using to load gps data? [SEC=UNCLASSIFIED]
Will Muir
will at mtintouch.net
Sun May 13 18:53:49 PDT 2007
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.
Will
Shapefile type: Point
Postgis type: POINT[2]
BEGIN;
CREATE TABLE "5-11" (gid serial PRIMARY KEY,
"shapeid" int4,
"ele" float8,
"time" varchar(32),
"magvar" float8,
"geoidheigh" float8,
"name" varchar(32),
"cmt" varchar(255),
"desc" varchar(255),
"src" varchar(255),
"link" varchar(255),
"sym" varchar(32),
"type" varchar(32),
"sat" int4,
"hdop" float8,
"vdop" float8,
"ageofdgpsd" float8,
"dgpsid" float8);
SELECT AddGeometryColumn('','5-11','the_geom','-1','POINT',2);
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','0
01',NULL,NULL,'Flag',NULL,'0','0.0000','0.0000','0.0000','0.0000','00000
00001C05BBE7AFEAC76744045E47357A3DE75');
On May 13, 2007, at 7:20 PM, Roppola, Antti - BRS wrote:
> Matthew Perry wrote:
>
>> gpsbabel -> gpx2shp -> shp2pgsql works great for me. I just wrap
>> it in
>
>> a little shell/bat script so everytime I need to get data off my gps
>> into the database, its just a single command.
>
> Does that just do tracks, or does it also maintain attribute data for
> each point (date/time, z-value, etc.)?
>
> I was thinking that keeping the points as points and having a line
> view
> would be a neat way of presenting tidy lines and keeping attribute
> data.
>
> Antti
>
> ------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
> ------
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070513/bf42723e/attachment.html>
More information about the postgis-users
mailing list