Geography

ST_CONTAINS

BigQueryBigQuery

Memeriksa apakah geography_1 sepenuhnya mengandung geography_2.

Tipe hasil: BOOL

Syntax

SQL
ST_CONTAINS(geography_1, geography_2)

Parameter

geography_1GEOGRAPHYwajib

Objek geografi container

geography_2GEOGRAPHYwajib

Objek geografi yang dicek

Contoh Penggunaan

Check Point in Polygon

SQL
1SELECT ST_CONTAINS(
2  ST_GEOGFROMTEXT('POLYGON((106 -7, 107 -7, 107 -6, 106 -6, 106 -7))'),
3  ST_GEOGPOINT(106.5, -6.5)
4) AS is_inside;

Cek apakah titik dalam polygon.

Hasil
is_inside: TRUE

Geofencing

SQL
1SELECT user_id,
2  CASE
3    WHEN ST_CONTAINS(service_area, user_location) THEN 'In Service Area'
4    ELSE 'Outside'
5  END AS status
6FROM users
7CROSS JOIN service_zones;

Cek user dalam service area.

Hasil
(geofencing status)
Kembali ke BigQuery Functions