Camden Street Lighting

London Borough of Camden

@ukgov.camden_street_lighting

Table List

1 table(661.96 KB)

Table 1

@ukgov.camden_street_lighting.table_1

661.96 KB
10659 rows
20 columns

local_authority_asset_number Local Authority Asset Number	street_name Street Name	ward_name Ward Name	postcode Postcode	description Description	switch_regime Switch Regime	wattage Wattage	lamp_type Lamp Type	column_type Column Type	column_height Column Height	heritage_status Heritage Status	install_date Install Date	easting Easting	northing Northing	longitude Longitude	latitude Latitude	location Location	spatial_accuracy Spatial Accuracy	organisation_uri Organisation URI	last_uploaded Last Uploaded
251509	LAMB'S CONDUIT STREET	Holborn and Covent Garden	WC1N 1EH	OPP PUB	35/18	86	Generic LED Lighting	Lighting Column	800	No	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	530575	182137	-0.119257	51.523065	POINT (-0.119257 51.523065)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:14 PM
249713	CROMER STREET	Kings Cross	WC1H 8LB	FRONT OF NORTHIAM HOUSE	35/18	41	Generic LED Lighting	Lighting Column	1000	No	Mon Feb 10 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	530341	182651	-0.122438	51.527738	POINT (-0.122438 51.527738)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:13 PM
247920	MURRAY STREET	Camden Square	NW1 9XE	OUTSIDE 59	35/18	60	Generic LED Lighting	Lighting Column	800	No	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	529515	184457	-0.133675	51.544158	POINT (-0.133675 51.544158)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:15 PM
248438	CAMLEY STREET	Kings Cross	NW1 0JZ	SOUTH OF BARKER DRIVE	35/18	41	LED Street Lights	Lighting Column	800	No		529660	184035	-0.13174	51.540333	POINT (-0.13174 51.540333)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:13 PM
259642	STUKELEY STREET	Holborn and Covent Garden	WC2B 5LR	NEAR DRAGON HOUSE	35/18	42	Generic LED Lighting	Wall Light			Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	530366	181408	-0.122538	51.516562	POINT (-0.122538 51.516562)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:15 PM
240612	FORDWYCH ROAD	Fortune Green	NW2 3TL	O/S 81	35/18	56	Generic LED Lighting	Lighting Column	800	No	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	524612	185000	-0.20415	51.550141	POINT (-0.20415 51.550141)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:12 PM
244070	HAVERSTOCK HILL	Haverstock	NW3 2BE	O/S NO 82	35/18	61	Generic LED Lighting	Lighting Column	800	Yes		527866	184676	-0.157362	51.546502	POINT (-0.157362 51.546502)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:12 PM
243758	AINGER ROAD	Primrose Hill	NW3 3AX	OPP MEADOWBANK RD	35/18	42	Generic LED Lighting	Lighting Column	600	No	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	527728	183996	-0.159598	51.540422	POINT (-0.159598 51.540422)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:14 PM
249291	PERCY STREET	Bloomsbury	W1T 2DA	O/S NO 29	35/18	51	Generic LED Lighting	Lighting Column	800	No	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	529609	181598	-0.133372	51.518443	POINT (-0.133372 51.518443)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:13 PM
241987	WEST END LANE	Kilburn	NW6 4SS	JCT. WITH ABBOTTS PLACE	35/18	48	Generic LED Lighting	Lighting Column	600	No	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	525516	183980	-0.191482	51.540774	POINT (-0.191482 51.540774)	Plotted by Council officer	http://opendatacommunities.org/id/london-borough-council/camden	12/04/2025 02:40:12 PM


CREATE TABLE table_1 (
  "local_authority_asset_number" BIGINT,
  "street_name" VARCHAR,
  "ward_name" VARCHAR,
  "postcode" VARCHAR,
  "description" VARCHAR,
  "switch_regime" VARCHAR,
  "wattage" DOUBLE,
  "lamp_type" VARCHAR,
  "column_type" VARCHAR,
  "column_height" DOUBLE,
  "heritage_status" VARCHAR,
  "install_date" TIMESTAMP,
  "easting" BIGINT,
  "northing" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "spatial_accuracy" VARCHAR,
  "organisation_uri" VARCHAR,
  "last_uploaded" VARCHAR
);