[GRASS-user] i.segment and i.segment.stats errors

[Moritz Lennert]

On 15/10/18 10:54, Moritz Lennert wrote:
> On 15/10/18 10:17, Moritz Lennert wrote:
>> On 12/10/18 21:10, Jamille Haarloo wrote:
>>> Markus. i.segment finished without giving an error.
>>>
>>> Moritz,
>>> I am back at the older error. I've seen this error documented online as
>>> a result of 'unaccepted' column-names. I tried to keep the name of the
>>> input maps for the statistics as short and simple possible (without dots
>>> etc).
>>>
>>> i.segment.stats -n map=SegW24IDM4DV4 at LUP1
>>> rasters=DV2 at LUP1,DV4 at LUP1,IDM2 at LUP1,IDM4 at LUP1,W2 at LUP1,W4 at LUP1
>>> raster_statistics=mean,stddev,variance,coeff_var,first_quart,median,third_quart,perc_90
>>> area_measures=compact_circle
>>> csvfile=C:\Users\haarlooj\Stats_SegW24IDM4DV4_11okt18
>>> vectormap=vSegW24IDM4DV4 processes=2
>>> Calculating geometry statistics...
>>> Calculating statistics for raster maps...
>>> Calculating neighborhood statistics...
>>> Creating output vector map...
>>> DBMI-SQLite driver error:
>>> Error in sqlite3_prepare():
>>> near "IDM4_third_qu": syntax error
>>> ERROR: Error while executing: 'CREATE TABLE segmstat_tmp_vect_12816 (cat
>>> int, compact_circle double precision, DV2_mean double precision,
>>> DV2_stddev double precision, DV2_variance double precision,
>>> DV2_coeff_var double precision, DV2_first_quart double precision,
>>> DV2_median double precision, DV2_third_quart double precision,
>>> DV2_perc_90 double precision, DV4_mean double precision, DV4_stddev
>>> double precision, DV4_variance double precision, DV4_coeff_var double
>>> precision, DV4_first_quart double precision, DV4_median double
>>> precision, DV4_third_quart double precision, DV4_perc_90 double
>>> precision, IDM2_mean double precision, IDM2_stddev double precision,
>>> IDM2_variance double precision, IDM2_coeff_var double precision,
>>> IDM2_first_quart double precision, IDM2_median double precision,
>>> IDM2_third_quart double precision, IDM2_perc_90 double precision,
>>> IDM4_mean double precision, IDM4_stddev double precision, IDM4_variance
>>> double precision, IDM4_coeff_var double precision, IDM4_first_quart
>>> double precision, IDM4_median double precision, IDM4_third_quart double
>>> precision, IDM4_perc_90 double precision, W2_mean double precision,
>>> W2_stddev double precision, W2_variance double precision, W2_coeff_var
>>> double precision, W2_first_quart double precision, W2_median double
>>> precision, W2_third_quart double precision, W2_perc_90 double precision,
>>> W4_mean double precision, W4_stddev double precision, W4_variance double
>>> precision, W4_coeff_var double precision, W4_first_quart double
>>> precision, W4_median double precision, W4_third_quart double precision,
>>> W4_perc_90 double precision, neighbors_count double precision,
>>> compact_circle_nbrmean double precision, compact_circle_nbrstddev double
>>> precision, DV2_mean_nbrmean double precision, DV2_mean_nbrstddev double
>>> precision, DV2_stddev_nbrmean double precision, DV2_stddev_nbrstddev
>>> double precision, DV2_variance_nbrmean double precision,
>>> DV2_variance_nbrstddev double precision, DV2_coeff_var_nbrmean double
>>> precision, DV2_coeff_var_nbrstddev double precision,
>>> DV2_first_quart_nbrmean double precision, DV2_first_quart_nbrstddev
>>> double precision, DV2_median_nbrmean double precision,
>>> DV2_median_nbrstddev double precision, DV2_third_quart_nbrmean double
>>> precision, DV2_third_quart_nbrstddev double precision,
>>> DV2_perc_90_nbrmean double precision, DV2_perc_90_nbrstddev double
>>> precision, DV4_mean_nbrmean double precision, DV4_mean_nbrstddev double
>>> precision, DV4_stddev_nbrmean double precision, DV4_stddev_nbrstddev
>>> double precision, DV4_variance_nbrmean double precision,
>>> DV4_variance_nbrstddev double precision, DV4_coeff_var_nbrmean double
>>> precision, DV4_coeff_var_nbrstddev double precision,
>>> DV4_first_quart_nbrmean double precision, DV4_first_quart_nbrstddev
>>> double precision, DV4_median_nbrmean double precision,
>>> DV4_median_nbrstddev double precision, DV4_third_quart_nbrmean double
>>> precision, DV4_third_quart_nbrstddev double precision,
>>> DV4_perc_90_nbrmean double precision, DV4_perc_90_nbrstddev double
>>> precision, IDM2_mean_nbrmean double precision, IDM2_mean_nbrstddev
>>> double precision, IDM2_stddev_nbrmean double precision,
>>> IDM2_stddev_nbrstddev double precision, IDM2_variance_nbrmean double
>>> precision, IDM2_variance_nbrstddev double precision,
>>> IDM2_coeff_var_nbrmean double precision, IDM2_coeff_var_nbrstddev double
>>> precision, IDM2_first_quart_nbrmean double precision,
>>> IDM2_first_quart_nbrstddev double precision, IDM2_median_nbrmean double
>>> precision, IDM2_median_nbrstddev double precision,
>>> IDM2_third_quart_nbrmean double precision, IDM2_third_quart_nbrstddev
>>> double precision, IDM2_perc_90_nbrmean double precision,
>>> IDM2_perc_90_nbrstddev double precision, IDM4_mean_nbrmean double
>>> precision, IDM4_mean_nbrstddev double precision, IDM4_stddev_nbrmean
>>> double precision, IDM4_stddev_nbrstddev double precision,
>>> IDM4_variance_nbrmean double precision, IDM4_variance_nbrstddev double
>>> precision, IDM4_coeff_var_nbrmean double precision,
>>> IDM4_coeff_var_nbrstddev double precision, IDM4_first_quart_nbrmean
>>> double precisDBMI-SQLite driver error > Error in sqlite3_prepare():
>>> near "IDM4_third_qu": syntax error
>>
>>
>> Hmm. Maybe the string just gets too long.
>>
>> I have to think about how to split this up into several calls.

I just committed a new version of i.segment.stats (r73548) which should 
avoid this problem. Please reinstall with g.extension and try again.

Moritz