Name: Deficiency

Display Field: REGIONNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: -124.214155895
YMin: 38.902196894
XMax: -122.905761944
YMax: 41.5805586930001
Spatial Reference: 4269 (4269)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,86,173,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

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)
• CYCLE (type: esriFieldTypeString, alias: LOS Cycle, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SEGMENTID (type: esriFieldTypeString, alias: Segment ID, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [03: District 3], [04: District 4], [05: District 5], ... 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)
• BEGPM (type: esriFieldTypeDouble, alias: Beg PM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENDPM (type: esriFieldTypeDouble, alias: End PM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZONE (type: esriFieldTypeString, alias: Budget Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Des-1: Des-1], [Des-2: Des-2], [Des-3: Des-3], ... 27 more ...)
• MAINT_DIST (type: esriFieldTypeSmallInteger, alias: Maintenance District, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: District 1], [2: District 2], [3: District 3], ... 10 more ...)
• MAINT_REG (type: esriFieldTypeString, alias: Maintenance Region, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [District 1 - Eureka Region: District 1 - Eureka Region], [District 11 - East Region: District 11 - East Region], [District 11 - West Region: District 11 - West Region], ... 21 more ...)
• SFX (type: esriFieldTypeString, alias: Route Suffix, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PFX (type: esriFieldTypeString, alias: MP Prefix, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DEFICIENCY_ID (type: esriFieldTypeString, alias: Deficiency ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DEFICIENCY_DATE (type: esriFieldTypeDate, alias: Deficiency Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ASSET_FAMILY (type: esriFieldTypeString, alias: Asset Family, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [RW: Roadway Asset (A, B, C, D, M)], [RS: Roadside Asset (E, G)], [EA: Electrical Asset (K)])
• DEFICIENCY_TYPE (type: esriFieldTypeSmallInteger, alias: Type of Deficiency Identified, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: RW - Guardrail Repair], [2: RW - Guardrail End Treatment Repair], [3: RW - Attenuator Repair], ... 11 more ...)
• LEVELOFMAINT (type: esriFieldTypeString, alias: Suggested Level of Maintenance, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [L: Light], [M: Medium], [H: Heavy])
• DEFICIENCY_COMMENTS (type: esriFieldTypeString, alias: Deficiency Comments, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
• WO_STATUS (type: esriFieldTypeString, alias: Work Order Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Open: Open], [Active: Active], [Closed: Closed])
• IMMS_SR (type: esriFieldTypeString, alias: IMMS Service Request Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOS_FIELD_EVALUATOR (type: esriFieldTypeString, alias: LOS Field Evaluator Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [s147472: Minh Chieng (HQ)], [s143251: Miguel A. Gomez (HQ)], [s103348: Adam Steiger (HQ - QA)], ... 24 more ...)
• TRAVEL_DIRECTION (type: esriFieldTypeString, alias: Travel Direction, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NB: Northbound], [SB: Southbound], [EB: Eastbound], ... 2 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)
• REGIONNAME (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [District 1 - Eureka Region: District 1 - Eureka Region], [District 11 - East Region: District 11 - East Region], [District 11 - West Region: District 11 - West Region], ... 21 more ...)
• LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSET_ID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Deficiency
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• WO_STATUS: Open

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/27/2025 5:04:16 PM

Schema Last Edit Date: 6/27/2025 5:04:16 PM

Data Last Edit Date: 6/27/2025 5:04:16 PM

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