Use CCTV Manager

CCTV Manager works with multiple input data schemas and can be configured to work with a custom schema. After using CCTV Manager, CCTV data can be viewed on a map and easily shared around an organization. Links to digital pictures and videos of observations are preserved and can be accessed via a map. Spatial analytics can be applied to the data providing additional asset management insights.

In this topic, you’ll learn how to use the solution by assuming the role of a user and performing the workflows below.

Import Access Tables

The Import Access Tables tool imports CCTV inspection data from Access tables into file geodatabase tables for use in ArcGIS Pro.

Note:

You must install the 64-bit version of Microsoft Access Database Engine 2016 Redistributable.

To import Access tables and convert them to a file geodatabase, complete the following steps:

1. Start ArcGIS Pro and click Start without a template or Open another project to open an existing project.
2. On the Analysis tab, in the Geoprocessing group, click Tools to open the Geoprocessing pane.
3. Browse to the Utility Solutions toolbox. In the CCTV toolset, click Import Access Tables to open the tool in the Geoprocessing pane.
4. For the Access Database parameter, specify the Access database with your CCTV inspection data.
5. Choose the tables for the Tables to Import parameter from the checklist.
6. Specify the File Geodatabase Location and File GDB Name parameters for the tool output.
7. Choose Import Data and schema or Import schema only from the Import Options drop-down menu.
8. Click Run.

Generate CCTV Pipe Features

The Generate CCTV Pipe Features tool enables you to generate spatial features from CCTV inspection data and condition tables. To create CCTV features, complete the following steps:

1. Start ArcGIS Pro and click Start without a template or Open another project to open an existing project.
2. On the Analysis tab, in the Geoprocessing group, click Tools to open the Geoprocessing pane.
3. Browse to the Utility Solutions toolbox, and in the CCTV toolset, click Generate CCTV Pipe Features to open the tool in the Geoprocessing pane.
4. Provide the required parameter information. The following screen capture provides an example of the parameter inputs:

   

5. If CCTV Database Schema is PACP v6.0.4, PACP v7.0.7, or Custom, expand Inspections, Conditions, Media Inspections, and Media Conditions and fill in their respective tables. If CCTV Database Schema is ITpipes v1.5.43 , expand Pipeline, Inspections, Conditions, Media, Media Inspection and Media Conditions and fill in their respective tables.

Note:

If the Custom schema is chosen for the CCTV Database Schema parameter, all fields will have to be filled in manually.
6. Expand Options and fill in any of the following optional parameters:
   • Shape Length Field—Specifies the length field for calculations. If left blank, the geometry will be used instead.
   • Inspection Name—Specifies the inspection name to store the resulting features.
   • Video URL—Provides a path for video URLs.
   • Media Folder—Specifies the storage location of CCTV media.
   • Load Videos as Attachments—Specifies whether to load videos as attachments.
7. If a map is not already open, click the Insert tab, and in the Project group, click New Map to open a new map.
8. Click Run.

   The tool creates CCTV Conditions, Continuous Defects, and Inspected Mains features.

   Note:

   Once the results are displayed on the map, open and close the map before selecting features. There is a known issue when selecting features in a group layer.

9. Update the pop-up configuration to view all attachments, by browsing to the Contents pane, right-clicking Inspected Mains, selecting Configure Pop-ups, and verifying that the Show list of Attachments check box is checked.

   Attachments are now visible in the Inspected Mains pop-ups.