places
Data license: CDLA permissive v2
3 rows where websites = "["http://parks.smcgov.org/pillar-point-bluff"]"
This data as json, CSV (advanced)
Suggested facets: updatetime (date), websites (array), socials (array), phones (array)
| id ▼ | updatetime | version | names | categories | confidence | websites | socials | emails | phones | brand | addresses | sources | bbox | geometry | type | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| tmp_24DB6FF719CE8359D3BB5307124DD920 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Pillar Point Bluff trailhead & Jean Lauer Trail", "local"]}]]} | {"main": "park", "alternate": ["hiking_trail", "attractions_and_activities"]} | 0.9020835161209106 | ["http://parks.smcgov.org/pillar-point-bluff"] | ["https://www.facebook.com/419933561359608"] | ["+16503558289"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Moss Beach", "94038-9683", "840 Airport St", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "419933561359608"]}] | {"minx": -122.505347, "maxx": -122.505347, "miny": 37.51153, "maxy": 37.51153} | <Binary: 21 bytes> | place | 37.51153 | -122.505347 | |
| tmp_8D3CC5E7C51339A40AB99371C00754A3 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Pillar Point Air Force Station", "local"]}]]} | {"main": "armed_forces_branch", "alternate": ["professional_services", "professional_services"]} | 0.7981731295585632 | ["http://parks.smcgov.org/pillar-point-bluff"] | ["https://www.facebook.com/147152308690145"] | {"names": null, "wikidata": null} | [{"key": ["locality", "region", "country"], "value": ["El Granada", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "147152308690145"]}] | {"minx": -122.4932258, "maxx": -122.4932258, "miny": 37.5032232, "maxy": 37.5032232} | <Binary: 21 bytes> | place | 37.5032232 | -122.4932258 | ||
| tmp_FAE62C5F0499271C5FFBA1850BA861AC | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Pillar Point Access & Maverick's Trailhead", "local"]}]]} | {"main": "hiking_trail", "alternate": ["landmark_and_historical_building", "monument"]} | 0.8557753562927246 | ["http://parks.smcgov.org/pillar-point-bluff"] | ["https://www.facebook.com/297512790683194"] | ["+16503558289"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "freeform", "country"], "value": ["94019", "West Point Ave", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "297512790683194"]}] | {"minx": -122.496682, "maxx": -122.496682, "miny": 37.501622, "maxy": 37.501622} | <Binary: 21 bytes> | place | 37.501622 | -122.496682 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [places] ( [id] TEXT PRIMARY KEY, [updatetime] TEXT, [version] INTEGER, [names] TEXT, [categories] TEXT, [confidence] FLOAT, [websites] TEXT, [socials] TEXT, [emails] TEXT, [phones] TEXT, [brand] TEXT, [addresses] TEXT, [sources] TEXT, [bbox] TEXT, [geometry] BLOB, [type] TEXT , [latitude] FLOAT, [longitude] FLOAT);