Municipal IoT Asset Utilization Logs

This dataset provides detailed, timestamped logs of IoT-enabled municipal asset utilization, including asset identity, location, operational status, and key performance metrics. It enables city leaders and analysts to monitor resource allocation, detect anomalies, optimize asset deployment, and drive data-driven sustainability and efficiency strategies for smart cities.

  • last updated 4 Jan 2026
  • by GoMask
The brief that made it

Real-time monitoring and optimization of municipal asset usage

Sample rows

preview · 8 of 122 rows · all 21 columns
log_idstringevent_typestringsignal_strengthfloatutilization_metric_unitstringasset_idstringasset_typestringasset_namestringlocation_latitudefloatlocation_longitudefloatlocation_street_addressstringlocation_citystringlocation_statestringlocation_postal_codestringlocation_countrystringtimestampdatetimeutilization_statusstringutilization_metric_valuefloatevent_descriptionstringoperator_idstringbattery_levelfloatfirmware_versionstring
SL-9d2e1b8areading-62.5kWhSL-10001streetlightMaple St Light 140.7128-74.006120 Maple StNew YorkNY10001USA2024-05-15T19:25:48Zactive12.3Energy consumption reading at evening hours.ops-east-10192.4v2.5.1
WB-2e7f3c4dreading-75.2%WB-20002waste_binCentral Park Bin 540.7851-73.96835 Central Park SNew YorkNY10019USA2024-05-16T13:12:28Zactive58.7Daily fill level recorded.ops-east-10574.6v1.14.0
TS-8a4b3f1creading-56.8vehiclesTS-3001traffic_sensor5th Ave Sensor40.7755-73.9654520 5th AveNew YorkNY10022USA2024-05-15T11:00:00Zactive823Traffic count for the morning rush.ops-east-11068.2v3.2.1
ES-7c2d1e4breading-82.7ppmES-4001environmental_sensorDowntown CO2 Sensor-34.6037-58.3816Av. de Mayo 877Buenos AiresCABA1084Argentina2024-05-15T09:45:15Zactive412CO2 levels measured.ops-arg-20153.1v4.0.0
PM-6f1e3b2dreading-74.1GBPPM-5001parking_meterBond St Meter51.5138-0.150228 Bond StLondonLondonW1S 1RSUK2024-05-16T11:45:00Zactive2.6Parking fee collected.ops-uk-30166v2.1.1
SL-3c9b2e1dreading-59.6kWhSL-10002streetlightElm St Light 237.7749-122.4194450 Elm StSan FranciscoCA94102USA2024-05-15T20:17:30Zactive13.7Evening energy usage recorded.ops-west-10285.3v2.3.0
WB-7e1d3c4breading-70.5%WB-20003waste_binOpera Bin 248.87082.331512 Rue de l'OperaParisIDF75001France2024-05-16T10:35:10Zactive67.2Bin fill level monitored.ops-fr-20272.9v1.15.3
TS-4b8a1c3ereading-61.3vehiclesTS-3002traffic_sensorNevsky Sensor59.934330.335110 Nevsky AveSt PetersburgSPB191186Russia2024-05-15T13:00:00Zactive412Midday traffic flow recorded.ops-ru-20374.7v3.2.0

What the 122 rows show

from the 122-row sample

Error (event type) stands out: mean signal_strength is -129.2, against -75.2 for the rest.

  • -76.3median signal_strength
  • 5asset types
  • 5utilization statuses
  • 14firmware versions
  • 18location countries
  • 22.6median utilization_metric_value
signal_strength122 rows, in bands of 10
015306461924263016-140-90-50signal_strength →

Median -76.3, from -140.0 to -52.3.

utilization_metric_unit102 rows with a value · 20 left blank
  1. vehicles21
  2. kWh20
  3. %17
  4. ppm9
  5. C6
  6. EUR6
  7. W/m26
  8. GBP4
  9. kg4
  10. CNY4
21 columns by typefrom the column list below
  • string 15
  • float 5
  • datetime 1

Columns

21 columns in three groups
blueprint · 21 columns
columntypedescriptionexample
Text 15 columns
log_idstringUnique identifier for each asset utilization log entryuniqueSL-9d2e1b8a
asset_idstringUnique identifier for the IoT-enabled municipal assetSL-10001
asset_typestringType or category of the municipal asset (e.g., smart streetlight, waste bin, traffic sensor)6 valuesstreetlight
asset_namestringHuman-readable name or label for the assetoptionalMaple St Light 1
location_street_addressstringStreet address where the asset is locatedoptional120 Maple St
location_citystringCity where the asset is locatedNew York
location_statestringState or province where the asset is locatedNY
location_postal_codestringPostal code of the asset's locationoptional10001
location_countrystringCountry where the asset is locatedUSA
utilization_statusstringCurrent operational status of the asset during the log eventactive · idle · offline · maintenance · erroractive
utilization_metric_unitstringUnit of measurement for the utilization metric (e.g., kWh, %, vehicles, liters)optionalkWh
event_typestringType of event captured (e.g., reading, alert, maintenance)reading · alert · maintenance · error · otherreading
event_descriptionstringDetailed description of the event or log entryoptionalCO2 levels measured.
operator_idstringIdentifier for the operator or system responsible for the asset at the time of the eventoptionalops-east-101
firmware_versionstringFirmware version of the asset at the time of the eventoptionalv2.5.1
Numbers 5 columns
location_latitudefloatLatitude coordinate of the asset's location-90 to 9040.7128
location_longitudefloatLongitude coordinate of the asset's location-180 to 180-74.006
utilization_metric_valuefloatNumeric value representing the asset's utilization (e.g., energy consumed, fill level, traffic count)0 or more · optional12.3
battery_levelfloatBattery level of the asset at the time of the event (percentage, 0-100)0 to 100 · optional92.4
signal_strengthfloatSignal strength of the IoT device at the time of the event (e.g., dBm)optional-62.5
Dates and times 1 column
timestampdatetimeDate and time when the utilization event was recorded2024-05-15T19:25:48Z

Use it for

  • median signal …-76.3122 rows

    A government dashboard

    Signal_strength by event_type and a breakdown of utilization_metric_unit. Excel, Power BI or Tableau.

  • Why do the 12 error rows have a mean signal_strength of -129.2?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable logs with asset_id, asset_type and asset_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset122 rows21 columns
Yours1,000 rows21 columnslocation_latitude: UK only

blueprint · municipal-iot-asset-utilization-logs

Behind this dataset

Same schema. As many rows as you need.

These 122 rows came out of a blueprint — 21 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each asset entry includes location, device type, and active status.
  • Usage events must be timestamped and linked to specific municipal functions.
  • Inactive periods exceeding defined thresholds flagged for review.
  • Energy consumption tracked for each device session.
  • Maintenance alerts generated based on usage and sensor readings.
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
municipal-iot-asset-utilization-logs

More in Government

Browse all
Also in GovernmentMunicipal IoT Device Health LogsLocal Government Budget BreakdownPublic Service Complaint ResolutionAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.