Baselight

Sustainability And Transformation Partnerships (April 2018) EN BSC

Office for National Statistics

@ukgov.sustainability_and_transformation_partnerships_april_2_e230e9f7

Table 1
@ukgov.sustainability_and_transformation_partnerships_april_2_e230e9f7.table_1

  • 12.17 KB
  • 42 rows
  • 10 columns
objectid

OBJECTID

stp18cd

STP18CD

stp18nm

STP18NM

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

shape_area

Shape, Area

shape_length

Shape, Length

globalid

GlobalID

1E54000005West Yorkshire411733442600-1.8230153.8794784378858488.08154405943.864265132fd200c7f-7537-4a5b-a01d-2d083ee0271e
2E54000006Humber, Coast and Vale492462462478-0.5892454.0499996514159422.85542799435.602411295babff7dd-8492-4aa3-a46f-709da8346a12
3E54000007Greater Manchester383161401102-2.2553553.5063511401460238.33473228861.41748435528ae8c57-9c9a-4cef-980a-e7b54905e05d
4E54000008Cheshire and Merseyside374405380936-2.3857253.324732986807435.94915513673.564722949dc6b8b02-79c3-4cf3-9c50-8b263560eb71
5E54000009South Yorkshire and Bassetlaw447764393041-1.2825653.4320112192101553.83473296595.586042897fa43be6d-70f1-4b32-82b4-69b300031a7f
6E54000010Staffordshire398243334651-2.0275652.9093022718185457.0284380121.16043046342062ad5-15ac-4b3e-b881-3e62680122ad
7E54000011Shropshire and Telford and Wrekin350226302960-2.7366852.622123486302285.97594433407.104181988d4f2b5c4-893b-43d3-a59d-b4ecaf95a63a
8E54000012Derbyshire426752353558-1.602153.0786022502444262.59325344765.5519435738882e4e8-f2bd-45e4-bac5-bc3d4a8cb80f
9E54000013Lincolnshire517985358542-0.2388253.1110385920347085.17499574778.81775995fb65f161-3ae0-4778-a2f0-c43b0665353f
10E54000014Nottinghamshire466571348422-1.0088353.0289691522339652.16168214836.342968163876ba9e2-396e-4fd7-8c89-fcd5793045ae

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
);

Share link

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