Name: Dispatch Assignments (All)

Display Field: Asset_Type

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN><SPAN>Created in 2023. This feature class contains detailed information about maintenance assignments. This data is populated when the HCTRA Dispatch Assignments Survey (Survey123) is filled out.</SPAN></SPAN></P></DIV></DIV></DIV>

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 3019691.309879467
YMin: 1.3781537836372554E7
XMax: 8319411.890207142
YMax: 1.8309590428871304E7
Spatial Reference: 102740  (2278)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Project_Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: Assigned
  Label: Assigned
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Canceled
  Label: Canceled
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Completed
  Label: Completed
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [156, 156, 156, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: In Progress
  Label: In Progress
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [76, 230, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Needs Verified
  Label: Needs Verified
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 112, 255, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Paused
  Label: Paused
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• HCTRAID ( type: esriFieldTypeString, alias: HCTRA ID, length: 20 )
• Asset_Type ( type: esriFieldTypeString, alias: Asset_Type, length: 30 , Coded Values: [Bridges: Bridges] , [Facilities: Facilities] , [Ferry: Ferry] , ...9 more... )
• Priority ( type: esriFieldTypeString, alias: Priority, length: 5 , Coded Values: [P1: P1] , [P2: P2] , [P3: P3] )
• Assigned_To ( type: esriFieldTypeString, alias: Assigned_To, length: 500 , Coded Values: [Dan Martinez: Dan Martinez] , [Darius Jones: Darius Jones] , [Donald Niver: Donald Niver] , ...25 more... )
• Requestor ( type: esriFieldTypeString, alias: Requestor, length: 50 , Coded Values: [Public: Public] , [IMS: IMS] , [RJA: RJA] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset ID, length: 20 )
• Engineer_Required ( type: esriFieldTypeString, alias: Engineer Required, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Start_Date ( type: esriFieldTypeDate, alias: Start Date, length: 8 )
• Maintenance_Section ( type: esriFieldTypeDouble, alias: Maintenance Section , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...5 more... )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 255 , Coded Values: [Sandra Murphy: Sandra Murphy] , [Tischelle Williams: Tischelle Williams] , [Rivers Peterson: Rivers Peterson] , ...23 more... )
• Due_Date ( type: esriFieldTypeDate, alias: Due Date, length: 8 )
• Project_Status ( type: esriFieldTypeString, alias: Project Status, length: 20 , Coded Values: [In Progress: In Progress] , [Paused: Paused] , [Completed: Completed] , ...3 more... )
• Paused_Date ( type: esriFieldTypeDate, alias: Paused Date, length: 8 )
• Canceled_Date ( type: esriFieldTypeDate, alias: Canceled Date, length: 8 )
• Pause_Reason ( type: esriFieldTypeString, alias: Pause Reason, length: 200 )
• Canceled_Reason ( type: esriFieldTypeString, alias: Canceled Reason, length: 200 )
• Field_Supervisor_Verified ( type: esriFieldTypeString, alias: Field Supervisor Verified, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• Dispatcher_Verified ( type: esriFieldTypeString, alias: Dispatcher Verified, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• Field_Verified ( type: esriFieldTypeString, alias: Field Verified, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Photos ( type: esriFieldTypeInteger, alias: Photos )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Assigned_To_Email ( type: esriFieldTypeString, alias: Assigned To Email, length: 500 )
• DayOfTheWeek ( type: esriFieldTypeString, alias: Day of the Week, length: 3 )
• OnCall ( type: esriFieldTypeString, alias: On Call, length: 255 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 255 , Coded Values: [Roy_Jorgenson: Roy Jorgensen] , [Ferrovial: Ferrovial] )
• S1AssignedTo ( type: esriFieldTypeString, alias: RJA Assigned To, length: 255 )
• S2AssignedTo ( type: esriFieldTypeString, alias: Webber Assigned To, length: 255 )
• Completion_Date ( type: esriFieldTypeDate, alias: Completion Date, length: 8 )
• History ( type: esriFieldTypeString, alias: History, length: 1000 )
• Assigned_Date ( type: esriFieldTypeDate, alias: Assigned Date, length: 8 )
• In_Progress_Date ( type: esriFieldTypeDate, alias: In Progress Date, length: 8 )
• Email_List ( type: esriFieldTypeString, alias: Email_List, length: 1000 )
• Other_Requestor ( type: esriFieldTypeString, alias: Other Requestor, length: 255 )
• HCTRA_Journal ( type: esriFieldTypeString, alias: HCTRA Journal, length: 1073741822 )
• Contractor_Journal ( type: esriFieldTypeString, alias: Contractor, length: 1073741822 )
• Cross_Street ( type: esriFieldTypeString, alias: Cross Street, length: 255 )
• Direction ( type: esriFieldTypeString, alias: Direction, length: 255 )
• Lane_Location ( type: esriFieldTypeString, alias: Lane Location, length: 255 )
• Roadway ( type: esriFieldTypeString, alias: Roadway, length: 255 )
• HCTRA_Journal_History ( type: esriFieldTypeString, alias: HCTRA Journal History, length: 1073741822 )
• Contractor_Journal_History ( type: esriFieldTypeString, alias: Contractory Journal History, length: 1073741822 )
• Facility_Type ( type: esriFieldTypeString, alias: Facility Type, length: 255 )
• Facility_Assignment ( type: esriFieldTypeString, alias: Facility Assignment, length: 255 )
• Other_Assignments ( type: esriFieldTypeString, alias: Other Assignments, length: 255 )
• Other_Contractor ( type: esriFieldTypeString, alias: Other Contractor, length: 255 )
• Location_Description ( type: esriFieldTypeString, alias: Location Description, length: 255 )
• FEMA_Related ( type: esriFieldTypeString, alias: FEMA_Related, length: 10 )
• Issues ( type: esriFieldTypeString, alias: Issues, length: 255 , Coded Values: [ADA Compliance: ADA Compliance] , [Clean: Clean] , [Climate Control: Climate Control] , ...31 more... )
• adCAL ( type: esriFieldTypeString, alias: adCAL, length: 255 )
• ContractorCalk ( type: esriFieldTypeString, alias: ContractorCalk, length: 255 )
• Maintenance_Zone ( type: esriFieldTypeString, alias: Maintenance Zone, length: 255 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• Contractor_Email ( type: esriFieldTypeString, alias: Contractor Email, length: 255 )
• HUB_Name ( type: esriFieldTypeString, alias: HUB_Name, length: 255 )
• adCalHUB ( type: esriFieldTypeString, alias: adCalHUB, length: 255 )

Relationships:

• SDE.HCTRAMaintenanceJournal (6) -- Related To: HCTRAMaintenanceContractorJourn (7)
• SDE.HCTRAMaintenanceJournal (7) -- Related To: HCTRAMaintenanceJournal (8)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata