Baselight

Sustainability And Transformation Partnerships (April 2018) EN BUC

Office for National Statistics

@ukgov.sustainability_and_transformation_partnerships_april_2_970460a2

Table 1
@ukgov.sustainability_and_transformation_partnerships_april_2_970460a2.table_1

  • 12.21 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.8794784377309619.67345378347.241550101b31ad34d-6bb5-48d4-ad1d-385171dbf519
2E54000006Humber, Coast and Vale492462462478-0.5892454.0499996530483346.10815677472.10918835649ad9a7c-0750-45aa-846d-a5da3fd22a67
3E54000007Greater Manchester383161401102-2.2553553.5063511401511558.72661215637.8717162040b602146-75e6-4048-8819-1f281cd1476a
4E54000008Cheshire and Merseyside374405380936-2.3857253.324732993927567.17686422147.263615534b9ce711e-131d-403e-9e0c-f08603a6edcf
5E54000009South Yorkshire and Bassetlaw447764393041-1.2825653.4320112188745966.61674277911.21805943596325a6e-ac3f-4293-9ef4-4282435df7dc
6E54000010Staffordshire398243334651-2.0275652.9093022721745973.15137348897.715646352acde3d56-4f66-4eab-802f-4da68334bbf4
7E54000011Shropshire and Telford and Wrekin350226302960-2.7366852.622123483611875.06413404487.32631198112e0c030-6fea-4d2f-9370-d2a3800c0323
8E54000012Derbyshire426752353558-1.602153.0786022500590818.52714317857.77645232355f55b4b-9f3c-4481-a71a-f071d7bd3880
9E54000013Lincolnshire517985358542-0.2388253.1110385948623889.31854482127.285117756e5050626-1e00-49a8-8f97-c2ee0139731f
10E54000014Nottinghamshire466571348422-1.0088353.0289691522987697.95827203596.12331548807af1b51-4ef1-4233-9465-f0ef129091b8

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.