Add fields to Location table: admin_unit_global_gaul_code, admin_unit_tropical_gaul_code.
Populate these fields by DataAcquisition as a "post-QC process". Use the PostGIS function ST_INTERSECTS because doing it in the Java used an extra 1Gb of RAM.
Remove geom field from the AdminUnitGlobalOrTropical entity as it is not used in the Java (and is much more memory hungry than the simplified geom).
Fix bug whereby locations could be duplicated if they were changed (i.e. snapped) as a result of QC stage 2 or 3.
Ensure that snapped points are rounded to 5 decimal places.