usp_sjqy_create_YWBaseData(国外英文).docVIP

usp_sjqy_create_YWBaseData(国外英文资料) _ yjxzgdl xk. _ yjxzgdmj xk. _ xmjsq xk. _ xmtzgs xk. _ xmbj xk. _ xmmbrw xk. _ xmtzgmjzjc xk. _ cwfx xk. _ jjshjstxyfx xk. _ jljjy xk. _ jdfd xk. _ zbx xk. _ tylx xk. xk _ dh. xk _ jd. xk _ dw. _ zyjx xk. _ tqcs xk. xm _ nm ) select caseno. 可行性研究编制单位. 项目所在地市县. 项目区所设计行政村镇. 项目区的经纬度坐标范围. 项目申报类型. 项目区地貌类型. 项目区土地利用现状. 土地权属情况. 项目范围. 项目建设规模. 预计新增耕地率. 预计新增耕地面积. 项目建设期. 项目投资估算. 项目背景. 项目目标任务. 项目投资规模及资金筹. 财务分析. 经济社会及生态效益分析. 结论及建议. 几度分带. 坐标系. 投影类型. 带号. 精度. 单位. 中央经线. 椭球参数. xm _ nm from xmkxxyjs @ dblink; - three, 坐标 delete from xm _ zbb; insert into _ zbb (xm _ xmbm xz, xz _ id _ dkb xz, _ dkmc xz, _ dxh xz, _ zzb xz, _ hzb xz, _ fsbc xz, _ dzqh xz, xz _ bz ) select caseno. createguid () 地块号. 地块名称. 点序号. - - to _ number (nvl (replace (replace (replace (replace (纵坐标, ,) ,) ,) , ), 0)) 纵坐标. to _ number (nvl (replace (replace (replace (replace (replace (replace (replace (纵坐标, ,) ,) ,) , ),,,), and chr (10).), ,), 0)) 纵坐标. to _ number (nvl (replace (replace (replace (replace (replace (replace (replace (横坐标, ,) ,) ,) , ),,,), and chr (10).), ,), 0)) 横坐标. nvl (replace (replace (replace (replace (replace (replace (replace (replace (反算边长, 面, null), -, null), , null),, null), , null),, null) ,) , ), 0) 地址圈号. 备注 from xm _ ghsjzbsm @ dblink where caseno not in (ys _ b1117, ghsj _ b1115, ghsj _ b3-83, _ b3-83 lx, lx _ b1216, lx _ b1381, ys _ b1117, ghsj _ b1115, _ b1381 lx, lx _ b733). - 地块信息 delete from xm _ dkb; insert into _ dkb (xm xd _ xmbm. xd _ id xd _ dkb. xd _ dkmc. _ tfh xd ) select caseno. createguid () 地块号. 地块名称. 图幅号 from xm _ ghsjzbsm @ dblink group by caseno, 地块号, 地块名称, 图幅号; - four, 验收 delete from xm _ yscbb; insert into _ yscbb xm ( xy _ xmbm. xy _ cbdw. xy _ xmpzwh. xy _ cbsj. xy _ qsdw. xy _ qswh. xy _ xmlx. xy _ tzlx. xy _ ssdw. xy _ ssmj. xy _ njzgdmj. xy _ njzqtdlmj. xy _ gdmj. xy _ stmj. xy _ hdmj. xy _ ydmj. xy _ ldmj. xy _ ktmj. xy _ jmdjgkyd. xy _ jtyd. xy _ ntslyd. xy _ wjyd. xy _ hjmj. xy _ gzchd. xy _ pzcd. xy _ tgzk. xy _ ggzk. xy