説明

与えられた二つのポイントジオメトリから定義されるBOX2Dを生成します．これは範囲クエリを実行する際に便利です．

例

--Return all features that fall reside or partly reside in a US national atlas coordinate bounding box
--It is assumed here that the geometries are stored with SRID = 2163 (US National atlas equal area)
SELECT feature_id, feature_name, the_geom
FROM features
WHERE the_geom && ST_SetSRID(ST_MakeBox2D(ST_Point(-989502.1875, 528439.5625),
	ST_Point(-987121.375 ,529933.1875)),2163)

関連情報

ST_MakePoint, ST_Point, ST_SetSRID, ST_SRID