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)
@aiden-f-dsouza▲ -1 net votes
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.