1 2 Previous Next 15 Replies Latest reply on Nov 4, 2013 1:37 PM by . Indumon

    Geographical Map

    Sat P

      Have a requirement to show customer details in Geographical Map based on following below filter in case natural calamity

       

      State:
      Latitude:
      Longitude:
      Radius in Miles:


      Eg. User will input
      State: New York
      Latitude : 40.67
      Longitude : 73.94
      Radius(miles) : 50

       

      It should show all the customer impacted within 50 miles of radius from center point with a circle

       

      All details / column is coming from database except Radius.

      Any suggestions/thought to achieve this.

       

      Have checked few of the post, but could not achieve the requirement.

        • 1. Re: Geographical Map
          Ramon Martinez

          Hi Satish,

           

          This is a typical scenario for Geographic Information System (GIS). Usually we have two spatial data sources, the term in GIS is two geographic layers, and one is used to select data in the other using spatial functions, in your case distance and overlapping.

           

          I'm almost sure that with some work and imagination it is possible to solve it in Tableau. I will play with that, but before I would like to call your attention that you scenario is missing the customer data source and using the Latitude & Longitude of states is not a good option in real situation as states can be very large areas its latitude & longitude are usually the centroid of the state.

           

          It would be good if you share a workbook with sample data.

           

          Allan Walker I'm sure you can contribute in this thread.

           

          Best,

          Ramon

          • 2. Re: Geographical Map
            Ramon Martinez

            Satish,

             

            This two articles can help to solve your problem:

             

            1) Calculate distance: http://kb.tableausoftware.com/articles/knowledgebase/calculating-distance

            2) Using radius filters on maps: Using Radius Filters on Maps | Tableau Software

             

            Ramon

            • 3. Re: Re: Geographical Map
              . Indumon

              Thanks Ramon.

               

              I have played with some sample data (Dubai) and able to simulate some part of it.

              Missing part:

              1. Create a center spot based on the parameter latitude and longitude.

              2. Draw a circle around the center distance as radius.( not sure it is possible)

               

              Dashboard 1.jpg

               

              waiting for Alan...

              • 4. Re: Geographical Map
                Shawn Wallwork

                Indumon, you might find this helpful: http://community.tableau.com/thread/117607

                 

                --Shawn

                • 5. Re: Geographical Map
                  . Indumon

                  Thanks Shawn.

                  I will try that as well...

                  • 6. Re: Geographical Map
                    Ramon Martinez

                    Hi Indumo,

                     

                    Sorry for my silence. This is just to let you know that I'm playing with your workbook trying to figure out a solution.

                     

                    Thanks also to Shawn for sharing the VizTalk article "Richard Leeke's Super-Charged Zip Code Radius-Finder", which is simply Brilliant!! as Jonathan said in a comment.

                     

                    Best,

                    Ramon

                    • 7. Re: Geographical Map
                      . Indumon

                      Thanks Ramon, Awaiting for a cracking solution from you

                      I am also looking into Richard Leeke's Super-Charged Zip Code Radius-Finder , method.

                       

                      thanks

                      • 8. Re: Geographical Map
                        Sat P

                        Hello,

                         

                        Thanks Ramon & Indumon for your input.

                         

                        I was able to achieve half part of the requirement. Still working on how to get the circle for the radius

                         

                        Regards,

                        Satish

                        • 9. Re: Geographical Map
                          Allan Walker

                          Satish,

                           

                          While the radius question has come up, I'd actually be doing this in a slightly different manner, using Voroni polygons.  This is a method that shows the area around the centroid, rather than a radius circle. Why? Because circles sometimes are not of high enough resolution, and can be misleading.

                           

                          For example, in a disaster scenario (say a downed pilot) - you may not wish to search in a circle - especially if it is on an island (i.e. you don't want to search in the water, just land) - what you want to do is to find the nearest neighbour, and that's where Theissen polygons come in.  In your example, you know where the centroids are, all you would need to do is to mask and then clip.  So, for Dubai, you use the outline and then work back from your area.

                           

                          Do you have ESRI?  If you do, then this is easy to achieve.  If I have time, I will work up your Dubai example.

                           

                          Like this:

                           

                          Inputs: OSM United Arab Emirates Points of Interest from Cloudmade + UAE Admin 0

                           

                          Start with the Points:

                          1.png

                          Now add the Admin 0 polygon

                          2.png

                          Create the Voroni polygons

                          3.png

                          Add the mask and clip

                          UAE POI Voroni.png

                          The clipped polygon and points

                          4.png

                           

                          The end result polygon

                          5.png

                           

                          Now, just import to Tableau.  However, if your customer insists on circles, that's been done before like the examples given; but I'd ask what the exact requirements are of the system that you'll be implementing.

                           

                          The upshot is; use Tableau as the viewer - but there are numerous GIS tools that can help you get to an answer.  You just need the resources and the knowledge/experience about how to tackle the problem to get to an appropriate and elegant solution.

                           

                          Best Regards,

                           

                          Allan

                          • 10. Re: Geographical Map
                            Sat P

                            Thank you everyone for the input.

                             

                            There is change in requirement.

                             

                            We have to show supplier (details) name, country, state based on longitue & latitude

                            We have Master_Supplier  (end product) & Seconday_Supplier(they supply part to master supplier)

                             

                            Table

                            Master_Supplier - This table contains the Master_Supplier

                            Seconday_Supplier - This table contains seconday_supplier

                             

                            Eg. User will input

                            State: New York

                            Latitude : 40.67

                            Longitude : 73.94

                            Radius(miles) : 50

                             

                            This will display all the supplier within Radius of 50 miles. (This i was able to achieve)

                            I have used union query as latitude and longitude is available in both the tables

                             

                            Seconday_supplier is located in "New York"

                            Master_Supplier is located in "London"

                             

                            If the impacted Supplier is a Seconday_Supplier the Geographical map should also Show Master_Supplier Details.

                             

                            As we are using Latitude , Longitude and raidus. It will show only the supplier within the radius parameter.

                             

                            Any suggestion/idea how to acheive this requirement.

                            • 11. Re: Geographical Map
                              . Indumon

                              Hi Allen,

                               

                              This is Brilliant! Can you please share the shape files of UAE?

                              • 12. Re: Geographical Map
                                Sat P

                                Hi Allan Walker, Ramon Martinez,Shawn Wallwork

                                 

                                Thank you for provind your input.

                                 

                                There is change in requirement.

                                 

                                We have to show supplier (details) name, country, state based on longitue & latitude

                                We have Master_Supplier  (end product) & Seconday_Supplier(they supply part to master supplier)

                                 

                                Table

                                Master_Supplier - This table contains the Master_Supplier

                                Seconday_Supplier - This table contains seconday_supplier

                                 

                                Eg. User will input

                                State: New York

                                Latitude : 40.67

                                Longitude : 73.94

                                Radius(miles) : 50

                                 

                                This will display all the supplier within Radius of 50 miles. (This i was able to achieve)

                                I have used union query as latitude and longitude is available in both the tables

                                 

                                Seconday_supplier is located in "New York"

                                Master_Supplier is located in "London"

                                 

                                If the impacted Supplier is a Seconday_Supplier the Geographical map should also Show Master_Supplier Details.

                                 

                                As we are using Latitude , Longitude and raidus. It will show only the supplier within the radius parameter.

                                 

                                Any suggestion/idea how to acheive this requirement.

                                • 13. Re: Geographical Map
                                  Allan Walker

                                  Indumon,

                                   

                                  You can find the SHP files here.

                                   

                                  Best Regards,

                                   

                                  Allan

                                  • 14. Re: Geographical Map
                                    Allan Walker

                                    Satish,

                                     

                                    You essentially need a filter for latitude and longitude.

                                     

                                    You then need data with latitude and longitude that matches the requirement: state (centroids), country (centroids), and supplier (both primary and secondary) address.  As State seems to be the lowest level, you need Natural Earth Admin 1 SHP file. Merge that file with your address point data.

                                     

                                    Best Regards,

                                     

                                    Allan

                                    1 2 Previous Next