Layer: Televised Mains (ID:3)

View In: Map Viewer

Name: Televised Mains

Display Field: InspectionName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Lineinspected","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[169,0,230,255],"width":3},"defaultLabel":"Unknown","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":3},"value":"0","label":"Fully inspected"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":3},"value":"1","label":"Partially inspected"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,248,202,255],"toColor":[252,248,202,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,179,252,255],"toColor":[194,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,196,255],"toColor":[252,182,196,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,240,252,255],"toColor":[187,240,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,216,255],"toColor":[184,252,216,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,248,255],"toColor":[252,184,248,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,215,252,255],"toColor":[222,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,221,212,255],"toColor":[252,221,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,252,179,255],"toColor":[210,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,237,255],"toColor":[252,207,237,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,239,255],"toColor":[215,252,239,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,222,187,255],"toColor":[252,222,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,217,252,255],"toColor":[179,217,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field: LineInspected

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 41, nullable: true, editable: true)
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)
InspectionID (type: esriFieldTypeInteger, alias: InspectionID, 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: 50, nullable: true, editable: true)
Certificate_Number (type: esriFieldTypeString, alias: Certificate Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
Customer (type: esriFieldTypeString, alias: Customer, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
Drainage_Area (type: esriFieldTypeString, alias: Drainage Area, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
PO_Number (type: esriFieldTypeString, alias: PO Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Pipe_Segment_Reference (type: esriFieldTypeString, alias: Pipe Segment Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Time (type: esriFieldTypeDate, alias: Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
Location_Details (type: esriFieldTypeString, alias: Location Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Upstream_MH (type: esriFieldTypeString, alias: Upstream Manhole, SQL Type: sqlTypeOther, length: 50, 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)
Downstream_MH (type: esriFieldTypeString, alias: Downstream Manhole, SQL Type: sqlTypeOther, length: 50, 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)
Sewer_Use (type: esriFieldTypeString, alias: Sewer Use, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [SS: Sanitary (SS)], [SW: Stormwater (SW)], [PR: Processes (PR)], ... 3 more ...)
Direction (type: esriFieldTypeString, alias: Direction, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [U: Upstream (U)], [D: Downstream (D)])
Flow_Control (type: esriFieldTypeString, alias: Flow Control, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [P: Plugged (P)], [L: Lift Station (L)], [B: Bypassed (B)], ... 2 more ...)
Height (type: esriFieldTypeSmallInteger, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
Width (type: esriFieldTypeSmallInteger, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape_1 (type: esriFieldTypeString, alias: Shape, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: Arched (A)], [B: Barrel (B)], [C: Circular (C)], ... 8 more ...)
Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement (AC)], [BR: Brick (BR)], [CAS: Cast Iron (CAS)], ... 23 more ...)
Lining_Method (type: esriFieldTypeString, alias: Lining Method, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [CP: Cured in Place (CP)], [FF: Fold and Form or Deform/Reform (FF)], [SW: Spiral Wound (SW)], ... 3 more ...)
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_Laid (type: esriFieldTypeSmallInteger, alias: Year Laid, SQL Type: sqlTypeOther, nullable: true, editable: true)
Year_Renewed (type: esriFieldTypeSmallInteger, alias: Year Renewed, SQL Type: sqlTypeOther, nullable: true, editable: true)
Media_Label (type: esriFieldTypeString, alias: Media Label, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
Purpose (type: esriFieldTypeString, alias: Purpose, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [A: Maintenance Related (A)], [B: Infiltration/Inflow Investigation (B)], [C: Post Rehabilitation Survey (C)], ... 7 more ...)
Sewer_Category (type: esriFieldTypeString, alias: Sewer Category, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Pre_Cleaning (type: esriFieldTypeString, alias: Pre-Cleaning, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [J: Jetting (J)], [H: Heavy Cleaning (H)], [N: No Pre-Cleaning (N)], ... 1 more ...)
Date_Cleaned (type: esriFieldTypeDate, alias: Date Cleaned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [1: Dry (1)], [2: Heavy Rain (2)], [3: Light Rain (3)], ... 4 more ...)
Location_Code (type: esriFieldTypeString, alias: Location Code, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [A: Main highway - urban (A)], [B: Main highway - suburban/rural (B)], [C: Light highway (C)], ... 12 more ...)
Additional_Info (type: esriFieldTypeString, alias: Additional Info, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Reverse_Setup (type: esriFieldTypeInteger, alias: Reverse Setup, SQL Type: sqlTypeOther, nullable: true, editable: true)
Sheet_Number (type: esriFieldTypeInteger, alias: Sheet Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
IsImperial (type: esriFieldTypeSmallInteger, alias: Imperial Units?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
PressureValue (type: esriFieldTypeSingle, alias: Pressure Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
WorkOrder (type: esriFieldTypeString, alias: Work Order, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
Project (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
Northing (type: esriFieldTypeString, alias: Northing, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Easting (type: esriFieldTypeString, alias: Easting, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Elevation (type: esriFieldTypeString, alias: Elevation, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Coordinate_System (type: esriFieldTypeString, alias: Coordinate System, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
GPS_Accuracy (type: esriFieldTypeString, alias: GPS Accuracy, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [L: Survey Level (L)], [M: Sub-Meter (M)], [N: Nearest Meter (N)])
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)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Field Name: LineInspected
Inherited
Field Name: Sewer_Use
Inherited
Field Name: Direction
Inherited
Field Name: Flow_Control
Inherited
Field Name: Shape_1
Inherited
Field Name: Material
Inherited
Field Name: Lining_Method
Inherited
Field Name: Purpose
Inherited
Field Name: Pre_Cleaning
Inherited
Field Name: Weather
Inherited
Field Name: Location_Code
Inherited
Field Name: IsImperial
Inherited
Field Name: GPS_Accuracy
Inherited

Field Name: LineInspected
Inherited
Field Name: Sewer_Use
Inherited
Field Name: Direction
Inherited
Field Name: Flow_Control
Inherited
Field Name: Shape_1
Inherited
Field Name: Material
Inherited
Field Name: Lining_Method
Inherited
Field Name: Purpose
Inherited
Field Name: Pre_Cleaning
Inherited
Field Name: Weather
Inherited
Field Name: Location_Code
Inherited
Field Name: IsImperial
Inherited
Field Name: GPS_Accuracy
Inherited

Relationships:

CCTVConditions (0) -- Related To: CCTV Conditions (1)
ContinuousDefects (2) -- Related To: Continuous Defects (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/9/2021 9:13:33 PM

Schema Last Edit Date: 4/9/2021 9:13:33 PM

Data Last Edit Date: 4/9/2021 9:13:33 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