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

# Geographical Map

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

State:
Latitude:
Longitude:

Eg. User will input
State: New York
Latitude : 40.67
Longitude : 73.94

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

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

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

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)

waiting for Alan...

• ###### 4. Re: Geographical Map

--Shawn

• ###### 5. Re: Geographical Map

Thanks Shawn.

I will try that as well...

• ###### 6. Re: Geographical Map

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

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

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

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

Create the Voroni polygons

The clipped polygon and points

The end result polygon

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

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

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

Hi Allen,

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

• ###### 12. Re: Geographical Map

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

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

Indumon,

You can find the SHP files here.

Best Regards,

Allan

• ###### 14. Re: Geographical Map

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