Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

Difference between editing buildstock.csv versus location + location-region.tsv?

asked 2019-09-19 22:46:36 -0500

y.tanaka gravatar image


  1. Using "project_singlefamilydetached" and opening that in the Parametric Analysis Tool
  2. Only looking at 10 buildings at a time; Downselect Logic is left empty

I produced "completed invalid workflow" data points every time I entered a "Location Region| CR00" option in the Downselect Logic cell, so I gave up, and decided to go off of the Manual Sampling note in the ResStock tutorial, editing the buildstock.csv instead.

However, a peer of mine told me that it's better to one hot encode the location.tsv and locations-region.tsv file instead to filter locations for data points, or else anything I put in Apply Upgrade won't go through. I really can't tell the difference, but can someone let me know, are there any differences between editing buildstock.csv versus editing location+location-region.tsv? Is it true that if I include an edited buildstock.csv file within the "housing_characteristics" directory, my Apply Upgrade inputs won't apply? And when I say "won't apply" I mean in the context of my results.csv file, autogenerated within the localResults directory of project_singlefamilydetached after running PAT.

Context: I wish to simulate using only the MI_Alpena.County.Rgnl.AP.726390 location, within CR04

edit retag flag offensive close merge delete


Did you mean to enter "Location Region|CR04" into the Downselect Logic cell instead of "Location Region| CR00"? I'm not really sure what you mean by "anything I put in Apply Upgrade won't go through". If that single location is the only one you want to simulate, then yes you should be able to manually downselect the buildstock.csv to that location (and renumber the building ids), and Apply Upgrade should apply as usual to the downselected datapoints.

joseph-robertson gravatar imagejoseph-robertson ( 2019-09-20 09:25:59 -0500 )edit

It's also possible that you've specified 10 simulations but everything is being downselected out, since the input is the number of simulations before applying the downselect logic, not after. You would need to specify > 10 simulations to get out 10 simulations associated with your Custom Region.

shorowit gravatar imageshorowit ( 2019-09-20 09:52:51 -0500 )edit

Apologies, to clarify, when I say "anything I put in Apply Upgrade won't go through", I mean that my results.csv file does not produce a apply_upgrade.run_measure column, and every column that starts with building_characteristics_report. is left blank, despite the building_characteristics_report option being unchecked. I am only able to produce values in columns that start with simulation_output_report.

In addition, am I supposed to produce twice the buildings simulated if I have an Apply Upgrade option? (e.g. 20 datapoints created if I ask for 10)

y.tanaka gravatar imagey.tanaka ( 2019-09-20 14:07:22 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2019-10-15 20:23:51 -0500

y.tanaka gravatar image

So, in experience so far, editing the buildstock.csv versus the locations.tsv and locations-region.tsv has no difference. I've been running analyses with the PAT on the ResStock directory with the edited buildstock.csv and it's been working fine.

With regards to my note on Apply Upgrade inputs not being implemented, I just needed to refer to this solution here

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer


Question Tools

1 follower


Asked: 2019-09-19 22:46:36 -0500

Seen: 181 times

Last updated: Oct 15 '19