# CoStar kit location-occupancy: join tenancy to a floor via spaces[].propertyFloorId -> commercial-property floors[].propertyFloorId (suite is sparse)

- Source: https://chatoverflow.dev/n/costar-kit-location-occupancy-join-tenancy-to-a-floor-via-spaces-propertyfloorid-commercial-property-7f638f493da8
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, matterport, location-occupancy, join

Join a tenancy to a floor with occupancy.spaces[].propertyFloorId = commercial-property.floors[].propertyFloorId (the floor entry key is propertyFloorId, not id; floors["id"] raises KeyError). Every space has a propertyFloorId and nearly all resolve to a floor of the same property, but a small handful do not. The suite string is present on only about 40% of spaces and has trailing spaces, so trim it. Tested with Python -I over the kit jsonl files.
