Configure Mowing Operations—ArcGIS Solutions

Mowing Operations can be used to create and refine mowing areas, monitor real-time mowing activity, share near real-time mowing status updates, track mower locations, and plan seasonal mowing operations.

In this topic, you will learn how to configure the Mowing Operations solution to meet specific needs in your organization.

Manage mowing areas, agreements and vehicle data

You can load data into the Mowing Operations solution using ArcGIS Pro or spreadsheets in your ArcGIS organization. To load data using ArcGIS Pro, complete the following steps:

Sign in to your ArcGIS organization and browse to the Mowing Data Management item.
From the item page, click Download.
Unzip the downloaded folder, and then from the unzipped folder, open the ArcGIS Pro project.
If you do not see the Catalog pane, from the View tab, in the Windows group, click Catalog Pane.
Expand the Tasks folder, and then double-click the Mowing Data Management task group.
In the Tasks pane, expand the Getting Started, Prepare Existing Data, Create New Data, and Append to Feature Layer task groups to see the collection of tasks.
Tip:
Click a group heading or task name to view its description at the bottom of the Tasks pane.
Double-click Understanding Mowing Data Management and complete the task.
Double-click each remaining task and complete it.

Prepare existing data

Your organization may have existing mowing areas, mowing agreements, and information about the vehicles supporting mowing operations. This data can be loaded into the target feature classes in the file geodatabase provided in the Mowing Data Management project.

Maintaining an authoritative inventory of vehicle information helps bring together disparate sources of information and creates a common operating picture of vehicles supporting mowing operations. The vehicle inventory also helps you understand the state of automated vehicle location (AVL) technology used by your fleet, identifies the needs of vehicles without AVL, and documents important vehicle information required by the solution. Before you can bulk upload vehicle information into the solution, follow the instructions in the Vehicles task to document vehicle information using the Vehicle Loading Excel spreadsheet.

Note:

In addition to uploading vehicle information in bulk, you can add new vehicles and modify vehicle information using the Mowing page in the Mowing Operations Center.

Mowing areas and agreements may represent the plans or goals for your agency’s mowing operators or mowing contractors. The mowing areas store site information, mowing status fields, last and next service dates, and assigned agreement ID. Follow the instructions in the Mowing Areas task to load existing mowing polygons and define Agreement IDs. Mowing agreements are associated with mowing areas through this agreement ID, enabling operations managers to measure operations progress, track service agreement compliance, and update mowing status. Follow the instructions in the Agreements task to load existing data and define Agreement IDs.

Create new data

New mowing areas can be created using the Mowing Areas task. Mowing areas store site information, mowing status fields, last and next service dates, and assigned agreement ID. When digitizing mowing areas – who the area is maintained by and service agreement compliance should be taken into account. Follow the instructions in the Mowing Areas task create new mowing polygons and define Agreement IDs. Follow the instructions in the Agreements task to add new mowing agreements and define Agreement IDs.

Append to feature layers

After preparing and processing new and existing data into the solution's schema using the geodatabase, mowing areas, agreements, and vehicles data are now ready to be loaded into feature layers deployed with the solution. Follow the steps in the Append to feature layers task group to complete the data management workflows required by the solution.

Note:

The Vehicles feature layer is shared by the Mowing Operations and Street Sweeping Operations solutions.

Bulk load mowing agreements data

To bulk load data from a spreadsheet to the Agreements table in the MowingAreas feature layer, complete the following steps:

Verify that you are signed in to your ArcGIS organization and browse to the Agreement Loading item.
If you do not have an inventory of mowing service agreements in ArcGIS, you may have them in a spreadsheet. If you don’t have a spreadsheet already, you can use the  Agreements.xlsx file included with the solution to add the service agreement details into the layer.
From the item page, click Download.
Open the Agreement Loading item and edit it with your information.
Ensure that the agreementid field is unique.
Save and close the file.
Browse to the MowingAreas feature layer.
From the item page, click Update Data.
Follow the steps in the Update data wizard to load your data.

Tip:

For more information about uploading data, see Manage hosted feature layers—Append data to layers.

Support equipment operators

The Mowing Operator Reporter QuickCapture project can be used to support operators of vehicles that do not have an AVL device. The Mowing Contractor Reporter QuickCapture  project can be used to support external staff that do not have an AVL device. These QuickCapture projects enable operators and contractors to track their location, report mowing area issues, and submit report status updates, issues in the roadway, and material information. By provisioning users and creating a track view, you will be able to connect to and process information from equipment operators using the QuickCapture projects in ArcGIS Velocity in the same way that you connect to and process information from an AVL device. This ensures that no matter what technology or device is supporting your vehicle with automated vehicle location reporting, you will be able to track where vehicles are in real-time, know when a mowing area was last serviced, and effectively measure the performance of your operations against your agreement details.

After completing the vehicle inventory, reference the Location Source field in the Vehicles table. If all vehicles are identified as Vendor AVL Only, you can proceed to the next section, Configure feeds.

If you have identified any vehicle's Location Source field as ArcGIS Only or Vendor AVL Locations with ArcGIS Field Operations, complete the following sections, Provision users, Create a track view, and Update QuickCapture projects, to support equipment operators of these vehicles with ArcGIS location sharing and field operations capabilities.

Provision users

Included with the Mowing Operations solution are two groups designed to help organize mower operators and contractors, provide access to their corresponding Mowing Operator Reporter and Mowing Contractor Reporter QuickCapture projects, and add mowers to an ArcGIS Tracker view.

Note:

User accounts must already be created for mowers' before you can perform this workflow. Mowers user accounts must have a minimum user type of Mobile Worker to use the Mowing Operations QuickCapture projects.

To add drivers to the Mowing Operators or Mowing Contractors group, complete the following steps:

Verify that you are signed in to your organization and that you have privileges to manage member groups.
Click Groups at the top of the site.
Click the Mowing Operators group, and then click View details to open the group details page.
On the Overview tab, click Invite members.
Check the check box next to the members that you want to add and click Add members to group.
Repeat steps these steps to add members to the Mowing Contractors group.

Create track view

When completing the vehicle inventory, you may have identified vehicles in your fleet with no AVL technology on board. The drivers of these vehicles will use devices in the vehicle to report vehicle location using ArcGIS location sharing technology.

Referencing the vehicle information created in the previous steps, you will use Track Viewer to create a track view of drivers supporting your operations.

Note:

To create track views, you must be a member of the default administrator role in your organization.

Verify that you are signed in to your ArcGIS organization and click the Apps button
in the header of the site.
Click Track Viewer.
By default, Track Viewer is in the app launcher you enable location sharing in and you have the view location tracks privilege.
Click Create View.
Type the name ArcGIS Mower Operators and click Create View.
Tip:
Make a note of the name used for the view. You will reference the name of this view in later steps when creating vehicle feeds in ArcGIS Velocity.
When you create the view, the group controls access to the view is also created.
On the Mobile Users tab, add drivers whose last known locations and tracks should be seen in the track view.
1. Click the Select to add mobile users drop-down arrow.
2. Scroll the list to the Groups (import members) section and select the Mowing Operators group.
3. Click Add.
Repeat the previous step for the Mowing Contractors group and members.

You have created a track view of mowers supporting your mowing operations using Track Viewer and location sharing within the Mowing Operator Reporter andMowing Contractor Reporter QuickCapture projects to report vehicle locations. You are now ready to configure a feed in ArcGIS Velocity to connect to this track view.

Update QuickCapture projects

The Mowing Operator Reporter QuickCapture project is used by mowing operators to share their location and to report operational status, photo observations, and issues such as illegal dumping.

The Mowing Contractor Reporter QuickCapture project is used by contractors that use mowers not managed by the Mowing Operations solution.

To update the Mowing Operator Reporter QuickCapture project, complete the following steps:

Verify that you are signed in to your ArcGIS organization and click the Apps button
in the header of the site.
Click QuickCapture.
Click Mowing Operator Reporter.
The project opens and there is one sharing-related error to resolve.
In the Messages pane on the left, click Share items.
The window Share the following items with project users appears.
Click Share items.
When the solution was initially deployed, the Mowing Operator Reporter QuickCapture project was automatically shared to related groups, but the feature layers used by the QuickCapture project were not.
Click Save.
Optionally, repeat steps 3 through 6 for the Mowing Contractor Reporter QuickCapture project.

You have shared the QuickCapture project with a group that will enable mowing operators with access. Next, you will need to create an ArcGIS Velocity feed that connects to the Track View.

Configure feeds

A feed is a real-time stream of data coming into ArcGIS Velocity. Feeds typically connect to external sources of observational data such as internet of Things (IoT) platforms, message brokers, or third-party APIs. Feeds parse incoming tabular, point, polyline, or polygon data and expose it for analysis and visualization.

The feed deployed with the solution, Vehicles and Last Service Status Feed, is already configured for you and only requires that you start the feed. You will also use feeds to connect to and ingest location data generated by your vehicles, whether from a vendor AVL system, drivers using ArcGIS location sharing on their devices, or a mix of both, depending on the needs identified during the vehicle inventory. The steps to configure vehicle feeds will vary depending on the needs of your organization.

Note:

Follow the steps in the order they are presented below when configuring feeds and analytics.

Start the Vehicles and Last Service Status Feed

The Vehicles and Last Service Status Feed ingests records from the Vehicles and Last Service Status feature layer view. This join view contains all vehicle records stored in the Vehicles table, and if present, is joined with the latest records created in the Service Status layer. Creating a feed from this join view enables the Mowing Operations solution to create a common operating picture from multiple vehicle feed sources.

Note:

The Vehicles and Last Service Status Feed is shared by the Mowing Operations and Street Sweeping Operations solutions. If you are using more than one of these solutions, this feed may already be running.

This feed is already configured and executable. To start the feed, complete the following steps:

Verify that you are signed in to your ArcGIS organization and click the Apps button
in the header of the site.
Click Velocity.
From the main menu, click Feeds.
Click Vehicles and Last Service Status Feed to open the feed Details page.
Click Start to start the feed.

Configure vehicle feeds

Configure vehicle feeds to connect to an automated vehicle location system through a supported third-party API or message broker using supported feed types in ArcGIS Velocity.

To configure a vehicle feed from a track view created in Track Viewer, complete the following steps:

Verify that you are signed in to your ArcGIS organization and click the Apps button
in the header of the site.
Click Velocity.
On the Home page, click Create feed to create a new feed.
Click See all in the ArcGIS feed type.
Under ArcGIS options, click Feature Layer.
For Select Layer, ensure that the search filter is My Content, and then search for and choose the ArcGIS Mower Operators feature layer.
Note:
If you do not own the location tracking layer in your organization, you will need to change the search filter to My Organization to find the ArcGIS Mower Operators feature layer.
Under Select a sublayer, click Tracks (0) then click Next.
Leave the default parameters for Filter Data step and click Next.
Leave the default parameters for Confirm Schema step and click Next.
Note:
You may receive a "There was a problem sampling for messages" error. This error occurs when ArcGIS Velocity is unable to derive a schema for your track view since there have been no recorded tracks for any mobile users in your track view within the last thirty days. To proceed, have at least one mobile user in your track view turn on their location tracking to log a track, and then resample or click Try again. See Confirm schema in the ArcGIS Velocity Configure input data help topic for more information.
In the Timestamp Field step, change the Date field for latest features to created_date and click Next.
Leave the default parameters for Identify Key Fields step and click Next.
Configure the Feed Polling Interval step to Runs periodically, Every 10 Seconds on Every day and click Next.
For step Save, type ArcGIS Mower Operators Feed for the Feed title parameter and optionally provide a summary.
An alternate name can be used for your vehicle feed, but the vehicle feed name above will be referenced in subsequent steps.
Optionally, change the folder where the feed will be stored.
The default location is the home folder.
Click Complete to finish configuring the feed.

You have just configured a feed to ingest vehicle locations reported by operators with ArcGIS location sharing technology on their devices. If you want to configure a vehicle feed to connect to a third-party API, data provider, cloud, or message broker, complete the following steps; otherwise, proceed to Update analytics.

When configuring feeds to connect to a third-party API, data provider, cloud, or message broker, consider the information gathered during the vehicle inventory. If the vehicle inventory indicates all vehicles are supported by your vendor AVL (Location Source is Vendor AVL Only for all vehicles), you only need to create a single vehicle feed.

To connect to a third-party API, data provider, cloud or message broker for vehicles in your inventory where the locationsource value is Vendor AVL Only, complete the following steps:

On the Home page, click Create feed.
Choose the feed type you want to create by browsing the groups of feeds or by using search with a keyword. The feed types needed to connect to your vendor AVL are grouped into three categories:
- Cloud
- Web and Messaging
- Data Providers
Choose the feed type you want to create.
Type the feed configuration details.
Note:
The configuration parameters vary depending on the feed type selected.
Click Next to continue with the remaining steps, including confirming the schema, identifying the key fields, and defining the polling interval (if applicable).
For step Save, type AVL Mowing Feed for the Feed title parameter for feed supporting vehicles whose Location Source field is set to Vendor AVL Only.
Note:
Alternate names can be used for your vehicle feeds, but the above vehicle feed names will be referenced in subsequent steps.
Click Complete to finish configuring the feed.
Note:
For more information, see Configure input data and the Create a feed quick lesson.

Update analytics

Two ArcGIS Velocity analytics deployed with the solution—one real-time analytic and one scheduled big data analytic—must be updated once all feeds have been configured and are successfully running.

Real-time analytics perform processing on data ingested from feeds, analyzing each individual message as it is received. Real-time analytics are used especially for transforming data, geofencing, and incident detection. The real-time analytics delivered with this solution are configured to transform one or more vehicle feeds into a common operating picture.

Note:

All feature layer outputs generated by the analytics have specific data retention settings—and where applicable, archiving settings—already configured. Any modifications to data retention and archiving settings should be made before the analytics run for the first time and after reading guidance in the Modify real-time analytic and Start big data analytic workflows below. Read more about data retention in ArcGIS Velocity.

Modify real-time analytic

The Mowing Vehicle Tracking real-time analytic connects to and merges vehicle and service status information with one or more vehicle feeds, intersects time zone and mowing area information, and generates two outputs: Mower Stream and Mower Tracks.

The Mower Stream output is used to visualize last known vehicle locations for the entire fleet and consists of a stream layer and a feature layer storing only the latest records for each vehicle.
The Mower Tracks output is used as an input for multiple tools in the Mowing Operations Analytics big data analytic. A short data retention window and no archiving is configured for this output as vehicle location history with archiving is already configured for this data on a different output generated by the Mowing Operations Analytics big data analytic.

The Mowing Vehicle Tracking analytic has been designed to support two different configurations of vehicle feeds consistent with the needs identified in the vehicle inventory and the vehicle feed or feeds you configured in the previous step. The Mowing Vehicle Tracking analytic will need to be modified to fit the needs of your organization by locating the correct vehicle feed in the analytic and replacing the broken placeholder feeds with your vehicle feeds. The steps below outline various tasks for updating the Mowing Vehicle Tracking real-time analytic to fit the needs of your organization.

To update the analytic with your vehicle feed and delete unused vehicle feed, complete the following steps:

Verify that you are signed in to your ArcGIS organization and click the Apps button
in the header of the site.
Click Velocity.
From the main menu, click Real-Time.
Click the Edit button for the Mowing Vehicle Tracking real-time analytic.
Add your vehicle feed or feeds to the analytic by clicking add Add Node on the left, and then click Feeds and choose Select existing feed.
Click your vehicle feed in the list and click Confirm.
If you configured more than one vehicle feed, repeat steps 3 through 6 above for each vehicle feed.
Review the broken placeholder feeds list below and their pipelines in the model. You will replace your vehicle feed with the corresponding pipeline.
Note:
Do not delete the Vehicles and Last Service Status Feed, regardless of which vehicle feed pipeline is used.
- If you configured a Mowing AVL Feed, delete the placeholder AVL Feed and connect your feed as the Target in the Join AVL Feed with Vehicles and Last Service Status Feed tool.
- If you configured an ArcGIS Mowing Operators Feed, delete the placeholder ArcGIS Location Tracking Feed and connect your feed to the Join Vehicles and Last Service Status to ArcGIS Location Tracking Feed tool.
Click Save to commit your changes and validate the analytic.
After vehicle feeds are connected to the correct pipeline, delete unused vehicle feed pipelines from the model.
- If only using the ArcGIS Mowing Operators Feed, delete the AVL Mower Feed from the placeholder vehicle feed to the Merge AVL and ArcGIS Mower Feeds tool. Reconnect the Map Fields Mowing Operators tool to the Project for Time Zones tool.
  A common configuration of the Mowing Vehicle Tracking real-time analytic is shown when only one vehicle feed pipeline is used: ArcGIS Mowing Operators Feed. The unused analytic pipeline, AVL Mower Feed, has been removed from the model. Click to view a larger version
  Note:
  You can select multiple nodes in the model by pressing Ctrl while selecting each node. Click Delete to remove the selected nodes from the model. If you make a mistake when deleting nodes, use keyboard shortcuts Ctrl+Z and Ctrl+Y to undo and redo edits, respectively.
- If only using AVL Mower Feed, remove the ArcGIS Mowing Operators Feed from the placeholder feed to the Merge AVL and ArcGIS Mower Feeds tool. Connect the Map Fields AVL Mowers tool directly to the Project for Time Zones tool.
  A common configuration of the Mowing Vehicle Tracking real-time analytic is shown when only one vehicle feed pipeline is used: AVL Mower Feed. The unused analytic pipeline, ArcGIS Mowing Operators Feed, has been removed from the model. Click to view larger version
Click Save to commit your changes and validate the analytic.
- If the ArcGIS Mowing Operators Feed is the only vehicle feed in your analytic, no additional configuration is needed in the Mowing Vehicle Tracking real-time analytic since the schema was already known by the tools connecting to the feed.
- If you have AVL feeds in your model, continue configuring your vehicle feeds following the steps below.

Additional configuration is required if you are using a vendor AVL for your vehicle feeds, since the schemas for these feeds vary for different AVL vendors.

To finish configuring the AVL Mower Feed in the Mowing Vehicle Tracking real-time analytic, complete the following steps:

Double-click Join AVL Feed with Vehicles and Last Service Status Feed to open the tool properties.
Click the Target field drop-down arrow and choose the asset or vehicle ID field from your feed.
The target field values will be matched to the vehicle ID values recorded in the vehicle inventory.
Click Apply.
Click Save to commit changes and validate the analytic.
Double-click Map Fields AVL Mowers to open the tool properties.
Click servicestatus to open field mapping options.
The servicestatus field will be used to transform raw values from your vehicle feed to indicate that the vehicle is currently mowing.

Click the Configure an Arcade expression button

. Use Arcade to classify raw values from the feed to a valid value below:

In Transit
Mowing

//Example Arcade expression to classify values from the feed to values used by the solution

var bladestatus = $feature.yourbladestatusfield
//example values are text, include "off", "engaged"

if (bladestatus == "off") {
     return 'In Transit'
}
else if (bladestatus == "engaged") {
     return 'Mowing'
}
else {
     return null
}

Click OK.
Click Update mapping.
Refer to the following table for a list of output fields and field types that must be mapped with your vehicle feed's input.
feed field name
speed (Int32)
feed field name
heading (Float64)
feed field name
vehicleid (String)
feed field name
location_timestamp (Date)
Some fields may require you to transform existing values into the data or value type defined by the output field. For example, if your feed contains speed expressed as meters per second, use the following Arcade expression to calculate miles per hour (miles per hour is the expected unit for speed Vendor AVL ingested into the Mowing Vehicle Tracker analytic):
```
//Example Arcade expression

Floor($feature["yourspeedfield"]*2.237)
```

Optionally, additional fields from your AVL can be retained and mapped into the solutions schema. Refer to the following table for a list of optional output fields and field types that can be mapped with your vehicle feed's input.

feed field name	aux1 (String) Reserved for Mower deck width in inches
feed field name	aux2 (String)
feed field name	aux3 (String)
feed field name	aux4 (Float64)
feed field name	aux5 (Float64)
feed field name	aux6 (Float64)

Click Apply.
Click Save to commit your changes and validate the analytic.
Click Start to start the analytic.

Start big data analytic

The Mowing Operations Analytics is a scheduled big data analytic that is configured with multiple analytic pipelines and summarizes area mowed, stores a history of mowed paths for each mower and service records for each mowing area, generates near real-time mowing area status updates, stores weather history, and measures operational performance.

The first analytic pipeline stores mower location history for each mower during operations. The pipeline produces two outputs a Mowed Paths feature layer and a MowedAreas feature layer. These layers exist on ArcGIS Online and are deployed with the solution. The MowedPaths layer stores each individual vehicle's mowed path into a polygon for each analytic run. The MowedAreas layer stores a single polygon for each analytic run and combines stats from each vehicle summarized by each Mowing Area ID.
The second analytic pipeline summarizes the mowed area by service status for each mowing area during operations. The MowedAreasSummary table is output to store metrics related to cumulative seasonal operations feature layer output is a feature layer that can be managed for your organization's needs. It stores only one record for each Mowing Area ID.
The third and fourth analytic pipelines generate near real-time mowing area status updates. The third pipeline connects to and updates last service information for Mowing Areas stored in a hosted feature layer. The fourth pipeline connects to and updates last service information, as well updates a next mowing date based on the Mowing Area Agreement interval computes metrics stored in the Mowing Area Metrics feature layer output stored in a hosted feature layer.

To update the Mowing Operations Analytics scheduled big data analytic, complete the following steps:

Verify that you are signed in to your ArcGIS organization and click the Apps button
in the header of the site.
Click Velocity.
From the main menu, click Big Data.
On the Big Data Analytics page, click the Edit button for the Mowing Operations Analytics big data analytic.
There is one broken input node in the analytic for Mowing Tracks. When the solution was initially deployed, this feature service did not yet exist.
Double-click the Mowing Tracks data source to access the properties.
Click Edit.
For the Select Layer step, ensure the search filter is My Content, and then search for and select the mowertracks_rat[UniqueID] feature service.
Ensure that the Feature Service is selected and not the map service of the same name.
Click Next.
For the Filter Data step, type the following text into the WHERE clause text box:
datetimeprocessed > CURRENT_TIMESTAMP - INTERVAL '15' MINUTE AND assignedoperation = 'Mowing'
Change the Output spatial reference to WGS 1984 Web Mercator Auxiliary Sphere 3857.
Click Next.
Leave the default parameters for the Confirm Schema step and click Next.
For the Timestamp Field step, confirm the Date field for latest features is set to the datetimeprocessed and click Next.
For the Identify Key Fields step, ensure Start time is set to the location_timestamp and Track ID is set to the vehicleid and then click Complete.
The analytic attempts to validate.
Click Save to commit updates to the analytic.
One or more warnings may be present, but the analytic has still successfully validated. The warnings are expected, and you can proceed to the next step. However, if errors are present, you will need to resolve them before moving on to the next step.
Click Start to run the scheduled big data analytic.

Note:

The Mowing Operations Analytics big data analytic is configured to run every five minutes. Change this interval to meet the needs of your organization.

You have completed the steps for updating the ArcGIS Velocity analytics delivered with the solution.

Configure mowing area agreement form

The Mowing Operations  solution includes the Mowing Area Agreement Details form that can be used by operations and maintenance managers to add and update service agreement IDs to their corresponding mowing areas. This form allows users to select a unique agreement ID from the Agreements table so that the given mowing area can be related to the active service agreement.

To modify the Mowing Area Agreement Details form, complete the following steps:

Install ArcGIS Survey123 Connect.
Start ArcGIS Survey123 Connect and sign in to your ArcGIS organization.
Click Mowing Area Agreement Details to download the survey.
In the Download window, click Download and click OK.
Click Mowing Area Agreement Details to open the survey.
On the left, from the side toolbar, click the XLSForm button.
At the bottom of the Microsoft Excel spreadsheet, click the settings tab.
This tab contains options for controlling the presentation and behavior in the survey.
In the submission_url column for the Populate a Mowing Area Agreement ID question (cell D2), paste the MowingAreas_editor feature layer view URL.
Note:
To create this URL, concatenate the portal Content Root with the MowingAreas_editor Item ID. The Item ID can be found at the end of the item details URL immediately following ?id= The portal Content Root for an ArcGIS Online item is https://www.arcgis.com/sharing/rest/content/items/ So the resulting submission_url should look like: https://www.arcgis.com/sharing/rest/content/items/776dbc177f67446b9971c2aa6f086ab2
At the bottom of the Microsoft Excel spreadsheet, click the survey tab.
This tab comprises all the questions in the survey.
In the appearance column for the select_one agreement question (cell F3), the Rest URL for the Agreements table must be specified.
There is a placeholder, #, that needs to be replaced by the Rest URL for the Agreements table from the MowingAreas_editor feature layer view.
To find the URL, browse to the MowingAreas_editor feature layer view.
From the item page, click Agreements under the Tables list.
Scroll to the bottom of the page and click Copy to copy the URL.
In the XLSForm, replace the # in the appearance value with the copied text.
Save and close the Microsoft Excel spreadsheet and preview your changes in ArcGIS Survey123 Connect.
In ArcGIS Survey123 Connect, in the left toolbar, click Publish to publish your changes.
Click Publish survey to publish your changes, and then click OK.

Feedback on this topic?

feed field name	speed (Int32)
feed field name	heading (Float64)
feed field name	vehicleid (String)
feed field name	location_timestamp (Date)