Baselight

Regions (December 2019) General Clipped Boundaries EN

Office for National Statistics

@ukgov.regions_december_2019_general_clipped_boundaries_en

Table 1
@ukgov.regions_december_2019_general_clipped_boundaries_en.table_1

  • 8.36 KB
  • 9 rows
  • 10 columns
objectid

OBJECTID

rgn19cd

RGN19CD

rgn19nm

RGN19NM

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

shape_area

Shape, Area

shape_length

Shape, Length

globalid

GlobalID

1E12000001North East417314600356-1.7288855.2970098597455729.42523999279.163440714e0e99a7e-c1cc-4054-9fec-781c77909bd0
2E12000002North West350014506279-2.7723954.4494414163638449.60262258155.315952410c11b662-0119-42c6-b354-90b69f1556b4
3E12000003Yorkshire and The Humber446902448736-1.2871453.9326415408879923.13921364750.8217735e54fec71-a469-4875-a81f-8be89f35c8e1
4E12000004East Midlands477659322635-0.8496952.79571915644777389.45091345384.2623356185a50bc-3373-4db0-8b60-e5b2d6e90c29
5E12000005West Midlands386294295477-2.2035852.55696913003737883.8069921092.032809303df8ba897-a0a3-4116-b70a-4baa90b9a8cb
6E12000006East of England5710782632350.50420752.2407319130289128.60583558122.16003652365cc83b-131e-4e7f-a303-1ee23b46bf77
7E12000007London517515178392-0.3086651.4922711573359480.52193418589.145538974d4b227f2-dd5e-4b1d-94a5-e7bd07a81cad
8E12000008South East470062172924-0.9931151.4509719087216879.39692585865.66126777a0854318-9abd-43ae-9f09-56331d9ec65a
9E12000009South West285013102567-3.6334650.81119223850481301.67393280244.31958794b0eae565-d6ec-4764-afa1-e0f8464a3fde

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