Electrical Energy Normalization: Difference between revisions

From Earlham CS Department
Jump to navigation Jump to search
Aagavri11 (talk | contribs)
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 |-..."
 
Akseewa11 (talk | contribs)
No edit summary
 
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 19: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"