<div dir="ltr"><div dir="ltr">I did with neighborhood statistics and vector, and without. <div><br></div><div><span style="background-color:rgb(255,242,204)">with neighb. statistics & with vector</span></div><div>i.segment.stats -n --overwrite 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_15okt18 vectormap=vSegW24IDM4DV4 processes=3<br></div><div><div>Calculating geometry statistics...</div><div>Calculating statistics for raster maps...</div><div>Calculating neighborhood statistics...</div><div>Creating output vector map...</div><div>DBMI-SQLite driver error:</div><div>Error in sqlite3_prepare():</div><div>near "IDM4_third_qu": syntax error</div><div>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:</div><div>Error in sqlite3_prepare():</div><div>near "IDM4_third_qu": syntax error</div><div>on, IDM4_first_quart_nbrstddev double precision, IDM4_median_nbrmean double precision, IDM4_median_nbrstddev double precision, IDM4_third_qu'</div><div>Traceback (most recent call last):</div><div> File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri</div><div>pts/<a href="http://i.segment.stats.py">i.segment.stats.py</a>", line 371, in <module></div><div> main()</div><div> File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri</div><div>pts/<a href="http://i.segment.stats.py">i.segment.stats.py</a>", line 358, in main</div><div> gscript.run_command('db.execute', input=insert_sql,</div><div>quiet=True)</div><div> File "C:\Program Files\GRASS GIS</div><div>7.6.svn\etc\python\grass\script\core.py", line 423, in</div><div>run_command</div><div> return handle_errors(returncode, returncode, args,</div><div>kwargs)</div><div> File "C:\Program Files\GRASS GIS</div><div>7.6.svn\etc\python\grass\script\core.py", line 334, in</div><div>handle_errors</div><div> returncode=returncode)</div><div>grass.exceptions.CalledModuleError: Module run None</div><div>['db.execute', '--q', 'input=Z:\\GRASS_GIS\\Cottica_LUP\\LUP</div><div>1\\.tmp/unknown\\10260.1'] ended with error</div><div>Process ended with non-zero return code 1. See errors in the</div><div>(error) output.</div><div>(Mon Oct 15 09:54:33 2018) Command finished (81 min 46 sec) </div><div><br></div><div><span style="background-color:rgb(255,242,204)">without neighb. statistics, but with vector</span></div><div>(Mon Oct 15 10:54:02 2018) </div><div>i.segment.stats --overwrite 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_15okt18 vectormap=vSegW24IDM4DV4 processes=3</div><div>Calculating geometry statistics...</div><div>Calculating statistics for raster maps...</div><div>Creating output vector map...</div><div>DBMI-SQLite driver error:</div><div>Error in sqlite3_prepare():</div><div>no such column: nan</div><div>DBMI-SQLite driver error:</div><div>Error in sqlite3_prepare():</div><div>no such column: nan</div><div>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)'</div><div>Traceback (most recent call last):</div><div> File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri</div><div>pts/<a href="http://i.segment.stats.py">i.segment.stats.py</a>", line 371, in <module></div><div> main()</div><div> File "C:\Users\haarlooj\AppData\Roaming\GRASS7\addons/scri</div><div>pts/<a href="http://i.segment.stats.py">i.segment.stats.py</a>", line 358, in main</div><div> gscript.run_command('db.execute', input=insert_sql,</div><div>quiet=True)</div><div> File "C:\Program Files\GRASS GIS</div><div>7.6.svn\etc\python\grass\script\core.py", line 423, in</div><div>run_command</div><div> return handle_errors(returncode, returncode, args,</div><div>kwargs)</div><div> File "C:\Program Files\GRASS GIS</div><div>7.6.svn\etc\python\grass\script\core.py", line 334, in</div><div>handle_errors</div><div> returncode=returncode)</div><div>grass.exceptions.CalledModuleError: Module run None</div><div>['db.execute', '--q', 'input=Z:\\GRASS_GIS\\Cottica_LUP\\LUP</div><div>1\\.tmp/unknown\\3516.1'] ended with error</div><div>Process ended with non-zero return code 1. See errors in the</div><div>(error) output.</div><div>(Mon Oct 15 12:17:00 2018) Command finished (82 min 57 sec) </div><div><br></div><div><div><div><span style="background-color:rgb(255,242,204)">without neighb. statistics & without vector</span></div></div></div><div>(Mon Oct 15 14:58:40 2018) </div><div>i.segment.stats --overwrite 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_15okt18b processes=3</div><div>Calculating geometry statistics...</div><div>Calculating statistics for raster maps...</div><div>(Mon Oct 15 15:15:18 2018) Command finished (16 min 38 sec) </div><div><br></div><div><div><span style="background-color:rgb(255,242,204)">with neighb. statistics, but without vector</span></div></div><div>(Mon Oct 15 15:32:39 2018) </div><div>i.segment.stats -n --overwrite 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_15okt18c processes=3</div><div>Calculating geometry statistics...</div><div>Calculating statistics for raster maps...</div><div>Calculating neighborhood statistics...</div><div>(Mon Oct 15 15:50:25 2018) Command finished (17 min 46 sec) </div><div><br></div><div><br></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Mon, Oct 15, 2018 at 6:18 AM Moritz Lennert <<a href="mailto:mlennert@club.worldonline.be" target="_blank">mlennert@club.worldonline.be</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 15/10/18 10:54, Moritz Lennert wrote:<br>
> On 15/10/18 10:17, Moritz Lennert wrote:<br>
>> On 12/10/18 21:10, Jamille Haarloo wrote:<br>
>>> Markus. i.segment finished without giving an error.<br>
>>><br>
>>> Moritz,<br>
>>> I am back at the older error. I've seen this error documented online as<br>
>>> a result of 'unaccepted' column-names. I tried to keep the name of the<br>
>>> input maps for the statistics as short and simple possible (without dots<br>
>>> etc).<br>
>>><br>
>>> i.segment.stats -n map=SegW24IDM4DV4@LUP1<br>
>>> rasters=DV2@LUP1,DV4@LUP1,IDM2@LUP1,IDM4@LUP1,W2@LUP1,W4@LUP1<br>
>>> raster_statistics=mean,stddev,variance,coeff_var,first_quart,median,third_quart,perc_90<br>
>>> area_measures=compact_circle<br>
>>> csvfile=C:\Users\haarlooj\Stats_SegW24IDM4DV4_11okt18<br>
>>> vectormap=vSegW24IDM4DV4 processes=2<br>
>>> Calculating geometry statistics...<br>
>>> Calculating statistics for raster maps...<br>
>>> Calculating neighborhood statistics...<br>
>>> Creating output vector map...<br>
>>> DBMI-SQLite driver error:<br>
>>> Error in sqlite3_prepare():<br>
>>> near "IDM4_third_qu": syntax error<br>
>>> ERROR: Error while executing: 'CREATE TABLE segmstat_tmp_vect_12816 (cat<br>
>>> int, compact_circle double precision, DV2_mean double precision,<br>
>>> DV2_stddev double precision, DV2_variance double precision,<br>
>>> DV2_coeff_var double precision, DV2_first_quart double precision,<br>
>>> DV2_median double precision, DV2_third_quart double precision,<br>
>>> DV2_perc_90 double precision, DV4_mean double precision, DV4_stddev<br>
>>> double precision, DV4_variance double precision, DV4_coeff_var double<br>
>>> precision, DV4_first_quart double precision, DV4_median double<br>
>>> precision, DV4_third_quart double precision, DV4_perc_90 double<br>
>>> precision, IDM2_mean double precision, IDM2_stddev double precision,<br>
>>> IDM2_variance double precision, IDM2_coeff_var double precision,<br>
>>> IDM2_first_quart double precision, IDM2_median double precision,<br>
>>> IDM2_third_quart double precision, IDM2_perc_90 double precision,<br>
>>> IDM4_mean double precision, IDM4_stddev double precision, IDM4_variance<br>
>>> double precision, IDM4_coeff_var double precision, IDM4_first_quart<br>
>>> double precision, IDM4_median double precision, IDM4_third_quart double<br>
>>> precision, IDM4_perc_90 double precision, W2_mean double precision,<br>
>>> W2_stddev double precision, W2_variance double precision, W2_coeff_var<br>
>>> double precision, W2_first_quart double precision, W2_median double<br>
>>> precision, W2_third_quart double precision, W2_perc_90 double precision,<br>
>>> W4_mean double precision, W4_stddev double precision, W4_variance double<br>
>>> precision, W4_coeff_var double precision, W4_first_quart double<br>
>>> precision, W4_median double precision, W4_third_quart double precision,<br>
>>> W4_perc_90 double precision, neighbors_count double precision,<br>
>>> compact_circle_nbrmean double precision, compact_circle_nbrstddev double<br>
>>> precision, DV2_mean_nbrmean double precision, DV2_mean_nbrstddev double<br>
>>> precision, DV2_stddev_nbrmean double precision, DV2_stddev_nbrstddev<br>
>>> double precision, DV2_variance_nbrmean double precision,<br>
>>> DV2_variance_nbrstddev double precision, DV2_coeff_var_nbrmean double<br>
>>> precision, DV2_coeff_var_nbrstddev double precision,<br>
>>> DV2_first_quart_nbrmean double precision, DV2_first_quart_nbrstddev<br>
>>> double precision, DV2_median_nbrmean double precision,<br>
>>> DV2_median_nbrstddev double precision, DV2_third_quart_nbrmean double<br>
>>> precision, DV2_third_quart_nbrstddev double precision,<br>
>>> DV2_perc_90_nbrmean double precision, DV2_perc_90_nbrstddev double<br>
>>> precision, DV4_mean_nbrmean double precision, DV4_mean_nbrstddev double<br>
>>> precision, DV4_stddev_nbrmean double precision, DV4_stddev_nbrstddev<br>
>>> double precision, DV4_variance_nbrmean double precision,<br>
>>> DV4_variance_nbrstddev double precision, DV4_coeff_var_nbrmean double<br>
>>> precision, DV4_coeff_var_nbrstddev double precision,<br>
>>> DV4_first_quart_nbrmean double precision, DV4_first_quart_nbrstddev<br>
>>> double precision, DV4_median_nbrmean double precision,<br>
>>> DV4_median_nbrstddev double precision, DV4_third_quart_nbrmean double<br>
>>> precision, DV4_third_quart_nbrstddev double precision,<br>
>>> DV4_perc_90_nbrmean double precision, DV4_perc_90_nbrstddev double<br>
>>> precision, IDM2_mean_nbrmean double precision, IDM2_mean_nbrstddev<br>
>>> double precision, IDM2_stddev_nbrmean double precision,<br>
>>> IDM2_stddev_nbrstddev double precision, IDM2_variance_nbrmean double<br>
>>> precision, IDM2_variance_nbrstddev double precision,<br>
>>> IDM2_coeff_var_nbrmean double precision, IDM2_coeff_var_nbrstddev double<br>
>>> precision, IDM2_first_quart_nbrmean double precision,<br>
>>> IDM2_first_quart_nbrstddev double precision, IDM2_median_nbrmean double<br>
>>> precision, IDM2_median_nbrstddev double precision,<br>
>>> IDM2_third_quart_nbrmean double precision, IDM2_third_quart_nbrstddev<br>
>>> double precision, IDM2_perc_90_nbrmean double precision,<br>
>>> IDM2_perc_90_nbrstddev double precision, IDM4_mean_nbrmean double<br>
>>> precision, IDM4_mean_nbrstddev double precision, IDM4_stddev_nbrmean<br>
>>> double precision, IDM4_stddev_nbrstddev double precision,<br>
>>> IDM4_variance_nbrmean double precision, IDM4_variance_nbrstddev double<br>
>>> precision, IDM4_coeff_var_nbrmean double precision,<br>
>>> IDM4_coeff_var_nbrstddev double precision, IDM4_first_quart_nbrmean<br>
>>> double precisDBMI-SQLite driver error > Error in sqlite3_prepare():<br>
>>> near "IDM4_third_qu": syntax error<br>
>><br>
>><br>
>> Hmm. Maybe the string just gets too long.<br>
>><br>
>> I have to think about how to split this up into several calls.<br>
<br>
I just committed a new version of i.segment.stats (r73548) which should <br>
avoid this problem. Please reinstall with g.extension and try again.<br>
<br>
Moritz<br>
<br>
</blockquote></div>