disambiguate UK placenames

[doug-leasure]

In the Beneficiaries map, we have added the "UK" option that allows users to browse towns and cities within the UK where research beneficiaries were located. In some cases, there is more than one town in the UK with the same place name, so it was ambiguous which is being referred to without further investigation .

@GISRedeDev has gone through the duplicate place names and selected the most likely in their judgement (often the most urban/populous town). In the attached csv, they listed the duplicate place names along and indicated the one they chose using the ID from the attached geopackage (layer=uk_region_placenames_with_duplicates).

We need to verify these place names by referring back to the Impact Case Studies, where possible, to find the correct location. We can indicate our selections in one of two ways:

1. Keep the desired place/delete the duplicate place from the attached geopackage, or
2. Edit the csv to include the correct ID.

There are additional layers in the geopackage that show the duplicates removed by @GISRedeDev (layer=best_guess_duplicates_removed) and the duplicates (layer=duplicates).

disambiguate_uk_placenames.zip

[doug-leasure]

A simplified ICS database to help link ambiguous place names to ICS more easily:

enhanced_ref_data_select.zip

[doug-leasure]

@GISRedeDev , we are working to produce a table with the following columns:

• ics_id (i.e. REF impact case study identifier from enhanced_ref_data.csv)
• placename (i.e. individual names taken from UK region tag values from enhanced_ref_data.csv)
• geo_id (i.e. the correct point ID from uk_region_placenames.gpkg)

Please confirm that this is everything you need for the next step of making sure the UK beneficiary place names for each ICS map to the correct location on the map in the dashboard.

[doug-leasure]

@GISRedeDev , we now have a completed spreadsheet to disambiguate UK placenames thanks to hard work from Alice. Could you please remind me what the next step is?

location duplicates.xlsx

[GISRedeDev]

Hi @doug-leasure. Sorry I have not missed this. I will try to take a look at it this week to refresh my memory. If everything is clear in the spreadsheet I will take a look at fixing it over the weekend. I'll give you a shout if I have a problem. Thanks to Alice!

[doug-leasure]

Feel free to ping me over the weekend if questions arise.

[GISRedeDev]

Hi @doug-leasure Sorry I've only just got round to this. I have fixed the geopackage as best I could, but the attached csv is what Alice was not able to identify (some locations are in different countries, so I assumed these can be dropped, but maybe the main database needs fixing in that case). Do you think you could spare 30-45 minutes some time to go through this and finalise everything? Let me know when you're free and I can jump on a call.

problems_remain.csv