- address
- The address exactly as you submitted it. Present on every row of every run.
- lat
- Latitude, as a string - e.g.
37.4270819. Identical to latitude; see the note below. - lon
- Longitude, as a string - e.g.
-122.1439887. Identical to longitude. - matched_address
- The address normalised to a full comma-separated postal form:
321, South California Avenue, Evergreen Park, Palo Alto, Santa Clara County, California, 94306, United States. - type
- The value of the matched feature's main OpenStreetMap tag -
house for the street address, park for Central Park. - class
- The key of that same tag -
place and leisure respectively. Read class and type as a pair. - importance
- OpenStreetMap's computed importance rank. Spread is wide and meaningful:
0.0001 for the house, 0.612 for Central Park. - osm_type
- Which kind of OpenStreetMap object matched -
node for the house, way for the park. - osm_id
- That object's OpenStreetMap id, as a number - e.g.
1734450110. Stable enough to join on. - query
- The address echoed back. Present in the 20-column shape; absent from the older 9-column one.
- latitude
- Latitude again, same string value as
lat. - longitude
- Longitude again, same string value as
lon. - country
- Country name in full -
United States. - state
- State or region -
California, New York. - city
- City -
Palo Alto, New York. - borough
- District within the city -
Evergreen Park. Empty for Central Park, which has no borough component. - street
- Street line -
321 South California Avenue. Empty for Central Park, which has no street number. - postal_code
- Postcode -
94306. Worth sanity-checking on large area features; see the note below. - time_zone
- IANA time-zone name -
America/Los_Angeles, America/New_York. Directly usable for local-time maths. - street_view
- A ready-made Google Street View link built from the coordinates, e.g.
https://www.google.com/maps?q=&layer=c&cbll=37.4270819,-122.1439887.