Open theo-armour opened 4 years ago
This is pretty awesome @theo-armour! @chriswmackey, should be able to help with the tables and some of the interesting queries that we can make for results visualization.
Thanks for putting this together so quickly @theo-armour . I totally hear you about these database files being much easier to use than expected. I'll admit that I was afraid to engage with the EnergyPlus sql output for years but I feel dumb now that I see how easy they made it for us.
To give you some guidance on the most useful things in the file, I should preface by saying most tables in the file do not contain particularly useful information. I have to imagine they are there because some E+ contributor or developer wanted a specific table for troubleshooting or recording the data they were interested in. In fact, all of the data that I currently import with the Grasshopper plugin comes from just ~4 tables:
I would recommend starting with the first one (ReportData), which contains all of the timeseries simulation results for each Room in the model. This particular model has 7 Rooms/Zones so you will find 7 lists of hourly data for each simulation output that was requested. In that particular sqlite file you are using for testing, I think I requested the following outputs:
You can see the sql queries that I used to extract these lists of timeseries data in this Python code here. The output_name
is one of the 4 strings above.
Hope that helps and thanks again!
@chriswmackey
Thanks for the tips. My efforts today were of little use. Fingers crossed, I can come up with something interesting using your guidelines.
@mostaphaRoudsari @chriswmackey @AntoineDao @
Spider sqlLite Viewer
After over thirty years of doing whatever it takes to avoid databases, here I am being dragged kicking and screaming into the tables. Thank goodness I waited. The required skill level has now dropped down to my designer-who-uses-code-but-is-not-a-programmer level of abilities.
I seem to have some basic thing that seems to be running. There are lots of tables and I have few clues as to what they for. I do see the occasional table with possibly interesting things - "Surfaces" see to be one. Also there is a ,CSV file with lots of numbers.
I will be playing with reading and visualizing these numbers in 3D the next few updates
Separately there were a lot of updates to the several viewers today. More about these effoets another day.