Skip to content

Instantly share code, notes, and snippets.

View cpopolo's full-sized avatar

cpopolo

View GitHub Profile
@cpopolo
cpopolo / index.html
Created December 4, 2015 07:12
Module 4, trying again but I think Git is broken. Again.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Mercator projection</title>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script src="//d3js.org/topojson.v1.min.js"></script>
<style type="text/css">
@cpopolo
cpopolo / index.html
Last active December 4, 2015 07:06
Module 4 - Store Electricity geo plotted ... with issues.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Mercator projection</title>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script src="//d3js.org/topojson.v1.min.js"></script>
<style type="text/css">
@cpopolo
cpopolo / index.html
Last active November 26, 2015 05:46
Module 3 Geo USA/CAN/MEX
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Mercator projection</title>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<style type="text/css">
@cpopolo
cpopolo / d3-gleason-electric-full-hourly-short.csv
Created November 15, 2015 18:12
Module 2 - Gleason Library Electricity
We can't make this file beautiful and searchable because it's too large.
assettype,assetid,sensor_sn,sensor_id,mydate,avgkw
"ELIGHT","5752","3860.279481.kW:R Room Lights 106 LC1","70930","2015-09-15 00","0"
"ELIGHT","5752","3860.279482.kW:R Lights Room 104 LC1","70931","2015-09-15 00","0"
"ELIGHT","5752","3860.279483.kW:R Lights Room 106 LC1","70932","2015-09-15 00","0"
"ELIGHT","5752","3860.279484.kW:Emergency Lights","70933","2015-09-15 00","0.33466666666666667"
"MISC","5751","3860.279485.kW:Lobby Room 105","70934","2015-09-15 00","1.207"
"ELIGHT","5752","3860.279486.kW:Circulation Soffit Lights","70935","2015-09-15 00","0"
"ELIGHT","5752","3860.279487.kW:Room 115, 116 Lights/Dimmers","70936","2015-09-15 00","0"
"ELIGHT","5752","3860.279488.kW:Staff Room Lights","70937","2015-09-15 00","0"
"EPLUG","5754","3860.279489.kW:Boiler Room Receptacle","70938","2015-09-15 00","0.17966666666666664"
@cpopolo
cpopolo / index.html
Last active November 6, 2015 21:50
Supermarket Electricity Data
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Bar Chart, Framed</title>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.min.js"></script>
<style type="text/css">
body {
margin: 0;
@cpopolo
cpopolo / Corey.RTU-3-short.csv
Created May 5, 2015 16:06
Module 6 - Circles, Lines, Areas, Transformations, Scale changes, and User date range
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 15 columns, instead of 8. in line 7.
AssetId,DateTime,64651.Corey Building.RTU-3.Mixed AIr Temp,64601.Corey Building.RTU-3.Discharge Air Temp (°F),64653.Corey Building.RTU-3.Return Air Temp (°F),64656.Corey Building.RTU-3.ZN-Q (PPM),64571.Corey Building.RTU-3.Outdoor Damper Output (%),64570.Corey Building.RTU-3.Outdoor Air Temp (°F),65506.Corey Building.RTU-3.Supply Fan CMD (1|0),Virtual.Per Cent OA (),Virtual.ABS OAT-RAT (),64569.Corey Building.RTU-3.Heating Output (%),DoW,Occupied,Weather OAT (°F)
Corey.RTU-3,2014-01-01 00:00:00,63.08,82.45,65.83,400.5,0,25,0.75,0,0,0,We,0,19.9
Corey.RTU-3,2014-01-01 01:00:00,47.54,67.13,52.65,398.25,0,24.53,0.25,0,0,0,We,0,19.2
Corey.RTU-3,2014-01-01 02:00:00,60.6,75.1,59.81,401.25,0,24.01,1,0,0,0,We,0,17.1
Corey.RTU-3,2014-01-01 03:00:00,61.49,84.17,64.66,395.5,0,23,0.25,0,0,0,We,0,16.83
Corey.RTU-3,2014-01-01 04:00:00,53.06,69.19,55.42,396.75,0,23.12,0.75,0,0,0,We,0,16
Corey.RTU-3,2014-01-01 05:00:00,62.6,78.6,65.52,396,0,23.27,0.75,0,0,0,We,0,15.78
Corey.RTU-3,2014-01-01 06:00:00,55.76,71.8,57.13,399.5,0,2
@cpopolo
cpopolo / Corey.RTU-3-short-2.csv
Created April 25, 2015 23:49
Module 5
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 15 columns, instead of 8. in line 7.
AssetId,DateTime,64651.Corey Building.RTU-3.Mixed AIr Temp,64601.Corey Building.RTU-3.Discharge Air Temp (°F),64653.Corey Building.RTU-3.Return Air Temp (°F),64656.Corey Building.RTU-3.ZN-Q (PPM),64571.Corey Building.RTU-3.Outdoor Damper Output (%),64570.Corey Building.RTU-3.Outdoor Air Temp (°F),65506.Corey Building.RTU-3.Supply Fan CMD (1|0),Virtual.Per Cent OA (),Virtual.ABS OAT-RAT (),64569.Corey Building.RTU-3.Heating Output (%),DoW,Occupied,Weather OAT (°F)
Corey.RTU-3,2014-01-01 00:00:00,63.08,82.45,65.83,400.5,0,25,0.75,0,0,0,We,0,19.9
Corey.RTU-3,2014-01-01 01:00:00,47.54,67.13,52.65,398.25,0,24.53,0.25,0,0,0,We,0,19.2
Corey.RTU-3,2014-01-01 02:00:00,60.6,75.1,59.81,401.25,0,24.01,1,0,0,0,We,0,17.1
Corey.RTU-3,2014-01-01 03:00:00,61.49,84.17,64.66,395.5,0,23,0.25,0,0,0,We,0,16.83
Corey.RTU-3,2014-01-01 04:00:00,53.06,69.19,55.42,396.75,0,23.12,0.75,0,0,0,We,0,16
Corey.RTU-3,2014-01-01 05:00:00,62.6,78.6,65.52,396,0,23.27,0.75,0,0,0,We,0,15.78
Corey.RTU-3,2014-01-01 06:00:00,55.76,71.8,57.13,399.5,0,2
@cpopolo
cpopolo / Corey.RTU-3-short-2.csv
Last active August 29, 2015 14:19
D3 Module 4
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 15 columns, instead of 8. in line 7.
AssetId,DateTime,64651.Corey Building.RTU-3.Mixed AIr Temp,64601.Corey Building.RTU-3.Discharge Air Temp (°F),64653.Corey Building.RTU-3.Return Air Temp (°F),64656.Corey Building.RTU-3.ZN-Q (PPM),64571.Corey Building.RTU-3.Outdoor Damper Output (%),64570.Corey Building.RTU-3.Outdoor Air Temp (°F),65506.Corey Building.RTU-3.Supply Fan CMD (1|0),Virtual.Per Cent OA (),Virtual.ABS OAT-RAT (),64569.Corey Building.RTU-3.Heating Output (%),DoW,Occupied,Weather OAT (°F)
Corey.RTU-3,2014-01-01 00:00:00,63.08,82.45,65.83,400.5,0,25,0.75,0,0,0,We,0,19.9
Corey.RTU-3,2014-01-01 01:00:00,47.54,67.13,52.65,398.25,0,24.53,0.25,0,0,0,We,0,19.2
Corey.RTU-3,2014-01-01 02:00:00,60.6,75.1,59.81,401.25,0,24.01,1,0,0,0,We,0,17.1
Corey.RTU-3,2014-01-01 03:00:00,61.49,84.17,64.66,395.5,0,23,0.25,0,0,0,We,0,16.83
Corey.RTU-3,2014-01-01 04:00:00,53.06,69.19,55.42,396.75,0,23.12,0.75,0,0,0,We,0,16
Corey.RTU-3,2014-01-01 05:00:00,62.6,78.6,65.52,396,0,23.27,0.75,0,0,0,We,0,15.78
Corey.RTU-3,2014-01-01 06:00:00,55.76,71.8,57.13,399.5,0,2
@cpopolo
cpopolo / Corey.RTU-3-short.csv
Created April 6, 2015 14:12
Module 3 - Bar chart
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 15 columns, instead of 8. in line 7.
AssetId,DateTime,64651.Corey Building.RTU-3.Mixed AIr Temp,64601.Corey Building.RTU-3.Discharge Air Temp (°F),64653.Corey Building.RTU-3.Return Air Temp (°F),64656.Corey Building.RTU-3.ZN-Q (PPM),64571.Corey Building.RTU-3.Outdoor Damper Output (%),64570.Corey Building.RTU-3.Outdoor Air Temp (°F),65506.Corey Building.RTU-3.Supply Fan CMD (1|0),Virtual.Per Cent OA (),Virtual.ABS OAT-RAT (),64569.Corey Building.RTU-3.Heating Output (%),DoW,Occupied,Weather OAT (°F)
Corey.RTU-3,2014-01-01 00:00:00,63.08,82.45,65.83,400.5,0,25,0.75,0,0,0,We,0,19.9
Corey.RTU-3,2014-01-01 01:00:00,47.54,67.13,52.65,398.25,0,24.53,0.25,0,0,0,We,0,19.2
Corey.RTU-3,2014-01-01 02:00:00,60.6,75.1,59.81,401.25,0,24.01,1,0,0,0,We,0,17.1
Corey.RTU-3,2014-01-01 03:00:00,61.49,84.17,64.66,395.5,0,23,0.25,0,0,0,We,0,16.83
Corey.RTU-3,2014-01-01 04:00:00,53.06,69.19,55.42,396.75,0,23.12,0.75,0,0,0,We,0,16
Corey.RTU-3,2014-01-01 05:00:00,62.6,78.6,65.52,396,0,23.27,0.75,0,0,0,We,0,15.78
Corey.RTU-3,2014-01-01 06:00:00,55.76,71.8,57.13,399.5,0,2
@cpopolo
cpopolo / Corey.RTU-3.csv
Last active August 29, 2015 14:17
We can't make this file beautiful and searchable because it's too large.
AssetId,DateTime,64651.Corey Building.RTU-3.Mixed AIr Temp (°F),64601.Corey Building.RTU-3.Discharge Air Temp (°F),64653.Corey Building.RTU-3.Return Air Temp (°F),64656.Corey Building.RTU-3.ZN-Q (PPM),64571.Corey Building.RTU-3.Outdoor Damper Output (%),64570.Corey Building.RTU-3.Outdoor Air Temp (°F),65506.Corey Building.RTU-3.Supply Fan CMD (1|0),Virtual.Per Cent OA (),Virtual.ABS OAT-RAT (),64569.Corey Building.RTU-3.Heating Output (%),DoW,Occupied,Weather OAT (°F)
Corey.RTU-3,2014-01-01 00:00:00,63.08,82.45,65.83,400.5,0,25,0.75,0,0,0,We,0,19.9
Corey.RTU-3,2014-01-01 01:00:00,47.54,67.13,52.65,398.25,0,24.53,0.25,0,0,0,We,0,19.2
Corey.RTU-3,2014-01-01 02:00:00,60.6,75.1,59.81,401.25,0,24.01,1,0,0,0,We,0,17.1
Corey.RTU-3,2014-01-01 03:00:00,61.49,84.17,64.66,395.5,0,23,0.25,0,0,0,We,0,16.83
Corey.RTU-3,2014-01-01 04:00:00,53.06,69.19,55.42,396.75,0,23.12,0.75,0,0,0,We,0,16
Corey.RTU-3,2014-01-01 05:00:00,62.6,78.6,65.52,396,0,23.27,0.75,0,0,0,We,0,15.78
Corey.RTU-3,2014-01-01 06:00:00,55.76,71.8,57.13,399.