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@LUP1
rasters=DV2@LUP1,DV4@LUP1,IDM2@LUP1,IDM4@LUP1,W2@LUP1,W4@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

_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user

Reply via email to