SpatialKey allows dataset Contributors and Creators/Editors to manipulate certain properties of imported columns (fields).  The properties that can change include:

  • Changing the name/label of a particular column
  • Adding a description to the column
  • Adjust the format of a numeric field
  • Adjust the currency format of a currency field
  • Setting the visibility of a column (enabled/disabled)

These properties can be managed through the Manage Data tab.  Click on the gear icon to view data settings, then select the “Advanced Settings” option on the left side of the screen.  On the “Fields” tab, you can manage column information for your dataset. Each column can be edited individually by hovering your mouse over the column and clicking the “edit button that appears.

Selecting the edit option will allow you to edit the label and description, enable or disable a column, and adjust the number and currency format.  The contents of the column edit window can vary based on the type of data that is contained within that column.

Editing Labels and Descriptions

When a dataset is imported into SpatialKey, the name and label of each column is produced based on the header line of an imported CSV file or from the column definitions from within a shape file.  In many cases these names may not be human readable (this is especially true when the data was extracted for another system like a database).  You can set the label and description values from within the column details window – these new labels and descriptions will appear when viewing the dataset in dashboards.