Name: TelevisedMains

Display Field: InspectionName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 338109.270115495
YMin: 252688.640480071
XMax: 360987.15513391
YMax: 280024.288892657
Spatial Reference: 102730 (3438)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[85,255,0,255],"width":5.25}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: true

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• InspectionName (type: esriFieldTypeString, alias: Inspection Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UniqueInspectionID (type: esriFieldTypeGUID, alias: Unique Inspection ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ConditionCount (type: esriFieldTypeSmallInteger, alias: Number of Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LineInspected (type: esriFieldTypeSmallInteger, alias: Line Inspected?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fully inspected], [1: Partially inspected])
• Surveyed_By (type: esriFieldTypeString, alias: Surveyed By, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Certificate_Number (type: esriFieldTypeString, alias: Certificate Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Reviewed_By (type: esriFieldTypeString, alias: Reviewed By, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Reviewer_Certificate_Number (type: esriFieldTypeString, alias: Reviewer Certificate Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Customer (type: esriFieldTypeString, alias: Customer, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PO_Number (type: esriFieldTypeString, alias: PO Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• WorkOrder (type: esriFieldTypeString, alias: WorkOrder, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Media_Label (type: esriFieldTypeString, alias: Media Label, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• Project (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• Inspection_Date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspection_Time (type: esriFieldTypeDate, alias: Inspection Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Sheet_Number (type: esriFieldTypeInteger, alias: Sheet Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PreCleaning (type: esriFieldTypeString, alias: PreCleaning, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Date_Cleaned (type: esriFieldTypeDate, alias: Date Cleaned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Flow_Control (type: esriFieldTypeString, alias: Flow Control, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Purpose (type: esriFieldTypeString, alias: Purpose, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Direction (type: esriFieldTypeString, alias: Direction, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Inspection_Technology_Used_CCTV (type: esriFieldTypeSmallInteger, alias: Inspection Technology Used CCTV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_Technology_Used_Lase (type: esriFieldTypeSmallInteger, alias: Inspection Technology Used Laser, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_Technology_Used_Sona (type: esriFieldTypeSmallInteger, alias: Inspection Technology Used Sonar, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_Technology_Used_Side (type: esriFieldTypeSmallInteger, alias: Inspection Technology Used Sidewall, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_Technology_Used_Zoom (type: esriFieldTypeSmallInteger, alias: Inspection Technology Used Zoom, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_Technology_Used_Othe (type: esriFieldTypeSmallInteger, alias: Inspection Technology Used Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_Status (type: esriFieldTypeString, alias: Inspection Status, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Consequence_Of_Failure (type: esriFieldTypeString, alias: Consequence Of Failure, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Pressure_Value (type: esriFieldTypeSingle, alias: Pressure Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Drainage_Area (type: esriFieldTypeString, alias: Drainage Area, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Pipe_Segment_Reference (type: esriFieldTypeString, alias: Pipe Segment Reference, SQL Type: sqlTypeOther, length: 51, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• Location_Code (type: esriFieldTypeString, alias: Location Code, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Location_Details (type: esriFieldTypeString, alias: Location Details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pipe_Use (type: esriFieldTypeString, alias: Pipe Use, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Height (type: esriFieldTypeInteger, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Width (type: esriFieldTypeInteger, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape_1 (type: esriFieldTypeString, alias: Shape, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Lining_Method (type: esriFieldTypeString, alias: Lining Method, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Coating_Method (type: esriFieldTypeString, alias: Coating Method, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Pipe_Joint_Length (type: esriFieldTypeSingle, alias: Pipe Joint Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Length (type: esriFieldTypeSingle, alias: Total Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Length_Surveyed (type: esriFieldTypeSingle, alias: Length Surveyed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year_Constructed (type: esriFieldTypeInteger, alias: Year Constructed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year_Renewed (type: esriFieldTypeInteger, alias: Year Renewed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Upstream_MH (type: esriFieldTypeString, alias: Upstream MH, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Up_Rim_to_Invert (type: esriFieldTypeSingle, alias: Up Rim to Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Up_Grade_to_Invert (type: esriFieldTypeSingle, alias: Up Grade to Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Up_Rim_to_Grade (type: esriFieldTypeSingle, alias: Up Rim to Grade, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Up_Northing (type: esriFieldTypeString, alias: Up Northing, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Up_Easting (type: esriFieldTypeString, alias: Up Easting, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Up_Elevation (type: esriFieldTypeString, alias: Up Elevation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Downstream_MH (type: esriFieldTypeString, alias: Downstream MH, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Down_Rim_to_Invert (type: esriFieldTypeSingle, alias: Down Rim to Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Down_Grade_to_Invert (type: esriFieldTypeSingle, alias: Down Grade to Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Down_Rim_to_Grade (type: esriFieldTypeSingle, alias: Down Rim to Grade, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Down_Northing (type: esriFieldTypeString, alias: Down Northing, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Down_Easting (type: esriFieldTypeString, alias: Down Easting, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Down_Elevation (type: esriFieldTypeString, alias: Down Elevation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MH_Coordinate_System (type: esriFieldTypeString, alias: MH Coordinate System, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Vertical_Datum (type: esriFieldTypeString, alias: Vertical Datum, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GPS_Accuracy (type: esriFieldTypeString, alias: GPS Accuracy, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Additional_Info (type: esriFieldTypeString, alias: Additional Info, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Reverse_Setup (type: esriFieldTypeInteger, alias: Reverse Setup, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsImperial (type: esriFieldTypeSmallInteger, alias: IsImperial, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Issue (type: esriFieldTypeString, alias: Issue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MediaID (type: esriFieldTypeInteger, alias: Media ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Video_Name (type: esriFieldTypeString, alias: Video Name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Video_Location (type: esriFieldTypeString, alias: Video Location, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• VideoURL (type: esriFieldTypeString, alias: VideoURL, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• CCTV_SEGREFID (type: esriFieldTypeString, alias: CCTV_SEGREFID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• InspectionID (type: esriFieldTypeInteger, alias: InspectionID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Report (type: esriFieldTypeString, alias: ReportURL, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• ORIG_OID (type: esriFieldTypeString, alias: Original ID (Matches with FacilityID From IAP), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IAP_Consequence_Score (type: esriFieldTypeDouble, alias: Info Asset Planner Consequence Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST_Score_Consequence (type: esriFieldTypeDouble, alias: Structural Consequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OM_Score_Consequence (type: esriFieldTypeDouble, alias: O&M Consequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Score_Consequence (type: esriFieldTypeDouble, alias: Total Score Consequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST_Quick_Consequence (type: esriFieldTypeDouble, alias: Structural Quick Consequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OM_Quick_Consequence (type: esriFieldTypeDouble, alias: O&M Quick Consequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Quick_Consequence (type: esriFieldTypeDouble, alias: Total Quick Consequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• IAP_Risk_Score (type: esriFieldTypeDouble, alias: IAP Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Score_Risk (type: esriFieldTypeDouble, alias: Total Score x Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST_Score_PACP (type: esriFieldTypeDouble, alias: ST Score PACP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OM_Score_PACP (type: esriFieldTypeDouble, alias: OM Score PACP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Score_PACP (type: esriFieldTypeDouble, alias: Total Score PACP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST_Quick_PACP (type: esriFieldTypeDouble, alias: ST Quick PACP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OM_Quick_PACP (type: esriFieldTypeDouble, alias: OM Quick PACP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Quick_PACP (type: esriFieldTypeDouble, alias: Total Quick PACP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST_Score_Risk (type: esriFieldTypeDouble, alias: ST Score x Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OM_Score_Risk (type: esriFieldTypeDouble, alias: OM Score x Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST_Quick_Risk (type: esriFieldTypeDouble, alias: ST Quick Score x Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OM_Quick_Risk (type: esriFieldTypeDouble, alias: OM Quick Score x Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Quick_Risk (type: esriFieldTypeDouble, alias: Total Quick Score x Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: TelevisedMains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Relationships:

• CCTVConditions (0) -- Related To: CCTVConditions (0)
• ContinuousDefects (2) -- Related To: ContinuousDefects (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/22/2025 8:34:38 PM

Schema Last Edit Date: 12/22/2025 8:01:51 PM

Data Last Edit Date: 12/22/2025 8:01:47 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat