Bands

Add a Band

Bands can be added using the following data sources:

• Spreadsheets

• Workflows

Add a Band Using Spreadsheet Data

When adding a band using spreadsheet data, you should first make sure that the data in the spreadsheet is readable by VertiGIS Inline. Follow the instructions in Prepare the Data to ensure your spreadsheet is uploaded correctly. Once you've uploaded your spreadsheet, you can Add Spreadsheet Data as a band.

Prepare the Data

To ensure your spreadsheet data is correctly read by VertiGIS Inline, follow the guidelines below to configure your spreadsheet into a readable format:

• CSV is preferred, but Excel files are also accepted.

• If using an Excel file:

  • Convert all formulas to real values.

  • Remove any merged cells

  • Place all data that you wish to upload to Inline in the first tab. In a multi-tabbed file, Inline will upload only the first tab.

• Measure values are preferred. However Inline also supports:

  • Surrogate measure value fields, such as an odometer value. If there is a known offset between the field and measure values, the adjustment must be made in the spreadsheet.

  • X and Y values. These values must be for the coordinate system used in the application.

• Ensure your header does NOT include:

  • Empty cells

  • Rows above header row

  • Multiple header rows

Add Spreadsheet Data

1. In VertiGIS Inline, click the Add New Band button.

2. Provide a Band Name.

3. In the Data Source dropdown, select Spreadsheet.

4. Click Choose File and then select the spreadsheet you would like to upload.

5. Click Next.

   If Inline is unable to parse the data in the spreadsheet, please review the guidance in Prepare the Data.

6. Select a Chart Type.

7. Choose to configure the Measures from one of the following:

   1. Coordinates

      1. Toggle on Calculate Measures from Coordinates.

      2. Configure the X Field and Y Field using headers from the spreadsheet.

      3. Configure the other fields if you have the appropriate data. Otherwise leave blank.

   2. Measure field or surrogate measure field.

   1. Set the Measure Field to one of the headings from your spreadsheet. If you are using a surrogate measure field, set the Measure Field to the surrogate heading.

   2. Configure the other fields if you have the appropriate data. Otherwise leave blank.

8. Click Done.

Add a Band Using Workflow Data

1. In the View, select the Add New Band button.

2. In the Add New Band dialog, provide a Band Name.

3. In the Data Source dropdown list, select one of the workflows in the list.

4. Click Next.

5. Select a Chart Type.

6. Choose to configure the Measures from one of the following:

   1. Coordinates

      1. Toggle on Calculate Measures from Coordinates.

      2. Configure the X Field and Y Field using fields from the workflow.

      3. Configure the other fields if you have the appropriate data. Otherwise leave blank.

   2. Measure field or surrogate measure field.

   1. Set the Measure Field to one of the fields from your workflow. If you are using a surrogate measure field, set the Measure Field to the surrogate field.

   2. Configure the other fields if you have the appropriate data. Otherwise leave blank.

7. Click Done.