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

Moritz Lennert mlennert at club.worldonline.be
Mon Oct 15 01:17:32 PDT 2018 

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 ?

Moritz


> ion, 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 <http://i.segment.stats.py>", line 370, in <module>
>      main()
>    File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri
> pts/i.segment.stats.py <http://i.segment.stats.py>", line 357, 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\\12816.1'] ended with error
> Process ended with non-zero return code 1. See errors in the
> (error) output.
> (Thu Oct 11 18:33:18 2018) Command finished (99 min 25 sec)
> 
> 
> On Thu, Oct 11, 2018 at 4:23 PM Moritz Lennert 
> <mlennert at club.worldonline.be <mailto:mlennert at club.worldonline.be>> wrote:
> 
>     On 11/10/18 19:42, Jamille Haarloo wrote:
>      > Markus, that's great! I will install the latest version and retry. I
>      > will report next Monday.
>      >
>      > Thanks Moritz. The spaces and '&' in paths of output files did
>     not give
>      > problems before, but I retried without the spaces and '&' just in
>     case.
>      > i.segment.stats -n --overwrite map=SegmW24IDM4DV4 at LUP1
>      > rasters=W2 at LUP1,W4 at LUP1,DV2 at LUP1,DV4 at LUP1,IDM2 at LUP1,IDM4 at LUP1
>      >
>     raster_statistics=mean,stddev,variance,coeff_var,first_quart,median,third_quart,perc_90
> 
>      > area_measures=compact_circle
>      >
>     csvfile=Z:\grass_cmd_output-i.segment.statsSegmWV24IDM4DV4_11okt2018.txt
> 
>      > vectormap=VSegmWV24IDM4DV4 processes=4
>      > Calculating geometry statistics...
>      > Calculating statistics for raster maps...
>      > Calculating neighborhood statistics...
>      > Traceback (most recent call last):
>      >    File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri
>      > pts/i.segment.stats.py <http://i.segment.stats.py>
>     <http://i.segment.stats.py>", line 370, in <module>
>      >      main()
>      >    File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri
>      > pts/i.segment.stats.py <http://i.segment.stats.py>
>     <http://i.segment.stats.py>", line 282, in main
>      >      quiet=True).splitlines()])
>      >    File "C:\Program Files\GRASS GIS
>      > 7.6.svn\etc\python\grass\script\core.py", line 478, in
>      > read_command
>      >      return handle_errors(returncode, stdout, 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
>      > ['r.neighborhoodmatrix', '--q', '-d',
>      > 'input=SegmW24IDM4DV4 at LUP1'] ended with error
> 
>     Try reinstalling r.neighborhoodmatrix with g.extension.
> 
>     Moritz
>

More information about the grass-user mailing list