路灯运行监控管理数据集

路灯运行监控管理数据集属自行生产的企业数据，数据采集依托城市道路两侧智能灯杆，每根灯杆安装具备4G通信能力的终端模块，每小时自动采集一次多维度数据并通过4G网络上传，覆盖籍山大道等路段灯杆及附属设备。数据构成含38753条记录，共27个字段；原始数据涵盖设备标识（灯杆编号、设备ID等）、运行状态（信号质量、开关状态等）、环境参数（温度、照度）、能耗参数（电流、电压、功率等）；经清洗（去异常值、去重、补缺失值）与标准化（时间格式统一为东八区“YYYY-MM-DD HH:MM:SS”、开关状态编码、用电量转kWh单位）后入库，同时解析extra_json提取扩展属性，形成结构化数据集。This street lamp operation monitoring and management dataset consists of self-generated enterprise internal data. Data collection is carried out via smart lamp poles on both sides of urban roads: each pole is equipped with a terminal module supporting 4G communication, which automatically collects multi-dimensional data every hour and uploads the data through the 4G network. The dataset covers lamp poles and their auxiliary equipment on road sections such as Jishan Avenue. The dataset contains 38,753 records and a total of 27 fields. The raw data covers multiple categories: equipment identification (including lamp pole number, device ID, etc.), operating status (including signal quality, switch status, etc.), environmental parameters (including temperature, illuminance), and energy consumption parameters (including current, voltage, power, etc.). After undergoing data cleaning (outlier removal, deduplication, and missing value imputation) and standardization (unifying the time format to "YYYY-MM-DD HH:MM:SS" in the East 8 Time Zone, encoding switch status, converting electricity consumption to kWh units), the data was stored in the database. Meanwhile, extended attributes were extracted by parsing the "extra_json" field to form a structured dataset.

搜集汇总

背景与挑战

背景概述

该数据集是一个城市路灯运行监控管理数据集，基于智能灯杆每小时自动采集的多维度数据，覆盖籍山大道等路段，包含38753条记录和27个字段，涵盖设备标识、运行状态、环境参数和能耗参数。数据经过清洗和标准化处理，如统一时间格式、编码开关状态和转换用电量单位，形成结构化数据集，适用于实时监控和智能照明管理分析。