[postgis-users] gps points to postgis

[Rich Gibson]

Hi Mike,

Do you really have one line segment that is 8500 GPS points, or do you 
have multiple segments?

I've been working with the same problem and I have decided that I want to 
represent track point as both individual points, each with its' own 
timestamp, as well as representing each track segments as an individual 
linestring.

Doing this allows  you to represent the track as a line when it suits you, 
as well as individual points when that makes sense.

Cheers,
Rich

On Tue, 2 Nov 2004, Mike Jackson wrote:

> Hi,
>   I have a text file of dms coordinates from a gps, which I would like to add to my database. The 
> file is ~8500 lines. I would like to be able to represent the journey on a mapserver map, using a 
> line instead of dots.
> 
>   What is the best way to store this? I have some road LINESTRINGs which are ~100 pairs of 
> coordinates, but storing 8500 pairs in one LINESTRING doesn't seem to me like the right way to go 
> about it. If I store them as single POINT records, can I represent it as a line in mapserver?
> 
>   Recommendations?
> 
> Thanks,
> Mike
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>