Need to show ALL accounts on map at similar address!

Ask for Help
1

I have multiple paid users that are listed at either the same address or at a similar address (with different suite #'s) and my problem is that the map only shows one dot on the map even when there are multiple accounts, so one person will have an unfair advantage and everyone else won’t get to be seen on the map
This is my map of Greater Boston showing locations of active businesses and professionals

image
image1910×891 87.7 KB

This is a salon that has 3 different paid accounts listed at the same address. Only one account shows
image
image1904×886 122 KB

This is an address that has 3 accounts with similar addresses, but they each have their own salon suites within this building and only one shows on the map
image
image853×860 69.2 KB

This is an example on google maps where different suite numbers will show up on the map even when at the same building address
image
image1691×878 124 KB

Any advice on how to fix this? I really don’t know what to do, and I feel like I can’t leave it as is

2

I think the way to do it is:

  • Have a new table to store unique addresses (this can be tricky, since one address can be written in 1 million forms, maybe geocode them first and store unique coordinates).

  • Use the map layout on the new unique addresses/coordinates.

  • Use a relation - rollup combo to count the number of accounts in each address/coordinate.

  • If rollup count = 1, then show the details screen of that specific account, else show an inline list of accounts belonging to that address/coordinate.

4 Likes
3

Oof, thanks Thinh! Unfortunately that’s a bit over my head, so I’m not sure if I can play that out myself, and I’m having a hard time envisioning how it will work if people are writing in addresses differently or having ever-so-slightly different coordinates if they are in different suite #'s. I wish it would just show up like on google maps, especially bc you can see the buildings in mapbox too

I was trying to create slightly different addresses thinking maybe I could hide them from the public but have it be what the map used to create the location, but it either wasn’t different enough (ex: instead of 150 Main St. I put in 150-2 Main, or 150B Main - but it still looked like one dot) or it made it way down the street (ex. 105 #102 Main St. or 150-102 Main St)