Hi Veronica, sorry for the late response. You can use the datetime[1] functionality of sqlite to perform this task, this should work for Jannuary:
t.rast.list input=cla_null_mayor65 where='start_time >= datetime(start_time, "start of year") and start_time <= datetime(start_time, "start of year", "1 month")' [1] https://www.sqlite.org/lang_datefunc.html Best regards Soeren 2014-06-17 20:40 GMT+02:00 Veronica Andreo <[email protected]>: > Hi list! > > I have a strds with 506 maps that correspond to 8-day composite products (11 > years). > > I want to get the list of maps where start_month is january, february and so > on... to use as input in r.series (or t.rast.series), but i'm not finding > the way to do that... > > i don't want to aggregate maps by month, i need to use the original maps > belonging to each month... is there a way to obtain that (aside from > manually :P)?? > > Till now the only query that has worked in the desired direction is: > > t.rast.list input=cla_null_mayor65 where="start_time >= '2003-01' and > start_time <= '2003-02'" > > cla_null_mayor65_1|clorofila|2003-01-01 00:00:00|2003-01-09 00:00:00 > cla_null_mayor65_2|clorofila|2003-01-09 00:00:00|2003-01-17 00:00:00 > cla_null_mayor65_3|clorofila|2003-01-17 00:00:00|2003-01-25 00:00:00 > cla_null_mayor65_4|clorofila|2003-01-25 00:00:00|2003-02-02 00:00:00 > > but that's only for january 2003... and i would need january 2004, 2005... > 2013 in the same list... when i add more clauses to the "where" query it > stops working... > > What would be the right approach here? > > THANKS MUCH IN ADVANCE! > > Best, > Vero > > _______________________________________________ > grass-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/grass-user _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
