Baselight

Sustainability And Transformation Partnerships (April 2018) EN BFC

Office for National Statistics

@ukgov.sustainability_and_transformation_partnerships_april_2_a9dbe879

Table 1
@ukgov.sustainability_and_transformation_partnerships_april_2_a9dbe879.table_1

  • 12.18 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.8794784378676021.32747443283.2011983061efba1fa-dcd2-44f8-a99a-758dabd1e3a3
2E54000006Humber, Coast and Vale492462462478-0.5892454.0499996506232173.413641115228.85818501f780a5c2-38a7-42e8-92ea-3b042934674d
3E54000007Greater Manchester383161401102-2.2553553.5063511402057510.69617258431.704569045682af2e4-3dec-40e9-82b6-3fd856f7d98c
4E54000008Cheshire and Merseyside374405380936-2.3857253.324732987661253.13841613834.74361539243c02972-a9a3-4808-ab07-2ed283ba69e7
5E54000009South Yorkshire and Bassetlaw447764393041-1.2825653.4320112189401650.47983361740.983943917da825256-2c51-46d8-a582-615826afafd5
6E54000010Staffordshire398243334651-2.0275652.9093022716766581.59086437360.14662997753485aa5-5638-4919-a572-4a4ddcc9e558
7E54000011Shropshire and Telford and Wrekin350226302960-2.7366852.622123487616586.64568497026.93557763ea32a9fb-a2ad-4e0d-9143-c6c4b8f17c71
8E54000012Derbyshire426752353558-1.602153.0786022502707042.49638398175.602150932904c27e7-73d6-4f2b-8752-e8bad2b91a7f
9E54000013Lincolnshire517985358542-0.2388253.1110385920779926.03622751704.605597747cfeca183-1a9b-42dc-918c-6106d0a83df6
10E54000014Nottinghamshire466571348422-1.0088353.0289691521517417.62183249714.9790789435aaa80eb-b811-4c3d-a5a5-531a6b6674f1

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.