NINGEN  

将使用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)

posted on 2016-10-23 14:54  NINGEN  阅读(182)  评论(0编辑  收藏  举报