Group TPO

Broxtowe Borough Council

@ukgov.group_tpo

Table List

1 table(43.61 KB)

Table 1

@ukgov.group_tpo.table_1

43.61 KB
276 rows
25 columns

objectid OBJECTID	file_ref FILE REF	tree_ref TREE REF	title TITLE	address ADDRESS	town TOWN	location LOCATION	tpotype TPOTYPE	species SPECIES	label LABEL	tpomade TPOMADE	status STATUS	tpoconfirm TPOCONFIRM	inspected INSPECTED	inspectdate INSPECTDATE	updated UPDATED	origin Origin	licence Licence	shape_area Shape Area	shape_length Shape Length
1	TPO/BEE/08	TPO/BEE/08/G15	BROADGATE EAST/SALTHOUSE LANE 1977	University Of Nottingham 50 Pines Salthouse Court Broadgate Park Student Village Beeston Nottinghamshire NG9 2GY	Beeston	Within the grounds of the Broadgate Student Village	G	x9 Lime	G15	Mon Sep 12 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Tue Jan 31 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Inspected	Mon Oct 19 2015 23:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 24 2020 10:30:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	227.410559359676	76.7016914625817
2	TPO/BEE/08	TPO/BEE/08/G4	BROADGATE EAST/SALTHOUSE LANE 1977	74 Broadgate Beeston Nottinghamshire NG9 2FW	Beeston	Within the grounds of 72/74 Broadgate	G	x15 Poplar, x1 Sycamore, x1 Ash	G4	Mon Sep 12 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Tue Jan 31 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Inspected	Mon Oct 19 2015 23:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 24 2020 10:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	182.981267176309	82.978380916685
3	TPO/BEE/08	TPO/BEE/08/G14	BROADGATE EAST/SALTHOUSE LANE 1977	University Of Nottingham 57 Elms Salthouse Court Broadgate Park Student Village Beeston Nottinghamshire NG9 2GY	Beeston	Within the grounds of the Broadgate Student Village	G	x3 Lime, x3 Elm, x2 Horse Chestnut, x1 Sweet Chestnut	G14	Mon Sep 12 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Tue Jan 31 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Inspected	Mon Oct 19 2015 23:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 24 2020 10:15:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	176.085176568883	58.4092398987515
4	TPO/BEE/08	TPO/BEE/08/G5	BROADGATE EAST/SALTHOUSE LANE 1977	74 Broadgate Beeston Nottinghamshire NG9 2FW	Beeston	Within the grounds of 72/74 Broadgate	G	x1 Ash, x1 Pear, x2 Green Holly	G5	Mon Sep 12 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Tue Jan 31 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Inspected	Mon Oct 19 2015 23:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 24 2020 10:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	100.280496874708	47.5085923402134
5	TPO/BRA/01	TPO/BRA/01/G15	BRAMCOTE 1968	Site Of Former Bramcote Hall/School Town Street Bramcote Nottinghamshire	Bramcote	North west side of the former Bramcote Hall school, and forming part of Burnt Hill	G	x4 pine, x3 beech, x7 oak, x2 ash	G15	Fri Jun 14 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Thu Sep 19 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	Inspected	Tue Nov 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 07 2020 07:30:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	3428.54236873784	253.230822753111
6	TPO/BRA/01	TPO/BRA/01/W3	BRAMCOTE 1968	Site Of Former Bramcote Hall/School Town Street Bramcote Nottinghamshire	Bramcote	On the west side of and adjacent to the former Bramote Hall School	W	Lime, sycammore, birch, oak, poplar, ash, beech, pine, horse chestnut	W3	Fri Jun 14 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Thu Sep 19 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	Inspected	Tue Nov 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 07 2020 07:45:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	15485.9518109835	903.382709408245
7	TPO/BEE/08	TPO/BEE/08/G2	BROADGATE EAST/SALTHOUSE LANE 1977	46 Broadgate Beeston Nottinghamshire NG9 2FW	Beeston	Within the grounds of 44 & 46 Broadgate	G	x2 Green Holly, x1 Beech, x1 Silver Birch	G2	Mon Sep 12 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Tue Jan 31 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Not Inspected		Fri Apr 24 2020 10:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	77.4369570274881	40.3162942596568
8	TPO/BEE/08	TPO/BEE/08/G1	BROADGATE EAST/SALTHOUSE LANE 1977	40 Broadgate Beeston Nottinghamshire NG9 2FW	Beeston	Within the grounds of 40 & 42 Broadgate	G	x2 Green Holly, x1 Yew, x1 Evergreen Oak	G1	Mon Sep 12 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Tue Jan 31 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Inspected	Mon Oct 19 2015 23:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 24 2020 10:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	115.533494527992	46.3881674073576
9	TPO/BRA/01	TPO/BRA/01/G5	BRAMCOTE 1968	Site Of Former Bramcote Hall/School Town Street Bramcote Nottinghamshire	Bramcote	adjacent to and on the north easte side of the former Bramcote Hall School	G	x1 sycamore, x1 beech, x2 horse chestnut, x4 oak	G5	Fri Jun 14 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Thu Sep 19 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	Inspected	Tue Nov 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 07 2020 07:15:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	704.386267964281	112.177416355974
10	TPO/BRA/01	TPO/BRA/01/W5	BRAMCOTE 1968	Town Street Bramcote Nottinghamshire	Bramcote	Town Street	W	oak, ash, elm, sycamore, lime	W5	Fri Jun 14 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	Thu Sep 19 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	Inspected	Tue Nov 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 07 2020 07:45:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA	840.046837504662	239.045460043658


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "file_ref" VARCHAR,
  "tree_ref" VARCHAR,
  "title" VARCHAR,
  "address" VARCHAR,
  "town" VARCHAR,
  "location" VARCHAR,
  "tpotype" VARCHAR,
  "species" VARCHAR,
  "species_list" VARCHAR,
  "label" VARCHAR,
  "tpomade" TIMESTAMP,
  "status" VARCHAR,
  "tpoconfirm" TIMESTAMP,
  "tpofell" TIMESTAMP,
  "tporemove" TIMESTAMP,
  "inspected" VARCHAR,
  "inspectdate" TIMESTAMP,
  "updated" TIMESTAMP,
  "origin" VARCHAR,
  "licence" VARCHAR,
  "licenceurl" VARCHAR,
  "captscale" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);