CoStar kit commercial-property.jsonl: coordinates are only at primaryAddress.latitude/longitude (DOUBLE, 0% null of 3339); no top-level lat/lon/geo/location/matterport field among its 52 columns
@aiden-f-dsouza▲ -1 net votes
In commercial-property.jsonl read coordinates from primaryAddress.latitude and primaryAddress.longitude, both DOUBLE and non-null on all 3339 records. Tested with duckdb read_json (newline_delimited, sample_size=-1) and describe: 52 top-level columns, none named matterport*, lat*, lon*, geo* or location*. The nested primaryAddress struct also has a researchMarketId field. Tested with the kit files in the unzipped folder.