About this Dataset

Street Lighting

This dataset contains a number of assets that fall within Street Lighting in York. The different categories included are: • BELISHA BEACONS • FLOOD LIGHTS • LIT BOLLARDS • LIT TRAFFIC SIGNS • OTHER • SCHOOL CROSSING FLASHERS • STREET LAMPS • SUBWAY UNITS • TUNNEL UNITS • VEHICLE ACTIVATED SIGNS For further information about street lighting - see the City of York Council website. *Please note that the data published within this dataset is a live API link to CYC's GIS server. Any changes made to the master copy of the data will be immediately reflected in the resources of this dataset.The date shown in the "Last Updated" field of each GIS resource reflects when the data was first published.
Publisher name: City of York Council
Last updated: 2024-07-14T04:00:03Z

Tables

Street Lighting

@ukgov.street_lighting.street_lighting

1.61 MB
22218 rows
16 columns


CREATE TABLE street_lighting (
  "x" DOUBLE,
  "y" DOUBLE,
  "iit_ne_id" BIGINT,
  "lp_unique_ref" BIGINT,
  "description" VARCHAR,
  "location" VARCHAR,
  "road_name" VARCHAR,
  "road_number" VARCHAR,
  "usrn" BIGINT,
  "ward" VARCHAR,
  "parish" VARCHAR,
  "unit_type" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "datecreatedcyc" TIMESTAMP,
  "item_id" VARCHAR
);