Tree Preservations

City of York Council

@ukgov.tree_preservations

Table List

1 table(153.49 KB)

Tree Preservations

@ukgov.tree_preservations.tree_preservations

Spreadsheet

153.49 KB
3550 rows
15 columns

x X	y Y	objectid OBJECTID	treeid TREEID	location LOCATION	botanical BOTANICAL	species SPECIES	owner OWNER	site_name SITE NAME	type TYPE
-1.14530646027328	53.9880869634373	74123	1/1970-T41	Sycamore	Acer Pseudoplatanus	Sycamore	Private	Nether & Upper Poppleton	Single tree
-1.1426763369544	53.9876817697209	74124	1/1970-T72	Beech	Fagus Sylvatica	Beech	Private	Nether & Upper Poppleton	Single tree
-0.96559419115257	53.8951866868989	74125	1/1988-T15	Horse Chestnut	Aesculus Hippocastanum	Horse Chestnut	Private	Main Street/Back Lane South, Wheldrake	Single tree
-1.1084633215537	53.9025062905219	74126	10/1988-T3	Ash	Fraxinus Excelsior	Ash	Private	Darling Lane/Mill Lane, Acaster Malbis	Single tree
-1.1348578394437	53.9991931724274	74127	1973/107-T9	Sycamore	Acer Pseudoplatanus	Sycamore	Private	The Vale, Skelton Village	Single tree
-1.13392423730315	53.9993392435946	74128	107/1973-T10	Fir	Abies	Fir	Private	The Vale, Skelton Village	Single tree
-0.954621571608033	53.8976534238033	74129	11/1993-T4	Beech	Fagus Sylvatica	Beech	Private	Fernby, Church Lane, Wheldrake,	Single tree
-1.00260685860011	53.9947986953477	74130	111/1988-T2	Oak	Quercus robur	Oak	Private	58 &74 The Village, Stockton on Forest	Single tree
-1.13355595638097	53.9943034096683	74131	125/1989-T4	Beech	Fagus Sylvatica	Beech	Private	Ambulance Service Trust, Fairfields,, Shipton Road	Single tree
-1.05207965559218	53.9112058644199	74132	13/1989-T1	Beech	Fagus Sylvatica	Beech	Private	Grove Cottage, Deighton	Single tree


CREATE TABLE tree_preservations (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "treeid" VARCHAR,
  "location" VARCHAR,
  "botanical" VARCHAR,
  "species" VARCHAR,
  "owner" VARCHAR,
  "site_name" VARCHAR,
  "type" VARCHAR,
  "age" BIGINT,
  "spread" DOUBLE,
  "height" DOUBLE,
  "trunk" BIGINT,
  "planted" BIGINT
);

Share link

Anyone who has the link will be able to view this.