Baselight

London Assembly Constituencies (December 2018) Boundaries EN BGC

Office for National Statistics

@ukgov.london_assembly_constituencies_december_2018_boundaries_en_bgc1

Table 1
@ukgov.london_assembly_constituencies_december_2018_boundaries_en_bgc1.table_1

  • 8.9 KB
  • 14 rows
  • 10 columns
objectid

OBJECTID

lac18cd

LAC18CD

lac18nm

LAC18NM

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

shape_area

Shape, Area

shape_length

Shape, Length

globalid

GlobalID

1E32000001Barnet and Camden524459191631-0.20451.60976108587945.04927866709.726315635450659fa2-87d0-4671-86e1-aef40f5f936f
2E32000002Bexley and Bromley5422981690010.04432451.402191210722870.656708106214.18230302162a010b1-7cad-4be3-8214-ef62cf66d863
3E32000003Brent and Harrow518065188059-0.297551.57904193669384.67037251642.137923058495082285-954b-46e4-8e5d-afa58d00a64c
4E32000004City and East5417921826040.04250851.52455194990776.004447995972.957072244588e23fb-6229-405c-9a9f-51919b9776b7
5E32000005Croydon and Sutton531404163450-0.1142451.354931130371624.09878570568.70329299224edcbed4-c80d-4d94-8852-ab730545499f
6E32000006Ealing and Hillingdon511153183733-0.3985851.541561171269376.97913484732.1346503015aecc2cda-b9dc-4a0a-8239-2955e7db0750
7E32000007Enfield and Haringey531691193902-0.0987751.628529111772686.19403854315.1374585807053d8ea9-0a2a-4bea-8074-de477d679534
8E32000008Greenwich and Lewisham5402851757280.01806751.46313982482105.797668563580.93153327666ac96887-a694-499e-9874-75618c5742eb
9E32000009Havering and Redbridge5561141868440.25066951.558868168743290.541985104317.463731993f4408508-846e-42da-9153-bb9ed52bb646
10E32000010Lambeth and Southwark532607175723-0.0923951.46495155634644.169670140633.139619807625b08e63-4014-4b36-ad02-a9424a733acf

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "lac18cd" VARCHAR,
  "lac18nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);

Share link

Anyone who has the link will be able to view this.