Forum Discussion

Cobalt58_9's avatar
Cobalt58_9
Frequent Visitor
1 year ago

Parent Points on Map

Hi everyone, having trouble figuring this out, and hope I explain it correctly.

 

I want to show affiliates on a map, specifically for sports leagues. Essentially, when you select the pro team, the map will show the minor league locations as well. 

 

This has to be possible right? I think I'm having the most trouble figuring out how to setup data amd relationships. What do you think? Thanks in advance.

Need Help

5 Replies

  • pborah's avatar
    pborah
    Solution Sage
    1 year ago

    Cobalt58_9 , what do you have for geo data either pro teams or minor leagues or both? You can create two related tables one containing pro teams and the other containing minor leagues with primary and foreign keys.

    • Cobalt58_9's avatar
      Cobalt58_9
      Frequent Visitor
      1 year ago

      I have not used lat/long, simply the city, state/province, and country names. And I do have them broken out by each league, sometimes up to four different leagues, and then tried using an "order" column to keep them organized, but that didn't seem to work.

      • pborah's avatar
        pborah
        Solution Sage
        1 year ago

        Thanks Cobalt58_9 , using lat/long will probably be more precise especially if multiple pro or minor teams belong to the same city.

         

        You mean you have both pro and minor teams in the same table? If so, it will difficult and complicated showing them on a map in that data structure.