Name: Culvert

Display Field: SYSNO

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: -13832807.5416658
YMin: -111325.494192645
XMax: -111317.234404365
YMax: 5161455.62985513
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"fa1409d2539af9ef6889547709470334","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAATklEQVQYlWPxsJQO/fqTwZcBC/j/9/8sFpDkpDSmWAFuVMmHrxkYapf8Y2ABcUCScqKM6PrBJFgBPkAlBSAHwexEdiRYAcgrINdiAyA5AG+lHagCn+DkAAAAAElFTkSuQmCC","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

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)
• 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_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: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• 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 ...)
• 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_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 ...)
• 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_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)

Templates:

Name: Culvert
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• 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
• MaintStation: -1
• last_RoadInsp: -1
• PartialInventory: 0

Relationships:

• View Activities (5) -- Related To: ActivityTable (9)
• View Overall Culvert System (2) -- 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