{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["area","point","target","aim","zoomin","stragegy","fire_door_param"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"area","index":0,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","area"]
["表描述","区域信息"]
[]
["字段","类型","长度","NotNull","注释","备注"]
["id","int",11,"Y","区域id"]
["area_name","text",null,"Y","区域名称"]
["type","int",11,"Y","区域类型","1：供电公司 2：变电站 3：区域 4：间隔/机柜"]
["type_name","text",null,"Y","类型名称","供电公司;变电站;区域;间隔/机柜"]
["pre_level","int",11,"Y","上级区域id"]

{"sheet":"point","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","point"]
["表描述","停靠点"]
[]
["字段","类型","长度","不为空","注释","备注"]
["id","int",11,"Y","与巡检目标编号对应"]
["uuid","varchar",32,"Y","Point UID for mapping with RCPM"]
["type","int",11,"Y","种类：起点、充电点、交点、停靠点。"]
["absolute_pos_x","int",11,"Y","绝对物理位置X坐标 unit:mm"]
["absolute_pos_y","int",11,"Y","绝对物理位置Y坐标 unit:mm"]
["relative_pos_x","int",11,"Y","地图相对位置X坐标 unit:pix"]
["relative_pos_y","int",11,"Y","地图相对位置Y坐标 unit:pix"]
["yaw","double",null,"Y","机器人朝向"]
["note","text",null,"N"]

{"sheet":"target","index":2,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","target"]
["表描述","巡检目标信息表(描述信息，巡检目标物理信息及描述信息)"]
[]
["字段","类型","长度","NotNull","注释","备注"]
["id","int",null,"Y","编号"]
["point_id","int",null,"Y","停靠点编号 与停靠点编号对应"]
["name","varchar",null,"N","巡检目标名称"]
["unit","varchar",null,"N","数据单位"]
["info_0","int",null,"N","通用描述信息:关联区域管理 lv1 id(供电公司id)"]
["info_1","int",null,"N","通用描述信息:关联区域管理 lv2 id（变电站id）\n"]
["info_2","int",null,"N","通用描述信息:关联区域管理 lv3 id（间隔/机柜id）\n"]
["info_3","int",null,"N","通用描述信息:关联区域管理 lv4 id（小类设备id）"]
["info_4","int",null,"N","通用描述信息"]
["info_5","int",null,"N","通用描述信息"]
["info_6","int",null,"N","通用描述信息"]
["info_7","int",null,"N","通用描述信息"]
["info_8","int",null,"N","通用描述信息"]
["info_9","int",null,"N","通用描述信息：关联算法类型 大类编码（1：图像识别 2：红外检测 3：局放检测 4：环境检测 5：声音检测）\n"]
["info_10","int",null,"N","通用描述信息"]
["info_11","int",null,"N","通用描述信息"]
["info_12","int",null,"N","通用描述信息"]
["info_13","int",null,"N","通用描述信息"]
["info_14","int",null,"N","通用描述信息"]
["info_15","int",null,"N","通用描述信息"]
["info_16","int",null,"N","通用描述信息"]
["info_17","int",null,"N","通用描述信息"]
["info_18","int",null,"N","通用描述信息"]
["info_19","int",null,"N","通用描述信息"]

{"sheet":"aim","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","aim"]
["表描述","巡检目标瞄准控制参数表(控制信息，AGV在远景状态下瞄准巡检目标的云台控制参数)"]
[]
["字段","类型","长度","NotNull","注释","备注"]
["id","long",null,"Y","与巡检目标编号对应"]
["roll","double",null,"Y","云台滚转角"]
["pitch","double",null,"Y","云台俯仰角"]
["yaw","double",null,"Y","云台方位角"]
["height","double",null,"Y","云台高度"]
["focus","int",null,"Y","云台焦距"]
["ratio","double",null,"Y","云台放大倍数"]
["aperture","int",null,"Y","云台光圈大小"]
["topleft_x","int",null,"Y","目标框选左上角X坐标"]
["topleft_y","int",null,"Y","目标框选左上角Y坐标"]
["botright_x","int",null,"Y","目标框选右下角X坐标"]
["botright_y","int",null,"Y","目标框选右下角Y坐标"]

{"sheet":"zoomin","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","zoomin"]
["表描述","巡检目标抵近控制参数表(控制信息，AGV在远景状态下瞄准巡检目标的云台控制参数。)"]
[]
["字段","类型","长度","NotNull","注释","备注*10"]
["id","long",null,"Y","与巡检目标编号对应"]
["roll","double",null,"Y","云台滚转角"]
["pitch","double",null,"Y","云台俯仰角","elevation"]
["yaw","double",null,"Y","云台方位角","azimuth超过1800需-3600"]
["height","double",null,"Y","云台高度"]
["focus","int",null,"Y","云台焦距"]
["ratio","double",null,"Y","云台放大倍数","absoluteZoom"]
["aperture","int",null,"Y","云台光圈大小"]
["topleft_x","int",null,"Y","目标框选左上角X坐标"]
["topleft_y","int",null,"Y","目标框选左上角Y坐标"]
["botright_x","int",null,"Y","目标框选右下角X坐标"]
["botright_y","int",null,"Y","目标框选右下角Y坐标"]

{"sheet":"stragegy","index":5,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","stragegy"]
["表描述","巡检策略参数表(算法信息，包含目标识别算法需要的所有参数)"]
[]
["字段","类型","长度","NotNull","注释","备注"]
["id","int",null,"Y","编号"]
["target_id","int",null,"Y","巡检目标编号"]
["algorithm","int",null,"N","算法种类"]
["range_min","double",null,"N","量程下限"]
["range_max","double",null,"N","量程上限"]
["scale","double",null,"N","量程范围"]
["matrix","varchar",null,"N","阵列式巡检目标类型矩阵"]
["aim_pic","varchar",null,"N","瞄准图片模板"]
["zoomin_pic","varchar",null,"N","抵近图片模板"]
["param_0","varchar",null,"N","通用参数"]
["param_1","varchar",null,"N","通用参数：算法标记绘图点坐标"]
["param_2","varchar",null,"N","通用参数：标记类型刻度范围"]
["param_3","varchar",null,"N","通用参数"]
["param_4","varchar",null,"N","通用参数"]
["param_5","varchar",null,"N","通用参数"]
["param_6","varchar",null,"N","通用参数"]
["param_7","varchar",null,"N","通用参数"]
["param_8","varchar",null,"N","通用参数"]
["param_9","varchar",null,"N","通用参数"]
["param_10","varchar",null,"N","通用参数"]
["param_11","varchar",null,"N","通用参数"]
["param_12","varchar",null,"N","通用参数"]
["param_13","varchar",null,"N","通用参数"]
["param_14","varchar",null,"N","通用参数"]
["param_15","varchar",null,"N","通用参数"]
["param_16","varchar",null,"N","通用参数"]
["param_17","varchar",null,"N","通用参数"]
["param_18","varchar",null,"N","通用参数"]
["param_19","varchar",null,"N","通用参数算法参照值（例：{\"0\":\"开\",\"1\":\"合\",\"2\":\"\",\"3\":\"\",\"4\":\"\",\"5\":\"\",\"6\":\"\",\"7\":\"\",\"8\":\"\"}）"]

{"sheet":"fire_door_param","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","fire_door_param"]
["表描述","防火门参数"]
[]
["字段","类型","长度","NotNull","注释","备注"]
["no","int",null,"Y","与巡检目标编号对应"]
["ip","varchar",null,"Y","ip"]
["port","int",null,"Y","端口"]
["def_state","int",null,"Y","默认状态(0: 关, 1: 开)"]
["def_ang","int",null,"Y","默认角度,预留(0°~180°"]
["Name","varchar",null,"Y","名称(位置)"]