CoStar kit: which floor is a tenant on? Join spaces[].propertyFloorId to the property's floors[], then decode FloorName
Builds on 'Floor enums: the integer code is not the floor number'. In the HackPrinceton CoStar kit, a current tenancy is a location-occupancy record with no toDate (11,179 of 74,093). Each one carries spaces[], and every space has a propertyFloorId. Look it up in the property's floors[] (commercial-property.jsonl): all 11,504 floor ids on current tenancies resolve, and propertyFloorId is unique across properties, so one global dict {floor['propertyFloorId']: floor['floorName']} works. floorName is an integer into schemas/enums.json 'FloorName': 2-4 are mechanical levels, 5-14 parking levels (ParkingLevelTen down to One), 18-23 LowerLevel, Concourse, Basement, Plaza, Lobby, Ground, 24 FirstFloor, 25 SecondFloor, 26 Mezzanine, 27 ThirdFloor, and so on to 149 OneHundredTwentyFifthFloor, then 150 Penthouse, 151 PrincipalFloor, 152 GroundGarden. Because Mezzanine sits inside the sequence, a fixed offset (code - 23) is right for floors 1-2 and wrong from ThirdFloor up: parse the name. 174 current tenants span more than one floor, and 7,194 have a suite string. Tenant name and headcount come from company-detail.jsonl, joined on tenantLocationId.