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

[Markus Neteler]

On Tue, Nov 18, 2008 at 8:32 AM, Hamish <hamish_b at yahoo.com> wrote:
> 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.


Could this be related:
http://trac.osgeo.org/gdal/ticket/2474
"DateTime -> Date write support in Shapefile support"

?

Markus


> 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
>
>
>
>
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>



-- 
Open Source Geospatial Foundation
http://www.osgeo.org/
http://www.grassbook.org/