| | |
|---|
| | | group by name |
|---|
| | | order by name; |
|---|
| | | -- select * from lf.sys_meta where dircode similar to fn_dir_similar('基础测绘'); |
|---|
| | | |
|---|
| | | -- 单个项目的下载个数、下载次数和数据总量 |
|---|
| | | select count(*) "下载个数", sum(c.dcount) "下载数量", round(sum(c.dcount * c.sizes)::numeric, 3) "数量总量(MB)" |
|---|
| | | from lf.sys_meta a inner join lf.sys_meta_down b on a.id = b.metaid |
|---|
| | | inner join lf.sys_download c on b.downid = c.id |
|---|
| | | where dircode like '06%'; |
|---|
| | | |
|---|
| | | -- 按照输送介质统计 |
|---|
| | | select |
|---|
| | | case medium when 'CPY' then '成品油' when 'TRQ' then '天然气' when 'YY' 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) "站场数量", |
|---|
| | | (select count(*) from bs.m_valvehousepoint d inner join bs.m_pipeline e on d.pipename = e.pipename where e.medium = a.medium) "阀室数量" |
|---|
| | | from bs.m_pipeline a |
|---|
| | | group by medium; |
|---|
| | | -- select * from lf.sys_domain where dom_name='dsg0016'; |
|---|
| | | --------------------------------------------------------- |
|---|
| | | select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" |
|---|
| | | from lf.sys_dir a |
|---|
| | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | select a.*, fn_tab_count(a.ns, a.tab, '1=1') "rows" from |
|---|
| | | (select distinct ns,tab,fn_get_entity(tab) entity,tab_desc,tableType from lf.sys_dict |
|---|
| | | order by tab |
|---|
