programs_info/无锡市生命线项目/其他文件/视图创建语句.txt

 SELECT 'rq_jg_fxpg'::text AS "table",
    '燃气'::text AS type,
    '1'::text AS code,
    rq_jg_fxpg.bsm,
    rq_jg_fxpg.xzqhdm,
    rq_jg_fxpg.fxdj,
    rq_jg_fxpg.fxms,
    rq_jg_fxpg.gkzt,
    rq_jg_fxpg.pgsj,
    rq_jg_fxpg.kjxx,
    rq_jg_fxpg.tbsj
   FROM citylifeline.rq_jg_fxpg
UNION
 SELECT 'gs_jg_gwfxhczxx'::text AS "table",
    '供水'::text AS type,
    '2'::text AS code,
    gs_jg_gwfxhczxx.bsm,
    gs_jg_gwfxhczxx.xzqhdm,
    gs_jg_gwfxhczxx.fxdj,
    gs_jg_gwfxhczxx.fxms,
    gs_jg_gwfxhczxx.gkzt,
    gs_jg_gwfxhczxx.pgsj,
    gs_jg_gwfxhczxx.kjxx,
    gs_jg_gwfxhczxx.tbsj
   FROM citylifeline.gs_jg_gwfxhczxx
UNION
 SELECT 'ps_jg_ysfxgk'::text AS "table",
    '内涝'::text AS type,
    '3'::text AS code,
    ps_jg_ysfxgk.bsm,
    ps_jg_ysfxgk.xzqhdm,
    ps_jg_ysfxgk.fxdj::integer AS fxdj,
    ''::character varying AS fxms,
        CASE
            WHEN ps_jg_ysfxgk.sfgk THEN 1
            ELSE 0
        END AS gkzt,
    ps_jg_ysfxgk.tbsj AS pgsj,
    NULL::geometry AS kjxx,
    ps_jg_ysfxgk.tbsj
   FROM citylifeline.ps_jg_ysfxgk
UNION
 SELECT 'dl_jc_dltxfx'::text AS "table",
    '道路'::text AS type,
    '4'::text AS code,
    dl_jc_dltxfx.bsm,
    dl_jc_dltxfx.xzqhdm,
    dl_jc_dltxfx.fxdj,
    ''::character varying AS fxms,
    NULL::integer AS gkzt,
    dl_jc_dltxfx.pgsj,
    dl_jc_dltxfx.kjxx,
    dl_jc_dltxfx.tbsj
   FROM citylifeline.dl_jc_dltxfx
UNION
 SELECT 'ql_jg_fxpg'::text AS "table",
    '桥梁'::text AS type,
    '5'::text AS code,
    ql_jg_fxpg.bsm,
    ql_jg_fxpg.xzqhdm,
    ql_jg_fxpg.fxdj,
    ''::character varying AS fxms,
    NULL::integer AS gkzt,
    ql_jg_fxpg.pgsj,
    ql_jg_fxpg.kjxx,
    ql_jg_fxpg.tbsj
   FROM citylifeline.ql_jg_fxpg
UNION
 SELECT 'zh_jg_jhfxyh'::text AS "table",
    '管线'::text AS type,
    '6'::text AS code,
    zh_jg_jhfxyh.bsm,
    zh_jg_jhfxyh.xzqhdm,
    NULL::integer AS fxdj,
    zh_jg_jhfxyh.yhmc AS fxms,
        CASE
            WHEN zh_jg_jhfxyh.czwcsj IS NOT NULL THEN 1
            ELSE 0
        END AS gkzt,
    zh_jg_jhfxyh.sbsj AS pgsj,
    NULL::geometry AS kjxx,
    zh_jg_jhfxyh.tbsj
   FROM citylifeline.zh_jg_jhfxyh
UNION
 SELECT 'zy_js_zdwxy'::text AS "table",
    '第三方施工'::text AS type,
    '7'::text AS code,
    zy_js_zdwxy.bsm,
    zy_js_zdwxy.xzqhdm,
        CASE
            WHEN zy_js_zdwxy.wxjb IS NOT NULL THEN 1
            ELSE 0
        END AS fxdj,
    zy_js_zdwxy.wxymc AS fxms,
    NULL::integer AS gkzt,
    zy_js_zdwxy.extract_time AS pgsj,
    zy_js_zdwxy.kjxx,
    zy_js_zdwxy.sjtbsj AS tbsj
   FROM citylifeline.zy_js_zdwxy



7大危险数据总统计表