South Lakeland Brownfield Land Register
South Lakeland District Council
@ukgov.south_lakeland_brownfield_land_register
South Lakeland District Council
@ukgov.south_lakeland_brownfield_land_register
CREATE TABLE south_lakeland_brownfield_land_register (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"sitereference" VARCHAR,
"previouslypartof" VARCHAR,
"sitenameaddress" VARCHAR,
"siteplanurl" VARCHAR,
"coordinatereferencesystem" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownershipstatus" VARCHAR,
"deliverable" VARCHAR,
"planningstatus" VARCHAR,
"permissiontype" VARCHAR,
"permissiondate" TIMESTAMP,
"planninghistory" VARCHAR,
"proposedforpip" VARCHAR,
"minnetdwellings" DOUBLE,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"effectivedate" TIMESTAMP,
"uprn" VARCHAR,
"shlaareference" DOUBLE,
"landallocationsreference" VARCHAR,
"planningreference" VARCHAR,
"aonbdpdref" VARCHAR,
"expiryofplanningpermission" TIMESTAMP,
"osgb36easting" DOUBLE,
"osgb36northing" DOUBLE,
"geopointlicensingurl" VARCHAR
);
Anyone who has the link will be able to view this.