Trees In Leeds City Centre

Leeds City Council

@ukgov.trees_in_leeds_city_centre

Table List

2 tables(499.4 KB)

2017

2010

2010

@ukgov.trees_in_leeds_city_centre.n_2010

229.52 KB
3750 rows
12 columns

ref REF	type TYPE	no_trees NO TREES	area_sq AREA SQ	location LOCATION	contact CONTACT	version VERSION	x X	y Y	shape_area SHAPE AREA	shape_len SHAPE LEN	area_ha AREA HA
1	Group	3	86.488	Woodhouse Lane (Opposite The Pack Horse, PH)	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429323.0633	434983.7642	86.4882428	34.84364269	0.008649
2	Single Tree	1	20.255	210 Clarendon Road	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429253.2434	434974.9568	20.25457995	15.97423526	0.002025
3	Single Tree	1	26.343	205 Clarendon Road	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429241.9312	434963.6446	26.34328961	18.21764485	0.002634
4	Group	4	539.75	Clarendon Road (Corner with traffic barriers leading to Leeds University)	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429218.2311	434918.5283	539.7496586	127.8855941	0.053975
5	Group	3	147.842	Clarendon Road (University car park)	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429200.8644	434903.6619	147.8417997	51.62963071	0.014784
6	Single Tree	1	40.806	Clarendon Road (University car park)	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429195.0797	434893.2144	40.80598411	24.40591322	0.004081
7	Linear Belt	4	170.59	Clarendon Road (University car park / Henry Price Residences)	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429188.0111	434874.0862	170.5904872	71.31098807	0.017059
8	Single Tree	1	75.805	Clarendon Road (Henry Price Residences - vehicle entrance)	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429159.6235	434793.5068	75.8255964	30.90339624	0.007581
9	Linear Belt	4	232.071	Clarendon Road (Henry Price Resodences - car park)	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429148.3395	434771.1589	232.0708007	82.25766265	0.023207
10	Single Tree	1	102.73	Clarendon Road (Henry Price Resodences - car park)	Glen Gorner, City Development - Parks and Countryside, e-mail: Glen.Gorner@leeds.gov.uk	V 1.0 - 24/06/2010	429136.687	434754.1521	102.7304864	41.36844194	0.010273


CREATE TABLE n_2010 (
  "ref" BIGINT,
  "type" VARCHAR,
  "no_trees" BIGINT,
  "area_sq" DOUBLE,
  "location" VARCHAR,
  "contact" VARCHAR,
  "version" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "shape_area" DOUBLE,
  "shape_len" DOUBLE,
  "area_ha" DOUBLE
);