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

Mon Oct 15 12:00:06 PDT 2018

I did with neighborhood statistics and vector, and without.

with neighb. statistics & with vector
i.segment.stats -n --overwrite 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_15okt18
vectormap=vSegW24IDM4DV4 processes=3
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_10260 (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 precisiDBMI-SQLite driver error:
Error in sqlite3_prepare():
near "IDM4_third_qu": syntax error
on, IDM4_first_quart_nbrstddev double precision, IDM4_median_nbrmean double
precision, IDM4_median_nbrstddev double precision, IDM4_third_qu'
Traceback (most recent call last):
  File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri
pts/i.segment.stats.py", line 371, in <module>
    main()
  File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri
pts/i.segment.stats.py", line 358, in main
    gscript.run_command('db.execute', input=insert_sql,
quiet=True)
  File "C:\Program Files\GRASS GIS
7.6.svn\etc\python\grass\script\core.py", line 423, in
run_command
    return handle_errors(returncode, returncode, args,
kwargs)
  File "C:\Program Files\GRASS GIS
7.6.svn\etc\python\grass\script\core.py", line 334, in
handle_errors
    returncode=returncode)
grass.exceptions.CalledModuleError: Module run None
['db.execute', '--q', 'input=Z:\\GRASS_GIS\\Cottica_LUP\\LUP
1\\.tmp/unknown\\10260.1'] ended with error
Process ended with non-zero return code 1. See errors in the
(error) output.
(Mon Oct 15 09:54:33 2018) Command finished (81 min 46 sec)

without neighb. statistics, but with vector
(Mon Oct 15 10:54:02 2018)

i.segment.stats --overwrite 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_15okt18
vectormap=vSegW24IDM4DV4 processes=3
Calculating geometry statistics...
Calculating statistics for raster maps...
Creating output vector map...
DBMI-SQLite driver error:
Error in sqlite3_prepare():
no such column: nan
DBMI-SQLite driver error:
Error in sqlite3_prepare():
no such column: nan
ERROR: Error while executing: 'INSERT INTO segmstat_tmp_vect_3516 VALUES
(1244,
1.128379,0.0694444477558136,0,0,0,0.0694444,0.0694444,0.0694444,0.0694444,0,0,0,nan,0,0,0,0,0.53125,0,0,0,0.53125,0.53125,0.53125,0.53125,1,0,0,0,1,1,1,1,3,0,0,0,3,3,3,3,1,0,0,0,1,1,1,1)'
Traceback (most recent call last):
  File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri
pts/i.segment.stats.py", line 371, in <module>
    main()
  File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri
pts/i.segment.stats.py", line 358, in main
    gscript.run_command('db.execute', input=insert_sql,
quiet=True)
  File "C:\Program Files\GRASS GIS
7.6.svn\etc\python\grass\script\core.py", line 423, in
run_command
    return handle_errors(returncode, returncode, args,
kwargs)
  File "C:\Program Files\GRASS GIS
7.6.svn\etc\python\grass\script\core.py", line 334, in
handle_errors
    returncode=returncode)
grass.exceptions.CalledModuleError: Module run None
['db.execute', '--q', 'input=Z:\\GRASS_GIS\\Cottica_LUP\\LUP
1\\.tmp/unknown\\3516.1'] ended with error
Process ended with non-zero return code 1. See errors in the
(error) output.
(Mon Oct 15 12:17:00 2018) Command finished (82 min 57 sec)

without neighb. statistics & without vector
(Mon Oct 15 14:58:40 2018)

i.segment.stats --overwrite 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_15okt18b processes=3
Calculating geometry statistics...
Calculating statistics for raster maps...
(Mon Oct 15 15:15:18 2018) Command finished (16 min 38 sec)

with neighb. statistics, but without vector
(Mon Oct 15 15:32:39 2018)

i.segment.stats -n --overwrite 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_15okt18c processes=3
Calculating geometry statistics...
Calculating statistics for raster maps...
Calculating neighborhood statistics...
(Mon Oct 15 15:50:25 2018) Command finished (17 min 46 sec)

On Mon, Oct 15, 2018 at 6:18 AM Moritz Lennert <mlennert at club.worldonline.be>
wrote:

> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20181015/06b80f5e/attachment-0001.html>