Municipal IoT Streetlight Efficiency Log

This dataset provides granular, real-time logs of municipal IoT-enabled streetlights, including uptime, energy consumption, maintenance activities, and failure events. Its comprehensive structure enables operational analysis, sustainability reporting, and proactive maintenance planning for city infrastructure managers and government CIOs.

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

City-wide streetlight operational efficiency analysis

Sample rows

preview · 8 of 120 rows · all 21 columns
streetlight_idstringuptime_statusstringenergy_consumed_kwhfloatis_smart_dimming_enabledbooleanaddress_statestringinstallation_datedatelocation_latitudefloatlocation_longitudefloataddress_streetstringaddress_citystringaddress_postal_codestringaddress_countrystringlog_datetimedatetimeuptime_duration_minutesintegerenergy_efficiency_ratingfloatmaintenance_eventstringmaintenance_descriptionstringmaintenance_technician_idstringfailure_codestringfirmware_versionstringfailure_descriptionstring
STL-100010online1.25trueNY2022-03-1540.7128-74.006Broadway AveNew York10007USA2024-06-07T20:11:00Z43800142.1noneblankblankblankv2.1.0blank
STL-100011offline0falseblank2016-05-1051.5074-0.1278Regent StLondonW1B 5TDUK2024-06-07T19:58:00Z0blanknoneblankblankblankv1.0.0blank
STL-100012online1.12trueblank2018-11-2235.6895139.6917Shibuya CrossingTokyo150-0002JPN2024-06-07T19:40:00Z99999134.9scheduledQuarterly scheduled cleaning and check.JPN-TECH-02blankv1.4.3blank
STL-100013maintenance0.85trueCA2020-07-1437.7749-122.4194Market StSan Francisco94105USA2024-06-07T18:50:00Z360138.2scheduledAnnual lens replacement.TECH-007blankv2.2.0blank
STL-100014fault0.05falseNSW2015-02-08-33.8688151.2093George StSydney2000AUS2024-06-07T18:05:00Z8blankemergencyEmergency bulb replacement after power surge.AUS-TECH-03PWR-SURGv0.9.8Power surge caused lamp failure.
STL-100015online1.08trueblank2017-09-1748.85662.3522Champs ElyseesParis75008FR2024-06-07T17:55:00Z7200140.3noneblankblankblankv1.3.5blank
STL-100016maintenance0.72falseblank2019-01-2952.5213.405Unter den LindenBerlin10117DE2024-06-07T17:40:00Z180130.7unscheduledUnexpected fixture alignment.DE-TECH-01blankv1.6.2blank
STL-100017fault0.09falseblank2016-12-0455.755837.6173Tverskaya StMoscow101000RU2024-06-07T17:30:00Z15blankemergencyEmergency sensor repair.RU-TECH-09E-SENSRv1.0.3Sensor malfunction caused outage.

What the 120 rows show

from the 120-row sample

Online (uptime status) stands out: mean energy_consumed_kwh is 1.2, against 0.28 for the rest.

  • 56%is_smart_dimming_enabled = true
  • 0.78median energy_consumed_kwh
  • 4maintenance events
  • 1,225median uptime_duration_minutes
  • 132.3median energy_efficiency_rating
Mean energy_consumed_kwh by uptime_status120 rows
0121.2online57 rows0.0offline18 rows0.59maintena…27 rows0.08fault18 rows
energy_consumed_kwh120 rows, in bands of 0.2
0204037710762327300.81.6energy_consumed_kwh →

Median 0.78, from 0.0 to 1.4.

address_state32 rows with a value · 88 left blank
  1. CA6
  2. NY3
  3. NSW3
  4. CDMX3
  5. ON3
  6. FL2
  7. RM2
  8. MI2
  9. OK1
  10. PA1
21 columns by typefrom the column list below
  • string 13
  • integer 1
  • float 4
  • date 1
  • datetime 1
  • boolean 1

Columns

21 columns in four groups
blueprint · 21 columns
columntypedescriptionexample
Text 13 columns
streetlight_idstringUnique identifier for each IoT-enabled streetlightuniqueSTL-100010
address_streetstringStreet address of the streetlight locationoptionalBroadway Ave
address_citystringCity where the streetlight is locatedoptionalNew York
address_statestringState or region where the streetlight is locatedoptionalNY
address_postal_codestringPostal code for the streetlight locationoptional10007
address_countrystringCountry where the streetlight is locatedoptionalUSA
uptime_statusstringOperational status of the streetlight at the log timeonline · offline · maintenance · faultonline
maintenance_eventstringType of maintenance event, if any, recorded at this log entrynone · scheduled · unscheduled · emergency · optionalnone
maintenance_descriptionstringDetailed description of the maintenance eventoptionalAnnual lens replacement.
maintenance_technician_idstringIdentifier for the technician who performed maintenanceoptionalJPN-TECH-02
failure_codestringCode indicating the type of failure, if applicableoptionalPWR-SURG
failure_descriptionstringDetailed description of the failure, if applicableoptionalPower surge caused lamp f…
firmware_versionstringCurrent firmware version of the streetlight IoT deviceoptionalv2.1.0
Numbers 5 columns
location_latitudefloatLatitude coordinate of the streetlight's location-90 to 9040.7128
location_longitudefloatLongitude coordinate of the streetlight's location-180 to 180-74.006
uptime_duration_minutesintegerNumber of minutes the streetlight has been online since last status change0 or more · optional43800
energy_consumed_kwhfloatEnergy consumed by the streetlight since the last log entry, measured in kilowatt-hours0 or more1.25
energy_efficiency_ratingfloatEfficiency rating of the streetlight (e.g., lumens per watt)0 or more · optional142.1
Dates and times 2 columns
installation_datedateDate the streetlight was installed2022-03-15
log_datetimedatetimeTimestamp of the log entry for uptime, energy, or maintenance event2024-06-07T20:11:00Z
True or false 1 column
is_smart_dimming_enabledbooleanIndicates if smart dimming features are enabledoptionaltrue

Use it for

  • is smart dimmi…56%67 of 120 rowsmean energy consumed …1.2onli…0.0offl…0.59main…0.08fault

    A government dashboard

    The is_smart_dimming_enabled rate, energy_consumed_kwh by uptime_status and a breakdown of address_state. Excel, Power BI or Tableau.

  • Why do the 57 online rows have a mean energy_consumed_kwh of 1.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 streetlights with installation_date, location_latitude and location_longitude 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 dataset120 rows21 columns
Yours1,000 rows21 columnslocation_latitude: UK only

blueprint · municipal-iot-streetlight-efficiency-log

Behind this dataset

Same schema. As many rows as you need.

These 120 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 row represents one streetlight per day
  • Include uptime percentage, energy consumed (kWh), and maintenance flag
  • Report location type (residential, commercial, mixed)
  • Flag for detected faults or outages
  • Include IoT sensor status summary
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-streetlight-efficiency-log

More in Government

Browse all
Also in GovernmentMunicipal Edge Sensor Health MetricsSmart Bin Sensor Fill LevelsLocal Government Budget BreakdownAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.