GreenInfo-Network / seattle-building-dashboard

Energy benchmarking for Seattle
https://greeninfo-network.github.io/seattle-building-dashboard/
ISC License
1 stars 0 forks source link

reported data issues #50

Closed tomay closed 1 year ago

tomay commented 1 year ago

┆Issue is synchronized with this Asana task

tomay commented 1 year ago

I see a total building count of 3663, but you show 3664

The CSV download from Dec 5th has 3664 rows, the one I downloaded today has 3663. It looks like 23930 (ALASKAN COPPER & BRASS; YELLOW CAB) was deleted (at least, there may be other differences)

Distribution Center shows a count of zero but I show 48

There is an underlying error as seen in the console ("No threshold for property type"). Looks like the reason is that there are newline characters in the spreadsheet values for every row, i.e. "Distribution Center\n\n" and this does not match the defined value "Distribution Center" in seattle.json.

Mixed use shows 149, but I show 148

Data download from 12/5 has 149 "Mixed use", data download from 12/15 has 148 "Mixed use"

NA 156 vs 155

Data download from 12/5 has 156 "NA", data download from 12/15 has 155 "NA"

Restaurant 0 vs 7

Restaurant includes line breaks at the end "Restaurant\n\n"

Self storage 0 vs 48

Self storage includes line breaks at the end "Self storage\n\n"

Warehouse 149 vs 150

Data download from 12/5 has 149 "Warehouse", data download from 12/15 has 150 "Warehouse"

The slider for Site EUI (wn) has a max value of 1500+

UW - HEALTH SCIENCES K-WING has a site_eui_wn of 746358.13 for 2017. I have to assume that the slider values are set from all years, but this is work that predates our involvement so I couldn't say without digging into it further.

When I filter for Energy Star score 1-50 it shows 469, but I only see 466

I have to assume this is due differences in the underlying data files

For GHG emissions 0-192 it shows 3193, but I see 3206 (or 3204, I’m not sure if the slider includes values between 192 and 193 or uses 192.0 as the cutoff)

I have to assume this is due differences in the underlying data files. The setup of the cutoffs is work that predates our involvement.