Forum Discussion

LeverPowerCLiff's avatar
LeverPowerCLiff
Frequent Visitor
1 year ago

Show Total by Reference Layer Region in Azure Maps

Hi,
I have a list of data points with their longitude and latitude that I am plotting on an Azure map. There are hundreds of points (though the example only shows less for clarity) so I want to show them by region, so I found and imported a geoJSON file that I am applying as a reference layer. Can I show the sum of all points in a given region and colour code them?

 

For example I want to show the points in Scotland summed together and colour code the regions by their value.

 

The regions show as orange as that is the colour I set as unmapped. 

 

I wanted to try to add a column for the region for each data point but I couldn't work out how to get the region of a point from the longitude and the latitude from the geoJSON file but I don't even know if this would be a fix.

 

Thank you for any help.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi LeverPowerCLiff ,
    Based on my testing, you can start by creating a region column based on latitude and longitude ranges

    Region = 
SWITCH(
    TRUE(),
    'Table'[LATITUDE] >= 54.6333 && 'Table'[LATITUDE] <= 60.8607 && 'Table'[LONGITUDE] >= -7.5722 && 'Table'[LONGITUDE] <= -0.7889 , "Scotland",
    'Table'[LATITUDE] >= 49 && 'Table'[LATITUDE] <= 55 && 'Table'[LONGITUDE] >= -6 && 'Table'[LONGITUDE] <= 2, "England"
)

    Go to format visal ->filed map ->Color

    Set the size as value

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

     

    • LeverPowerCLiff's avatar
      LeverPowerCLiff
      Frequent Visitor
      1 year ago

      I'm trying to use the regions in the reference layer that can be seen in the image above. For e.g. North West, Greater London, etc. not just the countries of the UK. 

      Also with my number of points, I think simplyfying Scotland into a rectangle will cause issues with points allocated the wrong country.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi LeverPowerCLiff ,
        If you don't divide it in rectangles, you need to have the name of each location and a table of the corresponding areas, which can also be achieved by placing the name in the LOCATION box

        Best regards,
        Albert He

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly