Index Of Place Names (July 2016) In GB (Table)
Office for National Statistics
@ukgov.index_of_place_names_july_2016_in_gb_table
Office for National Statistics
@ukgov.index_of_place_names_july_2016_in_gb_table
CREATE TABLE table_1 (
"fid" BIGINT,
"placeid" BIGINT,
"place15cd" VARCHAR,
"placesort" VARCHAR,
"place15nm" VARCHAR,
"splitind" BIGINT,
"popcnt" BIGINT,
"descnm" VARCHAR,
"ctyhistnm" VARCHAR,
"ctyltnm" VARCHAR,
"ctry15nm" VARCHAR,
"cty15cd" VARCHAR,
"cty15nm" VARCHAR,
"lad15cd" VARCHAR,
"lad15nm" VARCHAR,
"laddescnm" VARCHAR,
"wd15cd" VARCHAR,
"par15cd" VARCHAR,
"hlth12cd" VARCHAR,
"hlth12nm" VARCHAR,
"regd15cd" VARCHAR,
"regd15nm" VARCHAR,
"rgn15cd" VARCHAR,
"rgn15nm" VARCHAR,
"npark15cd" VARCHAR,
"npark15nm" VARCHAR,
"bua11cd" VARCHAR,
"pcon15cd" VARCHAR,
"pcon15nm" VARCHAR,
"eer15cd" VARCHAR,
"eer15nm" VARCHAR,
"pfa15cd" VARCHAR,
"pfa15nm" VARCHAR,
"gridgb1m" BIGINT,
"gridgb1e" BIGINT,
"gridgb1n" BIGINT,
"grid1km" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE
);
Anyone who has the link will be able to view this.