Name: Inspected Sanitary Main

Display Field: FACILITYID

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:

XMin: -9625118.24129022
YMin: 5174796.25345279
XMax: -9621744.64998903
YMax: 5178386.62279682
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"authoringInfo":{"visualVariables":[{"type":"colorInfo","minSliderValue":0,"maxSliderValue":5}]},"type":"classBreaks","field":"STPipeRatingsIndex","minValue":-9223372036854775808,"classBreakInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2.5},"classMaxValue":9223372036854775807}],"legendOptions":{"order":"ascendingValues"},"visualVariables":[{"type":"colorInfo","valueExpressionTitle":"Custom","valueExpression":"$feature.STPipeRatingsIndex","stops":[{"value":0,"color":[255,0,0,255],"label":"0.0"},{"value":2.5,"color":[255,255,0,255]},{"value":5,"color":[56,168,0,255],"label":"5.0"}],"legendOptions":{"title":"","showLegend":true,"order":"ascendingValues"}}]},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic], [AC: Asbestos Cement], [ASP: Asphalt], ... 33 more ...)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 28 more ...)
• MAINSHAPE (type: esriFieldTypeString, alias: Main Shape, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Circular: Circular], [Horseshoe: Horseshoe], [Oblong: Oblong], ... 5 more ...)
• LINEDYEAR (type: esriFieldTypeString, alias: Year Lined, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LINERTYPE (type: esriFieldTypeString, alias: Liner Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CP: Cured in Place], [FF: Fold and Form or Deform/Reform], [SN: Segmented Panel], ... 4 more ...)
• FROMMH (type: esriFieldTypeString, alias: From Manhole, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• TOMH (type: esriFieldTypeString, alias: To Manhole, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Treated: Treated Water], [Combined: Combined Waste Water], [Potable: Potable Water], ... 6 more ...)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: Benton Township], [3: Berrien County], [1: City of Benton Harbor], ... 4 more ...)
• MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: Benton Township], [3: Berrien County], [1: City of Benton Harbor], ... 4 more ...)
• SUMFLOW (type: esriFieldTypeDouble, alias: Flow Summary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DOWNELEV (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPELEV (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLOPE (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LifeCycleStatus (type: esriFieldTypeString, alias: Life Cycle Status, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [Abandoned: Abandoned], [In Service: In Service], [Out of Service: Out of Service], ... 1 more ...)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RecordLength (type: esriFieldTypeString, alias: Record Length, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• RecordDrawing (type: esriFieldTypeString, alias: Record Drawing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• PipeType (type: esriFieldTypeString, alias: Pipe Sub Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Collector: Collector], [Culvert: Culvert], [DeadEnd: Dead-End (Stub)], ... 7 more ...)
• InspectionID (type: esriFieldTypeInteger, alias: InspectionID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Surveyed_By (type: esriFieldTypeString, alias: Surveyed_By, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Certificate_Number (type: esriFieldTypeString, alias: Certificate_Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Reviewed_By (type: esriFieldTypeString, alias: Reviewed_By, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Reviewer_Certificate_Number (type: esriFieldTypeString, alias: Reviewer_Certificate_Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Customer (type: esriFieldTypeString, alias: Customer, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PO_Number (type: esriFieldTypeString, alias: PO_Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WorkOrder (type: esriFieldTypeString, alias: WorkOrder, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Media_Label (type: esriFieldTypeString, alias: Media_Label, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Project (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Inspection_Time (type: esriFieldTypeString, alias: Inspection_Time, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Sheet_Number (type: esriFieldTypeInteger, alias: Sheet_Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Weather (type: esriFieldTypeInteger, alias: Weather, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dry - No Precipitation During Survey], [2: Heavy Rain], [3: Light Rain], ... 2 more ...)
• PreCleaning (type: esriFieldTypeString, alias: PreCleaning, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [H: Heavy Cleaning], [L: Light Cleaning], [N: No Pre-Cleaning], ... 2 more ...)
• Flow_Control (type: esriFieldTypeString, alias: Flow_Control, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Purpose (type: esriFieldTypeString, alias: Purpose, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [A: Maintenance Related], [B: Infiltration/Inflow Investigation], [C: Post Rehabilitation Survey], ... 8 more ...)
• Direction (type: esriFieldTypeString, alias: Direction, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [D: Downstream], [U: Upstream])
• Inspection_Technology_Used_CCTV (type: esriFieldTypeString, alias: Inspection_Technology_Used_CCTV, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Inspection_Technology_Used_Lase (type: esriFieldTypeString, alias: Inspection_Technology_Used_Laser, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Inspection_Technology_Used_Sona (type: esriFieldTypeString, alias: Inspection_Technology_Used_Sonar, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Inspection_Technology_Used_Side (type: esriFieldTypeString, alias: Inspection_Technology_Used_Sidewall, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Inspection_Technology_Used_Zoom (type: esriFieldTypeString, alias: Inspection_Technology_Used_Zoom, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Inspection_Technology_Used_Othe (type: esriFieldTypeString, alias: Inspection_Technology_Used_Other, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Inspection_Status (type: esriFieldTypeString, alias: Inspection_Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Consequence_Of_Failure (type: esriFieldTypeString, alias: Consequence_Of_Failure, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Pressure_Value (type: esriFieldTypeString, alias: Pressure_Value, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Drainage_Area (type: esriFieldTypeString, alias: Drainage_Area, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Pipe_Segment_Reference (type: esriFieldTypeString, alias: Pipe_Segment_Reference, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Location_Code (type: esriFieldTypeString, alias: Location_Code, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Location_Details (type: esriFieldTypeString, alias: Location_Details, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Pipe_Use (type: esriFieldTypeString, alias: Pipe_Use, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Height (type: esriFieldTypeInteger, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Width (type: esriFieldTypeString, alias: Width, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Material_1724245414358 (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [ABS: Acrylonitrile Butadiene Styrene], [AC: Asbestos Cement], [BR: Brick], ... 24 more ...)
• Lining_Method (type: esriFieldTypeString, alias: Lining_Method, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [CIP: Cured-In-Place Pipe], [FF: Fold and Form or Deform/Reform], [FP: Formed-In-Place Liner], ... 11 more ...)
• Coating_Method (type: esriFieldTypeString, alias: Coating_Method, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [CM: Cement Mortar], [CT: Coal Tar or Bituminous], [EP: Epoxy], ... 6 more ...)
• Pipe_Joint_Length (type: esriFieldTypeString, alias: Pipe_Joint_Length, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Total_Length (type: esriFieldTypeDouble, alias: Total_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Length_Surveyed (type: esriFieldTypeDouble, alias: Length_Surveyed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year_Constructed (type: esriFieldTypeString, alias: Year_Constructed, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Year_Renewed (type: esriFieldTypeString, alias: Year_Renewed, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Upstream_MH (type: esriFieldTypeString, alias: Upstream_MH, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Up_Rim_to_Invert (type: esriFieldTypeString, alias: Up_Rim_to_Invert, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Up_Grade_to_Invert (type: esriFieldTypeString, alias: Up_Grade_to_Invert, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Up_Rim_to_Grade (type: esriFieldTypeString, alias: Up_Rim_to_Grade, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Up_Northing (type: esriFieldTypeString, alias: Up_Northing, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Up_Easting (type: esriFieldTypeString, alias: Up_Easting, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Up_Elevation (type: esriFieldTypeString, alias: Up_Elevation, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Downstream_MH (type: esriFieldTypeInteger, alias: Downstream_MH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Down_Rim_to_Invert (type: esriFieldTypeString, alias: Down_Rim_to_Invert, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Down_Grade_to_Invert (type: esriFieldTypeString, alias: Down_Grade_to_Invert, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Down_Rim_to_Grade (type: esriFieldTypeString, alias: Down_Rim_to_Grade, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Down_Northing (type: esriFieldTypeString, alias: Down_Northing, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Down_Easting (type: esriFieldTypeString, alias: Down_Easting, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Down_Elevation (type: esriFieldTypeString, alias: Down_Elevation, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• MH_Coordinate_System (type: esriFieldTypeString, alias: MH_Coordinate_System, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Vertical_Datum (type: esriFieldTypeString, alias: Vertical_Datum, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• GPS_Accuracy (type: esriFieldTypeString, alias: GPS_Accuracy, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Additional_Info (type: esriFieldTypeString, alias: Additional_Info, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Reverse_Setup (type: esriFieldTypeInteger, alias: Reverse_Setup, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsImperial (type: esriFieldTypeString, alias: IsImperial, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RatingID (type: esriFieldTypeInteger, alias: RatingID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InspectionID_1 (type: esriFieldTypeInteger, alias: InspectionID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STGradeScore1 (type: esriFieldTypeInteger, alias: STGradeScore1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STGradeScore2 (type: esriFieldTypeInteger, alias: STGradeScore2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STGradeScore3 (type: esriFieldTypeInteger, alias: STGradeScore3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STGradeScore4 (type: esriFieldTypeInteger, alias: STGradeScore4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STGradeScore5 (type: esriFieldTypeInteger, alias: STGradeScore5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OMGradeScore1 (type: esriFieldTypeInteger, alias: OMGradeScore1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OMGradeScore2 (type: esriFieldTypeInteger, alias: OMGradeScore2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OMGradeScore3 (type: esriFieldTypeInteger, alias: OMGradeScore3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OMGradeScore4 (type: esriFieldTypeInteger, alias: OMGradeScore4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OMGradeScore5 (type: esriFieldTypeInteger, alias: OMGradeScore5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STPipeRating (type: esriFieldTypeInteger, alias: STPipeRating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OMPipeRating (type: esriFieldTypeInteger, alias: OMPipeRating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OverallPipeRating (type: esriFieldTypeInteger, alias: OverallPipeRating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STQuickRating (type: esriFieldTypeString, alias: STQuickRating, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• OMQuickRating (type: esriFieldTypeString, alias: OMQuickRating, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PACPQuickRating (type: esriFieldTypeString, alias: PACPQuickRating, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• STPipeRatingsIndex (type: esriFieldTypeDouble, alias: STPipeRatingsIndex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OMPipeRatingsIndex (type: esriFieldTypeDouble, alias: OMPipeRatingsIndex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OverallPipeRatingsIndex (type: esriFieldTypeDouble, alias: OverallPipeRatingsIndex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LoFPACP (type: esriFieldTypeDouble, alias: LoFPACP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Risk (type: esriFieldTypeString, alias: Risk, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PipeShape (type: esriFieldTypeString, alias: PipeShape, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A: Arched], [B: Barrel], [C: Circular], ... 8 more ...)
• Inspection_Date (type: esriFieldTypeDate, alias: Inspection_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date_Cleaned (type: esriFieldTypeDate, alias: Date_Cleaned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• VideoLink (type: esriFieldTypeString, alias: Video Link, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• VideoLink2 (type: esriFieldTypeString, alias: Second Video Link, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ACINotes (type: esriFieldTypeString, alias: Abonmarche Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CreationDate_1724245414358 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator_1724245414358 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate_1724245414358 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor_1724245414358 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Inspected Sanitary Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/10/2025 8:25:52 PM

Schema Last Edit Date: 2/10/2025 8:25:52 PM

Data Last Edit Date: 2/10/2025 8:25:52 PM

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