Update ~ 2020-06-03 ~ Spider sqlLite Viewer

[theo-armour]

@mostaphaRoudsari @chriswmackey @AntoineDao @

Spider sqlLite Viewer

• Ajax requests to Honeybee Energy repo on GitHub
• Use sql.js to access data
• Select and display data from sql files
  • Create menu with option list of tables
  • Display contents of table as list
• Button to display number of items in table

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.

[mostaphaRoudsari]

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.

[chriswmackey]

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:

• ReportData (and the ReportDataDictionary that helps make sense of it)
• TabularDataWithStrings (this is actually just a specific view to the TabularData and Strings table)
• ZoneSizes
• ComponentSizes

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:

• 'Zone Ideal Loads Supply Air Total Cooling Energy'
• 'Zone Ideal Loads Supply Air Total Heating Energy'
• 'Zone Lights Electric Energy'
• 'Zone Electric Equipment Electric Energy'

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!

[theo-armour]

@chriswmackey

Thanks for the tips. My efforts today were of little use. Fingers crossed, I can come up with something interesting using your guidelines.