Introduction

The Cityworks CCTV Interface for PACP passes data between the Cityworks database to a PACP database and back again.

PACP is the Pipeline Assessment and Certification Program of NASSCO, Inc. (National Association of Sewer Service Companies), a not-for-profit trade association established in 1976 which includes contractors, manufacturers, suppliers, engineers, cities, and other professionals in the wastewater, water, and gas utilities. They set up standardized TV inspection codes for evaluating pipe condition as assessed by a closed-circuit television (CCTV) video camera. For more information, visit their website at: http://www.nassco.org/.

Cityworks supports PACP versions 5.3.7-6.5.7. Field mapping is supported between the PACP database and the Cityworks database or geodatabase for both exports and imports. If at least one geodatabase field is mapped, this establishes a connection to the geodatabase and the condition field calculated by the PACP software will load with the import.

NOTE: The PACP condition is calculated instantly, and not actually stored in the PACP database.

Cityworks work order data is exported to a blank PACP exchange database, populating the pipe segment IDs, and other applicable fields using the Export view of CCTV Interface for PACP. This data from the PACP exchange database is loaded into any third-party database using their software. The observations from the TV inspection are then added to a PACP database, using the third-party software program. You can download a blank PACP database from MyCityworks: Download Blank PACP Database for Use with CCTV Interface.

Once the TV inspection is complete, the Import view of CCTV Interface for PACP is used to import TV inspection data from the PACP data exchange database directly to the TV Inspection form associated with the Cityworks work orders.

NOTE: All images were taken on a Google Chrome browser. While there may be slight differences using other browsers, functionality is the same.