Chelmsford Planning Applications ODIS
Chelmsford City Council
@ukgov.chelmsford_planning_applications_odis
Chelmsford City Council
@ukgov.chelmsford_planning_applications_odis
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
);
Anyone who has the link will be able to view this.