programs_info/无锡市生命线项目/数据库备份/删除前备份/view_risk_collect备份.txt

 view_risk_collect
7大危险数据总统计表
SELECT 'rq_jg_fxpg'::text AS "table",
    '0'::text AS type,
    '燃气'::text AS code,
    NULL::text AS childtype,
    rq_jg_fxpg.bsm,
    rq_jg_fxpg.xzqhdm,
    rq_jg_fxpg.fxdj,
    rq_jg_fxpg.fxms AS fxmc,
    rq_jg_fxpg.fxms,
    rq_jg_fxpg.gkzt::character varying AS dispose_progress,
    rq_jg_fxpg.gkzt,
    rq_jg_fxpg.fxlx,
    NULL::text AS is_often,
    rq_jg_fxpg.pgsj,
    rq_jg_fxpg.kjxx,
    rq_jg_fxpg.tbsj,
    rq_jg_fxpg.zrdw,
    rq_jg_fxpg.pgdw,
    60 AS pgfz
   FROM rq_jg_fxpg
UNION ALL
 SELECT 'gs_jg_gwfxhczxx'::text AS "table",
    '2'::text AS type,
    '供水'::text AS code,
    NULL::text AS childtype,
    gs_jg_gwfxhczxx.bsm,
    gs_jg_gwfxhczxx.xzqhdm,
    gs_jg_gwfxhczxx.fxdj,
    gs_jg_gwfxhczxx.fxms AS fxmc,
    gs_jg_gwfxhczxx.fxms,
    gs_jg_gwfxhczxx.gkzt::character varying AS dispose_progress,
    gs_jg_gwfxhczxx.gkzt,
    NULL::integer AS fxlx,
    NULL::text AS is_often,
    gs_jg_gwfxhczxx.pgsj,
    gs_jg_gwfxhczxx.kjxx,
    gs_jg_gwfxhczxx.tbsj,
    NULL::text AS zrdw,
    gs_jg_gwfxhczxx.pgdw,
    60 AS pgfz
   FROM gs_jg_gwfxhczxx
UNION ALL
 SELECT 'ps_jg_ysfxgk'::text AS "table",
    '1'::text AS type,
    '内涝'::text AS code,
    '雨水'::text AS childtype,
    ps_jg_ysfxgk.bsm,
    ps_jg_ysfxgk.xzqhdm,
    ps_jg_ysfxgk.fxdj::integer AS fxdj,
    ps_jg_ysfxgk.fxmc,
    ps_jg_ysfxgk.fxmc AS fxms,
        CASE
            WHEN ps_jg_ysfxgk.sfgk THEN '1'::text
            ELSE '0'::text
        END AS dispose_progress,
    1 AS gkzt,
    NULL::integer AS fxlx,
    NULL::text AS is_often,
    NULL::timestamp without time zone AS pgsj,
    ps_jg_ysfxgk.kjxx,
    ps_jg_ysfxgk.tbsj,
    NULL::text AS zrdw,
    NULL::text AS pgdw,
    60 AS pgfz
   FROM ps_jg_ysfxgk
UNION ALL
 SELECT 'ps_js_yld'::text AS "table",
    '1'::text AS type,
    '内涝'::text AS code,
    '易涝点'::text AS childtype,
    ps_js_yld.bsm,
    ps_js_yld.xzqhdm,
    ps_js_yld.fxdj::integer AS fxdj,
    ps_js_yld.mc AS fxmc,
    ps_js_yld.mc AS fxms,
    '1'::character varying AS dispose_progress,
    1 AS gkzt,
    NULL::integer AS fxlx,
    NULL::text AS is_often,
    NULL::timestamp without time zone AS pgsj,
    ps_js_yld.kjxx,
    ps_js_yld.tbsj,
    NULL::text AS zrdw,
    NULL::text AS pgdw,
    60 AS pgfz
   FROM ps_js_yld
UNION ALL
 SELECT 'dl_jc_dltxfx'::text AS "table",
    '6'::text AS type,
    '道路'::text AS code,
    NULL::text AS childtype,
    dl_jc_dltxfx.bsm,
    dl_jc_dltxfx.xzqhdm,
    dl_jc_dltxfx.fxdj,
    dl_jc_dltxfx.gcmc AS fxmc,
    dl_jc_dltxfx.gcmc AS fxms,
    '1'::character varying AS dispose_progress,
    1 AS gkzt,
    NULL::integer AS fxlx,
    NULL::text AS is_often,
    dl_jc_dltxfx.pgsj,
    dl_jc_dltxfx.kjxx,
    dl_jc_dltxfx.tbsj,
    NULL::text AS zrdw,
    NULL::text AS pgdw,
    dl_jc_dltxfx.pgfz
   FROM dl_jc_dltxfx
UNION ALL
 SELECT 'ql_jg_fxpg'::text AS "table",
    '5'::text AS type,
    '桥梁'::text AS code,
    NULL::text AS childtype,
    ql_jg_fxpg.bsm,
    ql_jg_fxpg.xzqhdm,
    ql_jg_fxpg.fxdj,
    ql_jg_fxpg.fxmc,
    ql_jg_fxpg.fxms,
    '1'::character varying AS dispose_progress,
    1 AS gkzt,
    NULL::integer AS fxlx,
    NULL::text AS is_often,
    ql_jg_fxpg.pgsj,
    ql_jg_fxpg.kjxx,
    ql_jg_fxpg.tbsj,
    NULL::text AS zrdw,
    NULL::text AS pgdw,
    60 AS pgfz
   FROM ql_jg_fxpg