(Topic ID: 240391)

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

By LaughingOtter

7 months ago

Topic Stats

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


Linked Games

No games have been linked to this topic.

    You're currently viewing posts by Pinsider LaughingOtter.
    Click here to go back to viewing the entire thread.

    #1 7 months 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 7 months 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
    $ 25.00
    $ 99.99
    Playfield - Toys/Add-ons
    Lighted Pinball Mods
    $ 10.00
    From: $ 9.99
    Matt's Basement Arcade
    $ 89.99
    $ 2.50
    Playfield - Decals
    Doc's Pinball Shop
    € 4.95
    Playfield - Toys/Add-ons
    $ 38.00
    Playfield - Toys/Add-ons
    The MOD Couple
    $ 117.00
    Playfield - Toys/Add-ons
    The MOD Couple
    $ 24.00
    $ 7.00
    Playfield - Toys/Add-ons
    Pinball Z
    $ 25.00
    Playfield - Decals
    From: $ 42.00
    Cabinet - Shooter Rods
    ModFather Pinball Mods
    $ 19.99
    From: $ 9.99
    Matt's Basement Arcade
    $ 125.00
    Cabinet - Toppers
    Sparky Pinball
    $ 10.00
    $ 99.00
    Gameroom - Decorations
    Pinball Sales
    $ 269.00
    Cabinet - Other
    PinGraffix Pinside Shop
    $ 30.00
    Playfield - Decals
    $ 76.95
    Cabinet - Shooter Rods
    Super Skill Shot Shop
    € 6.50
    Flipper Parts
    $ 7,999.00
    Pinball Machine
    Nitro Pinball Shop

    You're currently viewing posts by Pinsider LaughingOtter.
    Click here to go back to viewing the entire thread.

    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