CCTV Cameras

Plymouth City Council

@ukgov.cctv_locations_in_plymouth

Table List

5 tables(36.15 KB)

Redeployable Cameras

@ukgov.cctv_locations_in_plymouth.redeployable_cameras

6.04 KB
14 rows
7 columns

fid Fid	camera_num Camera Num	camera_loc Camera Loc	easting Easting	northing Northing	x X	y Y
1	2011	Biddick Drive	245811	56749	-4.170487	50.39034
2	2012	Killerton Lane	250568	54058	-4.102553	50.367388
3	2016	Martin Street	247043	54307	-4.152179	50.368717
4	2015	North Road East	247037	54996	-4.152543	50.374907
5	2020	Whitleigh Bridge	247228	59594	-4.151731	50.416281
6	2021	Elphinstone Carpark	248278	53778	-4.13461	50.364285
7	2022	Bretonside	248243	54482	-4.135384	50.370597
8	2023	Coypool Carpark	252052	56926	-4.082826	50.393536
9	2025	North Down Cresent	245600	56839	-4.173489	50.391091
10	2026	Royal Parade	247751	54449	-4.142288	50.37018


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