{
  "id" : "ts8b-tshe",
  "name" : "RF granted extensions",
  "assetType" : "filter",
  "attribution" : "London Borough of Camden",
  "attributionLink" : "http://www.camden.gov.uk",
  "averageRating" : 0,
  "category" : "Environment",
  "createdAt" : 1473163685,
  "description" : "This dataset contains planning applications in the London Borough of Camden dating back to 01/01/2010. Planning application extents are captured against the OS MasterMap product, due to licensing restrictions with this product, this dataset is represented as point geometry, located to the nearest postcode (derived from the OS Code-Point Open product). Attribution includes application number, development address, development description, registered date, decision date and case officer.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 1361,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "UK_OGLV3.0",
  "locked" : false,
  "modifyingViewUid" : "2eiu-s2cw",
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 3078031,
  "provenance" : "community",
  "publicationAppendEnabled" : true,
  "publicationDate" : 1497255515,
  "publicationGroup" : 19355,
  "publicationStage" : "published",
  "queryString" : "SELECT `pk`, `application_number`, `development_address`, `development_description`, `decision_type`, `registered_date`, `registered_in_last_7_working_days`, `registered_in_last_28_working_days`, `earliest_decision_date`, `decision_date`, `decison_level`, `system_status`, `system_status_change_date`, `applicant_name`, `ward`, `conservation_areas`, `case_officer`, `case_officer_team`, `responsibility_type`, `comment`, `full_application`, `application_type`, `easting`, `northing`, `longitude`, `latitude`, `spatial_accuracy`, `last_uploaded`, `location`, `socrata_id` WHERE (contains(upper(`conservation_areas`), \"REDINGTON\")) and (contains(upper(`development_description`), \"EXTENSION\")) and (contains(upper(`decision_type`), \"GRANTED\")) ORDER BY `case_officer` DESC NULL LAST",
  "rowsUpdatedAt" : 1780623146,
  "rowsUpdatedBy" : "6jeh-p2ix",
  "tableId" : 2068717,
  "totalTimesRated" : 0,
  "viewCount" : 6548,
  "viewLastModified" : 1738625362,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1473163685,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1534242,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1473163685,
    "targetAudience" : "public",
    "workflowId" : 157,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "failureCount" : 0,
      "status" : "success"
    },
    "submitter" : {
      "id" : "57ha-8eym",
      "displayName" : "Redfrog"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 27121316,
    "name" : "ID",
    "dataTypeName" : "number",
    "description" : "",
    "fieldName" : "pk",
    "position" : 1,
    "renderTypeName" : "number",
    "tableColumnId" : 200930,
    "width" : 50,
    "format" : {
      "precisionStyle" : "standard",
      "noCommas" : "false",
      "align" : "right"
    }
  }, {
    "id" : 27121317,
    "name" : "Application Number",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "application_number",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 200913,
    "width" : 316,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121318,
    "name" : "Development Address",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "development_address",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 200914,
    "width" : 328,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121319,
    "name" : "Development Description",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "development_description",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 200915,
    "width" : 376,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121320,
    "name" : "Decision Type",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "decision_type",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 200916,
    "width" : 256,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121321,
    "name" : "Registered Date",
    "dataTypeName" : "calendar_date",
    "description" : "",
    "fieldName" : "registered_date",
    "position" : 6,
    "rdfProperties" : "",
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 200917,
    "width" : 280,
    "format" : {
      "view" : "date_dmy",
      "rdf" : "",
      "align" : "left"
    }
  }, {
    "id" : 27121322,
    "name" : "Registered In Last 7 Working Days",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "registered_in_last_7_working_days",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 217097,
    "width" : 100,
    "format" : { }
  }, {
    "id" : 27121323,
    "name" : "Registered In Last 28 Working Days",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "registered_in_last_28_working_days",
    "position" : 8,
    "renderTypeName" : "text",
    "tableColumnId" : 291124,
    "width" : 100,
    "format" : { }
  }, {
    "id" : 27121324,
    "name" : "Earliest Decision Date",
    "dataTypeName" : "calendar_date",
    "description" : "",
    "fieldName" : "earliest_decision_date",
    "position" : 9,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 200919,
    "width" : 364,
    "format" : {
      "view" : "date_dmy",
      "align" : "left"
    }
  }, {
    "id" : 27121325,
    "name" : "Decision Date",
    "dataTypeName" : "calendar_date",
    "description" : "",
    "fieldName" : "decision_date",
    "position" : 10,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 200918,
    "width" : 256,
    "format" : {
      "view" : "date_dmy",
      "align" : "left"
    }
  }, {
    "id" : 27121326,
    "name" : "Decision Level",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "decison_level",
    "position" : 11,
    "renderTypeName" : "text",
    "tableColumnId" : 200920,
    "width" : 256,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121327,
    "name" : "System Status",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "system_status",
    "position" : 12,
    "renderTypeName" : "text",
    "tableColumnId" : 200921,
    "width" : 256,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121328,
    "name" : "System Status Change Date",
    "dataTypeName" : "calendar_date",
    "description" : "",
    "fieldName" : "system_status_change_date",
    "position" : 13,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 257996,
    "width" : 100,
    "format" : {
      "view" : "date_dmy",
      "align" : "left"
    }
  }, {
    "id" : 27121329,
    "name" : "Applicant Name",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "applicant_name",
    "position" : 14,
    "renderTypeName" : "text",
    "tableColumnId" : 200922,
    "width" : 268,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121330,
    "name" : "Ward",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "ward",
    "position" : 15,
    "renderTypeName" : "text",
    "tableColumnId" : 200923,
    "width" : 148,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121331,
    "name" : "Conservation Areas",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "conservation_areas",
    "position" : 16,
    "renderTypeName" : "text",
    "tableColumnId" : 257997,
    "width" : 100,
    "format" : { }
  }, {
    "id" : 27121332,
    "name" : "Case Officer",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "case_officer",
    "position" : 17,
    "renderTypeName" : "text",
    "tableColumnId" : 200926,
    "width" : 244,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121333,
    "name" : "Case Officer Team",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "case_officer_team",
    "position" : 18,
    "renderTypeName" : "text",
    "tableColumnId" : 200927,
    "width" : 304,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121334,
    "name" : "Responsibility Type",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "responsibility_type",
    "position" : 19,
    "renderTypeName" : "text",
    "tableColumnId" : 200928,
    "width" : 316,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121335,
    "name" : "Comment",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "comment",
    "position" : 20,
    "renderTypeName" : "text",
    "tableColumnId" : 200934,
    "width" : 184,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121336,
    "name" : "Full Application",
    "dataTypeName" : "url",
    "description" : "",
    "fieldName" : "full_application",
    "position" : 21,
    "renderTypeName" : "url",
    "tableColumnId" : 200931,
    "width" : 316,
    "format" : {
      "align" : "left"
    },
    "subColumnTypes" : [ "url", "description" ]
  }, {
    "id" : 27121337,
    "name" : "Application Type",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "application_type",
    "position" : 22,
    "renderTypeName" : "text",
    "tableColumnId" : 200932,
    "width" : 148,
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 27121338,
    "name" : "Easting",
    "dataTypeName" : "number",
    "description" : "",
    "fieldName" : "easting",
    "position" : 23,
    "renderTypeName" : "number",
    "tableColumnId" : 200924,
    "width" : 196,
    "format" : {
      "precisionStyle" : "standard",
      "noCommas" : "false",
      "align" : "right"
    }
  }, {
    "id" : 27121339,
    "name" : "Northing",
    "dataTypeName" : "number",
    "description" : "",
    "fieldName" : "northing",
    "position" : 24,
    "renderTypeName" : "number",
    "tableColumnId" : 200925,
    "width" : 208,
    "format" : {
      "precisionStyle" : "standard",
      "noCommas" : "false",
      "align" : "right"
    }
  }, {
    "id" : 27121340,
    "name" : "Longitude",
    "dataTypeName" : "number",
    "description" : "",
    "fieldName" : "longitude",
    "position" : 25,
    "renderTypeName" : "number",
    "tableColumnId" : 217095,
    "width" : 100,
    "format" : { }
  }, {
    "id" : 27121341,
    "name" : "Latitude",
    "dataTypeName" : "number",
    "description" : "",
    "fieldName" : "latitude",
    "position" : 26,
    "renderTypeName" : "number",
    "tableColumnId" : 217096,
    "width" : 100,
    "format" : { }
  }, {
    "id" : 27121342,
    "name" : "Spatial Accuracy",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "spatial_accuracy",
    "position" : 27,
    "renderTypeName" : "text",
    "tableColumnId" : 217088,
    "width" : 100,
    "format" : { }
  }, {
    "id" : 27121343,
    "name" : "Last Uploaded",
    "dataTypeName" : "calendar_date",
    "description" : "",
    "fieldName" : "last_uploaded",
    "position" : 28,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 217089,
    "width" : 100,
    "format" : {
      "view" : "date_dmy",
      "align" : "left"
    }
  }, {
    "id" : 27121345,
    "name" : "Socrata ID",
    "dataTypeName" : "number",
    "description" : "",
    "fieldName" : "socrata_id",
    "position" : 30,
    "renderTypeName" : "number",
    "tableColumnId" : 217090,
    "width" : 100,
    "format" : { }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "UK Open Government Licence v3",
    "logoUrl" : "images/licenses/ogl.png",
    "termsLink" : "http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/"
  },
  "metadata" : {
    "rdfSubject" : "0",
    "richRendererConfigs" : {
      "page" : {
        "columns" : [ {
          "styles" : {
            "width" : "100%"
          },
          "rows" : [ {
            "fields" : [ {
              "tableColumnId" : 200913,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200913,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200914,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200914,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200915,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200915,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200916,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200916,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200917,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200917,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200918,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200918,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200919,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200919,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200920,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200920,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200921,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200921,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200922,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200922,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200923,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200923,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200924,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200924,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200925,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200925,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200926,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200926,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200927,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200927,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200928,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200928,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200929,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200929,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200930,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200930,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200931,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200931,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200932,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200932,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200933,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200933,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200934,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200934,
              "type" : "columnData"
            } ]
          }, {
            "fields" : [ {
              "tableColumnId" : 200935,
              "type" : "columnLabel"
            }, {
              "tableColumnId" : 200935,
              "type" : "columnData"
            } ]
          } ]
        } ]
      }
    },
    "custom_fields" : {
      "Point of Contact" : {
        "Address" : "The Crowndale Centre, 218 Eversholt Street",
        "Telephone" : "020 7974 4444",
        "Role Name" : "Open Data Administrator",
        "Organisation Name" : "London Borough of Camden",
        "City/Town" : "London",
        "Postcode" : "NW1 1BD",
        "Directorate" : "Culture and Environment"
      },
      "OS Licence Detail" : {
        "Licence Type" : "OS OpenData",
        "Licence Information" : "Data derived from OS products which is free to use under the Open Government Licence. The following statement MUST be included when using this data: Contains OS data © Crown copyright and database right [year]",
        "Licence URL" : "http://www.ordnancesurvey.co.uk/business-and-government/licensing/using-creating-data-with-os-products/os-opendata.html"
      },
      "Publication" : {
        "Dataset Language" : "English",
        "Spatial Reference System" : "EPSG:27700",
        "Frequency of Update" : "Daily"
      }
    },
    "rowLabel" : "Row",
    "availableDisplayTypes" : [ "table", "fatrow", "page" ],
    "renderTypeConfig" : {
      "visible" : {
        "table" : true
      }
    }
  },
  "owner" : {
    "id" : "57ha-8eym",
    "displayName" : "Redfrog",
    "profileImageUrlLarge" : "/api/users/57ha-8eym/profile_images/LARGE",
    "profileImageUrlMedium" : "/api/users/57ha-8eym/profile_images/THUMB",
    "profileImageUrlSmall" : "/api/users/57ha-8eym/profile_images/TINY",
    "screenName" : "Redfrog",
    "type" : "interactive",
    "flags" : [ "acceptedEula" ]
  },
  "query" : { },
  "rights" : [ "read" ],
  "tableAuthor" : {
    "id" : "6jeh-p2ix",
    "displayName" : "Open Data Camden",
    "screenName" : "Open Data Camden",
    "type" : "interactive",
    "flags" : [ "acceptedEula", "mayBeStoriesCoOwner" ]
  },
  "tags" : [ "planning", "applications" ],
  "flags" : [ "calculatedView", "ownerMayBeContacted", "restorable", "restorePossibleForType", "soqlBasedView" ]
}