2025-05-23     2025-05-24     2025-05-25

each adm2 lat/lng should be within its bounding box

number of errors=9
number of warnings=0
Group=chkGrpBBox

select geoname.geonameid,countrycode,name,admincode1 as adm1,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 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]

[{key=TR,number=9}]

geonameid	countrycode	name	adm1	fcl	fcode	shape	
7732341	TR	Yıldırım İlçesi	16	A	ADM2	http://map.immofacts.ch/servlet/geonames?srv=781&lat=40.195667&lng=29.036398	
437928	TR	İskenderun İlçesi	31	A	ADM2	http://map.immofacts.ch/servlet/geonames?srv=781&lat=36.4947222&lng=36.0897222	
9541389	TR	Defne	31	A	ADM2	http://map.immofacts.ch/servlet/geonames?srv=781&lat=36.23739&lng=36.16364	
8631472	TR	Pazarcık İlçesi	46	A	ADM2	http://map.immofacts.ch/servlet/geonames?srv=781&lat=37.594668&lng=36.93168	
8630874	TR	Karakoyunlu İlçesi	88	A	ADM2	http://map.immofacts.ch/servlet/geonames?srv=781&lat=39.8804&lng=43.633023	
9543301	TR	Balçova	35	A	ADM2	http://map.immofacts.ch/servlet/geonames?srv=781&lat=38.37302&lng=27.08714	
8521536	TR	Sultangazi	34	A	ADM2	http://map.immofacts.ch/servlet/geonames?srv=781&lat=41.21791981422846&lng=28.717403411865234	
8521538	TR	Şişli	34	A	ADM2	http://map.immofacts.ch/servlet/geonames?srv=781&lat=41.12514221619814&lng=29.00012969970703	
8631554	TR	Yayladere İlçesi	12	A	ADM2	http://map.immofacts.ch/servlet/geonames?srv=781&lat=38.498394&lng=40.342449