ITpipes and Cityworks


Infrastructure Technologies is proud to be a Cityworks Strategic Alliance Partner.  Our personnel have worked with Cityworks for years and have extensive experience coordinating storm and sewer inspection management within Cityworks and GIS.

IntroductionCreate an AssetAssign Work OrdersSample WorkflowIntegrationUpdate GIS AttributesReporting & PlottingInstant Inspection AccessPACP Upload Only

ITpipes has two options for communicating with Cityworks.

  • The PACP upload option, which uploads completed inspections using PACP codes.
  • The Integration module which makes automated, seamless data transfer between ITpipes and Cityworks.

Cityworks is GIS-centric, pulling asset data it uses from the GIS directly, therefore, many of the options for integrating ITpipes with Cityworks are actually GIS integration tools that enhance functionality for Cityworks.

Clients with ITpipes usually maintain three databases for their infrastructure management:

  1. ITpipes database: ITpipes excels at managing inspection data including data, snapshots, videos and more. Usually this is a “central” inspection database that syncs or merges data with portable/mobile inspection systems.
  2. ArcGIS database: Clients usually do not upload all inspection information into the GIS, as this would be quite cumbersome.
  3. Cityworks database: The Cityworks database contains work order and management information and completed inspection information.

ITpipes’ GIS Send module simplifies creating an asset inventory inside ITpipes, ensuring all known assets exist inside the ITpipes software.

gis send

GIS SEND: Work orders created in Cityworks are highlighted in the GIS. GIS Send then creates the asset in ITpipes saving time for the operator and ensuring information is accurately input! Assets can be sent one at a time or in groups for project management and work order tracking. Fully configurable setup options include layer selection, field mapping and more. GIS Send can be used in the field so inspectors can transfer assets as the inspection is to be performed. Or, supervisors in the office can use GIS Send to pre-populate ‘projects’ for inspectors to go complete. Either way, this speeds up the inspection process and eliminates q.c. issues with completed inspections.

Note: We recommend if using a locked asset inventory list in ITpipes that the client have an emergency project available for use in case an asset needs inspected that doesn’t exist in the known inventory.

cityworks NewWO

ITpipes’ Cityworks Work Order Module simplifies the process for assigning work orders to be inspected.  This allows a user to create the work order inside Cityworks to a specific user; that w.o. will then be “sent” to an existing asset inside ITpipes.  The asset inventory inside ITpipes can be created using ITpipes’ GIS Send Module.  The user inside ITpipes then has a SmartTab showing only work orders/inspections assigned to them.

cityworks data flow1The ITpipes Sync Module is integral to the Cityworks integration as it automatically uploads data from the CCTV Truck to the ITpipes central database.

cityworks uploaded observationsThe Cityworks Integration Module performs two main functions simultaneously:

  • Uploads completed inspections into Cityworks (PACP or non-PACP) and gives you detail on:
    • Work orders in Cityworks that had inspections completed and need closed,
    • Work orders that still have inspections that need performed,
    • Inspections that were performed and have no coordinating work orders (see our feature-rich options below!).
  • Synchronizes completed field inspections into the central ITpipes inspection database
    • Click here for details on the ITpipes merging tools and Sync Module.

This option works great for clients that want detail in Cityworks, want to see during integration what work orders are open, closed or inspections have been completed and need work orders, and want to maintain a comprehensive master inspection database within ITpipes.

gis receive

GIS RECEIVE: ITpipes can update information in the GIS, which of course then displays inside Cityworks as Cityworks is accessing the geodatabase for asset detail. GIS Receive updates your GIS with the latest field inspection information direct into your geodatabase. This includes pipe size changes, pipe material, section length or other detail. Using ESRI permission levels to maintain quality control, defined fields are tracked and a comparison displays original GIS attribute data against new inspection data. Updates are reviewed, accepted, and the GIS is updated! Spatial changes are noted as required changes for the GIS admin to correct as reviewed. Log sheets are maintained for historical reference.

GIS Select - This module is extremely popular for users that do intense reporting and for users that have inspections performed without creating work orders in advance. GIS Select can be used from ITpipes or from your GIS. Any SmartTab or selection from ITpipes can be instantly plotted on the map. Users can save selections as layers in the GIS or toggle back and forth for dynamic reporting and visualization. Here are some ideas on how to use this:

  • Inspections performed without a work order created in advance? highlight those inspections in ITpipes and select them in the GIS; from there its’ a single click with the Cityworks toolbar to create coordinating work orders
  • Operations and maintenance scheduling – setup a SmartTab to show all pipes that need root control, highlight those in the GIS and determine the best area to send a crew, use this same setup for cleaning, tving and other activities.
  • Contract bidding: Display all assets that need rehabilitation or relining and plot those on the map to determine if consecutive assets or assets in a specific area can be grouped together for a project; also provide a highlighted map to the contractor to display where assets are located;
  • Research problems: Do you know that all Orangeburg pipes need replaced by a certain date, highlight those on the map and schedule away.

GIS-Select-new2From the GIS, users can select one or multiple pipes to instantly view historical inspections with snapshots and video.

This can be used to:

  • Address customer complaints: have a specific location with a backup or a problem, select all assets near that location to quickly review detailed inspections and determine where the problem is likely coming from;
  • Need to inspect all the manholes in a specific area: Highlight all the manholes and save to a layer, view any of the inspections you want; in ITpipes select to display all manholes that have been inspected and instantly you can see which haven’t been inspected yet;
  • Determine work in an area where you already know a crew is going: If you know your sending a specific nozzle to an area, highlight all pipes in that area and see what other lines match criteria for that nozzle so you can have the crew do those while nearby.

GIS viewIT

GIS viewIT lets you click on a pipe, manhole or lateral and instantly GIS-ViewIT-newview:

  • Asset and inspection detail,
  • Observations color-coded by severity rating,
  • Snapshots,
  • Video,
  • and PDF reports.
  • Users can select an observation to view the snapshot or double-click on video to view full screen.

If using PACP inside ITpipes, Cityworks has a PACP upload module that imports inspections. This provides the most basic upload functionality and brings your inspection observations and defects into Cityworks. This imports snapshots as well.

Note: Cityworks can provide a demonstration of this upload functionality.

This option works well for clients that do not want to maintain comprehensive inspection detail in an ITpipes master database and simply want all data into Cityworks for usage.

This option does not upload data to an ITpipes master database – that can be done via the ITpipes merge tool.