Geographical functions

GEOCODE
GEOINFO
TOPONYM_TO_GEOPOINT
TOPONYM_TO_GEOPOLYGON

GEOCODE

Syntax:GEOCODE( address )

Converts address to its geographical coordinates.

DataLens caches the function result. When the function is invoked again, DataLens doesn't perform geocoding. The cache lifetime is 30 days.After 30 days, DataLens automatically invokes GEOCODE to convert addresses in the dataset.

GEOINFO

Syntax:GEOINFO( address, scale )

Converts address to geographical name corresponding to the specified scale.

Possible values for scale parameter:

"country",
"country_code",
"region",
"locality".

TOPONYM_TO_GEOPOINT

Syntax:TOPONYM_TO_GEOPOINT( name )

Converts the name of a geographical entity (country, region, city) name to the Geopoint type.

TOPONYM_TO_GEOPOLYGON

Syntax:TOPONYM_TO_GEOPOLYGON( name )

Converts the name of a geographical entity (country, region, city) name to the Geopolygon type.