In this topic
You can add data from MicroStrategy directly to a map.
When you add data from MicroStrategy, select the ArcGIS location type that best represents your information. Location information from MicroStrategy is used to create a relationship between your business data and the specified location type.
Default location types
The following default location types are available if your organization is using ArcGIS Online. If your organization is using Portal for ArcGIS, only the first two location types in the list (Address and Latitude, Longitude) are supported.
- Address—Depending on the geographic region of your organization, address data can be composed of any of the following: address, neighborhood, city, subregion, region, state, province, postal code, United States ZIP Code, country, and so on. The more address elements your
data contains, the more accurate your results will be. The address
elements can be in separate fields, or they can be contained in one
field (single-line address). Both methods of finding addresses are
supported, but the best results are obtained by using all address
elements and storing them in separate fields.
The Address location type is only available if your administrator has specified a geocoder for your organization. Multiple geocoders can be specified, but only geocoders that support batch processing are listed. If you're using the World Geocode Service, see Geocode coverage for geocode coverage information.
Geocoders that are specified for your organization are listed as follows:
- ArcGIS Online—If the default Esri World Geocoding Service has been specified, it appears in the list as Address. Any custom geocoders are listed by name.
- Portal for ArcGIS—Specified geocoders are listed by name.
To use the Address location type in Portal for ArcGIS deployments, your portal must have a configured hosting server and a valid geocoder that supports batch processing. For more information, see Configure the portal to geocode addresses and Configure a hosting server.
- Latitude, Longitude—Latitude and longitude values represent an x,y coordinate location on the map. You can map x,y coordinate data from any geographic or projected coordinate system. You can choose between World Geodetic Survey 1984 (WGS84) or Web Mercator, or you can specify the well-known ID of any other coordinate system. If you prefer to use WGS84 or Web Mercator, follow these guidelines: if your latitude (y) values fall between -90 and 90 and the longitude (x) values range from -180 to 180, use WGS84; if your coordinate values are in meters and have 6, 7, or 8 digits before (to the left of) the decimal point, use Web Mercator.
- Standard administrative boundaries (only available with ArcGIS Online)—Standard administrative boundaries include cities, states, provinces, United States ZIP Codes, postal codes, and countries. The administrative boundaries available to you are determined by your locale. Cities are added to
the map as points. States, provinces, postal codes, United States ZIP Codes, and countries are added to the map as polygons, which represent both the
shape and the location of the place.
When the product language is set to a language other than English, countries is the only available administrative boundary location type.
Custom location types
If none of the default location types represent your data, you can specify a dynamic map service or a feature service from ArcGIS to use as a location type. For example, if your organization has its own boundaries (water districts, sales districts, or zoning boundaries), you can map your data using those locations instead of the default location types as long as there is a one-to-one relationship between the rows in your business data and the shapes in the service used as a location type (see Choose a location type for more information). Esri Maps for MicroStrategy supports feature services and map services. For more information on adding a location type based on a dynamic map service or feature service, see Add a location type.
Choose a location type
When you use Esri Maps for MicroStrategy to plot your business data on the map, it is important to choose the correct location type. Before a row of input data can be drawn, it must be located and identified as having either a point, line, or polygon shape. The location type you choose facilitates this process.
Address and Latitude, Longitude
When you choose the Address location type, points are generated using one of the geocoders your organization's administrator configured on ArcGIS Online or Portal for ArcGIS.
For the Latitude, Longitude location type, data from the identified X and Y location columns is used to generate points.
Standard administrative boundaries and custom types
When you choose any standard administrative boundary or custom location type, the appropriate shapes are located and retrieved using the specified column or columns for the chosen location type. This is done by associating the rows of data with the location type through a common column, known as a key.
The name of the column in your data does not have to match the column name in the location type; however, the information in the column must be the same to produce a match. When a row of data cannot be located—that is, the shape cannot be retrieved from the location type—it's assigned a null shape and is not drawn on the map. The following table shows the supported keys for each location type:
|Location type||Shape type||Supported keys|
The following is required:
The following are required:
US ZIP Code
One of the following is required:
The following is required:
Optionally, the following can be specified:
The following is required:
Point, line, or polygon (determined by selected map or feature service layer)
Specified during Add a location type workflow.
Only English place names are supported.
When locating data using standard administrative boundaries or a custom location type, it is important to ensure that there is a one-to-one relationship between the rows of input data and the shapes in the chosen location type. In a one-to-one relationship, each row of input data corresponds to a single shape on the map. In the following example, each row of input data (Profit by state) corresponds to one U.S. state; the State column represents the unique key. The shape for each row of input data can therefore be determined and drawn on the map. In the following example, a single polygon shape corresponding to each row in the Profit by state input data (for example, Arizona) is drawn:
Choosing an inappropriate location type can cause unexpected results. This is because the wrong location type often leads to a many-to-one or a one-to-many relationship between the input data and the shapes in the chosen location type. Again, it is important to establish a one-to-one relationship as shown above.
In the following example, the input data shows profit by ZIP Code. The data also contains U.S. state information. Here, ZIP Codes represent the unique key in the input data. Many ZIP Codes are found in any given U.S. state. If the US State location type is chosen—that is, if State is treated as the unique key—each input row will be located to its associated state, creating a many-to-one relationship between the rows of input data and the shapes in the location type. This means that polygon shapes corresponding to the many input rows will be drawn directly on top of one another on a map. In this example, Arizona will be drawn four times. The US ZIP Code location type, not the US State location type, would be the appropriate choice in this case.
As with the many-to-one relationship, a one-to-many relationship should be avoided. In the case of a one-to-many relationship, only the first matching shape is retrieved and drawn on the map. This would not be an appropriate representation of the input data on a map.