Geography

ST_UNION

BigQuery

Menggabungkan dua objek GEOGRAPHY menjadi satu. ST_UNION_AGG untuk aggregate.

Tipe hasil: GEOGRAPHY

Syntax

SQL

ST_UNION(geography_1, geography_2) | ST_UNION_AGG(geography)

Parameter

geography_1GEOGRAPHYwajib

Objek geografi pertama

geography_2GEOGRAPHYwajib

Objek geografi kedua

Contoh Penggunaan

Union Two Polygons

SQL

1 SELECT ST_UNION(
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 merged;

Gabungkan dua polygon.

Hasil

merged: POLYGON(...)

Merge District Boundaries

SQL

1 SELECT
2   province,
3   ST_UNION_AGG(district_boundary) AS province_boundary
4 FROM districts
5 GROUP BY province;

Gabungkan boundary kecamatan jadi provinsi.

Hasil

(province boundaries)

Kembali ke BigQuery Functions

1	SELECT ST_UNION(
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 merged;

1	SELECT
2	province,
3	ST_UNION_AGG(district_boundary) AS province_boundary
4	FROM districts
5	GROUP BY province;