All Layers and Tables (Caltrans_Job_Hazard_Analysis_Survey_v2

Layers:

Layer: Caltrans_Job_Hazard_Analysis_Survey_v2 (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

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:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

Relationships:

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

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

employees (1)