Sustainability And Transformation Partnerships (April 2018) EN BGC
Office for National Statistics
@ukgov.sustainability_and_transformation_partnerships_april_2_811115c7
Table 1
@ukgov.sustainability_and_transformation_partnerships_april_2_811115c7.table_1
- 12.19 KB
- 42 rows
- 10 columns
objectidOBJECTID | stp18cdSTP18CD | stp18nmSTP18NM | bng_eBNG E | bng_nBNG N | longLONG | latLAT | shape_areaShape, Area | shape_lengthShape, Length | globalidGlobalID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | E54000005 | West Yorkshire | 411733 | 442600 | -1.82301 | 53.879478 | 4378684300.71144 | 436670.436100621 | 5a126c3b-4c21-4a05-b914-424ece995b9b |
| 2 | E54000006 | Humber, Coast and Vale | 492462 | 462478 | -0.58924 | 54.049999 | 6506383827.09587 | 1094165.09312889 | 54436afc-623f-4592-a33d-aedb278e9ac1 |
| 3 | E54000007 | Greater Manchester | 383161 | 401102 | -2.25535 | 53.506351 | 1402014904.63066 | 252276.294863881 | df8dc8bb-5310-4a12-b3bf-b899a381ae7d |
| 4 | E54000008 | Cheshire and Merseyside | 374405 | 380936 | -2.38572 | 53.32473 | 2987701856.62766 | 595190.913520295 | e3abe1a5-6ab0-4d10-b40f-8849b13e564c |
| 5 | E54000009 | South Yorkshire and Bassetlaw | 447764 | 393041 | -1.28256 | 53.432011 | 2189405536.21901 | 355238.438388387 | 58f0a3cb-5b4f-4a8a-89f4-5570cf052251 |
| 6 | E54000010 | Staffordshire | 398243 | 334651 | -2.02756 | 52.909302 | 2716723279.21507 | 425675.990232556 | 7827804d-666d-4ceb-b66e-90b63111eafd |
| 7 | E54000011 | Shropshire and Telford and Wrekin | 350226 | 302960 | -2.73668 | 52.62212 | 3487673955.42449 | 479479.632394605 | 8bf262b4-e72d-463b-8635-9094201a6c00 |
| 8 | E54000012 | Derbyshire | 426752 | 353558 | -1.6021 | 53.078602 | 2502756290.98907 | 385881.437936832 | aff14a6e-ad79-43ac-8b5c-89ffe2a1a34f |
| 9 | E54000013 | Lincolnshire | 517985 | 358542 | -0.23882 | 53.111038 | 5920609672.87216 | 729728.441038905 | 73f0e799-573f-463f-9307-1922d17629ae |
| 10 | E54000014 | Nottinghamshire | 466571 | 348422 | -1.00883 | 53.028969 | 1521492077.11179 | 242148.557985086 | 6390922c-8619-4470-9ae9-d3b966163567 |
CREATE TABLE table_1 (
"objectid" BIGINT,
"stp18cd" VARCHAR,
"stp18nm" VARCHAR,
"bng_e" BIGINT,
"bng_n" BIGINT,
"long" DOUBLE,
"lat" DOUBLE,
"shape_area" DOUBLE,
"shape_length" DOUBLE,
"globalid" VARCHAR
);