{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":160,"n_cols":13,"rows_kept":160,"cut":false,"hidden":false,"merged":[[1,0,43,0],[44,0,86,0],[87,0,129,0],[130,0,159,0],[1,1,16,1],[17,1,33,1],[34,1,43,1],[44,1,59,1],[60,1,76,1],[77,1,86,1],[87,1,102,1],[103,1,119,1],[120,1,129,1],[130,1,148,1],[150,1,159,1],[1,2,16,2],[17,2,33,2],[34,2,43,2],[44,2,59,2],[60,2,76,2],[77,2,86,2],[87,2,102,2],[103,2,119,2],[120,2,129,2],[130,2,148,2],[150,2,159,2],[2,12,8,12],[9,12,11,12]]}
["大类","表注释","表名","字段名","中文字段","字段类型","长度","非空","备注",null,"对应市级平台预警管理表字段","大屏处理逻辑补充"]
["燃气","监测报警属性结构表","RQ_JC_JCBJ","BSM","标识码","字符型",32,"M","自动生成，唯一",null,null,null,"预警来源：所有报警专项对应市级平台预警管理表字段“预警来源”的值都为“监测设备”"]
[null,null,null,"BJMC","报警名称","字符型",50,"M","-",null,"预警名称",null,"预警状态：所有报警专项\n1.当监测设备报警后，对应市级平台预警管理表字段“预警状态”的值都为“发布”；\n2.当监测设备的“处置状态”为“处置中”、“处置完成”，对应市级平台预警管理表字段“预警状态”的值都为“处置”；\n3.当监测设备的“报警是否解除”为“是”时，对应市级平台预警管理表字段“预警状态”的值都为“解除”。"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","程序自动生成，唯一"]
[null,null,null,"DWBSM","点位标识码","字符型",64,"M","关联监测点标识码"]
[null,null,null,"SBBSM","设备标识码","字符型",64,"M","关联监测设备标识码",null,"预警设备标识码"]
[null,null,null,"JCBJZB","监测报警指标","字符型",32,"M","见附录B表B.1监测设备及指标字典"]
[null,null,null,"DQBJJB","当前报警级别","字符型",16,"C","一级/二级/三级/四级；城市内涝 场景非必填",null,"预警级别"]
[null,null,null,"CCBJSJ","初次报警时间","时间日期型","-","M","-",null,"预警生成时间、预警上报时间"]
[null,null,null,"CCBJZ","初次报警值","浮点型",18.2,"M","初次触发报警的监测值",null,null,null,"预警设备名称：所有报警专项，通过“设备标识码”关联设备名称，此设备名称对应市级平台预警管理表字段“预警设备名称”"]
[null,null,null,"DQBJSJ","当前报警时间","时间日期型","-","M","-"]
[null,null,null,"DQBJZ","当前报警值","浮点型",18.2,"M","当前触发报警的监测值"]
[null,null,null,"LJBJPC","累计报警频次","整型","-","M","本次报警在报警解除之间所产生 的报警次数",null,null,null,"预警类型：此字段为字典值，报警暂时无此字段可以对应"]
[null,null,null,"BJSFJC","报警是否解除","布尔型","-","M","0(否)/1(是)",null,null,"预警为解除状态的预警从大屏实时预警列表里下架","预警报告：不确定“现场图片视频文件”是否能作为预警报告？"]
[null,null,null,"BJJCSJ","报警解除时间","时间日期型","-","C","当报警确认解除时， 填写报警解除 时间",null,"处置完成时间"]
[null,null,null,"BJJCSM","报警解除说明","字符型",255,"C","当报警确认解除时， 填写报警解除 说明"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明"]
[null,"报警分析属性结构表","rq_JC_BJFX","BSM","标识码","字符型",32,"M","自动生成，唯一"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","见监测报警属性表"]
[null,null,null,"BJDWWZ","报警点位位置","字符型",255,"M","-",null,"预警地址"]
[null,null,null,"XCPCRY","现场排查人员","字符型",32,"M","-",null,"处置人"]
[null,null,null,"XCPCRYSJ","现场排查人员手机","字符型",15,"M","-"]
[null,null,null,"DDXCSJ","到达现场时间","时间日期型","-","M","-"]
[null,null,null,"XCZKMS","现场状况描述","变长字符型","-","M","-",null,"预警简述"]
[null,null,null,"ZSRY","值守人员","字符型",32,"M","系统值守人员"]
[null,null,null,"ZSRYSJ","值守人员手机","字符型",15,"M","-"]
[null,null,null,"ZSRYDW","值守人员单位","字符型",100,"M","单位名称"]
[null,null,null,"ZSRYFXJS","值守人员分析简述","字符型",500,"M","-"]
[null,null,null,"XCRYFXBG","现场人员分析报告","二进制型","-","O","-",null,"分析报告"]
[null,null,null,"ZSRYFXSJ","值守人员分析时间","时间日期型","-","M","-"]
[null,null,null,"FXNR","分析内容","变长字符型","-","M","-",null,"研判分析"]
[null,null,null,"XCTPSPWJ","现场图片视频文件","二进制型","-","O","现场图片、视频文件",null,"增加该字段","预警详情页面也增加此字段及查看功能"]
[null,null,null,"GXSJ","更新时间","时间日期型","-","M","-"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明"]
[null,"报警处置属性结构表","rq_JC_BJCZ","BSM","标识码","字符型",32,"M","自动生成，唯一"]
[null,null,null,"XZQHDM","行政区划代码","字符型",6,"M","见附录A表A.1行政区划代码表",null,"行政区划"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","关联监测报警表"]
[null,null,null,"CZZT","处置状态","整型","-","M","1(处置中)/2(处置完成)",null,"处置状态"]
[null,null,null,"CZSJ","处置时间","时间日期型","-","M","-",null,"处置时间"]
[null,null,null,"CZNR","处置内容","变长字符型","-","M","-",null,"处置建议"]
[null,null,null,"CZBG","处置报告","二进制型","-","M","-",null,"处置报告"]
[null,null,null,"JLRY","记录人员","字符型",32,"M","-"]
[null,null,null,"GXSJ","更新时间","时间日期型","-","M","-"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明",null,"备注"]
["供水","监测报警","GS_JC_JCBJ","BSM","标识码","字符型",32,"M","自动生成，唯一"]
[null,null,null,"BJMC","报警名称","字符型",50,"M","-",null,"预警名称"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","程序自动生成，唯一"]
[null,null,null,"DWBSM","点位标识码","字符型",64,"M","关联监测点标识码"]
[null,null,null,"SBBSM","设备标识码","字符型",64,"M","关联监测设备标识码",null,"预警设备标识码"]
[null,null,null,"JCBJZB","监测报警指标","字符型",32,"M","见附录B表B.1监测设备及指标字典"]
[null,null,null,"DQBJJB","当前报警级别","字符型",16,"C","一级/二级/三级/四级；城市内涝 场景非必填",null,"预警级别"]
[null,null,null,"CCBJSJ","初次报警时间","时间日期型","-","M","-",null,"预警生成时间、预警上报时间"]
[null,null,null,"CCBJZ","初次报警值","浮点型",18.2,"M","初次触发报警的监测值"]
[null,null,null,"DQBJSJ","当前报警时间","时间日期型","-","M","-"]
[null,null,null,"DQBJZ","当前报警值","浮点型",18.2,"M","当前触发报警的监测值"]
[null,null,null,"LJBJPC","累计报警频次","整型","-","M","本次报警在报警解除之间所产生 的报警次数"]
[null,null,null,"BJSFJC","报警是否解除","布尔型","-","M","0(否)/1(是)"]
[null,null,null,"BJJCSJ","报警解除时间","时间日期型","-","C","当报警确认解除时， 填写报警解除 时间",null,"处置完成时间"]
[null,null,null,"BJJCSM","报警解除说明","字符型",255,"C","当报警确认解除时， 填写报警解除 说明"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明"]
[null,"报警分析","GS_JC_BJFX","BSM","标识码","字符型",32,"M","自动生成，唯一"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","见监测报警属性表"]
[null,null,null,"BJDWWZ","报警点位位置","字符型",255,"M","-",null,"预警地址"]
[null,null,null,"XCPCRY","现场排查人员","字符型",32,"M","-",null,"处置人"]
[null,null,null,"XCPCRYSJ","现场排查人员手机","字符型",15,"M","-"]
[null,null,null,"DDXCSJ","到达现场时间","时间日期型","-","M","-"]
[null,null,null,"XCZKMS","现场状况描述","变长字符型","-","M","-",null,"预警简述"]
[null,null,null,"ZSRY","值守人员","字符型",32,"M","系统值守人员"]
[null,null,null,"ZSRYSJ","值守人员手机","字符型",15,"M","-"]
[null,null,null,"ZSRYDW","值守人员单位","字符型",100,"M","单位名称"]
[null,null,null,"ZSRYFXJS","值守人员分析简述","字符型",500,"M","-"]
[null,null,null,"XCRYFXBG","现场人员分析报告","二进制型","-","O","-",null,"分析报告"]
[null,null,null,"ZSRYFXSJ","值守人员分析时间","时间日期型","-","M","-"]
[null,null,null,"FXNR","分析内容","变长字符型","-","M","-",null,"研判分析"]
[null,null,null,"XCTPSPWJ","现场图片视频文件","二进制型","-","O","现场图片、视频文件"]
[null,null,null,"GXSJ","更新时间","时间日期型","-","M","-"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明"]
[null,"报警处置","GS_JC_BJCZ","标识码","BSM","字符型",32,"M","自动生成，唯一"]
[null,null,null,"行政区划代码","XZQHDM","字符型",6,"M","见附录A表A.1行政区划代码表",null,"行政区划"]
[null,null,null,"报警编号","BJBH","字符型",64,"M","关联监测报警表"]
[null,null,null,"处置状态","CZZT","整型","-","M","1(处置中)/2(处置完成)",null,"处置状态"]
[null,null,null,"处置时间","CZSJ","时间日期型","-","M","-",null,"处置时间"]
[null,null,null,"处置内容","CZNR","变长字符型","-","M","-",null,"处置建议"]
[null,null,null,"处置报告","CZBG","二进制型","-","M","-",null,"处置报告"]
[null,null,null,"记录人员","JLRY","字符型",32,"M","-"]
[null,null,null,"更新时间","GXSJ","时间日期型","-","M","-"]
[null,null,null,"备注","BZ","字符型",255,"O","相关事项说明",null,"备注"]
["排水","监测报警","PS_JC_JCBJ","标识码","BSM","字符型",32,"M","自动生成，唯一"]
[null,null,null,"报警名称","BJMC","字符型",50,"M","-",null,"预警名称"]
[null,null,null,"报警编号","BJBH","字符型",64,"M","程序自动生成，唯一"]
[null,null,null,"点位标识码","DWBSM","字符型",64,"M","关联监测点标识码"]
[null,null,null,"设备标识码","SBBSM","字符型",64,"M","关联监测设备标识码",null,"预警设备标识码"]
[null,null,null,"监测报警指标","JCBJZB","字符型",32,"M","见附录B表B.1监测设备及指标字典"]
[null,null,null,"当前报警级别","DQBJJB","字符型",16,"C","一级/二级/三级/四级；城市内涝 场景非必填",null,"预警级别"]
[null,null,null,"初次报警时间","CCBJSJ","时间日期型","-","M","-",null,"预警生成时间、预警上报时间"]
[null,null,null,"初次报警值","CCBJZ","浮点型",18.2,"M","初次触发报警的监测值"]
[null,null,null,"当前报警时间","DQBJSJ","时间日期型","-","M","-"]
[null,null,null,"当前报警值","DQBJZ","浮点型",18.2,"M","当前触发报警的监测值"]
[null,null,null,"累计报警频次","LJBJPC","整型","-","M","本次报警在报警解除之间所产生 的报警次数"]
[null,null,null,"报警是否解除","BJSFJC","布尔型","-","M","0(否)/1(是)"]
[null,null,null,"报警解除时间","BJJCSJ","时间日期型","-","C","当报警确认解除时， 填写报警解除 时间",null,"处置完成时间"]
[null,null,null,"报警解除说明","BJJCSM","字符型",255,"C","当报警确认解除时， 填写报警解除 说明"]
[null,null,null,"备注","BZ","字符型",255,"O","相关事项说明"]
[null,"报警分析","PS_JC_BJFX","标识码","BSM","字符型",32,"M","自动生成，唯一"]
[null,null,null,"报警编号","BJBH","字符型",64,"M","见监测报警属性表"]
[null,null,null,"报警点位位置","BJDWWZ","字符型",255,"M","-",null,"预警地址"]
[null,null,null,"现场排查人员","XCPCRY","字符型",32,"M","-",null,"处置人"]
[null,null,null,"现场排查人员手机","XCPCRYSJ","字符型",15,"M","-"]
[null,null,null,"到达现场时间","DDXCSJ","时间日期型","-","M","-"]
[null,null,null,"现场状况描述","XCZKMS","变长字符型","-","M","-",null,"预警简述"]
[null,null,null,"值守人员","ZSRY","字符型",32,"M","系统值守人员"]
[null,null,null,"值守人员手机","ZSRYSJ","字符型",15,"M","-"]
[null,null,null,"值守人员单位","ZSRYDW","字符型",100,"M","单位名称"]
[null,null,null,"值守人员分析简述","ZSRYFXJS","字符型",500,"M","-"]
[null,null,null,"现场人员分析报告","XCRYFXBG","二进制型","-","O","-",null,"分析报告"]
[null,null,null,"值守人员分析时间","ZSRYFXSJ","时间日期型","-","M","-"]
[null,null,null,"分析内容","FXNR","变长字符型","-","M","-",null,"研判分析"]
[null,null,null,"现场图片视频文件","XCTPSPWJ","二进制型","-","O","现场图片、视频文件"]
[null,null,null,"更新时间","GXSJ","时间日期型","-","M","-"]
[null,null,null,"备注","BZ","字符型",255,"O","相关事项说明"]
[null,"报警处置","PS_JC_BJCZ","标识码","BSM","字符型",32,"M","自动生成，唯一"]
[null,null,null,"行政区划代码","XZQHDM","字符型",6,"M","见附录A表A.1行政区划代码表",null,"行政区划"]
[null,null,null,"报警编号","BJBH","字符型",64,"M","关联监测报警表"]
[null,null,null,"处置状态","CZZT","整型","-","M","1(处置中)/2(处置完成)",null,"处置状态"]
[null,null,null,"处置时间","CZSJ","时间日期型","-","M","-",null,"处置时间"]
[null,null,null,"处置内容","CZNR","变长字符型","-","M","-",null,"处置建议"]
[null,null,null,"处置报告","CZBG","二进制型","-","M","-",null,"处置报告"]
[null,null,null,"记录人员","JLRY","字符型",32,"M","-"]
[null,null,null,"更新时间","GXSJ","时间日期型","-","M","-"]
[null,null,null,"备注","BZ","字符型",255,"O","相关事项说明",null,"备注"]
["桥梁","监测报警","ql_jc_jcbj","标识码","bsm","varchar",32]
[null,null,null,"设备标识码","sbbsm","varchar",64,null,null,null,"预警设备标识码"]
[null,null,null,"点位标识码","dwbsm","varchar",64]
[null,null,null,"报警编号","bjbh","varchar",64]
[null,null,null,"报警名称","bjmc","varchar",50,null,null,null,"预警名称"]
[null,null,null,"初次报警时间","ccbjsj","date",0,null,null,null,"预警生成时间、预警上报时间"]
[null,null,null,"初次报警值","ccbjz","numeric",18]
[null,null,null,"当前报警级别","dqbjjb","varchar",16,null,null,null,"预警级别"]
[null,null,null,"当前报警时间","dqbjsj","date",0]
[null,null,null,"当前报警值","dqbjz","numeric",18]
[null,null,null,"监测报警指标","jcbjzb","varchar",32]
[null,null,null,"累计报警频次","ljbjpc","int4",32]
[null,null,null,"报警解除时间","bjjcsj","date",0,null,null,null,"处置完成时间"]
[null,null,null,"报警解除说明","bjjcsm","varchar",255]
[null,null,null,"报警是否解除","bjsfjc","varchar",1]
[null,null,null,"备注","bz","varchar",255]
[null,null,null,"原始库主键标志","yskzjbz","varchar",32]
[null,null,null,"数据同步状态","sjtbzt","varchar",16]
[null,null,null,"同步时间","tbsj","date",0]
[null,"报警分析","ql_jc_bjifx",{"$nulls":7},"前置库无此表"]
[null,"报警处置","ql_jc_bjcz","标识码","bsm","varchar",32]
[null,null,null,"行政区划代码","xzqhdm","varchar",6,null,null,null,"行政区划"]
[null,null,null,"报警编号","bjbh","varchar",64]
[null,null,null,"处置报告","czbg","varchar",255,null,null,null,"处置报告"]
[null,null,null,"处置内容","cznr","varchar",100,null,null,null,"处置建议"]
[null,null,null,"处置时间","czsj","date",0,null,null,null,"处置时间"]
[null,null,null,"处置状态","czzt","int4",32,null,null,null,"处置状态"]
[null,null,null,"更新时间","gxsj","date",0]
[null,null,null,"记录人员","jlry","varchar",32]
[null,null,null,"备注","bz","varchar",255,null,null,null,"备注"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}