number of errors=14
number of warnings=0
Group=chkGrpLocation
select geoname.name,geoname.geonameid,geoname.countrycode,coalesce(geoname_shape.countrycode,'xx'),geoshapeid,geoname.featurecode,relevance,population, 'http://map.immofacts.ch/servlet/geonames?srv=781&lat=' || GEONAME.longlat[1] || '&lng=' || GEONAME.longlat[0] as shape from geoname left outer join geoname_shape on level=1 and st_within(st_GeomFromText('Point(' || longlat[0] || ' ' || longlat[1] || ')',4326),wkb_geometry) where featureclass='P' and relevance>8 and geoname.countrycode<>coalesce(geoname_shape.countrycode,'xx') order by relevance desc,geoname.name
[{key=IL,number=5}, {key=SO,number=2}, {key=US,number=2}, {key=FO,number=1}, {key=JP,number=1}, {key=KY,number=1}, {key=MA,number=1}, {key=TK,number=1}]
name geonameid countrycode coalesce geoshapeid featurecode relevance population shape Cabudwaaq 63400 SO ET 23588 PPL 21 120000 http://map.immofacts.ch/servlet/geonames?srv=781&lat=6.24585&lng=46.2247 Nukunonu 7522181 TK xx null PPLA 20 426 http://map.immofacts.ch/servlet/geonames?srv=781&lat=-9.20045132431936&lng=-171.848042607307 North Side 3580575 KY xx null PPLA 19 1902 http://map.immofacts.ch/servlet/geonames?srv=781&lat=19.35&lng=-81.2 Við Sjógv 2610294 FO xx null PPL 14 1158 http://map.immofacts.ch/servlet/geonames?srv=781&lat=62.119666&lng=-6.750053 Smara 2461874 MA EH 24752 PPL 12 42056 http://map.immofacts.ch/servlet/geonames?srv=781&lat=26.73840524596216&lng=-11.671943664550781 Modiin Ilit 8199378 IL PS 29871 PPL 11 76374 http://map.immofacts.ch/servlet/geonames?srv=781&lat=31.932205609521006&lng=35.04415512084961 Ariel 8199394 IL PS 29871 PPLA 10 20540 http://map.immofacts.ch/servlet/geonames?srv=781&lat=32.10649727016813&lng=35.18448829650879 Balanbale 342803 SO ET 23588 PPL 10 68000 http://map.immofacts.ch/servlet/geonames?srv=781&lat=5.76896575&lng=45.76296795 Isumi 6822180 JP xx null PPLA2 10 35544 http://map.immofacts.ch/servlet/geonames?srv=781&lat=35.2300465&lng=140.404917 Majdal Shams 167444 IL SY 25138 PPL 10 11180 http://map.immofacts.ch/servlet/geonames?srv=781&lat=33.27029&lng=35.771604 Ghajar 173882 IL SY 25138 PPL 9 2607 http://map.immofacts.ch/servlet/geonames?srv=781&lat=33.271154&lng=35.62288 Mākena 5850639 US xx null PPL 9 196 http://map.immofacts.ch/servlet/geonames?srv=781&lat=20.6544444&lng=-156.4425 Sand Point 5873349 US xx null PPLA2 9 1064 http://map.immofacts.ch/servlet/geonames?srv=781&lat=55.33597&lng=-160.50071 Tel Qatsir 163684 IL SY 25138 PPL 9 2878 http://map.immofacts.ch/servlet/geonames?srv=781&lat=32.705449&lng=35.617614