Create PMV notebook for Monitored House 3 Living Room and Simulated Table Parser

[carlosparadis]

Use from DHHL database:

• Temperature
• Relative Humidity

Create one 1 plot for each of the 3 air speeds:

• 0 fpm
• 120 fpm
• 200 fpm

Assume:

• met = 1.0
• clo = 0.45

[carlosparadis]

Query:

select * from sensor_info where building_id = 3 and (type = 'Temperature' OR type = 'Humidity') and room_type = 'living/kitchen/hall';

Gives:

• Humidity: purpose_id = 56
• Temperature: purpose_id = 11

To extract tables:

psql -d dhhl -c "Copy (select * from reading where **purpose_id = <id>**) TO STDOUT With CSV HEADER DELIMITER ',';" > **house_<id>_<place>_<type>**.csv

psql -d dhhl -c "Copy (select * from reading where purpose_id = 56) TO STDOUT With CSV HEADER DELIMITER ',';" > house3_livingroom_humidity.csv

And for outdoor:

psql -d dhhl -c "Copy (select * from outdoor_hobo_temp_avg) TO STDOUT With CSV HEADER DELIMITER ',';" > houses_outdoor_temperature.csv

Output

Plots were added to 11_Data/from_hig on Drive.