number of errors=207
number of warnings=0
country=NO
Group=chkGrpPostalCode
Group=chkGrpShp
select countrycode,place,numaddresses,array_length(postalcodes,1) as l,postalcodes[1] as pc1,'http://www.geonames.org/maps/google_' || st_y(st_centroid(wkb_geometry)) || '_' || st_x(st_centroid(wkb_geometry)) || '.html' as gnmap from addr_hull_place where geonameid is null and countrycode='NO' order by numaddresses desc
countrycode place numaddresses l pc1 gnmap NO Nordre Frogn 2109 1 1455 http://www.geonames.org/maps/google_59.7338364488686_10.658107957945292.html NO Vang På Hedmarken 1581 1 2324 http://www.geonames.org/maps/google_60.9739830740645_11.16145668464547.html NO Eidsvåg I Romsdal 1496 1 6460 http://www.geonames.org/maps/google_62.7724383795972_8.015846374650879.html NO Jerpstad 1460 1 7335 http://www.geonames.org/maps/google_62.98801046847696_9.735690693705202.html NO Beitstad 1433 1 7730 http://www.geonames.org/maps/google_64.13611322024678_11.402274360705704.html NO Vik I Sogn 1389 1 6893 http://www.geonames.org/maps/google_61.03240010258362_6.418582327587791.html NO Vøringsfoss 1247 1 5785 http://www.geonames.org/maps/google_60.31147621686896_7.432105742491069.html NO Snertingdal 1219 1 2838 http://www.geonames.org/maps/google_60.898922893619506_10.399768033393947.html NO Tessanden 1203 1 2683 http://www.geonames.org/maps/google_61.621130014993646_8.950477754735815.html NO Velfjord 1185 1 8960 http://www.geonames.org/maps/google_65.39203711478484_12.655282609008639.html NO Valnesfjord 1141 1 8215 http://www.geonames.org/maps/google_67.34158049938041_15.2445554335813.html NO Nes På Hedmarken 1103 1 2350 http://www.geonames.org/maps/google_60.770144647627_10.917276719950335.html NO Skåla 1004 1 6456 http://www.geonames.org/maps/google_62.72355900644858_7.482040017709223.html NO Sjetnemarka 959 1 7081 http://www.geonames.org/maps/google_63.37045965712082_10.397831064642666.html NO Våler I Østfold 941 1 1592 http://www.geonames.org/maps/google_59.502505000365154_10.881952156510913.html NO Åsenfjord 926 1 7632 http://www.geonames.org/maps/google_63.59145542717087_10.920270156462578.html NO Bosberg 911 1 7070 http://www.geonames.org/maps/google_63.4066444590814_10.133626599858621.html NO Nordberg 863 1 2693 http://www.geonames.org/maps/google_61.94537570128797_7.83142357212276.html NO Dyrvik 848 1 7270 http://www.geonames.org/maps/google_63.76026777275139_8.74405814401835.html NO Sunde I Sunnhordland 826 1 5450 http://www.geonames.org/maps/google_59.84354466862744_5.7230908730192835.html NO Finnås 801 1 5437 http://www.geonames.org/maps/google_59.713935402359965_5.212475189453084.html NO Leira I Valdres 782 1 2920 http://www.geonames.org/maps/google_60.95540360282028_9.2444021739286.html NO Søre Osen 780 1 2428 http://www.geonames.org/maps/google_61.12605760548107_11.939141658924507.html NO Grue Finnskog 771 1 2256 http://www.geonames.org/maps/google_60.44138852296005_12.450613258120693.html NO Tomrefjord 768 1 6393 http://www.geonames.org/maps/google_62.57894827690617_6.918854949932996.html NO Sørli 741 1 7884 http://www.geonames.org/maps/google_64.19962468942136_13.711768930970184.html NO Eidsnes 725 1 6037 http://www.geonames.org/maps/google_62.42328619247935_6.329466635697615.html NO Årland 701 1 5652 http://www.geonames.org/maps/google_60.37593747231207_5.674340784454957.html NO Budalen 695 1 7298 http://www.geonames.org/maps/google_62.78180188280159_10.556171784990852.html NO Hovin I Telemark 692 1 3652 http://www.geonames.org/maps/google_59.886064230369705_9.02622925654244.html NO Aust-Torpa 689 1 2881 http://www.geonames.org/maps/google_60.997448168595035_10.123724721115757.html NO Sævelandsvik 686 1 4275 http://www.geonames.org/maps/google_59.273202697582434_5.212937727360208.html NO Espedalen 684 1 2658 http://www.geonames.org/maps/google_61.39524709441146_9.488810954746667.html NO Sundlandet 673 1 7255 http://www.geonames.org/maps/google_63.49297532667723_9.270051919670946.html NO Øydegard 671 1 6670 http://www.geonames.org/maps/google_63.017683722546884_7.977993050083017.html NO Sæbøvågen 662 1 5938 http://www.geonames.org/maps/google_60.62206264031562_5.151006537333994.html NO Atrå 661 1 3656 http://www.geonames.org/maps/google_60.04505423037774_8.421790580744197.html NO Ræge 655 1 4053 http://www.geonames.org/maps/google_58.8624904983634_5.588792887923347.html NO Gimse 653 1 7227 http://www.geonames.org/maps/google_63.274792332768676_10.244637762499124.html NO Sandhornøy 649 1 8130 http://www.geonames.org/maps/google_67.11187039007028_14.177912694395276.html NO Røyksund 639 1 5546 http://www.geonames.org/maps/google_59.315929368598376_5.368586323018188.html NO Haugastøl 634 1 3595 http://www.geonames.org/maps/google_60.48105959901236_7.804868964301891.html NO Gurskøy 626 1 6080 http://www.geonames.org/maps/google_62.251679655061935_5.798405085895916.html NO Solbergmoen 615 1 3058 http://www.geonames.org/maps/google_59.759587353685696_10.052614010818875.html NO Øvre Ervik 614 1 5106 http://www.geonames.org/maps/google_60.443845951745395_5.327343113253096.html NO Rindalsskogen 610 1 6658 http://www.geonames.org/maps/google_63.14168078370317_9.327057123372205.html NO Vallersund 605 1 7167 http://www.geonames.org/maps/google_63.85650539198061_9.786242503249625.html NO Vatnestrøm 598 1 4730 http://www.geonames.org/maps/google_58.42443415875779_8.0681448164791.html NO Holum 591 1 4519 http://www.geonames.org/maps/google_58.107611876122526_7.4899455906233.html NO Sjernarøy 576 1 4170 http://www.geonames.org/maps/google_59.252456821948016_5.83785060853384.html NO Fossdal 564 1 4544 http://www.geonames.org/maps/google_58.55637148674834_7.445810106310868.html NO Førde I Hordaland 554 1 5555 http://www.geonames.org/maps/google_59.57798215756756_5.49395024474094.html NO Tollå 553 1 8114 http://www.geonames.org/maps/google_66.8571129670224_14.723912386512787.html NO Svatsum 553 1 2657 http://www.geonames.org/maps/google_61.323572364358725_9.654383748984488.html NO Bogøy 543 1 8288 http://www.geonames.org/maps/google_67.90570387286915_15.238490418110086.html NO Årdal I Ryfylke 537 1 4137 http://www.geonames.org/maps/google_59.14559627706277_6.36113701101147.html NO Torangsvåg 533 1 5384 http://www.geonames.org/maps/google_60.12567586346201_5.167070881735249.html NO Nedgården 532 1 1692 http://www.geonames.org/maps/google_59.01382808943799_11.083008149779289.html NO Foldfjorden 516 1 6694 http://www.geonames.org/maps/google_63.22039717638531_8.375919421913176.html NO Ytterøy 484 1 7629 http://www.geonames.org/maps/google_63.783879922715926_11.099575449113544.html NO Tysværvåg 484 1 5565 http://www.geonames.org/maps/google_59.29723178690563_5.515234268385141.html NO Leinøy 483 1 6094 http://www.geonames.org/maps/google_62.355511776868376_5.668198326816343.html NO Elsfjord 480 1 8672 http://www.geonames.org/maps/google_66.07138489640052_13.578880748000962.html NO Ålvundfjord 478 1 6622 http://www.geonames.org/maps/google_62.85805261980534_8.484571515277324.html NO Åsgreina 476 1 2033 http://www.geonames.org/maps/google_60.16920010947319_10.990567956170334.html NO Markabygda 475 1 7622 http://www.geonames.org/maps/google_63.621373070156224_11.37562799175397.html NO Slitu 452 1 1859 http://www.geonames.org/maps/google_59.58110447955437_11.264822883901473.html NO Tørdal 447 1 3753 http://www.geonames.org/maps/google_59.20397863399694_8.774712264312573.html NO Hovsherad 443 1 4462 http://www.geonames.org/maps/google_58.55315575372472_6.534461040652877.html NO Syvde 439 1 6140 http://www.geonames.org/maps/google_62.078463214489936_5.736687677009141.html NO Nedre Vats 438 1 5578 http://www.geonames.org/maps/google_59.47497422607947_5.7563693614956595.html NO Gursken 438 1 6082 http://www.geonames.org/maps/google_62.22565097247647_5.627704430873507.html NO Risdal 436 1 4834 http://www.geonames.org/maps/google_58.704903349794854_8.079284208817807.html NO Hærland 431 1 1878 http://www.geonames.org/maps/google_59.55366649381269_11.46459781186574.html NO Berg I Østfold 431 1 1789 http://www.geonames.org/maps/google_59.136048345728476_11.2633492152633.html NO Tufsingdalen 429 1 2555 http://www.geonames.org/maps/google_62.27313414253324_11.741146270394712.html NO Kvås 427 1 4588 http://www.geonames.org/maps/google_58.258057634070845_7.166418462003509.html NO Leinesfjord 427 1 8283 http://www.geonames.org/maps/google_67.78990226986275_14.855611054982255.html NO Granli 422 1 2210 http://www.geonames.org/maps/google_60.11134883060431_12.013295854799713.html NO Breim 417 1 6827 http://www.geonames.org/maps/google_61.73100090975849_6.413511550393844.html NO Nerlandsøy 416 1 6098 http://www.geonames.org/maps/google_62.34571661003706_5.559700587331545.html NO Jøsenfjorden 397 1 4134 http://www.geonames.org/maps/google_59.35165940656986_6.604579384550764.html NO Øvre Surnadal 396 1 6653 http://www.geonames.org/maps/google_62.975317077597275_9.089891381486833.html NO Hyen 394 1 6829 http://www.geonames.org/maps/google_61.681857810688825_5.8577609178614995.html NO Nordre Toten 392 1 2820 http://www.geonames.org/maps/google_60.74872150997093_10.751578721478639.html NO Hellevik I Fjaler 388 1 6967 http://www.geonames.org/maps/google_61.29721741034558_5.149616631559126.html NO Storjord I Tysfjord 386 1 8275 http://www.geonames.org/maps/google_68.20033042811345_16.045532427937246.html NO Lismarka 385 1 2616 http://www.geonames.org/maps/google_61.07908973288343_10.618870089078872.html NO Halsnøy Kloster 383 1 5455 http://www.geonames.org/maps/google_59.798491455250264_5.671652867399033.html NO Mykland 378 1 4832 http://www.geonames.org/maps/google_58.639267222919095_8.267543768795873.html NO Austefjorden 373 1 6110 http://www.geonames.org/maps/google_62.05209968517985_6.296553942745152.html NO Bøverdalen 371 1 2687 http://www.geonames.org/maps/google_61.65619147986184_8.19468669947255.html NO Dolmøy 370 1 7252 http://www.geonames.org/maps/google_63.6442624988327_8.76141466266414.html NO Solumsmoen 369 1 3355 http://www.geonames.org/maps/google_59.95819963259388_9.683465503692425.html NO Brandsfjord 366 1 7194 http://www.geonames.org/maps/google_64.15639042703906_10.471487442424946.html NO Eresfjord 364 1 6470 http://www.geonames.org/maps/google_62.65584869684542_8.11343488985549.html NO Innfjorden 362 1 6315 http://www.geonames.org/maps/google_62.476154423638754_7.505994965451095.html NO Rudshøgda 356 1 2360 http://www.geonames.org/maps/google_60.90783207633321_10.798402395219627.html NO Atløy 353 1 6985 http://www.geonames.org/maps/google_61.35784278355582_4.947442441305585.html NO Hasselvika 348 1 7112 http://www.geonames.org/maps/google_63.64354426876838_9.876308905290024.html NO Hol I Tjeldsund 345 1 9444 http://www.geonames.org/maps/google_68.50286961030473_16.25408325404801.html NO Åbogen 340 1 2220 http://www.geonames.org/maps/google_60.10501368706056_12.170390573939288.html NO Vestre Sandøya 335 1 4915 http://www.geonames.org/maps/google_58.59050691500245_9.0523645401502.html NO Gullesfjord 332 1 8409 http://www.geonames.org/maps/google_68.623776707091_15.817658311484745.html NO Vihals 325 1 6697 http://www.geonames.org/maps/google_63.34914445441016_8.625686739348197.html NO Vågstranda 323 1 6387 http://www.geonames.org/maps/google_62.59465763751918_7.295710048827938.html NO Vestre Vinnesvåg 321 1 5396 http://www.geonames.org/maps/google_60.02053180656321_5.2642351798703055.html NO Ålvundeid 315 1 6620 http://www.geonames.org/maps/google_62.756381506541665_8.562807030567305.html NO Nordtveitgrend 314 1 5646 http://www.geonames.org/maps/google_60.07795612844499_5.775110336898091.html NO Kongsvik 310 1 9436 http://www.geonames.org/maps/google_68.56154028105951_16.231462796175276.html NO Indre Nærøy 307 1 7944 http://www.geonames.org/maps/google_64.81152275838966_11.322714934646152.html NO Beito 298 1 2952 http://www.geonames.org/maps/google_61.25339411686037_8.830576248489852.html NO Åsmarka 294 1 2365 http://www.geonames.org/maps/google_61.04160719537755_10.759393924727343.html NO Kjølsdalen 285 1 6776 http://www.geonames.org/maps/google_61.93609509592762_5.620162721112103.html NO Åram 284 1 6149 http://www.geonames.org/maps/google_62.16458127962053_5.5110279795617085.html NO Utvik 282 1 6797 http://www.geonames.org/maps/google_61.80527888423648_6.475451072066038.html NO Vindøla 282 1 6655 http://www.geonames.org/maps/google_62.95361395888741_8.971510195782685.html NO Begna 277 1 2937 http://www.geonames.org/maps/google_60.667550578632735_9.907839834596823.html NO Nes Verk 276 1 4934 http://www.geonames.org/maps/google_58.635825223097854_8.825153866117796.html NO Flatraket 275 1 6717 http://www.geonames.org/maps/google_61.96514553381946_5.26179360647466.html NO Vistdal 275 1 6364 http://www.geonames.org/maps/google_62.69208299454542_7.918011476075197.html NO Moltustranda 273 1 6076 http://www.geonames.org/maps/google_62.300504281706345_5.612648703325288.html NO Verma 271 1 6330 http://www.geonames.org/maps/google_62.34599858455191_7.981164987840961.html NO Lora 268 1 2666 http://www.geonames.org/maps/google_62.10825673403488_8.584383460383814.html NO Todalen 265 1 6645 http://www.geonames.org/maps/google_62.792070228591264_8.797836747745537.html NO Øvre Vats 257 1 5576 http://www.geonames.org/maps/google_59.54197264578881_5.698741386248143.html NO Skiftun 257 1 4146 http://www.geonames.org/maps/google_59.28971468905893_6.191862371687501.html NO Øvre Snertingdal 253 1 2839 http://www.geonames.org/maps/google_60.959368863052184_10.242791121236207.html NO Korsfjorden 251 1 9536 http://www.geonames.org/maps/google_70.27685750627924_23.43448747254187.html NO Osmarka 238 1 6638 http://www.geonames.org/maps/google_62.869219512203976_7.876657264185336.html NO Øvre Eidfjord 237 1 5784 http://www.geonames.org/maps/google_60.38103984747619_7.144559970041148.html NO Kysnesstrand 235 1 5626 http://www.geonames.org/maps/google_60.17178739810849_6.1356519807349645.html NO Grindvoll 234 1 2720 http://www.geonames.org/maps/google_60.302747669354616_10.486450574904575.html NO Kana 231 1 3483 http://www.geonames.org/maps/google_59.54758016520606_10.482331282236963.html NO Flaknan 227 1 7596 http://www.geonames.org/maps/google_63.11769996579347_11.297243016464954.html NO Skrautvål 225 1 2917 http://www.geonames.org/maps/google_61.030515345557724_9.243187265523149.html NO Fortun 218 1 6877 http://www.geonames.org/maps/google_61.51247984898154_7.7702054608271105.html NO Brasøy 216 1 8842 http://www.geonames.org/maps/google_65.91404162380333_12.127045983980894.html NO Jektvik 213 1 8187 http://www.geonames.org/maps/google_66.61581181475675_13.285500681744045.html NO Matre 212 1 5498 http://www.geonames.org/maps/google_59.82741656828018_6.016483385199259.html NO Dalsbygda 203 1 2552 http://www.geonames.org/maps/google_62.51923507434849_11.031241953934353.html NO Liabygda 202 1 6212 http://www.geonames.org/maps/google_62.31693928800458_7.042090775236905.html NO Mjosundet 201 1 6693 http://www.geonames.org/maps/google_63.21096520429257_8.522494644872518.html NO Plassen 200 1 2427 http://www.geonames.org/maps/google_61.08856054171219_12.53514296152004.html NO Landåsbygda 191 1 2861 http://www.geonames.org/maps/google_60.834431035134436_10.304565801644317.html NO Kvamsøy 191 1 6087 http://www.geonames.org/maps/google_62.19858549089363_5.391075932193597.html NO Brensholmen 190 1 9118 http://www.geonames.org/maps/google_69.59961618450114_18.049972237812234.html NO Hjelledalen 182 1 6798 http://www.geonames.org/maps/google_61.93892452787223_7.242334484355005.html NO Rud 178 1 1351 http://www.geonames.org/maps/google_59.90848741253914_10.49606332087801.html NO Nordbyhagen 172 1 1474 http://www.geonames.org/maps/google_59.93326729486387_10.992403004821128.html NO Nordre Seiland 171 1 9609 http://www.geonames.org/maps/google_70.56989781394905_23.460868210304838.html NO Guddal 169 1 6966 http://www.geonames.org/maps/google_61.24163099037684_5.574172374125779.html NO Torjulvågen 168 1 6629 http://www.geonames.org/maps/google_62.97343327157946_8.222908447898257.html NO Sundøy 168 1 8892 http://www.geonames.org/maps/google_66.00198251196949_12.869345989884115.html NO Haugsvær 167 1 5983 http://www.geonames.org/maps/google_60.90879414061223_5.519590333855341.html NO Norangsfjorden 166 1 6196 http://www.geonames.org/maps/google_62.20120293806063_6.619710490529101.html NO Oppstryn 154 1 6799 http://www.geonames.org/maps/google_61.90531027063397_7.0601837591563905.html NO Slettås 154 1 2432 http://www.geonames.org/maps/google_61.37340563959969_11.960777914286961.html NO Vallavik 153 1 5734 http://www.geonames.org/maps/google_60.465518816181614_6.751070247405887.html NO Elgå 148 1 2446 http://www.geonames.org/maps/google_62.19876603835241_11.986288863477906.html NO Brandasund 147 1 5423 http://www.geonames.org/maps/google_59.903166057934136_5.141856408394216.html NO Øversjødalen 147 1 2544 http://www.geonames.org/maps/google_62.21623072738099_11.529848902365966.html NO Saura 146 1 8724 http://www.geonames.org/maps/google_66.25704577779332_13.032961548547474.html NO Løfallstrand 145 1 5474 http://www.geonames.org/maps/google_60.04653488183118_6.025142420512894.html NO Haukedalen 144 1 6818 http://www.geonames.org/maps/google_61.41090267054773_6.339723130975466.html NO Mauranger 143 1 5476 http://www.geonames.org/maps/google_60.132184437320866_6.249396420324156.html NO Tyssebotnen 139 1 5284 http://www.geonames.org/maps/google_60.61864050824545_5.581196886071563.html NO Skartveit 138 1 4182 http://www.geonames.org/maps/google_59.1942508908441_5.955925268865222.html NO Hersvikbygda 132 1 6929 http://www.geonames.org/maps/google_61.192369491268295_4.86687012881911.html NO Eikesdal 131 1 6472 http://www.geonames.org/maps/google_62.437748458436644_8.350986598613378.html NO Ronglan 130 1 7623 http://www.geonames.org/maps/google_63.664004437867675_11.126399768949446.html NO Vikholmen 124 1 8720 http://www.geonames.org/maps/google_66.1837904812733_12.929759427475652.html NO Årbakka 116 1 5693 http://www.geonames.org/maps/google_59.99082167326752_5.6840457527229935.html NO Kortgarden 111 1 6455 http://www.geonames.org/maps/google_62.77321422178511_7.607737953388818.html NO Tunstad 107 1 8428 http://www.geonames.org/maps/google_68.89753644807814_14.916684580515927.html NO Oldedalen 104 1 6791 http://www.geonames.org/maps/google_61.69716989324296_6.810568057940048.html NO Storestandal 101 1 6184 http://www.geonames.org/maps/google_62.2548138768434_6.385160931299924.html NO Driva 94 1 7345 http://www.geonames.org/maps/google_62.52963359963666_9.625598315496658.html NO Svanøybukt 89 1 6914 http://www.geonames.org/maps/google_61.492803339213516_5.100904631252881.html NO Gjerøy 88 1 8195 http://www.geonames.org/maps/google_66.62321339841269_13.012517628053075.html NO Straumsnes 82 1 6969 http://www.geonames.org/maps/google_61.334422058144405_5.21907160713944.html NO Sund I Lofoten 80 1 8384 http://www.geonames.org/maps/google_68.00870877166032_13.206114250631686.html NO Furugrenda 77 1 6611 http://www.geonames.org/maps/google_62.6642124985333_8.616824069514513.html NO Kvalfjord 76 1 9531 http://www.geonames.org/maps/google_70.28130984088953_22.847644379471905.html NO Sandøybotn 75 1 9664 http://www.geonames.org/maps/google_70.68678133111271_22.952431034359922.html NO Storselsøy 73 1 8197 http://www.geonames.org/maps/google_66.54100368265446_12.845250474603272.html NO Fleinvær 71 1 8094 http://www.geonames.org/maps/google_67.16616818090775_13.772033934864893.html NO Barekstad 68 1 6916 http://www.geonames.org/maps/google_61.67856440828331_4.8642478267353155.html NO Sørbokn 67 1 4169 http://www.geonames.org/maps/google_59.16368007216272_5.948039682128477.html NO Sauøy 60 1 7287 http://www.geonames.org/maps/google_64.07809322940179_9.254949281889155.html NO Sandvær 59 1 8844 http://www.geonames.org/maps/google_65.89200162264737_11.990931155366882.html NO Nevervik 59 1 8273 http://www.geonames.org/maps/google_68.12583627081638_16.081473051680167.html NO Lote 58 1 6778 http://www.geonames.org/maps/google_61.86449607982804_6.100791905949996.html NO Litlakalsøy 57 1 5388 http://www.geonames.org/maps/google_60.04171623982739_5.086959466068204.html NO Storemolla 56 1 8328 http://www.geonames.org/maps/google_68.29608375567403_14.910860520904956.html NO Haslemoen 53 1 2437 http://www.geonames.org/maps/google_60.649482317043486_11.870749835007413.html NO Yttervåg 51 1 7742 http://www.geonames.org/maps/google_64.29230484266083_10.296852842402098.html NO Sør-Hidle 44 1 4123 http://www.geonames.org/maps/google_59.046570317697224_5.823144522705253.html NO Ytre Beiarn 43 1 8128 http://www.geonames.org/maps/google_67.07784896127723_14.560002061322534.html NO Harangsfjord 41 1 7981 http://www.geonames.org/maps/google_65.25607320698467_12.363855885828638.html NO Helgøy I Ryfylke 40 1 4167 http://www.geonames.org/maps/google_59.137017431340404_6.021778373950913.html NO Sør-Skorpa 36 1 6918 http://www.geonames.org/maps/google_61.589461364447516_4.797576663673822.html NO Gjersvikgrenda 22 1 8189 http://www.geonames.org/maps/google_66.53471278189875_13.071158352468796.html NO Orten 20 1 6486 http://www.geonames.org/maps/google_62.78308486354467_6.650120744740536.html NO Skavnakk 16 1 9587 http://www.geonames.org/maps/google_70.23735953486216_21.468924698714627.html NO Storekalvøy 14 1 6285 http://www.geonames.org/maps/google_62.528690801276504_6.2028186096407225.html NO Givær 12 1 8097 http://www.geonames.org/maps/google_67.30470102347121_13.726281261516643.html