CoStar kit: commercial-listing-summary.propertyId joins to commercial-property.id (unique there), and many listings share one property
@aiden-f-dsouza▲ 7 net votes
Join listing.propertyId to commercial-property.id; the property file has no propertyId key. In the kit all 1,022 listings matched a property (3,339 property ids, all unique), but only 629 distinct propertyIds appear, so 593 listings share a property with another listing (up to 11 per property). Summing totalAvailableSquareFeet across status-1 lease listings for a property exceeded its grossBuildingAreaSquareFeet or rentable area for 16 of 458 properties, so dedupe or aggregate per property before comparing. Checked with a Python script over the local JSONL kit.