[GRASS-user] grass-user Digest, Vol 126, Issue 37

[Diana Brito]

thank you so much Helmut, now is working!!!

2016-10-14 16:00 GMT-03:00 <grass-user-request at lists.osgeo.org>:

> Send grass-user mailing list submissions to
>         grass-user at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.osgeo.org/mailman/listinfo/grass-user
> or, via email, send a message with subject or body 'help' to
>         grass-user-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         grass-user-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of grass-user digest..."
>
>
> Today's Topics:
>
>    1. Re: Problem in running r.basin (Margherita Di Leo)
>    2. v.rast.stats ERROR (Diana Brito)
>    3. Re: v.rast.stats ERROR (Helmut Kudrnovsky)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 14 Oct 2016 17:41:10 +0200
> From: Margherita Di Leo <diregola at gmail.com>
> To: Priscilla_I <isacco.silvia at gmail.com>
> Cc: GRASS user list <grass-user at lists.osgeo.org>
> Subject: Re: [GRASS-user] Problem in running r.basin
> Message-ID:
>         <CABa=8QpETm2cohaWA8DtpgwmFkOW84QfCMQS-rn6DzKB8L6pYw at mail.
> gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Fri, Oct 14, 2016 at 4:59 PM, Priscilla_I <isacco.silvia at gmail.com>
> wrote:
>
> > I removed the old output and launched the command but now it gets this
> > error
> >
> > ERROR: option <output>: <Silvia\out_Ghiandone_DEM_outlet_coors.txt>
> > exists. To overwrite, use the --overwrite flag
> >
>
> Yes, this is the txt file that you have created with the previous run. You
> have to remove that as well before running r.basin again.
>
>
> --
> Margherita Di Leo
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.osgeo.org/pipermail/grass-user/
> attachments/20161014/431994e1/attachment-0001.html>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 14 Oct 2016 15:19:37 -0300
> From: Diana Brito <dianisbrito2 at gmail.com>
> To: grass-user at lists.osgeo.org
> Subject: [GRASS-user] v.rast.stats ERROR
> Message-ID:
>         <CAJE1VPs57iFG0c0KH=cS52km_9XH3ovoDfw4603iLe47LnVEBw@
> mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> HI LIST!
>
> I have a five years  time serie of NDVI, and i need to obtain the average
> value of some polygons in a vector shape named "buffer_xime4", Im trying to
> use v.rast.stats into a for cicle as follows:
>
> contador=1
> for map in `g.list rast pat=MOD13*A2010*NDVI`
> do
> v.rast.stats -c map=buffer_xime4 raster=$map column_prefix=$contador
> method=average
> let contador=contador+1
> done
>
> But grass (GRASS GIS 7.0.4) returns this error.
>
> ...................................................
> ....................................................
>
> RROR: Error mientras se ejecutaba: 'ALTER TABLE buffer_xime4 ADD COLUMN
>        1_average DOUBLE PRECISION'
> ERROR: Unable to add column <1_average DOUBLE PRECISION>.
> ERROR: Adding columns failed. Exiting.
> Preprocessing input data...
> DBMI-SQLite Error del manejador:
> Error en sqlite3_prepare():
> unrecognized token: "2_average"
>
> DBMI-SQLite Error del manejador:
> Error en sqlite3_prepare():
> unrecognized token: "2_average"
> RROR: Error mientras se ejecutaba: 'ALTER TABLE buffer_xime4 ADD COLUMN
>        1_average DOUBLE PRECISION'
> ERROR: Unable to add column <1_average DOUBLE PRECISION>.
> ERROR: Adding columns failed. Exiting.
> Preprocessing input data...
> DBMI-SQLite Error del manejador:
> Error en sqlite3_prepare():
> unrecognized token: "2_average"
>
> DBMI-SQLite Error del manejador:
> Error en sqlite3_prepare():
> unrecognized token: "2_average"
> ..................................
> ......................................
> ......................................
>
> Could you please tell me what im doing wrong?
>
> thanks in advance.
>
> --
> Diana Marcela Brito Hoyos
> Bióloga
>
> "*El bosque sería muy triste si solo cantaran los pájaros que mejor lo
> hacen"*
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.osgeo.org/pipermail/grass-user/
> attachments/20161014/d056ffb5/attachment-0001.html>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 14 Oct 2016 11:35:01 -0700 (MST)
> From: Helmut Kudrnovsky <hellik at web.de>
> To: grass-user at lists.osgeo.org
> Subject: Re: [GRASS-user] v.rast.stats ERROR
> Message-ID: <1476470101779-5290777.post at n6.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> >ERROR: Unable to add column <1_average DOUBLE PRECISION>.
> >ERROR: Adding columns failed. Exiting.
>
> AFAIR in SQL column names starting with a number isn't allowed.
>
> So try to switch from 1_average to average_1 and so on.
>
>
>
>
>
> -----
> best regards
> Helmut
> --
> View this message in context: http://osgeo-org.1560.x6.
> nabble.com/v-rast-stats-ERROR-tp5290775p5290777.html
> Sent from the Grass - Users mailing list archive at Nabble.com.
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>
> ------------------------------
>
> End of grass-user Digest, Vol 126, Issue 37
> *******************************************
>



-- 
Diana Marcela Brito Hoyos
Bióloga

"*El bosque sería muy triste si solo cantaran los pájaros que mejor lo
hacen"*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20161014/62c4c021/attachment.html>