View In:   ArcGIS Online Map Viewer

Name: Dispatch Assignments (Complete last 30 days)

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

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

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

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [169, 0, 230, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 255, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: true
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: false
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:

Fields:

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

Templates:

• Name: Dispatch Assignments (Complete last 30 days)
  Description:
  Prototype:
  HUB_Name: null
  Asset_Type: null
  Priority: null
  Assigned_To: null
  Requestor: null
  Asset_ID: null
  Engineer_Required: No
  Start_Date: null
  Maintenance_Section: null
  Due_Date: null
  Project_Status: null
  Paused_Date: null
  Canceled_Date: null
  Pause_Reason: null
  Canceled_Reason: null
  Field_Supervisor_Verified: No
  Dispatcher_Verified: No
  Field_Verified: No
  Photos: null
  adCalHUB: null
  Contractor_Email: null
  Maintenance_Zone: null
  ContractorCalk: null
  adCAL: null
  REL_GLOBALID: null
  HCTRAID: null
  Assigned_To_Email: null
  DayOfTheWeek: null
  OnCall: null
  Contractor: null
  S1AssignedTo: null
  S2AssignedTo: null
  Completion_Date: null
  History: null
  Assigned_Date: null
  In_Progress_Date: null
  Creator: null
  Email_List: null
  Other_Requestor: null
  HCTRA_Journal: null
  Contractor_Journal: null
  Cross_Street: null
  Direction: null
  Lane_Location: null
  Roadway: null
  HCTRA_Journal_History: null
  Contractor_Journal_History: null
  Facility_Type: null
  Facility_Assignment: null
  Other_Assignments: null
  Other_Contractor: null
  Location_Description: null
  FEMA_Related: null
  Issues: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata