About this Dataset

Street Works Register Camden

This dataset contains street works that are happening in the London Borough of Camden. Attribution includes the organisation that is carrying out the work, the proposed start and end dates of the work and the street on which the works are taking place.

The location of the works is represented as point, however the actual extent of the works may be an area or line on the stated road.
Publisher name: London Borough of Camden
Last updated: 2025-07-02T04:06:37Z

Tables

Table 1

@ukgov.street_works_register_camden.table_1

45.63 KB
172 rows
24 columns


CREATE TABLE table_1 (
  "local_authority_reference" VARCHAR,
  "works_status" VARCHAR,
  "works_type" VARCHAR,
  "category_of_works" VARCHAR,
  "description_of_works" VARCHAR,
  "street" VARCHAR,
  "location_of_works" VARCHAR,
  "locality" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "reference" VARCHAR,
  "responsible_company" VARCHAR,
  "contact_telephone_number" VARCHAR,
  "emergency_contact_telephone_number" VARCHAR,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" VARCHAR,
  "organisation_uri" VARCHAR
);