London Schools Atlas
Greater London Authority
@ukgov.london_schools_atlas
Greater London Authority
@ukgov.london_schools_atlas
CREATE TABLE all_schools_xy_2016 (
"objectid" DOUBLE,
"urn" BIGINT,
"school_nam" VARCHAR,
"type" VARCHAR,
"phase" VARCHAR,
"address" VARCHAR,
"town" VARCHAR,
"postcode" VARCHAR,
"status" VARCHAR,
"gender" VARCHAR,
"easting" BIGINT,
"northing" BIGINT,
"ward_name" VARCHAR,
"lsoa_name" VARCHAR,
"la_name" VARCHAR,
"weblink" VARCHAR,
"age" VARCHAR,
"map_icon" VARCHAR,
"new_urn" VARCHAR,
"old_urn" VARCHAR,
"map_icon_l" BIGINT,
"primary" BIGINT,
"x" DOUBLE,
"y" DOUBLE
);
Anyone who has the link will be able to view this.