| | |
| | | |
| | | <!-- 按大类统计 --> |
| | | <select id="countByMajor" resultType="com.lf.server.entity.ctrl.CountEntity"> |
| | | select '测绘(ESV)' "m1", '数字线划图' "m2", '平方千米' "m3", 0.0 "sizes" |
| | | select '测绘(ESV)' "m1", '数字线划图' "m2", '平方千米' "m3", 0.0 "sizes" |
| | | union all |
| | | select '测绘(ESV)' "m1", '数字正射影像图' "m2", '平方千米' "m3", 0.0 "sizes" |
| | | select '测绘(ESV)' "m1", '数字正射影像图' "m2", '平方千米' "m3", ( |
| | | select coalesce(sum(b.area), 0) from lf.sys_meta b |
| | | inner join lf.sys_dir c on b.dircode = c.code |
| | | where c.name = '数字正射影像图' and b.type in ('img', 'tif', 'tiff') ) "sizes" |
| | | union all |
| | | select '测绘(ESV)' "m1", '管线数据' "m2", '千米' "m3", cast( sum( st_length( st_geographyfromtext( st_astext(geom) ) ) ) / 1000 as decimal(12, 2) ) "sizes" from bs.m_pipeline |
| | | union all |
| | | select '勘察(EGE)' "m1", '勘探点' "m2", '个' "m3", count(*) "sizes" from bs.s_explorationpoint |
| | | union all |
| | | select '勘察(EGE)' "m1", '三维地质模型' "m2", '平方米' "m3", 0.0 "sizes" |
| | | select '勘察(EGE)' "m1", '三维地质模型' "m2", '平方米' "m3", ( |
| | | select coalesce(sum(b.area), 0) from lf.sys_meta b |
| | | inner join lf.sys_dir c on b.dircode = c.code |
| | | where b.type in ('fbx', 'ifc', 'rvt') ) "sizes" |
| | | union all |
| | | select '地灾(EGD)' "m1", '地灾点' "m2", '个' "m3", count(*) "sizes" from bd.b_geologic_hazard; |
| | | </select> |
| | |
| | | |
| | | <!-- 按项目统计数字高程模型面积 --> |
| | | <select id="countDemAreaByPrj" resultType="com.lf.server.entity.ctrl.CountEntity"> |
| | | select name "m1", 0.0 "area" |
| | | select name "m1", |
| | | (select coalesce(sum(b.area), 0) from lf.sys_meta b |
| | | inner join lf.sys_dir c on b.dircode = c.code |
| | | where c.name = '数字高程模型' and b.type in ('dem', 'tif', 'tiff') and b.depcode like a.code || '%') "area" |
| | | from lf.sys_dir a |
| | | where pid = 0 |
| | | order by code; |
| | | </select> |
| | | |
| | | <!-- 按项目统计三维地形模型面积 --> |
| | | <!-- 按项目统计三维地形模型面积:mpt --> |
| | | <select id="countMptAreaByPrj" resultType="com.lf.server.entity.ctrl.CountEntity"> |
| | | select name "m1", 0.0 "area" |
| | | from lf.sys_dir a |
| | |
| | | order by code; |
| | | </select> |
| | | |
| | | <!-- 按项目统计倾斜摄影模型面积 --> |
| | | <!-- 按项目统计倾斜摄影模型面积:osgb --> |
| | | <select id="countOsgbAreaByPrj" resultType="com.lf.server.entity.ctrl.CountEntity"> |
| | | select name "m1", 0.0 "area" |
| | | select name "m1", |
| | | (select coalesce(sum(area), 0) from lf.sys_meta b where b.type = 'osgb' and b.depcode like a.code || '%') "area" |
| | | from lf.sys_dir a |
| | | where pid = 0 |
| | | order by code; |
| | | </select> |
| | | |
| | | <!-- 按项目统计激光点云模型面积 --> |
| | | <!-- 按项目统计激光点云模型面积:las,laz --> |
| | | <select id="countLasAreaByPrj" resultType="com.lf.server.entity.ctrl.CountEntity"> |
| | | select name "m1", 0.0 "area" |
| | | select name "m1", |
| | | (select coalesce(sum(area), 0),count(*) from lf.sys_meta b where b.type in ('las', 'laz') and b.depcode like a.code || '%') "area" |
| | | from lf.sys_dir a |
| | | where pid = 0 |
| | | order by code; |