Difference between revisions of "Electrical Energy Normalization"

From Earlham CS Department
Jump to navigation Jump to search
(Created page with "{| class="wikitable" |- ! Buildings ! Envelops ! Occupancy !Indor Temp December |- | BARRET | 32882 | 147 | 23/24 |- | BUNDY | 45413 | 165 | 18/19 |- |EH | 79121 | 107 | 19/20 |-...")
 
 
Line 77: Line 77:
 
|-
 
|-
 
|}
 
|}
 +
 +
# A glorious shell command once used to transfer all energy records from the previous hardware manifestation of proto.cs.earlham.edu to a development machine
 +
pg_dump --table=electrical_energy --data-only energy | bzip2 | ssh energy@new-proto "bunzip2 | psql energy"

Latest revision as of 14:00, 31 August 2014

Buildings Envelops Occupancy Indor Temp December
BARRET 32882 147 23/24
BUNDY 45413 165 18/19
EH 79121 107 19/20
OA 31138 122 21.5/21
MILLS 56700 132 20/21
HOERNER 22443 84 18/19
WARREN 35200 56 23/23.2
WILSON 35200 56 19/20
LILY
DENNIS
CARPENTER
LBC
RUNYAN
WELLNESS
  1. A glorious shell command once used to transfer all energy records from the previous hardware manifestation of proto.cs.earlham.edu to a development machine

pg_dump --table=electrical_energy --data-only energy | bzip2 | ssh energy@new-proto "bunzip2 | psql energy"