KitWallace / treemap

3 stars 2 forks source link

Get University of Bristol dataset #38

Open MarkCDAshdown opened 7 years ago

MarkCDAshdown commented 7 years ago

http://maps.bristol.gov.uk/pinpoint/ filtered on Environment and Planning - Trees - Bristol University only shows tree at certain locations, but a * search lists 'the first 1500 matching records...' elsewhere (e.g. Royal Fort Garden), even though they are not shown on the map layer.

The dataset cannot be copied of the site. maybe the data is on a separate dataset in https://opendata.bristol.gov.uk/Environment/?

KitWallace commented 7 years ago

Contact made with Alan Stealey, Head of External Estates and Kevin Stuckey, Horticultural Manager Kevin provided a spreadsheet of data on 2,600 trees which have been parsed. This is the same data provided to BCC. However nearly 900 of them have incorrect os coordinates which places them in Wales. Kevin has been contacted.

KitWallace commented 7 years ago

Kevin and Alan contacted again re misplaced trees

KitWallace commented 7 years ago

Called Kevin - they are asking their data provider I tried a simple shift and this seems to have worked although some trees are misplaced

Discovered there are duplicate ids - arggggh

5 new locations need adding

Access to location would be a useful attribute to include

KitWallace commented 7 years ago

multiple duplicates have had a suffix added

KitWallace commented 7 years ago

Some trees have questionable locations- eg those on top of Senate house - need to let UoB know about them

KitWallace commented 7 years ago

request from kevin to export the revised data to pinpoint

KitWallace commented 7 years ago

need to merge in original data from the UoB data and then format to export

KitWallace commented 7 years ago

still not done the export ! ID duplication was a problem and still a number duplcated in the same site - also 2 trees out of position - contact Kevin