| | |
| | | --delete from bs.s_explorationpointstratum where parentid in (select eventid from lf.sys_meta where name='勘探点地层表.xlsx'); |
| | | select * from lf.sys_meta where type = 'tif' or type = 'tiff' or lower(name) in ('平面图索引文件.xlsx', '穿跨越地形图.dwg', '中线成果表.xlsx', '离散点.xlsx', '控制点.xlsx', '地面线.xlsx'); |
| | | |
| | | set autocommit off; |
| | | -- delete from lf.sys_apply where id > 47; delete from lf.sys_flow where applyid > 47; |
| | | select * from lf.sys_layer where position('SG' in url) > 0 order by id desc; |
| | | select * from lf.sys_layer order by id desc; |
| | |
| | | select * from lf.sys_dict order by id desc; |
| | | select * from lf.sys_meta where type in ('3dml'); |
| | | select * from lf.sys_ars; |
| | | |
| | | -- ALL -> 560, type=2 -> 442, WMS -> 340, url=null -> 77, type=2 & url -> 25, .json -> 17 |
| | | select serve_type from lf.sys_layer group by serve_type; |
| | | update lf.sys_layer set serve_type = null where type = 2; |
| | | update lf.sys_layer set serve_type = 'WMS' where type = 2 and position('LF:' in url) > 0; |
| | | update lf.sys_layer set serve_type = '3DML' where type = 2 and serve_type is null and position('b3dm' in url) > 0; |
| | | update lf.sys_layer set serve_type = 'Tileset' where type = 2 and serve_type is null and position('.json' in url) > 0; |
| | | update lf.sys_layer set serve_type = 'TMS' where type = 2 and serve_type is null and position('.png' in url) > 0; |
| | | update lf.sys_layer set serve_type = 'Mpt' where type = 2 and serve_type is null and position('.mpt' in url) > 0; |
| | | update lf.sys_layer set serve_type = 'DEM' where type = 2 and serve_type is null and position('terrain/' in url) > 0; |
| | | |
| | | select id, pid, cn_name, en_name, url, serve_type, data_type, elev, pubid, is_project, bak |
| | | from lf.sys_layer |
| | | where type = 2 and serve_type is not null |
| | | order by id; |
| | | |
| | | |
| | | |
| | |
| | | </select> |
| | | |
| | | <!-- 统计全国管网图输送介质长度 --> |
| | | <select id="countZhPipeMapLenByMed" resultType="java.util.Map"> |
| | | <!--select id="countZhPipeMapLenByMed" resultType="java.util.Map"> |
| | | SELECT medium AS type,count(*) AS count,sum(length)AS length FROM bs.m_pipesegment GROUP BY medium ; |
| | | </select--> |
| | | <select id="countZhPipeMapLenByMed" resultType="java.util.Map"> |
| | | select case medium when 'CO' then '原油' when 'RP' then '成品油' when 'GS' then '天然气' else '其它' end "type", |
| | | count(*) "count", round(sum(ST_Length(geom)::numeric), 2) "length" |
| | | from bs.m_pipeline |
| | | group by medium; |
| | | </select> |
| | | |
| | | <!-- 统计全国站场座数、阀室、管道数等 --> |
| | | <!-- 统计全国站场座数、阀室、管道数量 --> |
| | | <select id="countZhPipeStations" resultType="java.util.Map"> |
| | | select |
| | | case medium when 'CPY' then '成品油' when 'TRQ' then '天然气' when 'YY' then '原油' else '其它' end "输送介质", |
| | | case medium when 'CO' then '原油' when 'RP' then '成品油' when 'GS' then '天然气' else '其它' end "输送介质", |
| | | round(sum(st_length(geom))::numeric, 2) "总里程", |
| | | count(*) "管道数量", |
| | | (select count(*) from bs.m_sitepoint b inner join bs.m_pipeline c on b.pipename = c.pipename where c.medium = a.medium) "站场数量", |