If you extend your sql statement a little you can get things like sqlite3 -header -csv weewx.sdb "select inTemp from archive where DateTime > xxxxxxxxxx;" > out.csv
or sqlite3 -header -csv weewx.sdb "select * from archive where DateTime > xxxxxxxxxxx;" > out.csv or sqlite3 -header -csv weewx.sdb "select * from archive where DateTime > xxxxxxxxxxx and DateTime < yyyyyyyy;" > out.csv and so on. The data for the dailyplots is taken from the archive table in the database by a select statement anyway The data for the monthly and yearly is taken from the daily summary tables in the database by appropriate queries (select statements) I think On 21 March 2017 at 14:56, Laura Arjona Reina <[email protected]> wrote: > Hi > > El 21/03/17 a las 13:22, Andrew Milner escribió: > >> Can you be more precise? The data used to create a plot is the data from >> the database - can you specify more clearly what you are trying to achieve >> - a csv of the entire database? a csvfile for specific fields? There are >> also a couple of extensions (see the wiki) which create a csv file as >> their >> output. >> >> Thanks for your answer. > I've looked at the csv extension [1] and it seems to provide a way to > store the data that the station is recording, in csv format. > > I've used this line to create a csv from all the data stored in the > database: > > sqlite3 -header -csv weewx.sdb "select * from archive;" > out.csv > > But that's not what I'm looking for. > > The standard report, with the default skin, generates some plots: > > [day|week|month|year]barometer.png > [day|week|month|year]inside.png > [day|week|month|year]radiation.png > [day|week|month|year]rain.png > [day|week|month|year]rx.png > [day|week|month|year]tempchill.png > [day|week|month|year]tempdew.png > [day|week|month|year]uv.png > [day|week|month|year]winddir.png > [day|week|month|year]wind.png > [day|week|month|year]windvec.png > > I would like to provide, together with the png, a txt file with the data > (numbers) that is plotted in that particular png. > > If I go to the sqlite database, I can see some tables that may fit for > some of the plots: > > daybarometer.png -> archive_day_barometer > dayinside.png -> archive_day_inTemp > dayradiation.png -> archive_day_radiation > dayrain.png -> archive_day_rain > dayrx.png -> archive_day_rxCheckPercent > daytempchill.png -> archive_day_windchill > daytempdew.png -> archive_day_dewpoint > dayuv.png -> archive_day_UV > daywinddir.png -> archive_day_windDir > daywind.png -> archive_day_windGust > daywindvec.png -> ?? > > > First, I'm not sure if I did the correspondence correctly. If yes, > providing a csv dump of those tables from the sqlite database would solve > our needs for the "day" graphs, but I still would need to provide similar > data for the "week", "month" and "year" graphs. > > The "monthly" and "yearly" NOAA standard summaries do not resolve our > needs, because they provide temp, rain and wind data, but for example, no > data about radiation. > > I can probably tweak the NOAA templates in order to provide the data that > I need, but I wondered if the data "was already extracted" somewhere (since > it's needed to create the graphs), or if somebody already created such > templates. > > Thanks! > > >> On Tuesday, 21 March 2017 12:02:18 UTC+2, Laura Arjona Reina wrote: >> >> Hi everybody >>> We're happily using weewx since some time in my institution and it works >>> great, thanks! >>> >>> We use the standard report and the default skin to show data and charts >>> in our website. >>> >>> We would like to provide to our visitors with the data used to create >>> each plot, along with the plot itself. Is there an easy way to do this? >>> >>> I've looked at skin.conf ([ImageGenerator] section) but couldn't find >>> anything. >>> >>> Best regards >>> >>> -- >>> Laura Arjona >>> https://wiki.debian.org/LauraArjona >>> >>> >> > -- > Laura Arjona > https://wiki.debian.org/LauraArjona > > -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit https://groups.google.com/d/to > pic/weewx-user/OzwQvzq4tIg/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
