Coastwatch 2024 autumn survey data cleanup log

Began with file Coastwatch All Ireland Survey_2024_ALL RESULTS_241116.xlsx which Karin emailed to Paul and Eoin on 29 December 2024.

Generated a new column A, called “COMBINED_C”, which is in the same format as the survey unit field of the same name in the ESRI shapefile from Angel, CW_Survey_Units.shp: NxNxNxNx (e.g. 8x3x5x9x for a survey unit in Fingal called “Barnageeragh Cove (part)”).

Removed any characters from the A1 fields which were wrong (e.g. 8x3x4x7 in the Block Code and Unit Code of North Loughshinny and “13 & 14 - Galway + Galway South & City” in the County Code for Galway units).

Galway units were all made 13.