(Topic ID: 240391)

I'm back! Time to fix our Locations Map!

By LaughingOtter

15 days ago

Topic Stats

  • 2 posts
  • 1 Pinsider participating
  • Latest reply 13 days ago by LaughingOtter
  • No one calls this topic a favorite


Linked Games

No games have been linked to this topic.

    #1 15 days ago

    Hello again!
    It's been a while since I've been here, but I've had a bit of a hard time of it these last few years.

    A recent project has got me back at doing Google Maps again, so I thought I would pass along the data I've acquired and get our Maps back in shape again.

    The first scan has revealed more than 150 duplicates/triplicates/quadruplicate items. Ordinarily, you would just delete the oldest ones, but in some cases an older record will have more complete location information and we want to keep that. I'd also like to keep the original poster names. So, then, how to essentially collapse duplicates into a single record?

    I've also found more than 50 locations that are permanently closed. There's got to be a way we can indicate locations that are closed without them being counted or displayed in the active list, yet come up in a search that will then tell the user this location is closed.
    I myself use a location_status field in my own database, where:
    0 = unconfirmed location,
    1 = confirmed and active location,
    2 = permanently closed location.
    4 = location that is not only closed but the whole building where it was is gone as well (like the Home Plate Pub in Auburn, WA, USA, which burned to the ground last year and is now a huge gravel pit),
    ... and nine others ...
    Only locations with a status of 1 are counted and displayed on the general map.

    Just because a location is permanently closed doesn't mean the location is dead. I've found more than thirty instances already where an apparent duplicate was actually the location's previous and current DBA. In many cases where the location is a bar, this doesn't change the games located inside. I have a location_aka field so that old names can still be searched for and point to the current name. This solves a number of potential headaches.
    (Ex: The Westy in Seattle, WA, USA used to be the 418 Public House and Pies & Pints before that. All these DBAs had pinball. 418 Public House and Pies & Pints would be entries in the locations_aka table that would point to The Westy.)
    On the other hand, if I find a location replaced with something that has no games, I just mark the location as closed.

    How do we change a location's country? Pretty sure there's no Leicester in Andorra. In fact, ALL of the Andorra locations are UK/London addresses. There's no way to change the country without destroying the record.

    OK, that's pretty good for starters. I'll keep you posted about what's where as I find things out.


    #2 13 days ago

    And I'm finding out that quite a few of my suggestions have in fact been incorporated into the Maps Editor, it's just been a very long time since I've been here.
    All the Andorra entries have been relocated to London/Leicester.
    Time to start attacking duplicates. There are 165 to deal with, so that should keep me busy for a day or two.

    Promoted items from the Pinside Marketplace
    $ 199.00
    Lighting - Interactive
    Medisinyl Mods
    From: $ 99.99
    Cabinet - Other
    Lighted Pinball Mods
    $ 9.99
    Matt's Basement Arcade
    $ 11.95
    $ 229.99
    Lighting - Other
    Lighted Pinball Mods
    $ 29.99
    Cabinet - Sound/Speakers
    Lighted Pinball Mods
    From: $ 5,599.00
    Pinball Machine
    Great American Pinball
    $ 28.25
    Playfield - Toys/Add-ons
    The MOD Couple
    $ 89.99
    Lighting - Led
    Lighted Pinball Mods
    $ 5,799.00
    Pinball Machine
    Classic Game Rooms
    From: $ 22.00
    Playfield - Toys/Add-ons
    ModFather Pinball Mods
    $ 29.99
    Cabinet - Toppers
    Lighted Pinball Mods
    From: $ 99.99
    Cabinet - Other
    Lighted Pinball Mods
    $ 150.00
    Lighting - Interactive
    Professor Pinball
    $ 54.00
    Playfield - Toys/Add-ons
    From: $ 159.95
    Cabinet - Sound/Speakers
    Pinball Pro
    $ 5.00
    Cabinet - Other
    Chrome Candy
    $ 229.00
    Cabinet - Toppers
    $ 7,499.00
    Pinball Machine
    Little Shop Of Games
    $ 29.99
    Cabinet - Sound/Speakers
    Lighted Pinball Mods
    From: $ 220.00
    Playfield - Toys/Add-ons
    CzTV Mods
    £ 49.00
    Playfield - Other
    $ 44.95
    Playfield - Toys/Add-ons
    PinBoss Mods
    $ 149.00
    Flipper Parts

    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