Dataset: Chelmsford Planning Applications ODIS

About this Dataset

Chelmsford Planning Applications ODIS

Planning applications within Chelmsford published under the Open Data Incentive Scheme.
Publisher name: Chelmsford City Council
Last updated: 2022-07-01T04:07:05Z

Tables

Chelmsford Planning Applications ODIS

@ukgov.chelmsford_planning_applications_odis.chelmsford_planning_applications_odis

1.09 MB
8709 rows
36 columns


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