About this Dataset

SLDC Planning Applications

Planning applications in South Lakeland released as part of the open Data Incentive Scheme. Please note these cover the South Lakeland District Council Planning area, not including the Lake District or Yorkshire Dales National Park Authorities. Dataset is formatted to comply with the Local Government Open Data Incentive Scheme Schema compliance – planning applications. Please note the UPRNs for applications aren't listed as we aren't fully sync'd with the gazetteer. Updated annually, last update: October 2017.
Publisher name: South Lakeland District Council
Last updated: 2024-09-14T17:27:22Z

Tables

Planning Applications In South Lakeland Planning Area 2019

@ukgov.sldc_planning_applications.planning_applications_in_south_lakeland_planning_area_2019

1.91 MB
21102 rows
36 columns


CREATE TABLE planning_applications_in_south_lakeland_planning_area_2019 (
  "extractdate" TIMESTAMP,
  "publisheruri" VARCHAR,
  "publisherlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "casereference" VARCHAR,
  "caseurl" VARCHAR,
  "casedate" TIMESTAMP,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "classificationuri" VARCHAR,
  "classificationlabel" VARCHAR,
  "casetext" VARCHAR,
  "locationtext" VARCHAR,
  "decisiontargetdate" VARCHAR,
  "status" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" DOUBLE,
  "geoy" DOUBLE,
  "geopointlicensingurl" VARCHAR,
  "decisiondate" VARCHAR,
  "decision" VARCHAR,
  "decisiontype" VARCHAR,
  "decisionnoticedate" VARCHAR,
  "appealref" VARCHAR,
  "appealdecisiondate" VARCHAR,
  "appealdecision" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR,
  "groundarea" VARCHAR,
  "uprn" VARCHAR,
  "agent" VARCHAR,
  "publicconsultationstartdate" VARCHAR,
  "publicconsultationenddate" VARCHAR,
  "responsesfor" VARCHAR,
  "responsesagainst" VARCHAR
);

SLDC Planning Applications

@ukgov.sldc_planning_applications.sldc_planning_applications

2.16 MB
18661 rows
38 columns


CREATE TABLE sldc_planning_applications (
  "extractdate" TIMESTAMP,
  "publisheruri" VARCHAR,
  "publisherlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "casereference" VARCHAR,
  "caseurl" VARCHAR,
  "casedate" TIMESTAMP,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "classificationuri" VARCHAR,
  "classificationlabel" VARCHAR,
  "casetext" VARCHAR,
  "locationtext" VARCHAR,
  "decisiontargetdate" VARCHAR,
  "status" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" DOUBLE,
  "geoy" DOUBLE,
  "geopointlicensingurl" VARCHAR,
  "decisiondate" VARCHAR,
  "decision" VARCHAR,
  "decisiontype" VARCHAR,
  "decisionnoticedate" VARCHAR,
  "appealref" VARCHAR,
  "appealdecisiondate" VARCHAR,
  "appealdecision" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR,
  "groundarea" VARCHAR,
  "uprn" VARCHAR,
  "agent" VARCHAR,
  "publicconsultationstartdate" VARCHAR,
  "publicconsultationenddate" VARCHAR,
  "responsesfor" VARCHAR,
  "responsesagainst" VARCHAR,
  "applicantaddress" VARCHAR,
  "agentaddress" VARCHAR
);