NSPL Online Latest Centroids
Office for National Statistics
@ukgov.nspl_online_latest_centroids5
Office for National Statistics
@ukgov.nspl_online_latest_centroids5
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"objectid" BIGINT,
"pcd" VARCHAR,
"pcd2" VARCHAR,
"pcds" VARCHAR,
"dointr" BIGINT,
"doterm" DOUBLE,
"usertype" BIGINT,
"oseast1m" DOUBLE,
"osnrth1m" DOUBLE,
"osgrdind" BIGINT,
"oa21" VARCHAR,
"cty" VARCHAR,
"ced" VARCHAR,
"laua" VARCHAR,
"ward" VARCHAR,
"nhser" VARCHAR,
"ctry" VARCHAR,
"rgn" VARCHAR,
"pcon" VARCHAR,
"ttwa" VARCHAR,
"itl" VARCHAR,
"npark" VARCHAR,
"lsoa21" VARCHAR,
"msoa21" VARCHAR,
"wz11" VARCHAR,
"sicbl" VARCHAR,
"bua24" VARCHAR,
"ru21ind" VARCHAR,
"oac11" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE,
"lep1" VARCHAR,
"lep2" VARCHAR,
"pfa" VARCHAR,
"imd" BIGINT,
"icb" VARCHAR,
"globalid" VARCHAR
);
Anyone who has the link will be able to view this.