Loading routes

Available with Location Referencing license.

Note:

This functionality will be deprecated at the next release in ArcMap. It will be accessible in ArcGIS Pro.

Each LRS Network requires centerline features along with route definitions. The centerline and network feature classes are connected via the centerline sequence table. The Load Routes tool populates these features and tables. The NetworkID field in the centerline sequence table allows the routes from multiple networks to be stored in the same centerline feature class and centerline sequence table. The steps below outline the process of loading data into the centerline sequence table, centerline, and network feature classes.

The source routes you will use during route loading should have at least one text field with the route ID. Each route in your source routes should have a single route ID for each record. If your source routes have more than one record with the same route ID and from date, only one record for each route ID will be loaded. If your source routes have multipart features or physically gapped routes, they can still be loaded using the Load Routes tool as long as there is a single route ID for each record in the source routes, whether it is a single or multipart feature. Consider editing your source routes using geoprocessing tools, such as the Dissolve or Create Routes tools, to ensure there is a single record for each route ID before using the Load Routes tool.

For routes to be loaded and calibrated properly, source routes should not contain any curves. If your source routes contain curves, you can run the Densify geoprocessing tool on the source routes before route loading to ensure they will load and calibrate properly. For more information, see Densify.

Note:

If your source routes are z-enabled, the z-values will be added to the centerlines loaded into the centerline feature class during the route loading process. This will allow any routes created using the ArcGIS Pipeline Referencing editing tools to incorporate elevation into the length of a centerline when determining calibration.

1. Start ArcMap.
2. In the Catalog window, expand the LRS in the target geodatabase.
3. Right-click the LRS Network and click Load Routes.

   

   If you clicked Yes on the Do you want to load routes? dialog box after creating the LRS Network, the Load Routes dialog box appears.

   

4. Click the browse button next to Polyline Feature Class and choose your source polyline routes feature class.
   • The source polyline routes feature class does not need to be in the same geodatabase as your LRS.
   • Your source polyline routes feature class should have the same spatial reference and x,y, and z (if the feature class is z-enabled) tolerance and resolution as the network feature class the routes are being loaded into. Keeping the tolerance settings the same ensures routes and measures stay in alignment within Pipeline Referencing. For more information about tolerance and resolution in Pipeline Referencing, see LRS data model.
   • If you have a large source polyline routes feature class and your LRS is in a multiuser geodatabase, the database may run out of memory during the route loading process. Contact your database administrator to increase the memory before loading large datasets.
   • If your source routes have subtypes or coded value domains for fields in the route ID, they will be copied over to the LRS Network. For more information, see Coded value domains and subtypes.

5. Click the Route ID Field drop-down arrow and choose the route ID that contains the routes from your polyline feature class.
   • All string fields within the selected polyline feature class will be available in the drop-down list.
   • If your source data has multiple records with the same RouteID and From Date values, only one record for each route ID will be loaded. To ensure all records in the source data are loaded correctly, consider using the Dissolve geoprocessing tool to get a single route for each route ID.

6. If your routes have temporality, do the following:

   

   1. Click the From Date Field drop-down arrow and select the field with the from date from the polyline feature class.
   2. Click the To Date Field drop-down arrow and select the field with the to date from the polyline feature class.

   If your routes do not have temporality, leave this field blank and your routes will automatically be assigned a null value.

   Note:

   Both the From Date Field and To Date Field drop-down lists will show only date fields from the source polyline feature class.

7. Click the Target column drop-down arrow in the Route Attributes Mapping area, and choose an option to match the field in your polyline feature class with the field in the route table in the Route Attributes Mapping area of the dialog box.
   • If the column from your source data is already present in the network feature class, select that field using the Target column drop-down arrow.
   • If you want to load the column from your source data to a different column in your network feature class, select that field in the Target column list. Only fields that are the same type and less than or equal to the length of the field in your source data will appear in the Target column list.
   • If the column from your source data is not present in the route table and you want it to be created on the route table and have source data added, choose <Add to Network> in the Target column list.
   • If you do not want the source data for a column to be added to the route table and network feature class, choose <Do not map> in the Target column list.

   Note:

   If your source polyline feature class has editor tracking enabled, do not map the editor tracking fields in the Route Attributes Mapping area.

8. If the source routes in your polyline feature class have temporality, you can optionally check the Allow time range overlaps check box to allow both routes with identical route IDs and overlapping time ranges to be loaded.
   • If you unchecked the check box and your routes have duplicate route IDs and temporality, an error message will appear and the loading process will fail.
   • If you checked the check box and your routes have duplicate route IDs and temporality, an error message will appear and only the first record for each route ID will be loaded.
   • If you unchecked the check box and your routes have duplicate route IDs and partially overlapping temporality, an error message will appear and the loading process will fail.
   • If you checked the check box and your routes have duplicate route IDs and partially overlapping temporality, an error message will appear, but all records will be loaded.

   Note:

   If you leave the check box checked and load routes with identical route IDs and partially overlapping temporality, the result will be multiple copies of the same route during the overlapping time range. This could potentially cause problems when editing routes and events in Pipeline Referencing. If you load routes with duplicate route IDs and partially overlapping temporality, it is suggested you revisit those routes in your source data, edit them to remove the overlapping temporality, and run the Load Route Updates tool. For more information on loading additional and updated routes, see Loading additional and updated routes.

9. If your data is production level and you want to ensure the route IDs of your source data match the padding and null settings for the network, check the Enforce network rules for route IDs check box. If any route IDs do not match the network settings, the data load will fail and a list of records that do not match the settings will be provided. If this route loading is in a non production environment and you want to ignore the network settings, uncheck the check box.

   Note:

   If you choose to uncheck the check box and ignore the network settings, you still need a field with the route ID.

10. To check for any duplicate route IDs in your source routes, click Check.
    • If no duplicates are returned, proceed to the next step.
    • If duplicates are returned, close the tool, edit your source routes to eliminate any duplicates, and then launch the Load Routes tool to load your routes.

      Note:

      The Load Routes tool will not load routes if any duplicate route IDs exist in the source routes selected in step 3.

11. Click OK.

    In addition to loading data into the centerline feature class, centerline sequence table, and network feature class, the Load Routes tool will rebuild indexes to improve performance when creating calibration points and events in your LRS Network. Depending on the size of your dataset, the route loading process could take more than an hour to complete.

    A progress dialog box appears and shows the steps and progress of route loading.

12. Once route loading is complete, click Done.

    To calibrate the network, calibration points need to be created. At this point, your LRS will have an uncalibrated LRS Network.

13. Click Yes on the Do you wish to launch Update Calibration Points tool? dialog box to create or update calibration points.

    

    Tip:

    You can click No to return to ArcMap.

    If your LRS is created within a multiuser geodatabase, you may want to run the Compress command, Analyze Datasets, and Rebuild Indexes on the geodatabase before you create or update calibration points to improve performance. For more information, see The compress operation and geodatabases.