Intelligent Streetlight Control System

Optimizing streetlight energy use based on traffic, weather, and light

@kaggle.ziya07_intelligent_streetlight_control_system

Table List

1 table(70.07 KB)

Intelligent Streetlight Dataset

@kaggle.ziya07_intelligent_streetlight_control_system.intelligent_streetlight_dataset

70.07 KB
1000 rows
15 columns

timestamp Timestamp	street_id Street ID	day_night Day/Night	traffic_count Traffic Count	traffic_density Traffic Density	traffic_speed Traffic Speed	ambient_light_lux Ambient Light (lux)	weather Weather	energy_consumption_kwh Energy Consumption (kWh)	power_state Power State	dim_level Dim Level	latitude Latitude	longitude Longitude	special_event Special Event	holiday_weekend Holiday/Weekend
Sun Jan 21 2024 05:27:00 GMT+0000 (Coordinated Universal Time)	8	Day	154	41.75017291561123	59.38388411447831	172.43906508394792	Clear	0.37	1	50	40.877091839815726	-73.81353766977145	1
Thu Jan 11 2024 12:15:00 GMT+0000 (Coordinated Universal Time)	3	Night	103	30.94996119198077	24.20858620846751	189.3390420475644	Rainy			100	40.862553331001074	-74.12594318793971
Mon Jan 29 2024 20:18:00 GMT+0000 (Coordinated Universal Time)	9	Night	203	32.08960735460401	29.733311871024064	200.2360358342185	Cloudy			75	40.80982569568925	-73.8537242361468	1
Fri Jan 05 2024 13:42:00 GMT+0000 (Coordinated Universal Time)	5	Day	161	27.758248991263716	27.850047047853653	197.0784041652081	Cloudy	0.78	1	100	40.529601283455385	-74.07330166624979
Mon Jan 08 2024 07:45:00 GMT+0000 (Coordinated Universal Time)	1	Night	55	41.49245607160468	59.28213280305033	279.10977537762705	Clear	0.46	1	50	40.56581691009973	-74.11674236200211	1	1
Fri Jan 26 2024 17:13:00 GMT+0000 (Coordinated Universal Time)	6	Night	200	28.293919407708408	23.986351028223176	226.65412271901383	Cloudy	0.83	1	100	40.72857024464785	-73.85913926697171
Mon Jan 15 2024 17:21:00 GMT+0000 (Coordinated Universal Time)	2	Day	244	26.971331329402872	48.98025905516132	137.1543221453574	Clear			50	40.751900174288366	-73.77109106295624
Fri Jan 12 2024 04:06:00 GMT+0000 (Coordinated Universal Time)	6	Day	228	16.025011483655177	46.700968547303816	34.36878948564482	Cloudy	0.43	1	100	40.55216250862392	-74.16682238090326	1
Wed Jan 10 2024 17:16:00 GMT+0000 (Coordinated Universal Time)	1	Day	51	31.692599698473032	58.17235886225107	85.19757739169873	Clear			75	40.56995963738369	-73.88471373217855
Tue Jan 23 2024 08:54:00 GMT+0000 (Coordinated Universal Time)	1	Day	81	55.38302121858579	47.33211248765768	66.61026388569074	Clear			100	40.60396549691887	-74.05954125078397		1


CREATE TABLE intelligent_streetlight_dataset (
  "timestamp" TIMESTAMP,
  "street_id" BIGINT,
  "day_night" VARCHAR,
  "traffic_count" BIGINT,
  "traffic_density" DOUBLE,
  "traffic_speed" DOUBLE,
  "ambient_light_lux" DOUBLE,
  "weather" VARCHAR,
  "energy_consumption_kwh" DOUBLE,
  "power_state" BIGINT,
  "dim_level" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "special_event" BIGINT,
  "holiday_weekend" BIGINT
);