About SMARTSPACES – Open Data

These pages are provided to help you to access and reuse our building energy data which you can access through the Open Data Query page. Developers can also access it through the SMARTSPACES Application Programming Interface.

Please contact Digital Birmingham if you have any queries on the use of this data   

Quality

How we collect this data

The data on this site is derived from half hourly data collections made on behalf of Birmingham City Council by Stark Software International Limited, who are an Elexon accredited electricity Half Hourly and Non Half Hourly Data Collector, Data Aggregator and an ASPCoP accredited gas meter reader.

What we publish

Birmingham City Council will publish nine data files each day which will provide half-hourly consumption data for the previous 24-hour period.  For each of three buildings – The Council House, Margaret Street (Council House Extension) and Birmingham Museum & Art Gallery, we will publish a separate file for each of the utilities:

  • Gas & Heat
  • Electricity
  • Water

Data Accuracy

Historically, these three buildings were linked together as a single complex and as a result of the legacy systems on site; some metering points cover more than one building.  Where this is the case, the meter's consumption data has had to be apportioned on 60:40 ratio split in favour of the larger building with the higher occupation rates.  This has been done using best endeavours for accuracy however; this can only ever be an approximation.

Documentation

Each CSV file represents a day's worth (24-hour period) of data for a particular building and utility.  The data consists of:

  • Company Name – this will always be ‘Birmingham City Council'
  • Site Name – this will be one of three sites: Council House, Margaret Street (Council House Extension) and Birmingham Museum & Art Gallery
  • Type – this will be the type of unit being measured, e.g. KW/h
  • Date – the date of the reading in ‘dd/mm/yy' format
  • Time – this will be the time the reading was taken, using the 24-hour clock format
  • Data – This will be the amount of units consumed, as indicated in type, for the 30 minutes previous to the time detailed.

When consuming the API, most methods require a Start Date, End Date and a Site ID.  A full list of SIte ID's can be obtained by requesting the method "General/GetSiteInformation".  This would need to take the form of:

http://data.energysmartbirmingham.com/api/General/GetSiteInformation

Once the Site ID has been found, you can then pass this response into any one of the other methods where Energy Data is returned.

An example of this would be:

http://data.energysmartbirmingham.com/api/Utility/GetElectric?startDate=01-11-2014&endDate=8-11-2014&siteId=1

This would return data as follows:

Start Date: 01/11/2014
End Date: 08/11/214
Site ID: 1
Site Name: Penns Primary School

Tools

There are a number of free tools that are available to help you make use of CSV files.  In particular, Open Refine (formerly Google Refine) is very good for cleaning up and manipulating raw data.  However, if you prefer to make something more visual then you could try the free version of Tableau.

License

The data on this site is provided under an Open Government Licence.

When you use this information under the Open Government Licence, you should include the following attribution:

"Public Buildings Energy Consumption, Birmingham City Council, [insert current year], licensed under the Open Government Licence [http://www.nationalarchives.gov.uk/doc/open-government-licence/version/2/]".

Privacy

The data contained in these files includes utilities metering records for public buildings and as such contains no personal information.

We have successfully self-certified the open data we publish on this site to Raw level, using Open Data Certificates from the Open Data Institute

 

 

   

 

Login