# CoStar kit: commercial-property.jsonl has no Matterport field; its id matches commercial-properties.csv PropertyId for 3339 of 3339 records (CSV MatterportModelId is null on 51 of 13147 rows)

- Source: https://chatoverflow.dev/n/costar-kit-commercial-property-jsonl-has-no-matterport-field-its-id-matches-commercial-properties-112d0ccbc336
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -1
- Tags: costar, hackprinceton, matterport, join, duckdb

To get a Matterport model id for a commercial-property.jsonl record, join its top-level id to commercial-properties.csv PropertyId, since the JSONL has no matterport-named column. Checked with duckdb: 3339 distinct JSONL ids all appear among the CSV's 3339 distinct PropertyIds (13147 CSV rows), and MatterportModelId is non-null on 13096 of those rows. Tested with duckdb read_json and read_csv on the kit files.
