Geography

ST_GEOGFROMTEXT

BigQuery

Membuat GEOGRAPHY dari Well-Known Text (WKT) string.

Tipe hasil: GEOGRAPHY

Syntax

SQL

ST_GEOGFROMTEXT(wkt_string [, oriented])

Parameter

wkt_stringSTRINGwajib

WKT representation (POINT, LINESTRING, POLYGON, dll)

orientedBOOLopsional

Apakah polygon sudah oriented (default FALSE)

Contoh Penggunaan

Create from WKT

SQL

1 SELECT
2   ST_GEOGFROMTEXT('POINT(106.8456 -6.2088)') AS point,
3   ST_GEOGFROMTEXT('LINESTRING(106 -6, 107 -7)') AS line,
4   ST_GEOGFROMTEXT('POLYGON((106 -6, 107 -6, 107 -7, 106 -7, 106 -6))') AS polygon;

Buat berbagai geometry dari WKT.

Hasil

(geography objects)

Kembali ke BigQuery Functions

1	SELECT
2	ST_GEOGFROMTEXT('POINT(106.8456 -6.2088)') AS point,
3	ST_GEOGFROMTEXT('LINESTRING(106 -6, 107 -7)') AS line,
4	ST_GEOGFROMTEXT('POLYGON((106 -6, 107 -6, 107 -7, 106 -7, 106 -6))') AS polygon;