Name: Caltrans_Job_Hazard_Analysis_Survey_v2

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Caltrans Job Hazard Analysis Survey v2","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• starttime (type: esriFieldTypeDate, alias: Start Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• district (type: esriFieldTypeInteger, alias: Caltrans District, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: District 1], [2: District 2], [3: District 3], ... 10 more ...)
• divisions_programs (type: esriFieldTypeInteger, alias: Caltrans Divisions and Programs, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Administration], [2: Aeronautics], [3: Audits & Investigations], ... 24 more ...)
• crew (type: esriFieldTypeInteger, alias: Caltrans Crew, SQL Type: sqlTypeOther, nullable: true, editable: true)
• supervisorname (type: esriFieldTypeString, alias: Supervisor Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• activity (type: esriFieldTypeString, alias: Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• surveyid (type: esriFieldTypeString, alias: Survey ID, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• tasks_construction_staking (type: esriFieldTypeInteger, alias: Task - Construction Staking, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tasks_topographic_staking (type: esriFieldTypeInteger, alias: Task - Topographic Staking, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tasks_boundary (type: esriFieldTypeInteger, alias: Task - Boundary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tasks_mtls (type: esriFieldTypeInteger, alias: Task - MTLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tasks_suas (type: esriFieldTypeInteger, alias: Task - sUAS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tasks_office (type: esriFieldTypeInteger, alias: Task - Office, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tasks_control (type: esriFieldTypeInteger, alias: Task - Control, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tasks_other (type: esriFieldTypeInteger, alias: Task - Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• count_tasks (type: esriFieldTypeInteger, alias: Number of Tasks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tasks_other_text (type: esriFieldTypeString, alias: Other Task Performed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocDesc (type: esriFieldTypeString, alias: Location Description (optional), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• hazards_moving_equipment (type: esriFieldTypeInteger, alias: Hazard - Moving Equipment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_new_crew (type: esriFieldTypeInteger, alias: Hazard - New Crew, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_pedestrians (type: esriFieldTypeInteger, alias: Hazard - Pedestrians, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_site_conditions (type: esriFieldTypeInteger, alias: Hazard - Site Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_traffic (type: esriFieldTypeInteger, alias: Hazard - Traffic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_uneven_terrain (type: esriFieldTypeInteger, alias: Hazard - Uneven Terrain, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_vegetation (type: esriFieldTypeInteger, alias: Hazard - Vegetation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_water (type: esriFieldTypeInteger, alias: Hazard - Water, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_weather (type: esriFieldTypeInteger, alias: Hazard - Weather, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_wildlife (type: esriFieldTypeInteger, alias: Hazard - Wildlife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_other (type: esriFieldTypeInteger, alias: Hazard - Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• count_hazards (type: esriFieldTypeInteger, alias: Number of Hazards, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hazards_other_text (type: esriFieldTypeString, alias: Other Hazards, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hazardsmitigation (type: esriFieldTypeString, alias: How will the potential hazards be mitigated?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• mitigations (type: esriFieldTypeString, alias: Were any additional mitigations identified?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• mitigations_yes (type: esriFieldTypeString, alias: If Yes, describe below., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• authorize (type: esriFieldTypeString, alias: Did your supervisor authorize the work?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ppe (type: esriFieldTypeString, alias: What PPE do we need to perform today's tasks?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pinch (type: esriFieldTypeString, alias: What are the specific pinch points that a Caltrans employee may encounter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• conditions (type: esriFieldTypeString, alias: Have any conditions changed since we last worked in this area?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• conditions_yes (type: esriFieldTypeString, alias: If Yes, describe below., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• cms (type: esriFieldTypeString, alias: Will a worker safety message be used on a CMS?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• cms_no (type: esriFieldTypeString, alias: If No, why not?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• newemployee (type: esriFieldTypeString, alias: Is there a new employee(s) who will need support/mentoring?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• highheat (type: esriFieldTypeString, alias: Did crew review high heat procedures?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• currenttemp (type: esriFieldTypeInteger, alias: What is the current temperature? (F), SQL Type: sqlTypeOther, nullable: true, editable: true)
• drinkwater (type: esriFieldTypeString, alias: Have employees been encouraged to drink plenty of water?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• cooldown (type: esriFieldTypeString, alias: Have employees been reminded of their right to take a cool down rest when necessary and how to replenish water?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• sds (type: esriFieldTypeString, alias: Do we need to review a SDS to proceed with this task?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• digticket (type: esriFieldTypeString, alias: Do we have a current USA Dig ticket and has site been reviewed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• digticketnumber (type: esriFieldTypeString, alias: If Yes, record ticket number., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• coordination (type: esriFieldTypeString, alias: Does this task require special coordination with other crews?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• airquality (type: esriFieldTypeString, alias: Do we need to monitor air quality?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• specialpermits (type: esriFieldTypeString, alias: Does this task require any special permits or CSOP review?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• specialpermits_yes (type: esriFieldTypeString, alias: If Yes, please indicate which one., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• emp_count (type: esriFieldTypeInteger, alias: emp_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• emp_tracked (type: esriFieldTypeString, alias: emp_tracked, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• damage (type: esriFieldTypeString, alias: Any Caltrans equipment/property damage reported?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• damage_yes (type: esriFieldTypeString, alias: If Yes, describe below., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• printname (type: esriFieldTypeString, alias: Print Name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Survey Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [pending: Under Review], [complete: Supervisor Verified])
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• Caltrans_Job_Hazard_Analysis_Survey_v2_employees (1) -- Related To: employees (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/15/2021 5:28:53 PM

Schema Last Edit Date: 4/15/2021 5:28:53 PM

Data Last Edit Date: 4/15/2021 5:28:53 PM

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