Creating Tableau Polygons from ArcGIS Shapefiles
Version(s): 7.0, 8.0, 8.1
Last Modified Date: 19 Jun 2014
Article Note: This article is no longer actively maintained by Tableau. We continue to make it available because the information is still valuable, but some steps may vary due to product changes.
You can use the filled maps chart option to fill worldwide states and provinces and U.S. counties using built-in geocoding. Maps that require more detailed areas such as cities, zip codes, area codes, or custom areas, use the ArcGIS ShapeFiles to prepare and define a file that can be imported into Tableau Desktop as a polygon layer. For more general information about polygon filled areas, refer to Creating Polygon-Shaded Maps article.
The method requires a licensed version of ArcGIS (ArcView, ArcEditor, or ArcInfo) and the ET GeoWizards tool for ArcGIS. The software installs as a toolbar in ArcMap and the functionality required for preparing the Shapefile is covered under their free features.
Prepare the shapefile
In an ArcMap view that contains the polygon shapefile layer of interest, verify that the polygon is in a geographic coordinate system using decimal latitude and longitude units, such as GCS NAD 1983. If it is in a projected coordinate system, use ArcToolbox to project the shapefile to a geographic coordinate system.
Launch the ET GeoWizards tool in ArcMap and follow the step-by-step wizard to output a Polygon to Point feature. Be sure that the output points are the Vertices only.
Prepare the Tableau data source
Open the .DBF of the output shapefile into a program such as Excel. At a minimum, the file must contain the following fields for correct import into Tableau:
[ID] or [ET_ID] - either of these two fields can be used for the Level of Detail shelf
[ET_X] - this field corresponds to the longitude coordinate of the record
[EY_Y] - this field corresponds to the latitude coordinate of the record
[ET_ORDER] - this field contains the draw order of the points and is used in the Path shelf for the polygon
Please note that you can change the header names here to be more informative to the Tableau user. When ready, save the updated file to a data source supported in Tableau such as an Excel or Access format.
Refer to the remaining steps in the Creating Polygon-Shaded Maps article to complete the desired view in Tableau.
Alternate Search Terms:filled map, arcgis, shape file,