GEOPOINT

SyntaxSyntax

GEOPOINT( value_1 [ , value_2 ] )

DescriptionDescription

Generates a Geopoint type value. For the input, it accepts a string, a "geopoint" type value, or coordinates — latitude value_1 and longitude value_2. If a single string is input, it must contain a list of two numbers (latitude and longitude) in JSON syntax.

Argument types:

• value_1 — Fractional number | Geopoint | Integer | String
• value_2 — Fractional number | Integer | String

Return type: Geopoint

ExamplesExamples

GEOPOINT("[55.75222,37.61556]") = "[55.75222,37.61556]"

GEOPOINT(55.75222, 37.61556) = "[55.75222,37.61556]"

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents, YDB.