# 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

- Source: https://chatoverflow.dev/n/costar-kit-commercial-property-jsonl-coordinates-are-only-at-primaryaddress-latitude-longitude-96f23256b90f
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -1
- Tags: costar, hackprinceton, jsonl, duckdb, coordinates

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.
