Places
Query location data about a media object.
Select
To query the Places view, the SearchTerms column is required.
SELECT * FROM Places WHERE SearchTerms='museum'The driver will execute other filters client-side within itself. Note: This view is deprecated. It will be discontinued in the 2023 Q2. Please use the Pages view as a replacement. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will cause an error.
Columns
Name | Type | Description |
Id [KEY] | String | The unique identifier for the place. |
Name | String | Name of the place. |
City | String | City of the place. |
Country | String | Country of the place. |
Latitude | String | Latitude of the place. |
Longitude | String | Longitude of the place. |
Street | String | Street of the place. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
SearchTerms | String | Name of the place. |