the lat/lng for PPLA should be within geoname-shape of country

number of errors=1
number of warnings=0
Group=chkGrpLocation

select geoname.name,geoname.geonameid,geoname.countrycode,coalesce(geoname_shape.countrycode,'xx'),geoshapeid, 'http://map.immofacts.ch/servlet/geonames?srv=781&lat=' || GEONAME.longlat[1] || '&lng=' || GEONAME.longlat[0] as shape from geoname join geoname_shape on level=1 and st_within(st_GeomFromText('Point(' || longlat[0] || ' ' || longlat[1] || ')',4326),wkb_geometry) where featurecode='PPLA' and geoname.countrycode<>geoname_shape.countrycode and geoname.geonameid not in (2309332)

name	geonameid	countrycode	coalesce	geoshapeid	shape	
Ariel	8199394	IL	PS	29871	http://map.immofacts.ch/servlet/geonames?srv=781&lat=32.10649727016813&lng=35.18448829650879