[postgis-users] Re: PostGIS table structure

[Sean Fulton]

Eli Dylan Lorimer wrote:
> Hi,
> I'm going to be tracking myself with a gps for the next few months and 
> will be storing the collection of waypoints in a PostgreSQL/PostGIS db 
> for subsequent visualization. I'm just now trying to figure out the best 
> table structure to use. Although I'm pretty unfamiliar with spatial 
> databases in general, I believe I'll want to store the lat/lon as point 
> objects, correct? As the primary purpose of storing all this info is so 
> that I may examine spatio-temporal patterns in it, the time stamp for 
> each waypoint is very important too. Can anyone recommend a general way 
> to go about storing this data? I'm just looking for a few general ideas 
> and/or pitfalls to avoid so as not to screw myself in the end. Much thanks.


Take a look at gpx2shp <http://gpx2shp.sourceforge.jp/>. I believe it 
supports time attributes. Loading the resulting shapefile into Postgres 
should be much easier than doing a table by hand.

	Sean