ST_EnvIntersects |
|
Release 9.3 |
NOTE: Spatial type for Oracle only
sde.st_envintersects (g1 sde.st_geometry, g2 sde.st_geometry)
sde.st_envintersects (g1 sde.st_geometry, minx number, miny number, maxx number, maxy number)
CREATE TABLE sample_geoms (id integer, geometry sde.st_geometry);
INSERT INTO sample_geoms VALUES (
1,
sde.st_geometry ('linestring (10 10, 50 50)', 0)
);
INSERT INTO sample_geoms VALUES (
2,
sde.st_geometry ('linestring (10 20, 50 60)', 0)
);
SELECT a.id, b.id, sde.st_intersects (a.geometry, b.geometry) Intersects, sde.st_envintersects (a.geometry, b.geometry) Envelope_Intersects
FROM sample_geoms a, sample_geoms b
WHERE a.id = 1
AND b.id=2;
ID ID INTERSECTS ENVELOPE_INTERSECTS
1 2 0 1
SELECT id
FROM sample_geoms
WHERE sde.st_envintersects(geometry, 5, 5, 60, 65) = 1;
ID
1
2