Check out Propmodo’s great piece on real estate data and standards!
“In the real estate world, we have addresses, block and lot identifiers, and GPS coordinates. But these don’t always accurately identify a property. Address resolution is a tricky thing. According to Brett Friedman, head of sales and marketing for Cherre, “you have to make sure the real estate related entities (lot, building, unit, etc.) match across data sets before you can begin to think about appending data fields to a particular address or looking at the bigger picture. In a complex market like New York City, you encounter challenges such as alternate addresses, vanity addresses, entrances on different streets or avenues, or units described inconsistently.” Friedman says that in New York City, these “edge cases” where addresses between two different records might not match are the norm, and you’re in fact making the data lake dirtier by not resolving the entities as a first step in your process.”