Data Visualization of Pittsburgh’s Municipal Building Energy Usage

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

Image

Photo by Dan Chmill, via Flickr creative commons.

Energy Dashboard metrics for Pittsburgh Municipal buildings

Today we get our hands busy analysing data from Pittsburgh Open data. Few months ago we did Chicago wifi usage visualization and this is our first attempt analysing our own city data.

The very first thing we notice is that there is a metric “Energy Cost in Dollars” and seems very easy to understand so we plotted it against each year.

Energy Cost for Pittsburgh municipal buildings over the years

Reduced Energy Cost by 1 million dollars

Image

This one chart tells a very interesting fact, the buildings collectively reduced the Energy cost by 31.8% in 2014 as compared to the cost of energy in 2009. We don’t know if the buildings are being run more efficiently or the cost of energy has reduced from 2009 onwards. Either that or the usage of energy has gone down. At any rate it is a very interesting data piece. The cost reduction is close to one million dollars in 2014 alone compared to the cost in 2009. That is a significant savings.

We then plot couple of other metrics using the same bar charts but in the end we built a dynamic interactive dashboard so users can easily pick whatever metric and year as selections.

The Total Annual Consumption Of Natural Gas In KBtu For All Pittsburgh Municipal Buildings

Image

The Total Annual Consumption Of Natural Gas In Therms For All Pittsburgh Municipal Buildings

Image

And finally a treemap showing the top 30 municipal buildings by each metric

Image

Interactive Dashboard for Pittsburgh Building Energy Metrics

Image

In the above live dashboard, you can select the year and on the left there is a list of metrics. Selecting the metric will dynamically update the bar chart and the treemap below.

 

Energy meta-data

Data Source : https://data.wprdc.org/dataset/municipal-building-energy-usage

Organization: City of Pittsburgh
Group/Topic: Energy
Department: Department of Innovation & Performance

Data Notes: Data stored and reports generated in Portfolio Manager. Some data is unavailable, to be remedied if possible. Available data is accurate, verified by utility bills.

Data Steward Name: Ariel Lattanzi

Site EUI (kBtu/ft²)

Energy Use Intensity of the site: total energy consumed by the building in one year (measured in kBtu or GJ), divided by the total gross floor area of the building

Weather Normalized Site EUI (kBtu/ft²)

The amount of energy the building would have consumed in one year under 30-average weather conditions (also called climate normals), divided by the total gross floor area of the building. (This enables building performance comparison over time, despite unusual weather events)

Source EUI (kBtu/ft²)

Energy Use Intensity of the source: the total amount of raw fuel that is required to operate the building for one year (including all transmission, delivery, and production losses), divided by the total gross floor area of the building

Weather Normalized Source EUI (kBtu/ft²)

The amount of raw fuel that would have been required to operate the building for one year under 30-average weather conditions (also called climate normals), divided by the total gross floor area of the building. (This enables building performance comparison over time, despite unusual weather events)

Electricity Use – Grid Purchase (kBtu)

The total annual consumption of grid-purchased electricity in kBtu

Electricity Use – Grid Purchase (kWh)

The total annual consumption of grid-purchased electricity in kWh

Weather Normalized Site Electricity (kWh)

The amount of electricity the building would have consumed that year if weather had been climate normal

Natural Gas Use (kBtu)

The total annual consumption of natural gas in kBtu

Natural Gas Use (therms)

The total annual consumption of natural gas in therms

Weather Normalized Site Natural Gas Use (therms)

The amount of natural gas the building would have consumed that year if weather had been climate normal

District Steam Use (kBtu)

The total annual consumption of district steam in kBtu

Total GHG Emissions (Metric Tons CO2e)

The total annual greenhouse gas emissions due to building operations as calculated by Portfolio Manager (which accounts for the carbon dioxide, methane, and nitrous oxide emissions from on-site fuel combustion and purchased electricity and district heating and cooling)

Total GHG Emissions Intensity (kgCO2e/ft²)

The total annual greenhouse gas emissions due to building operations as calculated by Portfolio Manager, divided by the total gross floor area of the building

Energy Cost ($)

The total annual cost of energy for the building

Energy Cost Intensity ($/ft²)

The total annual cost of energy for the building, divided by the total gross floor area of the building

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH