Single TPO

Broxtowe Borough Council

@ukgov.single_tpo

Table List

1 table(83.09 KB)

Table 1

@ukgov.single_tpo.table_1

83.09 KB
1133 rows
24 columns

x X	y Y	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	notes NOTES	updated UPDATED	origin Origin	licence Licence
451248.25	337912.3749	1	TPO/BRA/08	TPO/BRA/08/T5	CLOSE QUARTERS/COW LANE 1989	1 The Pines Bramcote Nottinghamshire NG9 3BB	Bramcote	Front of Property	S	1 x Cherry	T5	Fri Aug 25 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1989/11/06 00:00:00+00	Inspected	Mon Nov 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	No Tree	Sun Sep 27 2020 23:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA
451237.4687	337891.218599999	2	TPO/BRA/08	TPO/BRA/08/T3	CLOSE QUARTERS/COW LANE 1989	3 The Pines Bramcote Nottinghamshire NG9 3BB	Bramcote	Front of Property	S	1 x Birch	T3	Fri Aug 25 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1989/11/06 00:00:00+00	Inspected	Mon Nov 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)		Sun Sep 27 2020 23:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA
451236.7812	337860.0624	3	TPO/BRA/09	TPO/BRA/09/T1	COW LANE 2 1989	88 Cow Lane Bramcote Nottinghamshire NG9 3BB	Bramcote	88 Cow Lane	S	Colorado Spruce	T1	Fri Dec 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1990/02/22 00:00:00+00	Inspected	Mon Nov 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	No Tree	Fri Oct 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA
451240.4687	337856.093599999	4	TPO/BRA/09	TPO/BRA/09/T3	COW LANE 2 1989	88 Cow Lane Bramcote Nottinghamshire NG9 3BB	Bramcote	88 Cow Lane	S	Cedar	T3	Fri Dec 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1990/02/22 00:00:00+00	Inspected	Mon Nov 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	As TPO 15m Est Height 450-600mm Dbh Est	Fri Oct 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA
451225.9375	337846.531099999	5	TPO/BRA/09	TPO/BRA/09/T4	COW LANE 2 1989	88 Cow Lane Bramcote Nottinghamshire NG9 3BB	Bramcote	88 Cow Lane	S	Oak	T4	Fri Dec 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1990/02/22 00:00:00+00	Inspected	Mon Nov 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	As TPO 15m Est Height 600mm Dbh Est	Fri Oct 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA
451231.5312	337829.531099999	6	TPO/BRA/09	TPO/BRA/09/T5	COW LANE 2 1989	88 Cow Lane Bramcote Nottinghamshire NG9 3BB	Bramcote	88 Cow Lane	S	Norway Maple	T5	Fri Dec 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1990/02/22 00:00:00+00	Inspected	Mon Nov 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	As TPO 15+m Est Height 450mm Dbh Est	Fri Oct 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA
451261.375	337834.9999	7	TPO/BRA/09	TPO/BRA/09/T7	COW LANE 2 1989	88 Cow Lane Bramcote Nottinghamshire NG9 3BB	Bramcote	88 Cow Lane	S	Cedar	T7	Fri Dec 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1990/02/22 00:00:00+00	Inspected	Mon Nov 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	As TPO 15-20m Est Height 450mm dbh Est	Fri Oct 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA
451248.5	337817.968599999	8	TPO/BRA/09	TPO/BRA/09/T9	COW LANE 2 1989	88 Cow Lane Bramcote Nottinghamshire NG9 3BB	Bramcote	88 Cow Lane	S	Lawson Cypress	T9	Fri Dec 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1990/02/22 00:00:00+00	Not Inspected			Fri Aug 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA
451241.3437	337816.6874	9	TPO/BRA/09	TPO/BRA/09/T8	COW LANE 2 1989	88 Cow Lane Bramcote Nottinghamshire NG9 3BB	Bramcote	88 Cow Lane	S	Holly	T8	Fri Dec 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1990/02/22 00:00:00+00	Not Inspected			Fri Aug 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA
451248.7812	337808.6249	10	TPO/BRA/09	TPO/BRA/09/T10	COW LANE 2 1989	88 Cow Lane Bramcote Nottinghamshire NG9 3BB	Bramcote	88 Cow Lane	S	Flowering Crab Apple	T10	Fri Dec 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Confirmed	1990/02/22 00:00:00+00	Inspected	Mon Nov 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Stump Only	Fri Oct 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	PSMA


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