Difference between revisions of "Charge Metrics Proposal"
Srchua.2015 (talk | contribs) (→Data) |
Srchua.2015 (talk | contribs) |
||
(36 intermediate revisions by 2 users not shown) | |||
Line 2: | Line 2: | ||
<!--Header--> | <!--Header--> | ||
{|style="background-color:#000000; color:#ffcc33; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | {|style="background-color:#000000; color:#ffcc33; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
− | | style="padding:0em; font-size:100%; background-color:# | + | | style="padding:0em; font-size:100%; background-color:#ffcc33; border-bottom:5px solid #ffcc33; text-align:center; color:#000000" width="10%" | [[Charge_Metrics_Proposal| |
− | |||
− | |||
− | |||
− | |||
<font color="#000000" size=2><b>PROPOSAL</b></font>]] | <font color="#000000" size=2><b>PROPOSAL</b></font>]] | ||
Line 21: | Line 17: | ||
| style="padding:0em; font-size:100%; background-color:#000000; border-bottom:5px solid #ffcc33; text-align:center; color:#000000" width="10%" | [[Charge_Metrics_Research_Paper| | | style="padding:0em; font-size:100%; background-color:#000000; border-bottom:5px solid #ffcc33; text-align:center; color:#000000" width="10%" | [[Charge_Metrics_Research_Paper| | ||
<font color="#ffcc33" size=2><b>RESEARCH PAPER</b></font>]] | <font color="#ffcc33" size=2><b>RESEARCH PAPER</b></font>]] | ||
+ | |||
+ | | style="background:none; border-bottom:5px solid #ffcc33;" width="1%" | | ||
+ | | style="padding:0em; font-size:100%; background-color:#000000; border-bottom:5px solid #ffcc33; text-align:center; color:#000000" width="10%" | [[Project_Groups| | ||
+ | <font color="#ffcc33" size=2><b>OTHER GROUPS</b></font>]] | ||
|} | |} | ||
<br> | <br> | ||
Line 30: | Line 30: | ||
<!-- END MOTIVATION --> | <!-- END MOTIVATION --> | ||
− | Household electricity consumption in Singapore has increased by about 17% over the past decade, according to a report by the National Environment Agency in May 2018. On aggregate levels, Singapore households consumed 7,295 GWh (gigawatt hours) in 2017, which roughly translates to an average expenditure of $1,000 a year on electricity per household. <br> | + | Household electricity consumption in Singapore has increased by about 17% over the past decade, according to a report by the National Environment Agency in May 2018. On aggregate levels, Singapore households consumed 7,295 GWh (gigawatt hours) in 2017, which roughly translates to an average expenditure of $1,000 a year on electricity per household. [1] <br> |
− | Electricity consumption is a national issue, especially given that Singapore | + | Electricity consumption is a national issue, especially given that about 95% of Singapore's electricity supply is imported. [2] It is therefore important to encourage households to consume electricity in more sustainable ways. <br> |
− | Traditionally, the lack of transparency surrounding electricity use has been acknowledged as a possible challenge in raising awareness on electricity consumption. Improving visualisation of household electricity consumption can help people in Singapore gain better clarity of their consumption habits and expenditure, and thus more incentive to reduce electricity usage. <br> | + | Traditionally, the lack of transparency surrounding electricity use has been acknowledged as a possible challenge in raising awareness on electricity consumption. [3] Improving visualisation of household electricity consumption can help people in Singapore gain better clarity of their consumption habits and expenditure, and thus more incentive to reduce electricity usage. [3] <br> |
Our project visualises the distribution of household electricity consumption across planning regions in Singapore, accounting for type of residential homes, income and demographic profiles. We aim to better communicate electricity consumption in everyday life to people in Singapore, and ultimately engage them to reduce electricity consumption. | Our project visualises the distribution of household electricity consumption across planning regions in Singapore, accounting for type of residential homes, income and demographic profiles. We aim to better communicate electricity consumption in everyday life to people in Singapore, and ultimately engage them to reduce electricity consumption. | ||
Line 57: | Line 57: | ||
! style="font-weight: bold;background: #000000;color:#ffcc33;width: 30%;" | Datasets | ! style="font-weight: bold;background: #000000;color:#ffcc33;width: 30%;" | Datasets | ||
! style="font-weight: bold;background: #000000;color:#ffcc33;width: 15%" | Data Attributes | ! style="font-weight: bold;background: #000000;color:#ffcc33;width: 15%" | Data Attributes | ||
− | ! style="font-weight: bold;background: #000000;color:#ffcc33;" | Rationale | + | ! style="font-weight: bold;background: #000000;color:#ffcc33;" | Rationale of Usage |
|- | |- | ||
− | | <center>EMA Household Energy Consumption<br/></center> | + | | <center>'''EMA Household Energy Consumption'''<br/></center> |
[[File:Datasource1.png|center|500px]] | [[File:Datasource1.png|center|500px]] | ||
− | <center>Source: https://www.ema.gov.sg/ | + | <center>'''Source''': https://www.ema.gov.sg/statistic.aspx?sta_sid=20140617E32XNb1d0Iqa </center> |
|| | || | ||
* Postal Code | * Postal Code | ||
Line 68: | Line 68: | ||
* Electricity Consumption | * Electricity Consumption | ||
|| | || | ||
− | + | This dataset contains granular data on average household monthly electricity consumption by postal code for each type of housing between 2013 to 2016. | |
− | + | |- | |
− | + | | <center>'''Average Monthly Household Electricity Consumption by Dwelling Type, 2005-2017'''<br/> | |
+ | [[File:Avg by dwelling type, 2005 to 2017.png|500px|center]] | ||
+ | '''Source''': https://www.ema.gov.sg/statistic.aspx?sta_sid=20140617E32XNb1d0Iqa </center> | ||
+ | || | ||
+ | * Type of Dwelling | ||
+ | * Average Monthly Electricity Consumption (in kWh) | ||
+ | * Date (mmm-yyyy) | ||
+ | || | ||
+ | This dataset will be used to visualise the overall historical trend of monthly average household electricity consumption in Singapore from 2005 to 2017. | ||
|- | |- | ||
− | | <center>Singapore Residents by Planning Area and Type of Dwelling, 2000 - 2017<br/> | + | | <center>'''Singapore Residents by Planning Area and Type of Dwelling, 2000 - 2017'''<br/> |
[[File:Datasource2.png|center|500px]] | [[File:Datasource2.png|center|500px]] | ||
− | Source: https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data</center> | + | '''Source''': https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data</center> |
|| | || | ||
* Planning Area | * Planning Area | ||
Line 82: | Line 90: | ||
|| | || | ||
This dataset is used to complement the main dataset by providing detailed information about the number of Singapore residents in each planning area, according to dwelling type. | This dataset is used to complement the main dataset by providing detailed information about the number of Singapore residents in each planning area, according to dwelling type. | ||
+ | |||
+ | |||
|- | |- | ||
− | | <center>HDB Property Information<br/> | + | | <center>'''HDB Property Information'''<br/> |
[[File:Datasource3.png|center|500px]] | [[File:Datasource3.png|center|500px]] | ||
− | Source: https://data.gov.sg/dataset/hdb-property-information</center> | + | '''Source''': https://data.gov.sg/dataset/hdb-property-information</center> |
|| | || | ||
* Block Number | * Block Number | ||
Line 99: | Line 109: | ||
* Number of Executive Condominiums Sold | * Number of Executive Condominiums Sold | ||
|| | || | ||
− | This dataset provides a comprehensive record of Singapore HDB Property Information | + | This dataset provides a comprehensive record of Singapore HDB Property Information, and enables us to scale the average electricity consumption by the number of units for the given dwelling type for the block. |
|- | |- | ||
− | | <center>Private Apartment Information<br/> | + | | <center>'''Private Apartment Information'''<br/> |
[[File:Datasource5.png|center|500px]] | [[File:Datasource5.png|center|500px]] | ||
− | Source: Real Estate Information System</center> | + | '''Source''': Real Estate Information System</center> |
|| | || | ||
* Block Number | * Block Number | ||
Line 117: | Line 127: | ||
|| | || | ||
− | + | This dataset will be a complementary dataset for private housing types by providing information on the number of units. | |
|- | |- | ||
− | | <center>List of Postal Districts <br/> | + | | <center>'''List of Postal Districts'''<br/> |
[[File:Datasource4.png|center|500px]] | [[File:Datasource4.png|center|500px]] | ||
− | Source: https://www.ura.gov.sg/realEstateIIWeb/resources/misc/list_of_postal_districts.htm</center> | + | '''Source''': https://www.ura.gov.sg/realEstateIIWeb/resources/misc/list_of_postal_districts.htm</center> |
|| | || | ||
* Postal District | * Postal District | ||
Line 128: | Line 138: | ||
|| | || | ||
− | + | This dataset is used to map the postal sector, also the first two digits of the postal code, to the corresponding postal district. | |
|} | |} | ||
Line 158: | Line 168: | ||
<p><center> '''Source''': http://cs109-energy.github.io/building-energy-consumption-prediction.html </center> </p> | <p><center> '''Source''': http://cs109-energy.github.io/building-energy-consumption-prediction.html </center> </p> | ||
|| | || | ||
− | * Calendar view map allows the user to view the daily | + | * Calendar view map allows the user to view the daily pattern of energy consumption, and detect any hourly patterns easily, if present. |
* Provide multiple possible machine learning models for the prediction on energy consumption. | * Provide multiple possible machine learning models for the prediction on energy consumption. | ||
− | * Direct illustration of graphs and models on python Jupyter notebook for effective | + | * Direct illustration of graphs and models on python Jupyter notebook for effective reproducible communication. |
|- | |- | ||
− | | <p><center> ''' | + | | <p><center> '''Visualising Energy Consumption in Philadelphia''' </center></p> |
[[File:ChargeMetrics Related3.png|400px|center]] | [[File:ChargeMetrics Related3.png|400px|center]] | ||
<p><center> '''Source''': http://www.kennethelder.com/visualizing-energy-consumption-in-philadelphia/ </center></p> | <p><center> '''Source''': http://www.kennethelder.com/visualizing-energy-consumption-in-philadelphia/ </center></p> | ||
Line 172: | Line 182: | ||
|- | |- | ||
− | | <p><center> ''' | + | | <p><center> '''Visualising U.S. Energy Consumption in One Chart''' </center></p> |
[[File:ChargeMetrics Related4.png|400px|center]] | [[File:ChargeMetrics Related4.png|400px|center]] | ||
<p><center> '''Source''': http://www.visualcapitalist.com/visualizing-u-s-energy-consumption-one-chart/ </center></p> | <p><center> '''Source''': http://www.visualcapitalist.com/visualizing-u-s-energy-consumption-one-chart/ </center></p> | ||
|| | || | ||
− | * | + | * Clear overview of how different energy sources are used and classified |
− | * | + | * Good usage of colours to clearly illustrate individual flow of the energy source |
|} | |} | ||
Line 185: | Line 195: | ||
==<div style="margin-top: 6px;font-weight:bold;text-align: left;font-size:20px; border-bottom:5px solid #ffcc33;text-align:center; background-color: #000000; color: #ffcc33; padding: 2px; font-family:sans-serif;">Prototype</div>== | ==<div style="margin-top: 6px;font-weight:bold;text-align: left;font-size:20px; border-bottom:5px solid #ffcc33;text-align:center; background-color: #000000; color: #ffcc33; padding: 2px; font-family:sans-serif;">Prototype</div>== | ||
− | + | ===Iteration 1=== | |
===Landing Page=== | ===Landing Page=== | ||
<center> [[File: Chargemetrics Prototype.jpg|800px|Prototype 1]] </center> <br /> | <center> [[File: Chargemetrics Prototype.jpg|800px|Prototype 1]] </center> <br /> | ||
[1]Logo <br /> | [1]Logo <br /> | ||
− | [2]Bivariate | + | [2]Bivariate Choropleth Map<br /> |
[3]Filter <br /> | [3]Filter <br /> | ||
[4]Button to Historical Trend Page<br /> | [4]Button to Historical Trend Page<br /> | ||
Line 205: | Line 215: | ||
<!-- END PROTOTYPE --> | <!-- END PROTOTYPE --> | ||
+ | |||
+ | <!-- START Application Architecture --> | ||
+ | ==<div style="margin-top: 6px;font-weight:bold;text-align: left;font-size:20px; border-bottom:5px solid #ffcc33;text-align:center; background-color: #000000; color: #ffcc33; padding: 2px;font-family:sans-serif;">Application Architecture</div>== | ||
+ | |||
+ | [[File:aass.jpg|500px|center|ChargeMetrics_Timeline]] | ||
+ | |||
+ | <!-- END Application Architecture --> | ||
<!-- START Project Schedules --> | <!-- START Project Schedules --> | ||
Line 211: | Line 228: | ||
− | [[File: | + | [[File:ChargeMetrics_Timeline2.jpg|1000px|center|ChargeMetrics_Timeline]] |
Project Schedule on Google Sheet:https://docs.google.com/spreadsheets/d/1IlT3Na8Ujlv9izY-0PWvCWEWzfqOmzq3jGHIbWCDiwk/edit?usp=sharing | Project Schedule on Google Sheet:https://docs.google.com/spreadsheets/d/1IlT3Na8Ujlv9izY-0PWvCWEWzfqOmzq3jGHIbWCDiwk/edit?usp=sharing | ||
− | |||
Line 259: | Line 275: | ||
− | [1] Energy Market Authority (https://www.ema.gov.sg/singapore_energy_statistics.aspx) <br /> | + | [1] The Straits Times (https://www.straitstimes.com/singapore/singapores-household-electricity-consumption-up-17-per-cent-over-past-decade) <br /> |
− | [ | + | [2] Energy Market Authority (https://www.ema.gov.sg/electricity_market_overview.aspx) <br /> |
− | [ | + | [3] National Center for Biotechnology Information (https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4746293/) <br /> |
− | [ | + | [4] Energy Market Authority (https://www.ema.gov.sg/singapore_energy_statistics.aspx) <br /> |
− | [ | + | [5] Data.gov Database (https://data.gov.sg) <br /> |
− | [ | + | [6] D3.js (Documentation https://d3js.org/) <br /> |
+ | [7] Observale (https://beta.observablehq.com/) <br /> | ||
+ | [8] OneMap (https://www.onemap.sg/main/v2/) <br /> | ||
+ | [9] Prediction of Buildings Energy Consumption (http://cs109-energy.github.io/building-energy-consumption-prediction.html) <br /> | ||
<!-- END References --> | <!-- END References --> | ||
Line 270: | Line 289: | ||
<!-- START Feedback --> | <!-- START Feedback --> | ||
− | ==<div style="margin-top: 6px;font-weight:bold;text-align: left;font-size:20px; border-bottom:5px solid #ffcc33;text-align:center; background-color: #000000; color: #ffcc33; padding: 2px; | + | ==<div style="margin-top: 6px;font-weight:bold;text-align: left;font-size:20px; border-bottom:5px solid #ffcc33;text-align:center; background-color: #000000; color: #ffcc33; padding: 2px; font-family:sans-serif;">Feedback </div>== |
Please feel free leave your comments, suggestions or anything interesting :) | Please feel free leave your comments, suggestions or anything interesting :) | ||
<!-- END Feedback --> | <!-- END Feedback --> |
Latest revision as of 19:29, 25 November 2018
PROJECT POSTER | RESEARCH PAPER | OTHER GROUPS |
Contents
Motivation
Household electricity consumption in Singapore has increased by about 17% over the past decade, according to a report by the National Environment Agency in May 2018. On aggregate levels, Singapore households consumed 7,295 GWh (gigawatt hours) in 2017, which roughly translates to an average expenditure of $1,000 a year on electricity per household. [1]
Electricity consumption is a national issue, especially given that about 95% of Singapore's electricity supply is imported. [2] It is therefore important to encourage households to consume electricity in more sustainable ways.
Traditionally, the lack of transparency surrounding electricity use has been acknowledged as a possible challenge in raising awareness on electricity consumption. [3] Improving visualisation of household electricity consumption can help people in Singapore gain better clarity of their consumption habits and expenditure, and thus more incentive to reduce electricity usage. [3]
Our project visualises the distribution of household electricity consumption across planning regions in Singapore, accounting for type of residential homes, income and demographic profiles. We aim to better communicate electricity consumption in everyday life to people in Singapore, and ultimately engage them to reduce electricity consumption.
Objectives
This project aims to create an interactive data visualisation tool to achieve the following objectives:
- Provide a clear geographical visualisation for household electricity consumption across planning areas
- Provide an overview of the relationship between resident population and electricity consumption for the various housing types across time
- Allow users to explore household electricity consumption in Singapore by comparing across planning regions
- Ensure a smooth interactivity for a better user experience
Data
Datasets | Data Attributes | Rationale of Usage |
---|---|---|
|
This dataset contains granular data on average household monthly electricity consumption by postal code for each type of housing between 2013 to 2016. | |
Source: https://www.ema.gov.sg/statistic.aspx?sta_sid=20140617E32XNb1d0Iqa |
|
This dataset will be used to visualise the overall historical trend of monthly average household electricity consumption in Singapore from 2005 to 2017. |
Source: https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data |
|
This dataset is used to complement the main dataset by providing detailed information about the number of Singapore residents in each planning area, according to dwelling type.
|
Source: https://data.gov.sg/dataset/hdb-property-information |
|
This dataset provides a comprehensive record of Singapore HDB Property Information, and enables us to scale the average electricity consumption by the number of units for the given dwelling type for the block. |
Source: Real Estate Information System |
|
This dataset will be a complementary dataset for private housing types by providing information on the number of units. |
Source: https://www.ura.gov.sg/realEstateIIWeb/resources/misc/list_of_postal_districts.htm |
|
This dataset is used to map the postal sector, also the first two digits of the postal code, to the corresponding postal district. |
Related Works
Related Works | What We Can Learn |
---|---|
|
|
| |
| |
|
Prototype
Iteration 1
Landing Page
[1]Logo
[2]Bivariate Choropleth Map
[3]Filter
[4]Button to Historical Trend Page
[5]Slope Graph
Historical Trend Page
[1]Area Chart for Total Electricity Consumption
[2]Area Chart for Number of Singapore Resident
[3]Connected Scatter Plot
[4]Rate of Change of Number of Singapore Resident and Total Electricity Consumption
Application Architecture
Project Schedules
Project Schedule on Google Sheet:https://docs.google.com/spreadsheets/d/1IlT3Na8Ujlv9izY-0PWvCWEWzfqOmzq3jGHIbWCDiwk/edit?usp=sharing
Challenges
Challenges | Possible Solutions |
---|---|
Unfamiliarity with D3.js |
|
Data merge, cleaning and transformation |
|
Choice of web hosting provider |
|
Unfamiliar with implementation efforts required for customised D3.js interactivity |
|
References
[1] The Straits Times (https://www.straitstimes.com/singapore/singapores-household-electricity-consumption-up-17-per-cent-over-past-decade)
[2] Energy Market Authority (https://www.ema.gov.sg/electricity_market_overview.aspx)
[3] National Center for Biotechnology Information (https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4746293/)
[4] Energy Market Authority (https://www.ema.gov.sg/singapore_energy_statistics.aspx)
[5] Data.gov Database (https://data.gov.sg)
[6] D3.js (Documentation https://d3js.org/)
[7] Observale (https://beta.observablehq.com/)
[8] OneMap (https://www.onemap.sg/main/v2/)
[9] Prediction of Buildings Energy Consumption (http://cs109-energy.github.io/building-energy-consumption-prediction.html)
Feedback
Please feel free leave your comments, suggestions or anything interesting :)