Baselight

Metropolitan Counties (December 2018) Boundaries EN BFE

Office for National Statistics

@ukgov.metropolitan_counties_december_2018_boundaries_en_bfe

Table 1
@ukgov.metropolitan_counties_december_2018_boundaries_en_bfe.table_1

  • 8.01 KB
  • 6 rows
  • 10 columns
objectid

OBJECTID

mcty18cd

MCTY18CD

mcty18nm

MCTY18NM

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

shape_area

Shape, Area

shape_length

Shape, Length

globalid

GlobalID

1E11000001Greater Manchester377940401102-2.3340753.5061491275981137.66568248706.0748621279ee5f7a6-5860-46e1-9157-0db0f672c33d
2E11000002Merseyside344324390164-2.8389353.40535817571401.831245276340.1044041531b5a00c2-d970-4fc2-b1b2-cf2939c39c3e
3E11000003South Yorkshire441052398663-1.3828453.4831091552093262.20369251952.619091691e514bb60-e7d8-4948-853b-076a0daddad7
4E11000005West Midlands402507289715-1.9644852.505341901639656.935059256430.29277164171b90e5a-9877-42d6-a486-9a0af9902abf
5E11000006West Yorkshire418686427238-1.7181753.7411992029258666.12323282889.9933635968d48cf37-f7c1-4247-b803-33097ecd77a4
6E11000007Tyne and Wear425911560989-1.5970754.942902550755393.400116173253.58114761499fdea2f-ed0a-45f1-8f4d-c2b4b63e9822

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "mcty18cd" VARCHAR,
  "mcty18nm" 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.