Geography

ST_INTERSECTS

BigQuery

Memeriksa apakah dua objek GEOGRAPHY memiliki intersection (bersinggungan atau overlap).

Tipe hasil: BOOL

Syntax

SQL

ST_INTERSECTS(geography_1, geography_2)

Parameter

geography_1GEOGRAPHYwajib

Objek geografi pertama

geography_2GEOGRAPHYwajib

Objek geografi kedua

Contoh Penggunaan

Check Intersection

SQL

1 SELECT ST_INTERSECTS(
2   ST_GEOGFROMTEXT('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'),
3   ST_GEOGFROMTEXT('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))')
4 ) AS overlaps;

Cek apakah dua polygon overlap.

Hasil

overlaps: TRUE

Kembali ke BigQuery Functions

1	SELECT ST_INTERSECTS(
2	ST_GEOGFROMTEXT('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'),
3	ST_GEOGFROMTEXT('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))')
4	) AS overlaps;