CCTV Cameras

Plymouth City Council

@ukgov.cctv_locations_in_plymouth

Table List

5 tables(36.15 KB)

CCTV Cameras

@ukgov.cctv_locations_in_plymouth.cctv_cameras

11.73 KB
136 rows
7 columns

fid Fid	camera_num Camera Num	camera_nam Camera Nam	easting Easting	northing Northing	x X	y Y
7	3	Bedford Way	247861	54589	-4.140805	50.371459
8	2	New George Street	247783	54593	-4.141897	50.37148
9	12	Royal Parade	247781	54483	-4.141881	50.370493
10	38	St Andrews Cross	247999	54478	-4.13881	50.370505
12	24	Maderia Road	247850	53805	-4.140634	50.364414
13	17	Western Approach	247294	54642	-4.148792	50.371797
14	16	Frack Fort Gate	247327	54633	-4.148324	50.37172
15	20	Harwell Court	247361	54680	-4.147862	50.372148
16	7	Cornwall Street	247490	54688	-4.146046	50.372257
17	33	New George Street	247495	54598	-4.145952	50.371453


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