类别

SQL语句

查询时间(秒)

点

SELECT COUNT(ID) FROM SDE.TABLEA A WHERE SDE.ST_INTERSECTS (A.SHAPE, SDE.ST_POINT (123.36, 39.15, 11)) = 1

0.062

SELECT COUNT (ID) FROM SDE.TABLEA A WHERE SDE.ST_INTERSECTS (SDE.ST_POINT (123.36, 39.15, 11), A.SHAPE) = 1

122

SELECT COUNT (ID) FROM SDE.TABLEA A WHERE SDE.WITHIN (SDE.ST_POINT (123.36, 39.15,11), A.SHAPE) = 1

0.062

SELECT COUNT (ID) FROM SDE.TABLEA A WHERE SDE.ST_CONTAINS (A.SHAPE, SDE.ST_POINT (123.36, 39.15, 11)) = 1

113

线

SELECT COUNT (ID) FROM SDE.TABLEA A WHERE SDE.ST_INTERSECTS (A.SHAPE, SDE.ST_LINEFROMTEXT ('LINESTRING (123.36 39.15, 122.53 37.55)', 11)) = 1

1.201

SELECT COUNT (ID) FROM SDE.TABLEA A WHERE SDE.ST_INTERSECTS (SDE.ST_LINEFROMTEXT ('LINESTRING (123.36 39.15, 122.53 37.55)', 11), A.SHAPE) = 1

190.7

缓冲区(面)

SELECT COUNT (ID) FROM SDE.TABLEA A WHERE SDE.ST_INTERSECTS (A.SHAPE, SDE.ST_BUFFER (SDE.ST_POINT (123.36, 39.15, 11), 0.1)) = 1

0.265

SELECT COUNT (ID) FROM SDE.TABLEA A WHERE SDE.ST_INTERSECTS (SDE.ST_BUFFER (SDE.ST_POINT (123.36, 39.15, 11), 0.1), A.SHAPE) = 1

329.6