Tree Trails - Castle Hill Country Park
Leicester City Council
@ukgov.tree_trails_castle_hill_country_park
Table 1
@ukgov.tree_trails_castle_hill_country_park.table_1
Tree Trails - Castle Hill Country Park (csv)
- 14 KB
- 17 rows
- 8 columns
tree_noTree No | common_nameCommon Name | latin_nameLatin Name | descriptionDescription | eastingEasting | northingNorthing | tree_photographTree Photograph | locationLocation |
|---|---|---|---|---|---|---|---|
| 1 | Oak | Quercus robur | Known as the ‘Great Oak’ this fantastic old tree is a remnant of the trees that once would have covered this area. It is one of the oldest trees in the city, thought to be around 300 years old. Fencing has been installed to protect the area surrounding this veteran tree. | 456008 | 308976 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/987cee8acd9d5b9bac714456482195cf | 52.67560165524849, -1.1730828793894053 |
| 2 | Whitebeam | Sorbus aria | The Whitebeam is a medium sized, dome shaped deciduous tree native to southern England. It has oval serrated leaves that have distinctive white, felt-like fur underneath. It has clusters of white flowers in May and red berries in the autumn. | 456042 | 309107 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/6b39c5d4ae273b11312d69fbad97e0c0 | 52.67677566989935, -1.1725578371834295 |
| 3 | Alder | Alnus glutinosa | This native tree was once used to produce clogs in northern England. Its natural habitat is boggy land and riverbanks and can survive many weeks with its roots underwater. Has distinctive yellow catkins in March. | 456085 | 309202 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/3f76ad175dcca790895c6570beffed2b | 52.677625158583815, -1.1719057829724249 |
| 4 | Lime | Tilia platyphyllos | The broad-leaved Lime is a native of Britain. It is a large, fast-growing tree which has roughly fissured bark when mature, its small flowers appear in June/July. It is commonly planted in large gardens and parks and is useful for avenue planting. | 456204 | 309401 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/4daaa528c5a98b7e2fae1e23984152ca | 52.67940160802351, -1.1701120125740017 |
| 14 | Sycamore | Acer pseudoplatanus | Native or not? The sycamore has long been naturalised in Britain. It is a very large tree, and extremely fast growing for the first 20 years. The environmental impact of this tree is not to be understated. It hosts a wide range of wildlife and provides a refuge in landscapes that do not readily supp… | 455912 | 308794 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/5097794477ea60d6a5903ea906e77f65 | 52.67397559955587, -1.1745333774056985 |
| 15 | Hybrid Black Poplars | Populus x canadensis | Hybrid Black Poplars arise when the European Black Poplar is crossed with the American Eastern Cottonwood. Some hybrids are natural, but many are artificial. Hybrid Black Poplars are common, they are grown for timber, but many are planted in parks and along riversides. They grow rapidly and form lar… | 455801 | 308578 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/998e0d9dc08b3e2c3ba87745eb0943b4 | 52.67204544959942, -1.1762113210370768 |
| 7 | Hawthorn | Crataegus monogyna | This small native tree is usually seen forming many of the hedgerows in the UK, but it does form a sturdy small tree. It has small white fragrant flowers which appear in May – June, which are followed by small red fruits in autumn, providing much needed food for wild birds. | 456400 | 309676 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/b90edc66816aabcd3152b1c31f4daa93 | 52.681853177061264, -1.1671662681494261 |
| 9 | Fruit Orchard | Malus, Pyrus & Prunus species | Fruit orchard with mixed species. This is a young establishing orchard. It is a haven for all kinds of wildlife. Located close to the entrance off Anstey Lane between Thurcaston and Anstey. | 456221 | 309833 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/e9b5f10356f90c5c0efa6e47d7f55eef | 52.68328296909665, -1.1697869851571894 |
| 10 | Horse Chestnut | Aesculus hippocastanum | One of the most well known and loved trees. It was introduced to Britain from the borders of Greece and Albania in the 1600s. This tree has very attractive candle-like white flowers tinged with yellow then pink in late spring. Then in the autumn the “conkers” in their spikey casings open and fall to… | 456028 | 309510 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/c9cecdc94b136109714da21348be276a | 52.680399567486155, -1.1726964605842602 |
| 13 | Beech | Fagus sylvatica | Located in a wooded area, the beech is one of our most beautiful trees and makes a magnificent individual specimen. Identifiable by its silver-grey bark in amongst the other trees at this location. It matures into a stately tree and is well suited to large gardens and parks. It also a very valuable … | 455849 | 309234 | https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/tree-trails-castle-hill-country-park/files/97aa80a4ca37b08dcdf3780229f9610a | 52.67793712183818, -1.1753905538216507 |
CREATE TABLE table_1 (
"tree_no" BIGINT,
"common_name" VARCHAR,
"latin_name" VARCHAR,
"description" VARCHAR,
"easting" BIGINT,
"northing" BIGINT,
"tree_photograph" VARCHAR,
"location" VARCHAR
);