About this Dataset

Rushmoor Planning Data

Rushmoor Planning Application Data Produced for the "Local Government Open Data Incentive Scheme" There are two versions of the file: - An Open Data version with no licensed information inside - A File containing information licenced from the Ordnance Survey (and Geoplace) under the PSMA Enduser Licence Downloading the second file will take you to an end-user licence agreement, which must be accepted before using the data.
Publisher name: Rushmoor Borough Council
Last updated: 2024-09-15T09:39:36Z

Tables

Rushmoor Planning Data

@ukgov.rushmoor_planning_data.rushmoor_planning_data

731.5 KB
5446 rows
36 columns


CREATE TABLE rushmoor_planning_data (
  "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" VARCHAR,
  "status" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" VARCHAR,
  "geoy" VARCHAR,
  "geopointlicensingurl" VARCHAR,
  "decisiondate" VARCHAR,
  "decision" VARCHAR,
  "decisiontype" VARCHAR,
  "decisionnoticedate" VARCHAR,
  "appealref" VARCHAR,
  "appealdecisiondate" VARCHAR,
  "appealdecision" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR,
  "groundarea" DOUBLE,
  "uprn" VARCHAR,
  "agent" VARCHAR,
  "publicconsultationstartdate" VARCHAR,
  "publicconsultationenddate" VARCHAR,
  "responsesfor" DOUBLE,
  "responsesagainst" DOUBLE
);