each island lat/lng should be within its bounding box

number of errors=10
number of warnings=0
Group=chkGrpBBox
Group=ckgGrpIsland

select geoname.geonameid,countrycode,name,featureclass as fcl,geoname.featurecode as fcode,'http://map.immofacts.ch/servlet/geonames?srv=781&lat=' || GEONAME.longlat[1] || '&lng=' || GEONAME.longlat[0] as shape,'http://map.immofacts.ch/shape/' || geoshapeid || '/' as geoshapeid from geoname_bbox,geoname where geoname.geonameid=geoname_bbox.geonameid and (south>longlat[1] or longlat[1]>north or (westeast)) or (west>east and ((longlat[0]<0 and longlat[0]>west) or (longlat[0]>0 and longlat[0]

geonameid	countrycode	name	fcl	fcode	shape	geoshapeid	
3391468	BR	Ilha Inajatuba	T	ISL	http://map.immofacts.ch/servlet/geonames?srv=781&lat=-1.799977&lng=-49.717972	http://map.immofacts.ch/shape/4704/	
3394100	BR	Ilha Murituba	T	ISL	http://map.immofacts.ch/servlet/geonames?srv=781&lat=-1.95020477&lng=-50.4553167	http://map.immofacts.ch/shape/721957/	
8508248	BR	Ilha Itapera	T	ISL	http://map.immofacts.ch/servlet/geonames?srv=781&lat=-1.90440245&lng=-50.1423333	http://map.immofacts.ch/shape/722073/	
3422229	GL	Kullorsuaq	T	ISL	http://map.immofacts.ch/servlet/geonames?srv=781&lat=74.60796&lng=-57.13274	http://map.immofacts.ch/shape/15391/	
1282367	MV	Fehigili	T	ISL	http://map.immofacts.ch/servlet/geonames?srv=781&lat=5.55741015&lng=73.48139426	http://map.immofacts.ch/shape/704094/	
1680578	MY	Turtle Islands	T	ISLS	http://map.immofacts.ch/servlet/geonames?srv=781&lat=6.2113&lng=118.094	null	
1821133	PH	Kalayaan Islands	T	ISLS	http://map.immofacts.ch/servlet/geonames?srv=781&lat=10.671404468527436&lng=115.8453369140625	null	
5872069	US	Pribilof Islands	T	ISLS	http://map.immofacts.ch/servlet/geonames?srv=781&lat=56.909&lng=-169.94202	null	
5879148	US	Aleutian Islands	T	ISLS	http://map.immofacts.ch/servlet/geonames?srv=781&lat=52.0969444&lng=-173.5005556	null	
1821005	null	Spratly Islands	T	ISLS	http://map.immofacts.ch/servlet/geonames?srv=781&lat=10&lng=114	null