About this Dataset

TPO Single Trees

Bradford Council maintains 2 separate data sources for its recording and management of Tree Preservation Orders (TPO), Single_Tree_Inspire and Groups_Areas_Woodlands. Both datasets must be used in conjunction to provide a comprehensive dataset of TPO within its boundary. Users of this dataset must be aware that this is NOT the definitive dataset and reveals only Confirmed Orders. Any and all queries with regard to TPOs should be directed to Bradford Council’s Planning Department. In 2002 Bradford Council carried out a data capture exercise to digitise its paper (map based) records of its TPOs, since then it has created and managed its TPO records via ESRI’s desktop products and the IDOX Uniform TPO Module. A tree preservation order is a written order made by a local planning authority (e.g. a borough, district or unitary council or a national park authority) which, in general, makes it an offence to cut down, top, lop, uproot, wilfully damage or wilfully destroy a tree protected by that order without the authority’s permission.
Publisher name: City of Bradford Metropolitan District Council
Last updated: 2024-09-18T04:00:04Z

Tables

Table 1

@ukgov.tpo_single_trees11.table_1

767.84 KB
6111 rows
108 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "unisdeliveufrm_tptree_pointobjectid" BIGINT,
  "unisdeliveufrm_tptree_pointkeyval" VARCHAR,
  "unisdeliveufrm_tptree_pointcreatedby" VARCHAR,
  "unisdeliveufrm_tptree_pointmodifiedby" VARCHAR,
  "unisdeliveufrm_tptree_pointdate_created" TIMESTAMP,
  "unisdeliveufrm_tptree_pointdate_modified" TIMESTAMP,
  "unisdeliveufrm_tptree_pointstatus" BIGINT,
  "unisdeliveufrm_tptree_pointtransaction_type" VARCHAR,
  "unisdeliveufrm_tptree_pointsymbol" BIGINT,
  "unisdeliveufrm_tptree_pointx" BIGINT,
  "unisdeliveufrm_tptree_pointy" BIGINT,
  "unisdeliveufrm_tptree_pointcaseno" VARCHAR,
  "unisdeliveufrm_tptree_pointtreetype" VARCHAR,
  "unisdeliveufrm_tptree_pointtnum" DOUBLE,
  "unisdeliveufrm_tptree_pointrefval" VARCHAR,
  "unisdeliveufrm_tptree_pointtptreecat" VARCHAR,
  "unisdeliveufrm_tptree_pointcatnos" DOUBLE,
  "unisdeliveufrm_tptree_pointlabel" VARCHAR,
  "unisdeliveufrm_tptree_pointtpstatus" VARCHAR,
  "unisdeliveufrm_tptree_pointlatitude" VARCHAR,
  "unisdeliveufrm_tptree_pointlongitude" VARCHAR,
  "unisdeliveufrm_tptree_pointmap_x" DOUBLE,
  "unisdeliveufrm_tptree_pointmap_y" DOUBLE,
  "unisdeliveufrm_tptree_pointdescript" VARCHAR,
  "unisdeliveufrm_tptree_pointaddress" VARCHAR,
  "unisdeliveufrm_tptree_pointdaterem" VARCHAR,
  "unisdeliveufrm_tptree_pointse_anno_cad_data" VARCHAR,
  "uni73livetptreekeyval" VARCHAR,
  "uni73livetptreepkeyval" VARCHAR,
  "uni73livetptreeu_version" VARCHAR,
  "uni73livetptreetptreecat" VARCHAR,
  "uni73livetptreecatnos" DOUBLE,
  "uni73livetptreetpkeyval" VARCHAR,
  "uni73livetptreetreetype" VARCHAR,
  "uni73livetptreetnum" DOUBLE,
  "uni73livetptreecomments" VARCHAR,
  "uni73livetptreemapnorth" BIGINT,
  "uni73livetptreemapeast" BIGINT,
  "uni73livetptreecreatedd" TIMESTAMP,
  "uni73livetptreeupdatedd" TIMESTAMP,
  "uni73livetptreeupdateby" VARCHAR,
  "uni73livetptreesituat" VARCHAR,
  "uni73livetptreedaterem" VARCHAR,
  "uni73livetptreedaterepdue" VARCHAR,
  "uni73livetptreedaterep" VARCHAR,
  "uni72livecncodelistname" VARCHAR,
  "uni72livecncodecodevalue" VARCHAR,
  "uni72livecncodeu_version" VARCHAR,
  "uni72livecncodecodetext" VARCHAR,
  "uni72livecncodecodecat" VARCHAR,
  "uni72livecncodehistoric" VARCHAR,
  "uni72livecncodextratext" VARCHAR,
  "uni73livetpapplkeyval" VARCHAR,
  "uni73livetpapplu_version" VARCHAR,
  "uni73livetpapplrefval" VARCHAR,
  "uni73livetpappltpstatus" VARCHAR,
  "uni73livetpappltpapptype" VARCHAR,
  "uni73livetpapplprkeyval" VARCHAR,
  "uni73livetpappladdress" VARCHAR,
  "uni73livetpapplmapeast" BIGINT,
  "uni73livetpapplmapnorth" BIGINT,
  "uni73livetpappldescript" VARCHAR,
  "uni73livetpappldaterec" TIMESTAMP,
  "uni73livetpapplofficer" VARCHAR,
  "uni73livetpapploffcost" VARCHAR,
  "uni73livetpapplward" VARCHAR,
  "uni73livetpapplparish" VARCHAR,
  "uni73livetpapplrequreason" VARCHAR,
  "uni73livetpappldatedraft" TIMESTAMP,
  "uni73livetpappltargetdate" TIMESTAMP,
  "uni73livetpapplcommitted" TIMESTAMP,
  "uni73livetpappldconfirmed" TIMESTAMP,
  "uni73livetpapplserveddate" TIMESTAMP,
  "uni73livetpappltotcost" VARCHAR,
  "uni73livetpapplconsexp" VARCHAR,
  "uni73livetpapplordtype" DOUBLE,
  "uni73livetpapplapprovyn" VARCHAR,
  "uni73livetpappllastlett" VARCHAR,
  "uni73livetpapplordexp" TIMESTAMP,
  "uni73livetpapplconschng" VARCHAR,
  "uni73livetpapplordschng" VARCHAR,
  "uni73livetpappldatewith" TIMESTAMP,
  "uni73livetpappltpneilett" VARCHAR,
  "uni73livetpapplneiconyn" VARCHAR,
  "uni73livetpappllastprntd" VARCHAR,
  "uni73livetpapplackyn" VARCHAR,
  "uni73livetpappltpreasend" VARCHAR,
  "uni73livetpappltpmckeyval" VARCHAR,
  "uni73livetpapplcreatedd" TIMESTAMP,
  "uni73livetpapplupdatedd" TIMESTAMP,
  "uni73livetpapplupdateby" VARCHAR,
  "uni73livetpapplmodified" VARCHAR,
  "uni73livetpappldatestadv" VARCHAR,
  "uni73livetpappldateexpiry" VARCHAR,
  "uni73livetpappldateadvprt" VARCHAR,
  "uni73livetpapplsnprnt" VARCHAR,
  "uni73livetpappladprnt" VARCHAR,
  "uni73livetpappltpsslacode" DOUBLE
);