Your data has issues

There is a problem

• 3 entries must have dates in YYYY-MM-DD format

Reference	Name	Documentation URL	Document URL	Made date	Confirmed date	Notes	Entry date	Start date	End date
59/00003/TPO	Hall Green Road Hall Green West Bromwich West Midlands	https://webcaps.sandwell.gov.uk/publicaccess/treesDetails.do?activeTab=documents&keyVal=HMSYL1NRI1012	https://webcaps.sandwell.gov.uk/publicaccess/files/BED1FF11FAA8D662EBC41A01E8F6EE6B/pdf/59_00003_TPO-TPO-1374683.pdf			ELM	2023-10-04		Invalid date
61/00012/TPO	Church Vale West Bromwich	https://webcaps.sandwell.gov.uk/publicaccess/treesDetails.do?activeTab=documents&keyVal=HMUDAMNRI1000	https://webcaps.sandwell.gov.uk/publicaccess/files/F1DB70BAE7605E9BDCC6915A5602DDF3/pdf/61_00012_TPO-TPO-1374718.pdf			WYCH ELM	2024-02-28		Invalid date
90/00103/TPO	Tree Preservation Order 103 Hill Lane Great Barr Birmingham West Midlands	https://webcaps.sandwell.gov.uk/publicaccess/treesDetails.do?activeTab=summary&keyVal=HNW4F3NRI1000	https://webcaps.sandwell.gov.uk/publicaccess/files/B6BB27A7FDFABC9E8F5C6399FC393748/pdf/90_00103_TPO-SMBC_TPO_ORDER_NO._103__HILL_LANE__GREAT_BARR_-1374243.pdf			HORSE CHESTNUT	2005-10-10		Invalid date

How to fix this issue

Your dataset is missing the end-date column.

The Tree preservation order guidance explains how to fix the issue:

end-date

Where the tree preservation order is revoked, this should be the date that it was no longer in effect, written in YYYY-MM-DD format. If the TPO is still active, leave this field blank. If the tree has been felled, use the felled-date field.

Example: 1999-01-20

How to improve Sandwell Metropolitan Borough Council’s data

1. Fix the errors indicated
2. Use the check service to make sure the data meets the standard
3. Publish the updated data on the endpoint URL