[GRASS-dev] Which are the strds 'columns'?

[Nikos Alexandris]

Awesome explanation, as usual!

Much appreciated.

Nikos

* Veronica Andreo <veroandreo at gmail.com> [2017-10-21 15:01:14 +0200]:

>Hi Nikos,
>
>the columns that you use in the where condition of temporal modules are
>those in the SQLite table that stores metadata about each map in the
>st(r)ds: min, max, start_time, end_time. AFAIK, there's no metadata for the
>mean, i.e. no column in the SQLite table containing that info. Here there
>are some examples with t.rast.list [1] using where. Maybe the error message
>could be improved as to specify which columns are available.
>
>If, from the output t.rast.univar (with or without -e) you want to get
>those maps where LST mean is higher than 10, then you would need a
>different procedure. What I did eventually, was import the .txt file into
>R, and there, make queries with sqldf package. There's for sure other much
>better options that I would love to learn.
>
>hth,
>Vero
>
>[1]
>https://grasswiki.osgeo.org/wiki/Temporal_data_processing#Listing_maps_and_selections
>
>2017-10-21 14:34 GMT+02:00 Nikos Alexandris <nik at nikosalexandris.net>:
>
>> Shouldn't the following work?
>>
>> t.rast.univar lst where="mean > 10"
>> ..
>> sqlite3.OperationalError: no such column: mean
>>
>>
>> 'min', 'max' and 'start_time' work.
>>
>> Where are the "columns"?
>> Isn't the whole of what t.rast.univar -e reports supported?
>>
>> Thank you, Nikos
>>
>> _______________________________________________
>> grass-dev mailing list
>> grass-dev at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/grass-dev
>>

-- 
Nikos Alexandris | Remote Sensing & Geomatics
GPG Key Fingerprint 6F9D4506F3CA28380974D31A9053534B693C4FB3 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-dev/attachments/20171021/20af0ebf/attachment.sig>