利用ST_GEOMETRY实现按辖区对点数据分类

按照空间查询所属上庄镇的gsmm数据。

declare

shp clob;
num number;
begin
select sde.st_asText(t.shape) into shp from hdyljspatial.hdjd_pg t where t.jdname='上庄镇';

select count(*) into num from hdyljspatial.gsmm g where sde.ST_Contains(sde.st_geomfromtext(shp,22),sde.st_geomfromtext(sde.st_asText(g.shape),22))=1;
dbms_output.put_line(num);
end;