Designer Data Import JSON

 Load JSON Data into CMaps Analytics

JSON data streams are supported as a URL and can be modified using the Javascript API.

  • CMaps Analytics Designer will NOT upload your JSON content to CMaps Analytics cloud.
  • JSON URs  must be accessible via HTTPS inside of CMaps Designer. Once saved to your desktop or another application you can use HTTP.
  • JSON files or streams be loaded from a server that grants cross domain access (contact your server administrator for more details) Learn about CORS
  • JSON files can not be loaded from file shares or your desktop

Supported Fields

“locations” (Array) – REQUIRED
“labels” (Array) – REQUIRED
“values” (Array) – REQUIRED
“colors” (Array)
“categories” (Array)
“drillIds” (Array)

Example:

{
"locations": [
"37.7693911,-122.41750",
"37.7480245,-122.4208806",
"37.7512649,-122.4201445"
],
"labels": [
"2323 M Street, San Francisco CA",
"4125 A Street, San Francisco CA",
"2443 S Street, San Francisco CA"
],
"values": [
"3",
"5",
"36"
]
}

 

Data Column Definitions and Ordering

Column ordering grants control to a designer to modify the default column data order based on your original data set. While it is generally recommended to load data into CMaps Designer using the default order, there could be scenarios where a map may need to accommodate data that is slightly different in ordering of columns. Simply drag and drop the columns to change the order.

Capture

Location

Any address value or comma separated latitude,longitude: Example: 43.43434,-33.54545

Label

The label is the name of each asset (point of interest or shape) displayed in the InfoWindow, chart, tile, and other views. It is the primary identifier visible to mobile users. Example: Dr Klauss

Value (measure)

A value is a numeric value associated with each point or region. This value is used for dynamic icon sizing, alerts, and chart visuals. Currently CMaps Designer supports 1 measure at a time. You can easily toggle between measures using the CMaps Designer API. Example: 45000

Color

If you want to define the color in your data rather than the property sheet you can use hexidecimal color codes to change the color of points or shapes: example: #FF0055

Category

Category is a placeholder for future functionality, including embedded pie charts, and other visualization options.

Drill ID

Drill ID represents the parent and child elements when you are drilling between multiple layers. The Drill ID establishes a simple hierarchy. When using more than 2 levels, any layer in between top and bottom must contain both the parent, and current drill levels with a “|” delimiter.

Examples are illustrated below:

Example 1 is 2 Layer Hierarchy

Layer 1

Label  |   Drill ID

West    West
East     East

Layer 2

Label  |   Drill ID

CA    West
NV     West
NY    East
FL     East

Example 2 is 3 Layer Hierarchy

Layer 1

Label  |   Drill ID

West    West
East     East

Layer 2

Label  |   Drill ID

CA    West|CA
NV     West|NV
NY    East|NY
FL     East|FL

Layer 3

Los Angeles    CA
San Diego       CA
Nevada           NV
Reno               NV

 

Next Post