Name: Culvert Line

Display Field: SYSNO

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 5000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13832829.6294671
YMin: 3835606.24127876
XMax: -12723889.1615877
YMax: 5161516.30151249
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","valueExpression":"var findHMCIP = Find('HMCIP', $feature.last_comment)\nvar containsHMCIP = IIF(findHMCIP > -1, \"Contains HMCIP\", \"Does Not Contain HMCIP\")\nvar nullHS = IIF(IsEmpty($feature.HealthScore),0,1)\n\n \n\nWHEN(\n$feature.ConveyanceType == 1 && $feature.HealthScore >= 80 && nullHS == 1, \"Good Culvert (80-100)\",\n$feature.ConveyanceType == 1 && $feature.HealthScore >= 50 && $feature.HealthScore <= 79 && nullHS == 1, \"Fair Culvert (50-79)\",\n$feature.ConveyanceType == 1 && $feature.HealthScore >= 0 && $feature.HealthScore <= 49 && nullHS == 1, \"Poor Culvert (0-49)\",\n$feature.ConveyanceType == 1 && $feature.HealthScore == -1 && (containsHMCIP == \"Does Not Contain HMCIP\" || $feature.last_cipeditor != \"HMCIP\"), \"Culverts Not Evaluated (N/A)\",\n($feature.ConveyanceType == 1 && $feature.HealthScore == -999) || ($feature.ConveyanceType == 1 && $feature.HealthScore == -1 && (containsHMCIP == \"Contains HMCIP\" || $feature.last_cipeditor == \"HMCIP\")), \"Culverts Pending Inspection\",\n$feature.ConveyanceType == 2, \"Ditch\",\n$feature.ConveyanceType == 3, \"Slotted Drain\",\n\"All Other Records\")","valueExpressionTitle":"Conveyance","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[85,255,0,255],"width":10},"value":"Good Culvert (80-100)","label":"Good Culvert (80-100)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":10},"value":"Fair Culvert (50-79)","label":"Fair Culvert (50-79)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":10},"value":"Poor Culvert (0-49)","label":"Poor Culvert (0-49)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":10},"value":"Culverts Not Evaluated (N/A)","label":"Culverts Not Evaluated (N/A)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,170,0,255],"width":10},"value":"Culverts Pending Inspection","label":"Culverts Pending Inspection"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,255,197,255],"width":10},"value":"Ditch","label":"Ditch"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,255,197,255],"width":10},"value":"Slotted Drain","label":"Slotted Drain"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[51,51,51,255],"width":7},"value":"All Other Records","label":"All Other Records"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,252,252,255],"toColor":[199,252,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,179,252,255],"toColor":[250,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[248,252,184,255],"toColor":[248,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,194,192,255],"toColor":[252,194,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,199,252,255],"toColor":[179,199,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,205,255],"toColor":[182,252,205,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,246,255],"toColor":[252,210,246,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,232,204,255],"toColor":[252,232,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,226,252,255],"toColor":[202,226,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[201,252,179,255],"toColor":[201,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[228,252,212,255],"toColor":[228,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[218,189,252,255],"toColor":[218,189,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,212,252,255],"toColor":[222,212,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"// Write a script that will be used to label features.\n// For example, append the value of two fields:\n// $feature.name + \" \" + $feature.status\nRight($feature.INETNO,3) + \"-\" + Right($feature.OUTETNO,3)\n"},"lineOrientation":"unconstrained","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":false,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":false,"removeDuplicates":"all","removeDuplicatesDistance":0,"useCodedValues":true,"maxScale":0,"minScale":5000,"name":"Simple Culvert Name","priority":0,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Tahoma","size":8,"style":"normal","weight":"normal","decoration":"none"}}}]}

HasZ: true

HasM: false

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: 0, nullable: false, editable: false)
• SYSNO (type: esriFieldTypeString, alias: System Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• INETNO (type: esriFieldTypeString, alias: Inlet End Treatment Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• OUTETNO (type: esriFieldTypeString, alias: Outlet End Treatment Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [01: District 1], [02: District 2], [03: District 3], ... 10 more ...)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [01: Del Norte (DN)], [02: Siskiyou (SIS)], [03: Modoc (MOD)], ... 55 more ...)
• Route (type: esriFieldTypeString, alias: Route, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [001: 001], [002: 002], [003: 003], ... 245 more ...)
• PrefixCode (type: esriFieldTypeString, alias: Prefix Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [00: 00 - Left - __ - No Prefix], [01: 01 - Left - R - Realignment], [02: 02 - Left - * - Signalized Intersection], ... 77 more ...)
• Postmile (type: esriFieldTypeDouble, alias: Postmile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MaintStation (type: esriFieldTypeString, alias: Maintenance Station, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0056: 0056 - Crecent City - 641], [0057: 0057 - Eureka/Bracut - 642], [0058: 0058 - Willow Creek - 643], ... 229 more ...)
• DistrictMaintenance (type: esriFieldTypeString, alias: District Responsible for Maintenance, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [01: District 1], [02: District 2], [03: District 3], ... 10 more ...)
• Status (type: esriFieldTypeSmallInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Active], [1: Inactive])
• HealthScore (type: esriFieldTypeSmallInteger, alias: Health Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape1 (type: esriFieldTypeSmallInteger, alias: Shape, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Circular], [2: Box], [3: Elliptical], ... 6 more ...)
• Material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: CSP], [2: RCP], [6: Composite], ... 8 more ...)
• CoatingType (type: esriFieldTypeSmallInteger, alias: Coating Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Asphalt], [7: Concrete], [15: Liner], ... 3 more ...)
• CoatingTypeBottom (type: esriFieldTypeSmallInteger, alias: Coating Type Bottom, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Asphalt], [7: Concrete], [15: Liner], ... 3 more ...)
• Diameter (type: esriFieldTypeDouble, alias: Culvert Diameter (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Width (type: esriFieldTypeDouble, alias: Culvert Width (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height (type: esriFieldTypeDouble, alias: Culvert Height (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ConstructionDate (type: esriFieldTypeDate, alias: Date Constructed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReportLength (type: esriFieldTypeDouble, alias: Reported Culvert Length (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• CalcLength (type: esriFieldTypeDouble, alias: Calculated Culvert Length (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• MeasuredLength (type: esriFieldTypeDouble, alias: Measured Culvert Length (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TravelDirection (type: esriFieldTypeString, alias: Direction of Travel, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NB: Northbound], [SB: Southbound], [EB: Eastbound], ... 2 more ...)
• Side (type: esriFieldTypeSmallInteger, alias: Culvert Side, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: RT], [2: LT], [3: Center], ... 1 more ...)
• Barrel (type: esriFieldTypeSmallInteger, alias: Culvert Barrels, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Orientation (type: esriFieldTypeSmallInteger, alias: Culvert Orientation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Transverse], [2: Longitudinal], [3: Skewed])
• Skew (type: esriFieldTypeSmallInteger, alias: Culvert Skew, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 0], [2: 1 - 22.5], [3: 22.6 - 45.0], ... 1 more ...)
• Slope (type: esriFieldTypeSmallInteger, alias: Slope of Culvert (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sewer (type: esriFieldTypeSmallInteger, alias: Sewer, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• RoadwayType (type: esriFieldTypeSmallInteger, alias: Roadway Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Hwy], [2: Paved Rd], [3: Unpaved Rd], ... 2 more ...)
• LaneCrossings (type: esriFieldTypeSmallInteger, alias: Number of Roadway Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FishPassage (type: esriFieldTypeSmallInteger, alias: Fish Passage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• WildlifePassage (type: esriFieldTypeSmallInteger, alias: Wildlife Passage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• MaxFill (type: esriFieldTypeDouble, alias: Maximum Fill, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MinFill (type: esriFieldTypeDouble, alias: Minimum Fill, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QAQCStatus (type: esriFieldTypeSmallInteger, alias: QAQC Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needs Review], [1: In Progress], [2: Approved], ... 3 more ...)
• SB1Qualify (type: esriFieldTypeSmallInteger, alias: SB1 Qualify, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_activitydate (type: esriFieldTypeDate, alias: Last Date of Activity, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_activitytype (type: esriFieldTypeString, alias: Last Type of Activity Performed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CUL_INSP: General Inspection], [CUL_VID: Video Inspection Only], [CUL_SUPP: Support (QC)], ... 4 more ...)
• last_feasibleaction (type: esriFieldTypeSmallInteger, alias: Last Feasible Action Recommended, SQL Type: sqlTypeOther, nullable: true, editable: true)
• last_inspection (type: esriFieldTypeDate, alias: Last Date of Inspection, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_cleaning (type: esriFieldTypeDate, alias: Last Date of Cleaning, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_repair (type: esriFieldTypeDate, alias: Last Date of Repair, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_comment (type: esriFieldTypeString, alias: Last Comment Provided, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_cipeditor (type: esriFieldTypeString, alias: Last CIP Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_cipeditdate (type: esriFieldTypeDate, alias: Last Date of CIP Edit, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_WWAInsp (type: esriFieldTypeSmallInteger, alias: Last Waterway Adequacy Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [0: No Deficiencies Found], [1: Good], ... 3 more ...)
• last_AlignInsp (type: esriFieldTypeSmallInteger, alias: Last Alignment Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [0: No Deficiencies Found], [1: Good], ... 3 more ...)
• last_JointInsp (type: esriFieldTypeSmallInteger, alias: Last Joint Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [0: No Deficiencies Found], [1: Good], ... 3 more ...)
• last_MtrlInsp (type: esriFieldTypeSmallInteger, alias: Last Material Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [0: No Deficiencies Found], [1: Good], ... 3 more ...)
• last_ShapeInsp (type: esriFieldTypeSmallInteger, alias: Last Geometric Shape Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [0: No Deficiencies Found], [1: Good], ... 3 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConditionOverall (type: esriFieldTypeSmallInteger, alias: Condition Overall, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [0: Poor], [1: Fair], ... 2 more ...)
• ConveyanceType (type: esriFieldTypeSmallInteger, alias: Conveyance Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Culvert], [2: Ditch], [3: Slotted Drain])
• last_RoadInsp (type: esriFieldTypeSmallInteger, alias: Last Roadway Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [0: No Deficiencies Found], [1: Good], ... 3 more ...)
• last_activityID (type: esriFieldTypeString, alias: Last Activity ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INET_latitude (type: esriFieldTypeDouble, alias: Inlet End Treatment Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INET_longitude (type: esriFieldTypeDouble, alias: Inlet End Treatment Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OUTET_latitude (type: esriFieldTypeDouble, alias: Outlet End Treatment Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OUTET_longitude (type: esriFieldTypeDouble, alias: Outlet End Treatment Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PartialInventory (type: esriFieldTypeSmallInteger, alias: Partial Inventory, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• RTL_Date (type: esriFieldTypeDate, alias: RTL Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Award_Date (type: esriFieldTypeDate, alias: Award Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Approval_Date (type: esriFieldTypeDate, alias: Approval Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ECWC_Date (type: esriFieldTypeDate, alias: ECWC Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CCA_Date (type: esriFieldTypeDate, alias: CCA Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReinspectionPriority (type: esriFieldTypeSmallInteger, alias: Reinspection Priority, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Low Priority - 7 Years], [2: Moderate Priority - 5 Years], [3: High Priority - 4 Years], ... 2 more ...)
• CulvertID (type: esriFieldTypeString, alias: Culvert ID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Culvert Line
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MaintStation: -1
• Status: 0
• Shape1: 1
• CoatingType: 17
• CoatingTypeBottom: 17
• Diameter: 0
• Width: 0
• Height: 0
• CalcLength: -1
• MeasuredLength: 0
• Side: 1
• Barrel: 1
• Orientation: 1
• Skew: 1
• Slope: -1
• Sewer: 0
• RoadwayType: 1
• LaneCrossings: -1
• FishPassage: 0
• WildlifePassage: 0
• MaxFill: -1
• MinFill: -1
• QAQCStatus: 0
• last_WWAInsp: -1
• last_AlignInsp: -1
• last_JointInsp: -1
• last_MtrlInsp: -1
• last_ShapeInsp: -1
• PartialInventory: 0

Relationships:

• View Activities (6) -- Related To: ActivityTable (9)
• View Overall Culvert System (1) -- Related To: Culvert System (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/29/2023 6:43:58 PM

Schema Last Edit Date: 9/29/2023 6:42:42 PM

Data Last Edit Date: 9/29/2023 6:43:58 PM

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