Geography

ST_DISTANCE

BigQuery

Menghitung jarak terpendek antara dua objek GEOGRAPHY dalam meter.

Tipe hasil: FLOAT64

Syntax

SQL

ST_DISTANCE(geography_1, geography_2 [, use_spheroid])

Parameter

geography_1GEOGRAPHYwajib

Objek geografi pertama

geography_2GEOGRAPHYwajib

Objek geografi kedua

use_spheroidBOOLopsional

Gunakan spheroid untuk akurasi lebih (default TRUE)

Contoh Penggunaan

Distance Between Cities

SQL

1 SELECT ST_DISTANCE(
2   ST_GEOGPOINT(106.8456, -6.2088),  -- Jakarta
3   ST_GEOGPOINT(110.4203, -6.9666)   -- Semarang
4 ) / 1000 AS distance_km;

Jarak Jakarta ke Semarang.

Hasil

distance_km: 441.5

Find Nearby Stores

SQL

1 SELECT
2   store_name,
3   ST_DISTANCE(location, ST_GEOGPOINT(106.8, -6.2)) AS distance_m
4 FROM stores
5 WHERE ST_DISTANCE(location, ST_GEOGPOINT(106.8, -6.2)) < 5000
6 ORDER BY distance_m;

Toko dalam radius 5km.

Hasil

(nearby stores with distances)

Kembali ke BigQuery Functions

1	SELECT ST_DISTANCE(
2	ST_GEOGPOINT(106.8456, -6.2088), -- Jakarta
3	ST_GEOGPOINT(110.4203, -6.9666) -- Semarang
4	) / 1000 AS distance_km;

1	SELECT
2	store_name,
3	ST_DISTANCE(location, ST_GEOGPOINT(106.8, -6.2)) AS distance_m
4	FROM stores
5	WHERE ST_DISTANCE(location, ST_GEOGPOINT(106.8, -6.2)) < 5000
6	ORDER BY distance_m;