[GRASS-user] d.what.vect multi-layer, SQLite datetime

Hamish hamish_b at yahoo.com
Tue Nov 18 02:32:51 EST 2008


Hamish wrote:
> I have a 5 layer vector map created with v.in.ogr's GPX
> driver.
....
> also I get a number of warnings like:
>  WARNING: SQLite driver: unable to parse decltype: datetime
>  WARNING: SQLite driver: unable to parse decltype: datetime
>  WARNING: SQLite driver: column 'time', SQLite type
> 3 is not supported
> 
> ?
> (timestamps are rather important to tell overlapping tracks
> apart)

some more info:

ogr2ogr gives this warning for GPX->shp:
 Warning 6: Field time create as date field, though DateTime requested.
 Warning 6: Field time create as date field, though DateTime requested.
 Warning 6: Field time create as date field, though DateTime requested.

and time column in track_points shapefile is empty when it has a value,
and 0 when not. In GRASS with v.in.ogr track_points layer fills in
previous column (elevation) in time column when there is no timestamp,
or real timestamp when it does have it.  mmph.


shp uses dbf, which will cut column names at 10 chars, but output layers
are named well (route_points, routes, track_points, tracks, waypoints)
which are lost when called grass layers 1-5.


Hamish



      



More information about the grass-user mailing list