Hi!
Just finished with the last Pinside database evaluation.
There are 38 URLs which have bad characters in them so those locations and games would never be displayed. Right now they report a "Location not found." message. (50s-cafyo-1-42000-saint-y‰tienne-france, a–¼-daytona-beach-pier-daytona-beach-fl-united-states, beseco-bowlinghalle-8352-ra¼mikon-winterthur-switzerland, billardcafa©-chicago-live-20537-hamburg-germany, bk-milen-–-biljard-1-gyiteborg-sweden, blue-shell-50674-ka¶ln-germany, bowling-lunivher-1-85330-noirmoutier-en-lyŽle-france, bowlinghalle-beseco-gmbh-ra¼mikon-winterthur-zh-switzerland, brentwood-bowl-1-south-san-francisco‎-california‎-94080-united-states, bunny’s-bar-and-grill-1-st-louis-park-mn-united-states, cafyo-de-la-gare-1-85330-noirmoutier-en-lyŽle-france, camping-des-gorges-play-area-07700-saint-martin-darda¨che-france, chez-lauvergnat-1-85330-noirmoutier-en-lyŽle-france, coiffeur-frankie-b-8001-za¼rich-zh-switzerland, dicka€™s-wings-orange-park-fl-united-states, doubledaves-pizzaworks-1-katy-tx-‎-united-states, evie’s-pizzeria-on-the-range-4609-sarasota-fl-united-states, grakula-bowling-club-1-toruÅ„-poland, gustave-cafyo-1-85330-noirmoutier-en-lyŽle-france, ha´tel-central-ra©sidence-spa-1854-leysin-vd-switzerland, hotel-ferienclub-silbertal-gamesroom-6450-sa¶lden-austria, joker-1-miÄ™dzyzdroje-zp-poland, kyeringsund-resort-conference-1-eckeryi-y…land-finland, landhotel-zur-hopfenka¶nigin-gamesroom-91174-spalt-germany, mecca-cafï¿u-the-321-seattle-wa-united-states, one-eyed-betty’s-2732-ferndale-mi-united-states, onkels-billard-cafe-64546-ma¶rfelden-waldorf-germany, porter’s-pinball-parlor-1-cincinnati-oh-united-states, shoppingraststa¤tte-wa¼renlos-wa¼renlos-switzerland, sport-bowling-1-88000-y‰pinal-france, starvin-marvin’s-restaurant-1-branson-mo-united-states, the-shanty-bar-1-coeur-d’alene-id-united-states, tom-cata€z-bar-grill-san-diego-caa€z-united-states, videobiljarden-y–rebro-1-y–rebro-sweden, vince’s-sports-center-1-newark-de-united-states, y–rebro-videobiljarden-1-y–rebro-sweden, and zippya€™s-seattle-wa-united-states).

Lots of duplicates, lots of misspellings, locations in other towns than what the Locator says they're in. That's what happens when you try to use a WordPress structure to do a database.

Next part of the update will happen when I've finished sorting out all the duplicates/triplicates/quadruplicates/quintuplicates/sextuplets. You've done it again with a camping ground. Last time you did that was with Rock Fantasy in Middletown, NY. Considering he has 20-25 games at any time, that's a pretty major error!

Steve Cartoon

_{Post edited by LaughingOtter: Whoops. Only duplicates and triplicates here.}

Sorry about that! I was also scanning through PinballRebel. THEY have the sextuple entry for a camping ground. You've only got triplicates to deal with!

I've essentially matched up almost every location against both Yelp and Google Places (except the last forty or so I just got that didn't map to something already registered).
Got a number of status codes I use, too. Zero means a new and unconfirmed location (something entered by a non-admin). 1 means the place definitely exists. 2 means the place is closed. 3 means a mall listing with no arcade venues at all. 4 means not only is the location closed, but totally gone. 6 means I can't find any evidence the place exists or even existed. 7 means a complete bullshit entry. 9 is a private collection. 11 means a place that will open in future.
Working with a number of USA, Canada, and UK dudes on this one! We're gonna set some standards!
Steve