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

[Moritz Lennert]

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.
> 
> Could you try without -n (i.e. without the neighborhood statistics) just
> to make sure this works ?


Correct that: try running the command with the -n flag, but without the 
vectormap= parameter. This will only create the csv file and so avoid 
the table creation difficulties.

Moritz