[GRASS-user] error on importing shapefile

Sat Nov 4 23:20:17 PDT 2017

Dear Martin,

The error seems to be caused by a single record.

Here is the error message -

ERROR: Cannot insert new row: insert into tmp1509862383896 values ( 661,
743818, 'ENMAC076001600023897000000', 'E', 'S', 'C', 258.750000, '',
25.386566, -33.806219, '23897', 0.000020, 0.869174, 'MC',
'C07600160002389700000', '2009-08-20', '', '', '', '', '', , , '', '', '',
'' )

If I remove this record v.buffer.distance executes completely

I have attached a sample of with the offending record.

Algorithm v.buffer.distance - Creates a buffer around features of given
type. starting...

g.proj -c proj4="+proj=longlat +ellps=WGS84 +towgs84=0,0,0,0,0,0,0 +no_defs"

v.in.ogr min_area=0.0001 snap=-1 input="/home/mazizi/test-data"
layer=error-area output=tmp1509862383896 --overwrite -o

g.region n=-33.802331778 s=-33.809531866 e=25.390795097 w=25.38292819
res=100

v.buffer input="tmp1509862383896" distance="0" tolerance="0.01"
output=output98bf354b4c5c4bffb14fc9e15d649c22 --overwrite

v.out.ogr -s -e input=output98bf354b4c5c4bffb14fc9e15d649c22 type=auto
output="/tmp/processing2b242a8d30d6406f8c62be6c79983c49/39c2cc63e0dc47fe84a5fcafa7cc698f"
format=ESRI_Shapefile output_layer=output --overwrite

Cleaning up temporary files...

Starting GRASS GIS...

Executing ...

Default region was updated to the new projection, but if you have multiple
mapsets `g.region -d` should be run in each to update the region from the
default

Projection information updated

WARNING: Datum not recognised by GRASS and no parameters found

Over-riding projection check

Check if OGR layer contains polygons...

0..2..4..6..8..10..12..14..16..18..20..22..24..26..28..30..32..34..36..38..40..42..44..46..48..50..52..54..56..58..60..62..64..66..68..70..72..74..76..78..80..82..84..86..88..90..92..94..96..98..100

Importing 718 features (OGR layer )...

0..2..4..6..8..10..12..14..16..18..20..22..24..26..28..30..32..34..36..38..40..42..44..46..48..50..52..54..56..58..60..62..64..66..68..70..72..74..76..78..80..82..84..86..88..90..DBMI-SQLite
driver error:

Error in sqlite3_prepare():

near ",": syntax error

DBMI-SQLite driver error:

Error in sqlite3_prepare():

near ",": syntax error

ERROR: Cannot insert new row: insert into tmp1509862383896 values ( 661,
743818, 'ENMAC076001600023897000000', 'E', 'S', 'C', 258.750000, '',
25.386566, -33.806219, '23897', 0.000020, 0.869174, 'MC',
'C07600160002389700000', '2009-08-20', '', '', '', '', '', , , '', '', '',
'' )

Note: In latitude-longitude coordinate system specify distances in degree
unit

WARNING: Unable to open vector map on level 2. Try to rebuild vector
topology with v.build.

ERROR: Unable to open vector map

ERROR: Vector map not found

Execution of finished.

Cleaning up temporary files...

Starting GRASS GIS...

Executing ...

ERROR: Vector map not found

Execution of finished.

Cleaning up temporary files...

Converting outputs

Loading resulting layers

Algorithm v.buffer.distance - Creates a buffer around features of given
type. finished

Strangely though if I run the the same command in a Windows machine I do
not get the above error message.

On Thu, Nov 2, 2017 at 1:34 PM, Martin Landa <landa.martin at gmail.com> wrote:

> Hi,
>
> 2017-11-02 10:47 GMT+01:00 Zizi Jama <mazizi.jama at gmail.com>:
> > I get the error below on running v.buffer.distance via the grass qgis
> > plugin.
>
> please send exact commands with plugin runs and sample data to
> reproduce the behaviour. And ideally fill a new ticket [1]. Martin
>
> [1] https://trac.osgeo.org/grass/newticket
>
> --
> Martin Landa
> http://geo.fsv.cvut.cz/gwiki/Landa
> http://gismentors.cz/mentors/landa
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20171105/d3e04627/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: error-area.zip
Type: application/zip
Size: 75253 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20171105/d3e04627/attachment-0001.zip>