前置条件:需要创建空间索引
按空间范围查询
SELECT tablename FROM fieldname WHERE ROWID IN
(SELECT pkid FROM idx_ tablename_geom WHERE
xmin > 730000 AND xmax < 734000 AND ymin > 4810000 AND ymax < 4850000);
前置条件:需要创建空间索引
按空间范围查询
SELECT tablename FROM fieldname WHERE ROWID IN
(SELECT pkid FROM idx_ tablename_geom WHERE
xmin > 730000 AND xmax < 734000 AND ymin > 4810000 AND ymax < 4850000);
转载于:https://my.oschina.net/u/615762/blog/3066931