Building Colors

../_images/example1.png

 

Introduction

You can easily change the color of any building inside Sandbox by selecting a building and choosing a color from presets or entering your own RGB or HEX values. It is also possible to change the color of buildings with datasets, useful for visualizing energy consumption or other datapoints related to a building mass over time.

Building ID

To find the building ID (UUID) in Sandbox, click the building and read its output ports in the Properties Panel. The building ID is used in the dataset to identify a building:

../_images/example2.png

Formatting a CSV dataset

In a dataset, buildings can be colored using a gradient between blue and red, where blue is 0 and red is 1. For example, a CSV file with the following entry would color a building blue on June 1st at midnight, and red on July 1st at midnight:

1building_id,Date/Time,Value
2Building_178914308,2024-06-01 00:00:00,0.00
3Building_178914308,2024-07-01 00:00:00,1.00

Color gradient

Use the following gradient as a reference for available colors:

../_images/gradient.png

Use any decimal value between 0 and 1 to select a color between blue and red.

Uploading Datasets

After a dataset is created, upload the dataset in the Datasets section in the Asset Library. Make sure Building Color (CSV) is selected as Type:

../_images/upload1.png

Press the Submit button to upload the dataset.

Loading Dataset in Sandbox

Once the dataset is uploaded, go back to the Dashboard and reconnect to your session. The dataset needs to be loaded into Sandbox by pressing the reload button in the Local Data section. After the data is loaded, the data shows up under analysis:

../_images/local1.png

  1. Click analysis, then buildings. The datasets will then be shown:

    datasets

  2. Click on the desired dataset, then click value .

  3. Lastly, click the building colors icon as shown below to finish loading the dataset.

    ../_images/icon.png

Enabling Dataset in data-view

Once the dataset is loaded in Sandbox, it must be enable it in the Data View. Find the Building color section and press the toggle button for the newly uploaded dataset:

../_images/dataview.png

Video Tutorial

Learn how to:

  • Find the ID of a building for use in a dataset

  • Upload sample datasets to Sandbox

  • Load sample datasets in Local Data

  • Enable the dataset in the Data View

  • Visualize the dataset in the Timeline

Sample Dataset Files

Single Building

Below is an example of a single building going through a different color each day. Each day represents a 0.03 increase, starting at 0 and ending at 1.0.

Download example file: https://docs.osc.no/wp-content/uploads/2025/05/buildings_example_single.csv

 1building_id,Date/Time,Value
 2Building_178914308,2024-06-01 00:00:00,0.00
 3Building_178914308,2024-06-02 00:00:00,0.03
 4Building_178914308,2024-06-03 00:00:00,0.06
 5Building_178914308,2024-06-04 00:00:00,0.09
 6Building_178914308,2024-06-05 00:00:00,0.12
 7Building_178914308,2024-06-06 00:00:00,0.15
 8Building_178914308,2024-06-07 00:00:00,0.18
 9Building_178914308,2024-06-08 00:00:00,0.21
10Building_178914308,2024-06-09 00:00:00,0.24
11Building_178914308,2024-06-10 00:00:00,0.27
12Building_178914308,2024-06-11 00:00:00,0.30
13Building_178914308,2024-06-12 00:00:00,0.33
14Building_178914308,2024-06-13 00:00:00,0.39
15Building_178914308,2024-06-14 00:00:00,0.42
16Building_178914308,2024-06-15 00:00:00,0.45
17Building_178914308,2024-06-16 00:00:00,0.48
18Building_178914308,2024-06-17 00:00:00,0.51
19Building_178914308,2024-06-18 00:00:00,0.54
20Building_178914308,2024-06-19 00:00:00,0.57
21Building_178914308,2024-06-20 00:00:00,0.60
22Building_178914308,2024-06-21 00:00:00,0.63
23Building_178914308,2024-06-22 00:00:00,0.66
24Building_178914308,2024-06-23 00:00:00,0.69
25Building_178914308,2024-06-24 00:00:00,0.72
26Building_178914308,2024-06-25 00:00:00,0.75
27Building_178914308,2024-06-26 00:00:00,0.78
28Building_178914308,2024-06-27 00:00:00,0.81
29Building_178914308,2024-06-28 00:00:00,0.84
30Building_178914308,2024-06-29 00:00:00,0.87
31Building_178914308,2024-06-30 00:00:00,0.90
32Building_178914308,2024-07-01 00:00:00,0.93
33Building_178914308,2024-07-02 00:00:00,0.96
34Building_178914308,2024-07-03 00:00:00,0.99
35Building_178914308,2024-07-04 00:00:00,1.00

Multiple Buildings

Below is an example on how to change multiple buildings in a single CSV file. The buildings use starting values that are offset by a value of 0.10.

Download CSV

  1building_id,Date/Time,Value
  2Building_178916505,2024-06-01 00:00:00,0.00
  3Building_178916505,2024-06-02 00:00:00,0.11
  4Building_178916505,2024-06-03 00:00:00,0.12
  5Building_178916505,2024-06-04 00:00:00,0.30
  6Building_178916505,2024-06-05 00:00:00,0.40
  7Building_178916505,2024-06-06 00:00:00,0.50
  8Building_178916505,2024-06-07 00:00:00,0.60
  9Building_178916505,2024-06-08 00:00:00,0.70
 10Building_178916505,2024-06-09 00:00:00,0.80
 11Building_178916505,2024-06-10 00:00:00,0.90
 12Building_178916505,2024-06-11 00:00:00,1.00
 13Building_178916505,2024-06-12 00:00:00,1.00
 14Building_19989445,2024-06-01 00:00:00,0.10
 15Building_19989445,2024-06-02 00:00:00,0.20
 16Building_19989445,2024-06-03 00:00:00,0.30
 17Building_19989445,2024-06-04 00:00:00,0.40
 18Building_19989445,2024-06-05 00:00:00,0.50
 19Building_19989445,2024-06-06 00:00:00,0.60
 20Building_19989445,2024-06-07 00:00:00,0.70
 21Building_19989445,2024-06-08 00:00:00,0.80
 22Building_19989445,2024-06-09 00:00:00,0.90
 23Building_19989445,2024-06-10 00:00:00,1.00
 24Building_19989445,2024-06-11 00:00:00,0.00
 25Building_19989445,2024-06-12 00:00:00,0.00
 26Building_178916491,2024-06-01 00:00:00,0.20
 27Building_178916491,2024-06-02 00:00:00,0.30
 28Building_178916491,2024-06-03 00:00:00,0.40
 29Building_178916491,2024-06-04 00:00:00,0.50
 30Building_178916491,2024-06-05 00:00:00,0.60
 31Building_178916491,2024-06-06 00:00:00,0.70
 32Building_178916491,2024-06-07 00:00:00,0.80
 33Building_178916491,2024-06-08 00:00:00,0.90
 34Building_178916491,2024-06-09 00:00:00,1.00
 35Building_178916491,2024-06-10 00:00:00,0.00
 36Building_178916491,2024-06-11 00:00:00,0.10
 37Building_178916491,2024-06-12 00:00:00,0.10
 38Building_178916297,2024-06-01 00:00:00,0.30
 39Building_178916297,2024-06-02 00:00:00,0.40
 40Building_178916297,2024-06-03 00:00:00,0.50
 41Building_178916297,2024-06-04 00:00:00,0.60
 42Building_178916297,2024-06-05 00:00:00,0.70
 43Building_178916297,2024-06-06 00:00:00,0.80
 44Building_178916297,2024-06-07 00:00:00,0.90
 45Building_178916297,2024-06-08 00:00:00,1.00
 46Building_178916297,2024-06-09 00:00:00,0.00
 47Building_178916297,2024-06-10 00:00:00,0.10
 48Building_178916297,2024-06-11 00:00:00,0.20
 49Building_178916297,2024-06-12 00:00:00,0.20
 50Building_178916289,2024-06-01 00:00:00,0.40
 51Building_178916289,2024-06-02 00:00:00,0.50
 52Building_178916289,2024-06-03 00:00:00,0.60
 53Building_178916289,2024-06-04 00:00:00,0.70
 54Building_178916289,2024-06-05 00:00:00,0.80
 55Building_178916289,2024-06-06 00:00:00,0.90
 56Building_178916289,2024-06-07 00:00:00,1.00
 57Building_178916289,2024-06-08 00:00:00,0.00
 58Building_178916289,2024-06-09 00:00:00,0.10
 59Building_178916289,2024-06-10 00:00:00,0.20
 60Building_178916289,2024-06-11 00:00:00,0.30
 61Building_178916289,2024-06-12 00:00:00,0.30
 62Building_10146380,2024-06-01 00:00:00,0.50
 63Building_10146380,2024-06-02 00:00:00,0.60
 64Building_10146380,2024-06-03 00:00:00,0.70
 65Building_10146380,2024-06-04 00:00:00,0.80
 66Building_10146380,2024-06-05 00:00:00,0.90
 67Building_10146380,2024-06-06 00:00:00,1.00
 68Building_10146380,2024-06-07 00:00:00,0.00
 69Building_10146380,2024-06-08 00:00:00,0.10
 70Building_10146380,2024-06-09 00:00:00,0.20
 71Building_10146380,2024-06-10 00:00:00,0.30
 72Building_10146380,2024-06-11 00:00:00,0.40
 73Building_10146380,2024-06-12 00:00:00,0.40
 74Building_178916254,2024-06-01 00:00:00,0.50
 75Building_178916254,2024-06-02 00:00:00,0.60
 76Building_178916254,2024-06-03 00:00:00,0.70
 77Building_178916254,2024-06-04 00:00:00,0.80
 78Building_178916254,2024-06-05 00:00:00,0.90
 79Building_178916254,2024-06-06 00:00:00,1.00
 80Building_178916254,2024-06-07 00:00:00,0.00
 81Building_178916254,2024-06-08 00:00:00,0.10
 82Building_178916254,2024-06-09 00:00:00,0.20
 83Building_178916254,2024-06-10 00:00:00,0.30
 84Building_178916254,2024-06-11 00:00:00,0.40
 85Building_178916254,2024-06-12 00:00:00,0.40
 86Building_178916262,2024-06-01 00:00:00,0.60
 87Building_178916262,2024-06-02 00:00:00,0.70
 88Building_178916262,2024-06-03 00:00:00,0.80
 89Building_178916262,2024-06-04 00:00:00,0.90
 90Building_178916262,2024-06-05 00:00:00,1.00
 91Building_178916262,2024-06-06 00:00:00,0.00
 92Building_178916262,2024-06-07 00:00:00,0.10
 93Building_178916262,2024-06-08 00:00:00,0.20
 94Building_178916262,2024-06-09 00:00:00,0.30
 95Building_178916262,2024-06-10 00:00:00,0.40
 96Building_178916262,2024-06-11 00:00:00,0.50
 97Building_178916262,2024-06-12 00:00:00,0.50
 98Building_10134331,2024-06-01 00:00:00,0.70
 99Building_10134331,2024-06-02 00:00:00,0.80
100Building_10134331,2024-06-03 00:00:00,0.90
101Building_10134331,2024-06-04 00:00:00,1.00
102Building_10134331,2024-06-05 00:00:00,0.00
103Building_10134331,2024-06-06 00:00:00,0.10
104Building_10134331,2024-06-07 00:00:00,0.20
105Building_10134331,2024-06-08 00:00:00,0.30
106Building_10134331,2024-06-09 00:00:00,0.40
107Building_10134331,2024-06-10 00:00:00,0.50
108Building_10134331,2024-06-11 00:00:00,0.60
109Building_10134331,2024-06-12 00:00:00,0.60
110Building_10134358,2024-06-01 00:00:00,0.80
111Building_10134358,2024-06-02 00:00:00,0.90
112Building_10134358,2024-06-03 00:00:00,1.00
113Building_10134358,2024-06-04 00:00:00,0.00
114Building_10134358,2024-06-05 00:00:00,0.10
115Building_10134358,2024-06-06 00:00:00,0.20
116Building_10134358,2024-06-07 00:00:00,0.30
117Building_10134358,2024-06-08 00:00:00,0.40
118Building_10134358,2024-06-09 00:00:00,0.50
119Building_10134358,2024-06-10 00:00:00,0.60
120Building_10134358,2024-06-11 00:00:00,0.70
121Building_10134358,2024-06-12 00:00:00,0.70
122Building_10143527,2024-06-01 00:00:00,0.90
123Building_10143527,2024-06-02 00:00:00,1.00
124Building_10143527,2024-06-03 00:00:00,0.00
125Building_10143527,2024-06-04 00:00:00,0.10
126Building_10143527,2024-06-05 00:00:00,0.20
127Building_10143527,2024-06-06 00:00:00,0.30
128Building_10143527,2024-06-07 00:00:00,0.40
129Building_10143527,2024-06-08 00:00:00,0.50
130Building_10143527,2024-06-09 00:00:00,0.60
131Building_10143527,2024-06-10 00:00:00,0.70
132Building_10143527,2024-06-11 00:00:00,0.80
133Building_10143527,2024-06-12 00:00:00,0.80
134Building_19984923,2024-06-01 00:00:00,1.00
135Building_19984923,2024-06-02 00:00:00,0.00
136Building_19984923,2024-06-03 00:00:00,0.10
137Building_19984923,2024-06-04 00:00:00,0.20
138Building_19984923,2024-06-05 00:00:00,0.30
139Building_19984923,2024-06-06 00:00:00,0.40
140Building_19984923,2024-06-07 00:00:00,0.50
141Building_19984923,2024-06-08 00:00:00,0.60
142Building_19984923,2024-06-09 00:00:00,0.70
143Building_19984923,2024-06-10 00:00:00,0.80
144Building_19984923,2024-06-11 00:00:00,0.90
145Building_19984923,2024-06-12 00:00:00,0.90