发布featureServer失败!!
就一个图层,这个图层由1个视图查询出来,视图关联了2张表,在arcmap里可以查看到图层,但是发布失败!
视图创建语句如下:
create or replace view 市_农作物 as
select fssc.OBJECTID OBJECTID,------------返回图层ID
fssc.SHAPE SHAPE,---------------返回图层字段
fssc.地市编码 地市编码,
fssc.地市名称 地市名称,
fssc.SE_AVG SE_AVG,
fssc.SE_MIN SE_MIN,
fssc.SE_MAX SE_MAX,
fssc.COUNTY_NUM COUNTY_NUM,
fssc.TOWN_NUM TOWN_NUM,
fssc.POINT_NUM POINT_NUM,
fssc.AREA_NUM AREA_NUM,
fssc.JINGDU JINGDU,
fssc.WEIDU WEIDU,
fssc.PH_AVG PH_AVG,
fssc.PH_MIN PH_MIN,
fssc.PH_MAX PH_MAX,
tss.pointheight POINTHEIGHT,
tss.corptype CORPTYPE,
tss.judgevalue JUDGEVALUE,
tss.AdminLevel ADMINLEVEL,
tss.AdminCode ADMINCODE,
tss.AdminDiv ADMINDIV,
tss.AdminUpCode ADMINUPCODE,
tss.AdminUpDiv ADMINUPDIV,
tss.CorpTypeNo CORPTYPENO,
tss.PointTotal POINTTOTAL,
tss.HeightAvg HEIGHTAVG,
tss.TotalAvg TOTALAVG,
tss.HeightVAR_POP HEIGHTVAR_POP,
tss.TotalVAR_POP TOTALVAR_POP,
tss.HeightSTDDEV HEIGHTSTDDEV,
tss.TotalSTDDEV TOTALSTDDEV,
tss.HEIGHTRATE
from SDA.FTS_SDA_SE_CITY fssc, TBL_SDA_SeCropType tss
where tss.adminlevel = '2'
and fssc.地市编码 = tss.admincode
如图:
1 个回复
朱政
赞同来自:
要回复问题请先登录或注册