(Topic ID: 96928)

Stand by for MAJOR update to your locations database...

By LaughingOtter

5 years ago

Topic Stats

  • 3 posts
  • 2 Pinsiders participating
  • Latest reply 5 years ago by LaughingOtter
  • No one calls this topic a favorite


Linked Games

No games have been linked to this topic.

    #1 5 years ago

    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!

    #2 5 years ago

    Thanks for all of your work, the location database is a great asset to pinside.

    #3 5 years ago

    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!

    Promoted items from the Pinside Marketplace
    From: $ 25.00
    $ 999.00
    Flipper Parts
    $ 7,499.00
    Pinball Machine
    Flip N Out Pinball
    $ 7.95
    Various Novelties
    Pinball Wheezer
    $ 1,099.00
    From: $ 129.95
    Lighting - Interactive
    $ 49.00
    Playfield - Toys/Add-ons
    Pixels Arcade Games
    $ 76.95
    Cabinet - Shooter Rods
    Super Skill Shot Shop
    $ 15.00
    Playfield - Decals
    $ 369.00
    Cabinet - Decals
    $ 15.00
    Lighting - Led
    3D MODS
    $ 200.00
    Lighting - Interactive
    Professor Pinball
    $ 9.99
    Matt's Basement Arcade
    $ 126.95
    Cabinet - Shooter Rods
    Super Skill Shot Shop
    $ 125.00
    Cabinet - Toppers
    Sparky Pinball
    $ 36.99
    Lighting - Interactive
    Lee's Parts
    From: $ 40.00
    Lighting - Interactive
    Professor Pinball
    $ 9.99
    Matt's Basement Arcade
    $ 9.99
    Matt's Basement Arcade
    $ 89.99
    Lighting - Led
    Lighted Pinball Mods
    From: $ 19.99
    $ 48.00
    Cabinet - Other
    ModFather Pinball Mods
    $ 74.00
    Cabinet - Armor And Blades
    Id Rather Play Pinball

    Hey there! Got a moment?

    Great to see you're enjoying Pinside! Did you know Pinside is able to run thanks to donations from our visitors? Please donate to Pinside, support the site and get anext to your username to show for it! Donate to Pinside