Name: Camden Street Lighting
Creator: UK Government
License: https://data.europa.eu/en/copyright-notice

About this Dataset

Camden Street Lighting

This dataset contains the location of Camden Council owned street lighting across the borough of Camden.
Publisher name: London Borough of Camden
Last updated: 2025-06-30T04:00:28Z

Tables

Table 1

@ukgov.camden_street_lighting.table_1

676.96 kB
10,659 rows
20 columns

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
);