LogoLogo
  • CHARTS USER GUIDE
    • Introduction
    • Angular Gauge Chart
    • Bar/Column Chart
    • Bubble Chart
    • Bullet Chart
    • Calendar Heatmap Chart
    • Column Range Chart
    • Combination Chart
    • Dumbbell Chart
    • Filter Chart
    • Funnel Chart
    • Grid Chart
    • Table heatmap
    • Histogram Chart
    • KPI Animation Chart
    • KPI Ring Chart
    • Line/Area line Chart
    • Mekko Chart
    • Packed Bubble Chart
    • Pie Chart
    • Polar Charts
    • Sankey Chart
    • Simple KPI Chart
    • Slope Chart
    • Sparkline Chart
    • Stacked Column/Bar
    • Text Node
    • Tornado Chart
    • Trellis Chart
    • Variwide Chart
    • Waffle Chart
    • Waterfall Chart
    • Wordcloud Chart
    • Workstation
    • Allow/Block URLs
    • Animation Duration
    • Attribute Forms
    • Auto Scroll
    • Axes
    • Background Images
    • Backward Compatibility
    • Bar/Column Width
    • Color Picker with Opacity
    • Connect Null Points
    • Custom Markers
    • Custom SVG Markers
    • Data Markers
    • Data label customization
    • Dossiers/Documents differences
    • Drilling
    • Error Bars
    • Export to PDF
      • Export engine local resource set up
    • Formatting metric data
    • Gradient Threshold
    • Legend
    • Negative Sign
    • Pattern Fill
    • Play Animation
    • Plot lines/Reference lines
    • Reset color property
    • Reset font properties
    • Right Click Menu
    • Right-to-left Support
    • Series using Attribute
    • Small Multiples
    • Smooth Line
    • Tooltip Customization
    • Tooltip Links
  • GRID/MICROCHART GUIDE
    • Appearance
    • Auto Size
    • Column Totals
    • Context Menu
    • Creating a micro chart
    • Custom markers
    • Custom Editor
    • Filter Data
    • Format/Clear Format
    • Grand Total
    • Pivoting and Row Grouping
    • Horizontal Bars/Pins
    • Embed Images
    • Manage Scaling Grouping
    • Manage Column Grouping
    • Manage Metric Grouping
    • Pin Column
    • Reorder columns
    • Reset Columns
    • Show/Hide Column
    • Sorting
    • Subtotals
    • Thresholds
    • Tooltip
    • Transparency
    • Trend Lines
    • Value Aggregation
    • Variance
  • MAPS USER GUIDE
    • Creating New Maps
    • Custom Layouts
    • Customization of the Map chart
    • Default Maps
    • Formatting Options
    • Generic Merge tool
    • US map using counties data
    • US Map using ZIP Codes
  • IBCS USER GUIDE
    • IBCS
      • Why IBCS
      • Mapping IBCS Scenarios
      • Negative Metrics
      • Scaling Multiple Charts
    • CERTIFIED CHARTS
      • Multi-tier Bar chart
      • Multi-tier Column chart
      • Small Multiples
      • Vertical Waterfall
  • CUSTOMIZATION GUIDE
    • Introduction
    • Custom CSS
    • Custom CSS Samples
    • Custom Color Palette
    • Custom Fonts
    • Condensed Metric Format
    • Disable Edit button
    • Grid Custom CSS
    • Localization
  • FAQ
    • Contact Us
    • FAQS
  • INSTALL DOCS
    • Installing on MicroStrategy Web
    • Installing on MicroStrategy Desktop/Workstation
    • Installing on MicroStrategy Library
    • Installing on MicroStrategy Mobile
    • Release Notes
    • Release Notes Maps
Powered by GitBook
On this page
  • Creating US map using Zip Codes
  • Vitara Zip code grouping tool
  • Example of zip code aggregation:

Was this helpful?

  1. MAPS USER GUIDE

US Map using ZIP Codes

PreviousUS map using counties dataNextIBCS USER GUIDE

Last updated 2 days ago

Was this helpful?

Creating US map using Zip Codes

Using zip codes, we can easily obtain any projection of a US map. The zip codes can then be grouped at any level, such as county, state, or an unique region. The best use case for zip code grouping is that it allows us to create our own regions by grouping the zip codes that we wish to be in that region. Finally, we can create a map that shows the level at which we classified the zip codes.

Vitara Zip code grouping tool

Based on a data file containing grouping information, the Zip Code grouping tool blends separate zip codes into regions/states to generate a single region.

To access the tool, follow this link:

The below screenshot is from vitara zip code grouping tool web page.

Example of zip code aggregation:

Consider that there are ten zip codes. Now I want to create a US map chart with all of these zip codes divided into two regions and data at the region level. It is possible to create a map that depicts regions by grouping these zip codes into relevant regions. The table below contains ten zip codes and their related regions.

Zip Code
Region

29105

1

29137

1

29164

1

29801

1

29802

1

29803

2

29804

2

29805

2

29808

2

29809

2

I need a shape file (.json) of these regions in order to make a map that depicts them. The methods below demonstrate how to create a shape file using zip codes.

Step 1:

Step 2:

Upload the csv file by clicking “Choose File” option.

Step 3:

In our example, we want to group zip code at region level, fill the “Group By” field with the column name “Region”.

Step 4:

We want to group zip codes, fill the “Apply Grouping To” field with column name “ZipCode”.

Step 5:

Click “Merge & Export” and json file will be downloaded.

The next steps will be the same as we covered while demonstrating how to create a the world continents map. The screenshot below is of a Vitara map chart made from zip codes in the United States, sorted by state.

Access the Vitara zip code grouping tool using the link mentioned below. The zip codes file should be a csv file.

VitaraMaps - Tool for grouping zip codes
VitaraMaps - Tool for grouping zip codes