Op 27 juni 2019 23:05:17 schreef Markus Metz <[email protected]>:
On Thu, Jun 27, 2019 at 9:27 PM Paulo van Breugel <[email protected]>
wrote:
Hi devs,
I am trying to import a shapefile using v.in.ogr, filtering on date
using datetime, e.g.,
v.in.ogr input=myshapefile.shp layer=myshapefile output=outputlayer
where="datm_start >= datetime('2019-01-01')"
I am getting the message:
ERROR 1: Undefined function 'datetime' used.
ERROR: Error setting attribute filter 'datm_start >= datetime('2019-01-01')'
Does this mean it is not possible to use functions in v.in.ogr? Or am I
doing somthing wrong?
The OGR shapefile driver does not support this function. You need to import
the shapefile into GRASS, using anything but the dbf driver as database
driver (default is sqlite), then try to filter with v.extract
where="datm_start >= datetime('2019-01-01')"
Ok, thanks, was hoping I could do a selection before to safe on the time ik
takes to import. I'll look for a way to filter before import using another
tool.
HTH,
Markus M
Running grass gis 7.6, Linux.
Cheers,
Paulo
_______________________________________________
grass-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/grass-dev
_______________________________________________
grass-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/grass-dev