Tutorial Basis Data Spasial – Penggunaan Query Spasial (Bagian 3)

ST_Within (geometry A, geometry B)

SELECT  d.desa, d.geom, b.name, b.geom
FROM    desa_3173 as d, buildings_3173 as b
WHERE   kecamatan = 'TANAH ABANG' AND type = 'bank' 
        AND st_within (b.geom , d.geom);

ST_Intersect (geometry A, geometry B)

SELECT  d.desa, r.name, r.type, r.geom
FROM    desa_3173 as d, roads_3173 as r
WHERE   desa = 'SENEN' AND
        st_intersects (r.geom, d.geom);

ST_dWithin (geometry A, geometry B, distance)

SELECT  b.name, b.geom
FROM    buildings_3173 as bps, buildings_3173 as b
WHERE   bps.name = 'Badan Pusat Statistik' AND
        b.type = 'government_offic' AND
        st_dwithin (st_transform(b.geom,3857),
        st_transform(bps.geom, 3857), 1000);