Dataset

Tree preservation order

This dataset is the yield of the Tree preservation order pipeline. The pipeline has been configured to collect, process and yield data that matches the Tree preservation order schema.

Configuration summary

• Typology: Legal instrument
• Sources: 9
• Pipeline rules: 190
• Lookup rules: 34602
• Collection: Tree preservation order

Pipeline rules

180 column rules

Map resource column name to dataset field

Showing 5 column rules

Dataset	Column	Endpoint	Field	Resource	Entry date	Start date	End date
tree-preservation-order	Description		notes	10a1d54078c8dddf5a75e745bc78ec0febe6d8b074043814d580897188068230
tree-preservation-order	Location		address-text	10a1d54078c8dddf5a75e745bc78ec0febe6d8b074043814d580897188068230
tree-preservation-order	TPO		reference	10a1d54078c8dddf5a75e745bc78ec0febe6d8b074043814d580897188068230
tree-preservation-order	Location		address-text	20ab1d84c669217e70328f90d2379c75c59a3889945bfba4941090021ab2214f
tree-preservation-order	Made_date		start-date	20ab1d84c669217e70328f90d2379c75c59a3889945bfba4941090021ab2214f

See all column rules

1 combine rules

Combine a series of facts from multiple entries

Showing 1 combine rule

Dataset	Endpoint	Field	Resource	Separator	Entry date	Start date	End date
tree-preservation-zone	d551675f1579af9e69e105e9fe8f33fc4160dd8004fd6975863480e0d16b6337	geometry

See all combine rules

7 concat rules

Concatenate fields during the harmonise phase

Showing 5 concat rules

Dataset	Endpoint	Field	Fields	Resource	Separator	Entry date	Start date	End date
tree-preservation-zone		tree-species-list	SPECIES_1_NAME;SPECIES_2_NAME;SPECIES_3_NAME;SPECIES_4_NAME;SPECIES_5_NAME;SPECIES_6_NAME		;
tree-preservation-zone		reference	TPO;TPO_Group	10a1d54078c8dddf5a75e745bc78ec0febe6d8b074043814d580897188068230	/
tree-preservation-zone		reference	TPO;TPO_Group	565ccd7f93f479428b2164f3e02e49a454f47721bf418b1a153ac19049ec05ea	/
tree-preservation-zone		reference	TPO;TPO_Group	7315d937dcef7d3b9028d71e0ce6cd9b0277e36cb2b69783e1b215a955ce20db	/
tree-preservation-zone		reference	TPO;TPO_Group	eb5dbbbc4aed2ec190375d15f06b772559d336b94ba776aa3ddd3c042efa34f8	/

See all concat rules

0 convert rules

Convert a resource

0 default rules

Take a missing field default value from another field

0 default-value rules

provide a default value for a missing or empty field

0 filter rules

Filter entries

34602 lookup rules

Lookup entities

Showing 5 lookup rules

Dataset	Endpoint	Entity	Entry number	Organisation	CURIE prefix	Reference	Resource	Value	Entry date	Start date	End date
		7002016036		local-authority-eng:NET	tree	2016/007.T3
		7002004075		local-authority-eng:BUC	tree	ZZZZZUESRW189
		7002004076		local-authority-eng:BUC	tree	ZZZZZUESRW190
		7002004077		local-authority-eng:BUC	tree	ZZZZZUESRW191
		7002004078		local-authority-eng:BUC	tree	ZZZZZUESRW192

See all lookup rules

2 patch rules

Assert a field value during harmonise

Showing 2 patch rules

Dataset	Endpoint	Entry number	Field	Pattern	Resource	Value	Entry date	Start date	End date
tree			reference	^$	8f35e0a7bbca0daeda982d6f39aac0afa7b0fae1bf9419c53a5d279f450ad7b3	2551?
tree			reference	^$	a993375ec694f798bbfacff2a8553141a537436d017c6f30e161c6c4b55b5292	2551?

See all patch rules

0 skip rules

Remove lines from a resource during normalise

0 transform rules

None

Sources

Showing 9 sources.

See table of all sources for Tree preservation order dataset.

• 558360515b8a3f3a44ec5e63e80f7095 - https://opendata.arcgis.com/datasets/dbbcc688ab9c4b53ac03df44e02ae704_0.geojson
• fb375ed5db29f44e4cb8b8b4904a6a8a - https://raw.githubusercontent.com/digital-land/tree-preservation-order-collection/main/data/Southwark/TPO%20zones%20-%20Area%20type.zip
• ccf524e2bd6df2bf6a712b1e51d2b26b - https://raw.githubusercontent.com/digital-land/tree-preservation-order-collection/main/data/Southwark/TPO%20zones%20-%20Group%20type.zip
• d501adae0632f09bc2b4d7b2857024af - https://raw.githubusercontent.com/digital-land/tree-preservation-order-collection/main/data/Southwark/TPO%20zones%20-%20Individual%20type.zip
• bb04ccd6b1e787c99e48f5d309039707 - https://raw.githubusercontent.com/digital-land/tree-preservation-order-collection/main/data/Southwark/TPO%20zones%20-%20Woodland%20type.zip
• 082543b7e19b363a064ec0a97b4b5e88 - https://opendata.arcgis.com/datasets/a4ddbb5114274ba89e33a33545c407c8_0.geojson
• 3e8714cb058213519c3881a058553d76 - https://datamillnorth.org/download/treepreservationorders/0ba9ca5d-a094-4c56-9931-ae8096006038/TPOs_points.csv
• ceabe0236af8e247687c8fc73eb10961 - https://datamillnorth.org/download/treepreservationorders/8aed98d7-cc84-4c3f-bd21-a75d6899f02c/TPOs_areas.csv
• e505d00fdc8c6267abb3f0989fc568fe - https://medwaymaps.medway.gov.uk/WFS/wfs.exe?service=WFS&version=2.0.0&request=GetFeature&TypeNames=ENV_TREE_PRESERVATION_ORDERS