Combined Authorities (December 2018) Boundaries EN BUC
Office for National Statistics
@ukgov.combined_authorities_december_2018_boundaries_en_buc1
Table 1
@ukgov.combined_authorities_december_2018_boundaries_en_buc1.table_1
- 8.58 KB
- 10 rows
- 10 columns
objectidOBJECTID | cauth18cdCauth18cd | cauth18nmCauth18nm | bng_eBng E | bng_nBng N | longLong | latLat | shape_areaShape, Area | shape_lengthShape, Length | globalidGlobalID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | E47000001 | Greater Manchester | 377940 | 401102 | -2.33407 | 53.506149 | 1273598337.12234 | 206057.361351532 | 926fc230-605f-48ef-96bb-ba4d120bda12 |
| 2 | E47000002 | Sheffield City Region | 441052 | 398663 | -1.38284 | 53.483109 | 1550440102.76178 | 213333.912916697 | fc1fe058-9845-423d-8939-086edca1add3 |
| 3 | E47000003 | West Yorkshire | 418686 | 427238 | -1.71817 | 53.741199 | 2029163329.69075 | 240199.032682458 | f62dac31-f5fb-49a7-873f-123eb34803d3 |
| 4 | E47000004 | Liverpool City Region | 344324 | 390164 | -2.83893 | 53.40535 | 724614858.4338 | 245540.901061698 | 845daa00-2f73-45a9-8b79-7b3432af847a |
| 5 | E47000006 | Tees Valley | 436951 | 521739 | -1.42972 | 54.589512 | 804194735.868973 | 220536.289265444 | e29bbbbc-34c0-4270-ac69-9069a2ce4e41 |
| 6 | E47000007 | West Midlands | 402507 | 289715 | -1.96448 | 52.505341 | 902348993.609993 | 206334.877572412 | 9a71f1d5-3e07-45a9-ab1a-ea005acccb1b |
| 7 | E47000008 | Cambridgeshire and Peterborough | 536856 | 271834 | 0.006854 | 52.327549 | 3398352833.6425 | 369773.111163292 | e3280b7b-ae22-4135-987c-055c30a7a7d6 |
| 8 | E47000009 | West of England | 366423 | 173496 | -2.48467 | 51.459431 | 980943542.394302 | 178038.588232417 | 29939502-f227-4c6a-8916-14ab5e9a846f |
| 9 | E47000010 | North East | 413482 | 537463 | -1.79217 | 54.731972 | 2578238246.43355 | 274934.344599648 | eb28bea7-e8da-4c70-af7d-164261e5d56c |
| 10 | E47000011 | North of Tyne | 397234 | 600992 | -2.04512 | 55.30302 | 5224882205.60121 | 425702.369786596 | 7ea6f718-e145-49a1-bc76-2f89605bbb96 |
CREATE TABLE table_1 (
"objectid" BIGINT,
"cauth18cd" VARCHAR,
"cauth18nm" VARCHAR,
"bng_e" BIGINT,
"bng_n" BIGINT,
"long" DOUBLE,
"lat" DOUBLE,
"shape_area" DOUBLE,
"shape_length" DOUBLE,
"globalid" VARCHAR
);