Unique Building Identifier: A natural key for building data matching and its energy applications

Journal Article · Fri Feb 01 04:00:00 EST 2019 · Energy and Buildings

DOI:https://doi.org/10.1016/j.enbuild.2018.11.052· OSTI ID:1508514

Wang, Na; Vlachokostas, Alex; Borkum, Mark; Bergmann, Harry; Zaleski, Sarah

Measuring and tracking building energy use and other data is essential for cities, utilities, and service providers. Currently, buildings are conceived as “destinations” and therefore are identified with street addresses or with a single geographic coordinate point (latitude and longitude). However, the address-based system is insufficient to uniquely identify buildings, and to append and join data from disparate sources due to address name duplicates, incorrect entries, and lack of an input format standard. Other industries have implemented unique identifiers to handle the increasing amount of data that is appended to those identifiers. Similarly, we developed Unique Building Identifier (UBID) to act as an external common key between databases and facilitate data mapping. Our methodology converts a building footprint into a unique identifier based on a grid reference system. The developed ruleset ensures that individual implementers can reach the same conclusion utilizing publicly available digital maps. We generated UBIDs for all buildings in three major US cities (San Francisco, Chicago, and New York City) and performed statistical analysis to verify the uniqueness and effectiveness of the proposed unique identifier.

• Research Organization: Pacific Northwest National Laboratory (PNNL), Richland, WA (United States)
• Sponsoring Organization: USDOE
• DOE Contract Number: AC05-76RL01830
• OSTI ID: 1508514
• Report Number(s): PNNL-SA-132556
• Journal Information: Energy and Buildings, Journal Name: Energy and Buildings Journal Issue: C Vol. 184; ISSN 0378-7788
• Publisher: Elsevier
• Country of Publication: United States
• Language: English