[GRASS-user] DBMI-SQLite drive error when running i.segment.stats (with vector map creation)

Helmut Kudrnovsky hellik at web.de
Wed Oct 19 01:48:10 PDT 2016


James Duffy wrote
> I think that you're correct.
> 
> v.db.addcolumn --verbose map=angle_region_1_poly at angle1 columns=test.test
> 
> gives:
> 
> Adding column 
> <test.test>
>  to the table
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> near ".": syntax error
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> near ".": syntax error
> ERROR: Error while executing: 'ALTER TABLE angle_region_1_poly ADD COLUMN
> test.test'
> ERROR: Unable to add column 
> <test.test>
> .
> 
> Given that the default output names created when multi band rasters are
> read into GRASS with r.in.gdal contain a '.', and that these names can
> sometimes be used for labeling in vector operations (as I have
> described)...Is this something that can be rectified in the code of tools,
> or just something that should be worked around by the person using the
> tools?
> 
> I guess I could do this with a g.rename.
> 
> Thanks
> 
> James
> 
> On 18 October 2016 at 17:51, Helmut Kudrnovsky <

> hellik@

> > wrote:
> 
>> >angle_ortho.1_min double precision
>>
>> I suspect that it is the point in the column name.
>>
>> to verify, try to add such a column name in one of your vectors.
>>
>>
>>
>> -----
>> best regards
>> Helmut
>> --
>> View this message in context: http://osgeo-org.1560.x6.
>> nabble.com/DBMI-SQLite-drive-error-when-running-i-segment-
>> stats-with-vector-map-creation-tp5291318p5291319.html
>> Sent from the Grass - Users mailing list archive at Nabble.com.
>> _______________________________________________
>> grass-user mailing list
>> 

> grass-user at .osgeo

>> http://lists.osgeo.org/mailman/listinfo/grass-user
> 
> 
> 
> 
> -- 
> *James Duffy*
> PhD Researcher
> Environment and Sustainability Institute
> Penryn Campus
> University of Exeter
> Penryn
> Cornwall
> TR10 9FE
> 
> _______________________________________________
> grass-user mailing list

> grass-user at .osgeo

> http://lists.osgeo.org/mailman/listinfo/grass-user

maybe open an enhancement ticket in track to add new separators for
multiband import in r.in.gdal. 



-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DBMI-SQLite-drive-error-when-running-i-segment-stats-with-vector-map-creation-tp5291318p5291397.html
Sent from the Grass - Users mailing list archive at Nabble.com.


More information about the grass-user mailing list