将使用arcgis的一些技巧记下来，以供翻阅

1.判断点在面内

insert into grid_res_relation

(GRIDID, GRIDTYPE, RESID, restype, typename, resNo, resName)

select m.jrqid GRIDID, 2520010 GRIDTYPE,  m.resid RESID, m.typeid restype,(case

when m.typeid = 209 then  '小区' end) typename, m.resno resNo, m.resname resName

from (select a.resid   jrqid,  b.resid   resid, b.typeid  typeid,  b.resno   resno,  b.resname resname

from %s a, %s b where (select sde.st_intersects(b.shape, a.shape) from dual) = 1

and a.resid = '%s') m

2.构造shape

sde.st_point(‘point(x y)’,4326)