Question-and-Answer Resource for the Building Energy Modeling Community
Get s tarted with the Help page

# Revision history [back]

I can help you get into the Sqlite files. On free tool in windows is "sqlitebrowser" which can be installed here: https://sqlitebrowser.org/dl/. There are other database IDE's (Dbeaver being another good one) but if you just need sqlite3 browsing this should work.

Now an incomplete summary of the Sqlite structure is shown in the next 3 images:

Table Structure of the SQLITE Outputs:

Data Elements of the Meters that are outputs as reports:

The location of the observations for each meter:

Now for an example, if you wanted to return all of the results of "Electricity:Building" for each run period you could use the following query in the "Execute Query" tab. To return all results remove the final line "Limit 500" or comment it our with two dashes before the line "--".

Select t.*,RMD.VariableValue
from ReportMeterData RMD
join time t on t.TimeIndex=RMD.TimeIndex