IoT Sensors - Sensus Water Meters (English, CSV)
Explore the interactive map. IoT Sensors - Sensus Water Meters: English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From City of Fredericton, updated Feb 2025.
- Format
- CSV
- Access
- Table on demand (prepared when opened) and interactive map
- Fields
- 16
- Publisher-reported update
- 2025-02-08
This layer is a view between the IoT Sensors feature layer and the table storing sensor information for Sensus manufactured sensors. These sensors measure the flow of water and are installed at several arenas. There is a 1-1 relationship between the sensor feature and the table resulting in only the most recent record of information displaying for the sensor. This layer gives access to published data from the City of Fredericton IoT sensors. The features represent static locations for each of the sensors while the attributes are updated in real-time.
Data overview
- Formats
- CSV
- File languages
- English
- Available actions
- Explore table (prepared automatically) · Explore map · Access original file
Available fields (16/16)
Fields from the recorded map schema.
| Field | Recorded type |
|---|---|
| ObjectId | esriFieldTypeOID |
| Name | esriFieldTypeString |
| DevEUI | esriFieldTypeString |
| Type | esriFieldTypeString |
| TableName | esriFieldTypeString |
| BatteryPercentage | esriFieldTypeInteger |
| AccelerationDetected | esriFieldTypeInteger |
| AccelerationX | esriFieldTypeDouble |
| AccelerationY | esriFieldTypeDouble |
| AccelerationZ | esriFieldTypeDouble |
| MeterReading | esriFieldTypeInteger |
| Alarm | esriFieldTypeInteger |
| MeterManufacturer | esriFieldTypeInteger |
| Temperature | esriFieldTypeDouble |
| Timestamp | esriFieldTypeDate |
| DevEUI_1625699872329 | esriFieldTypeString |
Sample rows
The first 4 rows, as CanQuery read them from the start of the publisher's file on 2026-11-06.
| X | Y | DevEUI | Type | Name | TableName | BatteryPercentage | AccelerationDetected | AccelerationX | AccelerationY | AccelerationZ | MeterReading | Alarm | MeterManufacturer | Temperature | Timestamp | DevEUI_1625699872329 | ObjectId |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| -7418000.39229143 | 5773001.75804419 | 70b3b514900b018c | Climate | Sensus1 18c | Sensus | 16.9 | 2022/12/05 06:50:24.078+00 | 70b3b514900b018c | 1 | ||||||||
| -7418507.32076972 | 5768248.42476312 | 70b3b514900b0024 | Climate | Sensus1 024 | Sensus | 4 | 13.6 | 2022/12/05 06:54:20.524+00 | 70b3b514900b0024 | 2 | |||||||
| -7415882.51604727 | 5776965.28273511 | 70b3b514900b0035 | Climate | Sensus1 035 | Sensus | 191481 | 14 | 2022/12/05 06:11:17.872+00 | 70b3b514900b0035 | 3 | |||||||
| -7418679.80130382 | 5774509.5081982 | 70b3b514900b014d | Climate | Sensus1 14d (unknown location) | Sensus | 1 | 21.5 | 2022/12/05 06:21:54.842+00 | 70b3b514900b014d | 4 |