Camden Public Wi-Fi Locations

London Borough of Camden

@ukgov.camden_public_wi_fi_locations

Table List

1 table(63 KB)

Table 1

@ukgov.camden_public_wi_fi_locations.table_1

63 KB
119 rows
15 columns

wi_fi_name Wi-Fi Name	wi_fi_type Wi-Fi Type	location_description Location Description	range_in_metres Range In Metres	install_date Install Date	install_type Install Type	column_number Column Number	road Road	easting Easting	northing Northing	longitude Longitude	latitude Latitude	location Location	range Range	last_uploaded Last Uploaded
Public Wi-Fi on Lighting Column 10 FORTESS ROAD	Public Wi-Fi	BY 57	30	Fri Dec 19 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	10	FORTESS ROAD	529010.73	185548.16	-0.140543	51.55408	POINT (-0.140543114119 51.554079374825)	POLYGON ((-0.140110577594 51.554079315273, -0.14014353945 51.553976132555, -0.140237332536 51.553888667596, -0.140377677541 51.553830236023, -0.140543208374 51.553809733392, -0.140708724858 51.553830280992, -0.140849029 51.553888750688, -0.140942760929 51.55397624112, -0.140975650645 51.554079432783…	29/10/2018 02:53:47 PM
Public Wi-Fi on Lighting Column 18 CHALK FARM ROAD	Public Wi-Fi	O/S NO. 47	30	Fri Oct 24 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	18	CHALK FARM ROAD	528466.45	184295.76	-0.148846	51.542949	POINT (-0.148846440464 51.54294823641)	POLYGON ((-0.148414009463 51.54294820746, -0.148446944495 51.542845022213, -0.148540698774 51.542757550452, -0.148680998901 51.542699108838, -0.148846485613 51.542678594456, -0.149011965452 51.542699130385, -0.149152246004 51.542757590266, -0.149245970989 51.542845074232, -0.149278871464 51.54294826…	29/10/2018 02:53:47 PM
Public Wi-Fi on Lighting Column 7 CAMDEN HIGH STREET	Public Wi-Fi	OPP INVENESS STREET	30	Thu Oct 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	7	CAMDEN HIGH STREET	528861.56	183951.79	-0.143277	51.539768	POINT (-0.143277862182 51.53976703733)	POLYGON ((-0.142845461336 51.53976698786, -0.142878406663 51.53966380412, -0.14297216508 51.539576336761, -0.143112462556 51.539517901773, -0.143277940234 51.539497395233, -0.143443406029 51.539517939026, -0.143583669667 51.539576405595, -0.14367737744 51.539663894057, -0.143710263029 51.53976708520…	29/10/2018 02:53:47 PM
Public Wi-Fi on Lighting Column 1 ROYAL COLLEGE STREET	Public Wi-Fi	J/W ROYAL COLLEGE ST	30	Fri Dec 19 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	1	ROYAL COLLEGE STREET	529076.81	184402.4	-0.14001	51.543768	POINT (-0.140010657468 51.543767495224)	POLYGON ((-0.139578218712 51.543767433712, -0.139611174318 51.543664250961, -0.139704947221 51.543576786273, -0.139845261184 51.543518355232, -0.14001075484 51.543497853314, -0.140176233672 51.543518401701, -0.14031650542 51.543576872135, -0.140410215144 51.543664363146, -0.140443096226 51.543767555…	29/10/2018 02:53:47 PM
Public Wi-Fi on Lighting Column 16 NEW OXFORD STREET	Public Wi-Fi	FRONT OF N 78	30	Fri Oct 24 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	16	NEW OXFORD STREET	529993.7	181427.4	-0.127893	51.516822	POINT (-0.127893566991 51.516821434274)	POLYGON ((-0.127461383483 51.516821328122, -0.12749434701 51.516718148298, -0.127588087769 51.516630692888, -0.127728334417 51.516572276064, -0.127893735835 51.516551791136, -0.12805911155 51.516572356699, -0.128199284997 51.516630841883, -0.128292916203 51.516718342969, -0.128325750502 51.516821538…	29/10/2018 02:53:47 PM
Public Wi-Fi on Lighting Column 7 KILBURN HIGH ROAD	Public Wi-Fi	OPP 43	30	Fri Apr 25 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	7	KILBURN HIGH ROAD	525530.1	183493.4	-0.191453	51.536398	POINT (-0.191453099705 51.536397357041)	POLYGON ((-0.19102073083 51.536397485101, -0.191053564786 51.536294287799, -0.19114722392 51.536206781916, -0.191287449317 51.536148289307, -0.191452893091 51.53612771482, -0.19161836832 51.536148190685, -0.191758683292 51.536206599687, -0.191852476486 51.536294049705, -0.191885468578 51.53639722738…	29/10/2018 02:53:47 PM
Public Wi-Fi on Lighting Column 8 EVERSHOLT STREET	Public Wi-Fi	O/S 64	30	Fri Oct 24 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	8	EVERSHOLT STREET	529599.6	182826.6	-0.133055	51.529487	POINT (-0.13305573424 51.529486325449)	POLYGON ((-0.132623430808 51.529486238314, -0.13265639182 51.529383057264, -0.132750148703 51.529295597919, -0.13289042766 51.52923717505, -0.133055872655 51.529216682889, -0.133221296578 51.529237241131, -0.133361515527 51.52929572002, -0.133455182601 51.529383216797, -0.133488037674 51.52948641099…	29/10/2018 02:53:47 PM
Public Wi-Fi on Lighting Column 14 SOUTH END GREEN	Public Wi-Fi	O/S BUS STAND	30	Fri Dec 19 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	14	SOUTH END GREEN	527288.41	185545.15	-0.165373	51.554444	POINT (-0.165373188986 51.554443043964)	POLYGON ((-0.164940649004 51.55444307592, -0.164973554947 51.55433988624, -0.165067301157 51.554252401449, -0.165207615462 51.554193940191, -0.165373136444 51.554173402543, -0.165538665424 51.554193915124, -0.165679002508 51.55425235513, -0.165772782811 51.554339825721, -0.165805728968 51.5544430104…	29/10/2018 02:53:47 PM
Public Wi-Fi on Lighting Column 44 HAVERSTOCK HILL	Public Wi-Fi	O/S GARAGE	30	Fri Dec 19 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	44	HAVERSTOCK HILL	527211.81	185223.6	-0.166593	51.551571	POINT (-0.16659365912 51.551570570161)	POLYGON ((-0.166161146379 51.551570606614, -0.166194047488 51.551467416542, -0.166287785454 51.551379930733, -0.166428089359 51.551321467987, -0.166593599367 51.551300928608, -0.166759118471 51.551321439478, -0.166899448281 51.551379878053, -0.166993225018 51.551467347713, -0.16702617186 51.55157053…	29/10/2018 02:53:47 PM
Public Wi-Fi on Lighting Column 33 KENTISH TOWN ROAD	Public Wi-Fi	O/S NO. 177	30	Fri Dec 19 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Lighting Column	33	KENTISH TOWN ROAD	528938.85	184665.54	-0.141902	51.546164	POINT (-0.141902642442 51.546163805829)	POLYGON ((-0.141470180969 51.54616375129, -0.141503134028 51.54606056805, -0.14159690823 51.545973101885, -0.14173722714 51.545914668607, -0.141902728639 51.545894164029, -0.142068217015 51.545914709739, -0.142208498556 51.545973177889, -0.14230221683 51.546060667353, -0.142335103917 51.546163858775…	29/10/2018 02:53:47 PM


CREATE TABLE table_1 (
  "wi_fi_name" VARCHAR,
  "wi_fi_type" VARCHAR,
  "location_description" VARCHAR,
  "range_in_metres" BIGINT,
  "install_date" TIMESTAMP,
  "install_type" VARCHAR,
  "column_number" DOUBLE,
  "road" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "range" VARCHAR,
  "last_uploaded" VARCHAR
);