Tree Preservation Orders
Plymouth City Council
@ukgov.tree_preservation_orders117
TPO Zones
@ukgov.tree_preservation_orders117.tpo_zones
CSV containing data about the TPO zones found across the city
- 333.83 KB
- 487 rows
- 10 columns
unnamed_0Unnamed: 0 | referenceReference | nameName | tree_preservation_orderTree-preservation-order | tree_preservation_zone_typeTree-preservation-zone-type | notesNotes | start_dateStart-date | entry_dateEntry-date | end_dateEnd-date | geometryGeometry |
|---|---|---|---|---|---|---|---|---|---|
| 10 | 10 | Area | St Marys Beechfield School Hartley Road Plymouth PL3 5LW | MULTIPOLYGON (((248231.016 56920.708, 248240.761 56924.42, 248253.754 56929.757, 248286.7 56890.313, 248298.301 56875.464, 248289.717 56861.775, 248292.269 56859.223, 248293.429 56852.958, 248285.308 56853.654, 248284.148 56837.181, 248278.812 56823.492, 248279.972 56791.705, 248252.826 56806.323, 2… | |||||
| 1 | 11 | 11 | Area | St Marys Beechfield School Hartley Road Plymouth PL3 5LW | MULTIPOLYGON (((248165.076 56859.738, 248219.855 56855.236, 248219.6 56855.15, 248219.35 56852.3, 248218.9 56848.6, 248218.4 56845.4, 248218.25 56844.75, 248217.85 56842.15, 248217.8 56841.5, 248217.75 56840.8, 248217.75 56839, 248217.8 56838.35, 248217.8 56837.65, 248217.9 56837, 248217.95 56836.35… | ||||
| 2 | 12 | 12 | Group | St Marys Beechfield School Hartley Road Plymouth PL3 5LW | MULTIPOLYGON (((248171.619 56890.081, 248173.475 56895.418, 248173.011 56896.578, 248192.733 56906.323, 248195.749 56901.218, 248171.619 56890.081))) | ||||
| 3 | 13 | 13 | Area | Land Between Houndiscombe Road And Southerland Road Plymouth PL4 6HH | MULTIPOLYGON (((248025.05 55410.8, 248042.25 55421.95, 248049.7 55426.8, 248062.65 55435, 248064.7 55432.9, 248063.55 55430.45, 248061.35 55424.65, 248058.05 55415.9, 248052.55 55400.2, 248052.05 55398.15, 248051.5 55395.65, 248050.6 55391.8, 248049.4 55386.7, 248048.35 55381.85, 248047 55373.65, 24… | ||||
| 4 | 18 | 18 | Group | East Side Of Woodford Road Plymouth PL6 7HX | MULTIPOLYGON (((250670.033 60778.036, 250680.971 60785.517, 250688.544 60762.89, 250688.825 60760.646, 250689.245 60757.653, 250689.526 60755.409, 250689.386 60753.914, 250687.983 60751.482, 250686.441 60749.988, 250684.197 60747.932, 250684.057 60747.932, 250682.514 60746.622, 250671.996 60740.079,… | ||||
| 5 | 19 | 19 | Area | Boston Close Plymouth | MULTIPOLYGON (((250070.517 53099.781, 250074.692 53100.989, 250077.597 53100.507, 250080.501 53099.781, 250082.679 53098.329, 250083.224 53094.698, 250083.042 53088.402, 250082.498 53081.629, 250081.227 53076.059, 250075.963 53054.52, 250074.692 53052.098, 250073.785 53051.616, 250060.171 53045.807,… | ||||
| 6 | 21 | 21 | Area | 42 And 44 Glenfield Road Plymouth PL6 7LN | MULTIPOLYGON (((250658.7 60457.95, 250661.4 60457.2, 250665.55 60456.15, 250667.75 60455.65, 250670.95 60455, 250683.35 60452.4, 250694.3 60450, 250696.2 60449.65, 250696.7 60449.5, 250706.25 60447.65, 250706.7 60447.35, 250712.6 60421, 250716.4 60402.95, 250716.45 60402.95, 250732.45 60399.2, 25073… | ||||
| 7 | 22 | 22 | Area | Area 8 And 9 At Mainstone | MULTIPOLYGON (((251461.338 59156, 251467.783 59156.889, 251473.338 59157.556, 251672.45 59189.556, 251675.339 59176.222, 251471.783 59144.889, 251461.338 59156))) | ||||
| 8 | 23 | 23 | Woodland | Area 8 And 9 At Mainstone | MULTIPOLYGON (((251524.367 59025.88, 251523.953 59046.303, 251524.05 59046, 251541.7 59044.9, 251544.3 59044.7, 251546.85 59044.5, 251549.45 59044.35, 251551.4 59044.2, 251553.3 59044.05, 251555.2 59043.95, 251557.7 59043.75, 251558.95 59043.7, 251561.2 59043.6, 251563.45 59043.55, 251565.7 59043.45… | ||||
| 9 | 26 | 26 | Group | East Of Haye Road Elburton | MULTIPOLYGON (((253244.013 53471.817, 253244.861 53474.754, 253246.897 53476.112, 253251.477 53477.697, 253266.067 53479.054, 253284.558 53479.505, 253301.692 53479.96, 253306.103 53479.96, 253308.987 53479.732, 253310.175 53479.054, 253311.023 53477.925, 253311.362 53476.34, 253311.362 53476.112, 2… |
CREATE TABLE tpo_zones (
"unnamed_0" BIGINT,
"reference" BIGINT,
"name" BIGINT,
"tree_preservation_order" VARCHAR,
"tree_preservation_zone_type" VARCHAR,
"notes" VARCHAR,
"start_date" VARCHAR,
"entry_date" VARCHAR,
"end_date" VARCHAR,
"geometry" VARCHAR
);