Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question
5

Accessing Detailed Radiance Daylighting Data (WAS:How to open Radout.sql?)

asked 2015-07-16 13:49:55 -0500

Maryam gravatar image

updated 2015-11-08 08:36:27 -0500

Dear all,

I need to get the data regarding daylighting metrics after I run a simulation in Radiance through openstudio. It seems that it is saved in the file 'radout.sql'. However, when I try to open this file through notepad I only see a bunch of mixed fonts and numbers. Anybody has any idea how to fix this?

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted
7

answered 2015-07-16 16:04:39 -0500

updated 2015-07-16 16:31:28 -0500

Dan is right, you need to look at the radout.sql in ResultsViewer or some other SQL viewer. But the illuminance data is also saved in a regular text format. Way down in your project's output directory is this directory:

[your_model]/run/1-Ruby-0/out/files/in/model/radiance/output/ts

In that directory you will find one directory for each space in your model, and in there is an ".ill" file corresponding to the name of your illuminance map for that space. In that ASCII text file is a header explaining the data format, the illuminance map's spatial definition/bounds, and the illuminance data itself, in CSV:

## OpenStudio Daylight Simulation Results file
## Header: xmin ymin z xmax ymin z xmax ymax z xspacing yspacing
## Data: month,day,time,directNormalIllumimance(external),diffuseHorizontalIlluminance(external),daylightSensorIlluminance,pointIlluminance [lux]
0.313154583129337 0.4019080153264 0.762 8.531689383129338 0.4019080153264 0.762 8.531689383129338 8.2589380153264 0.762 0.82185348 0.785703
1,1,01:00:00,0.0,0.0,0.000000000000000e+00,0.000000000000000e+00,0.000000000000000e+00,0.000000000000000e+00,0.000000000000000e+00,...

There is also a file called "merged_space.ill" in the /ts directory which is an ASCII text file where each row is a calculation point in your model, and each column is an hour in the 8,760 (annual hourly) dataset. Issues abound with this guy; first off, the buried location cited above. Next, the data is saved as ASCII. Last, the list of points is not linked with the points' spatial location. You will likely find the individual space illuminance map files more useful for plotting.

edit flag offensive delete link more

Comments

Ok, Thank you very much!

Maryam gravatar imageMaryam ( 2015-07-17 09:53:12 -0500 )edit
4

answered 2015-07-16 14:17:42 -0500

updated 2015-07-28 10:54:40 -0500

The .sql file is not a clear text file. You should be able to open it using the OpenStudio ResultsViewer program.

edit flag offensive delete link more

Comments

Thank you for the answer. However, ResultViewer only has the charts. I need the numbers so I can export them to Excel. So is there any way to view the data in a table or something?

Maryam gravatar imageMaryam ( 2015-07-16 14:54:05 -0500 )edit

OpenStudio does not currently export those results in a text format similar to eplusmap.csv. We are currently reformatting the results to a new clear text format but that will not be ready until version 1.9.0.

macumber gravatar imagemacumber ( 2015-07-16 15:00:21 -0500 )edit

Depending on how comfortable you are with OpenStudio scripting you could use the SqlFile class to access the illuminance map data in the radout.sql file.

macumber gravatar imagemacumber ( 2015-07-16 15:03:03 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

 



Question Tools

Stats

Asked: 2015-07-16 13:49:55 -0500

Seen: 397 times

Last updated: Jul 28 '15