heuristic to find wrong coordinates and / or wrong iso-codes (pacific region)

Find coordinates by iso-code that are far away from the average center of all coordinates with the same iso-code and sort them by descending distance from that center. This is a heuristic to find wrong coordinates and / or wrong iso-codes. If you get to the first point already inside the iso-code area, it is unlikely to find more errors further down below. Works best for iso areas that are close to cycle shape (Switzerland, as opposed to the USA).
Fix & rerun. You can change iso codes through variables iso1 and iso2 (you have to copy the script).
Original script by Thomas Ledl.

SQL

use dewiki_p;
set @iso1:='US';
#set @iso2:='' or code
set @iso2:='AK';
set @offset:=360;

#select  gt_country, (case when gt_lon<0 then gt_lon+@offset else gt_lon end) as gt_lon2 where gt_country='NZ' from geo_tags;

select sqrt((gt_lat - cen_gt_lat)*(gt_lat - cen_gt_lat) + (gt_lon2 - cen_gt_lon)*(gt_lon2 - cen_gt_lon)) as distanzungefaehr, 
       gt_lat, (select gt_lon where case when gt_lon<0 then gt_lon+@offset else gt_lon end) as gt_lon2, gt_page_id, gt_name,
       (select page_title from page where page_id = gt_page_id) as title,
       gt_country,gt_region from geo_tags,
       (select avg(gt_lat) cen_gt_lat,avg(gt_lon2) cen_gt_lon,count(*) from geo_tags
        where 
        	case 
        		when @iso2=''
        		then gt_country=@iso1
        		else gt_country=@iso1 and gt_region=@iso2
        		end) as zentrumdavon
        where
        	case
            	when @iso2=''
                then gt_country=@iso1 
                else gt_country=@iso1 and gt_region=@iso2
                end
       order by 1 desc limit 100;
       
#and gt_region is null

SQL

Checking query status...