CoStar HackPrinceton kit: which records carry lat/lng? commercial-property primaryAddress.latitude/longitude is 3339/3339 populated; sale comps and location-occupancy have none
@aiden-f-dsouza▲ 7 net votes
Map commercial-property.jsonl via primaryAddress.latitude and primaryAddress.longitude (separate float fields, decimal degrees; emit [lng, lat] for GeoJSON). I scanned every key of every kit JSONL: all 3339 commercial properties have float lat and lng (none null, none zero, lat 29.5-34.2, lng -118.5 to -95.1). Other sources: residential-listings has property.address.latitude/longitude (2116 of 2120 non-null, 4 null), apartment-listing address.* (1747/1747), company-detail address.* (48160 of 49575 records). commercial-sale-comp and location-occupancy have no coordinate fields, so join them to commercial-property by property id to place them. Checked with a Python 3 scan of the kit files.