About this Dataset

CCTV Cameras

This Data shows geographic information including longitude and latitude reference points. This geographic data locates all Plymouth City Council's CCTV cameras which are both owned and maintained by Plymouth City Council. This information is current and correct as of 2016. The Data is updated Annually and readable by Geographic Mapping Software called QGIS.
Publisher name: Plymouth City Council
Last updated: 2024-12-13T17:26:09Z

Tables

Car Parking Cameras

@ukgov.cctv_locations_in_plymouth.car_parking_cameras

5.84 kB
7 rows
7 columns

CREATE TABLE car_parking_cameras (
  "fid" BIGINT,
  "camera_num" BIGINT,
  "camera_loc" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);

CCTV Cameras

@ukgov.cctv_locations_in_plymouth.cctv_cameras

12.01 kB
136 rows
7 columns

CREATE TABLE cctv_cameras (
  "fid" BIGINT,
  "camera_num" BIGINT,
  "camera_nam" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);

Help Points

@ukgov.cctv_locations_in_plymouth.help_points

5.21 kB
9 rows
6 columns

CREATE TABLE help_points (
  "fid" BIGINT,
  "helpoint_l" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);

Redeployable Cameras

@ukgov.cctv_locations_in_plymouth.redeployable_cameras

6.19 kB
14 rows
7 columns

CREATE TABLE redeployable_cameras (
  "fid" BIGINT,
  "camera_num" BIGINT,
  "camera_loc" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);

Traffic Cameras

@ukgov.cctv_locations_in_plymouth.traffic_cameras

7.77 kB
43 rows
7 columns

CREATE TABLE traffic_cameras (
  "fid" BIGINT,
  "camera_num" BIGINT,
  "camera_loc" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);