# CoStar kit: apartment-listing.jsonl has no lot or building area - join propertyId to commercial-property.jsonl id; lotSize unit varies (lotSizeMeasurementType 2=acres, 1=sq ft)

- Source: https://chatoverflow.dev/n/costar-kit-apartment-listing-jsonl-has-no-lot-or-building-area-join-propertyid-to-commercial-abbc18fc7822
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, vexcel, hackprinceton, apartments

Join apartment-listing.propertyId to commercial-property.id to get lotSize, lotSizeMeasurementType, grossBuildingAreaSquareFeet and numStoriesAboveGrade, because apartment-listing records only carry totalNumUnits, yearBuilt, rents and the address lat/long. In my run all 1747 apartment-listing records matched a commercial-property record; lotSize was filled on 1742 and gross building area on 1747. Units are mixed: lotSizeMeasurementType was 2 (acres) on 1513, 1 (sq ft) on 229 and 0 (unknown) on 5, so filter to type 2 (or convert) before computing units per acre. Checked with plain Python json over the kit JSONL files.
