阿里云物联网

最新推荐文章于 2023-05-26 16:10:23 发布

原创最新推荐文章于 2023-05-26 16:10:23 发布 · 198 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

7 篇文章

订阅专栏

该查询涉及到物联网设备的数据上报，包括设备ID、产品ID、地理位置、温度、湿度、降雨量、PM2.5指数、噪音水平、液位、垃圾箱满载状态、阀门位置、扩展参数、电压和功率模式等关键信息。这些数据可用于实时监控和智能分析，以提升设备管理和运营效率。

规则查询语句：

SELECT topic(1) as productKey, attribute('deviceidkey') as deviceidkey, attribute('productid') as product_id, deviceName() as deviceName, attribute('tag') as tag, attribute('coordinate') as gprs_gd, items.temper.value as temperature, items.humidity.value as humidity, items.rain.value as rain, items.PM25.value as PM25, items.noise.value as noise, items.liquidLevel.value as liquidLevel,items.wasteLevel.value as wasteLevel, items.valvePosition.value as valvePosition, items.extendParam.value as extendParam, items.voltage.value as voltage, items.voltage1.value as voltage1, items.pwrMode.value as pwrMode, items.virtualDev.value as virtualDev, items.ctrlMode.value as ctrlMode, to_base64(*) as baseContentAli, timestamp('yyyy-MM-dd HH:mm:ss') as time FROM "/a1ttYz/+/thing/event/property/post"