View In:   ArcGIS Online Map Viewer

Name: STC_Safety_Subcontractor_Form_Management

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 21f7962903b0472fb444884dcdba9a61

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -180.0
YMin: -90.0
XMax: 180.0
YMax: 90.0
Spatial Reference: 4326  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 0, 255] Width: 1
Label: STC Safety Subcontractor Form Management
Description: Survey Data Locations
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: false
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: true
Supports Query With LOD Spatial Reference: true
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:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• stcsub ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Your company:, type: esriFieldTypeString , Coded Values: [Aecon Utilities: Aecon Utilities] , [Aecon Foundations: Aecon Foundations] , [Aecon Geomatics: Aecon Geomatics] , ...17 more... )
• stcsub_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other., type: esriFieldTypeString )
• stcsub_collated ( nullable: true, editable: true, defaultValue: null, length: 255, alias: stcsub (collated), type: esriFieldTypeString )
• location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Work Location:, type: esriFieldTypeString , Coded Values: [EEB1: EEB1] , [EEB2: EEB2] , [EEB3: EEB3] , ...12 more... )
• sublocation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work sub-location (if applicable):, type: esriFieldTypeString )
• location_collated ( nullable: true, editable: true, defaultValue: null, length: 255, alias: location(collated), type: esriFieldTypeString )
• stcsub_man_hours ( nullable: true, editable: true, defaultValue: null, alias: Total no. of crew hours:, type: esriFieldTypeDouble )
• sky_condition ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sky condition:, type: esriFieldTypeString , Coded Values: [sunny: ☀️ Sunny] , [partly_cloudy: ⛅️ Cloudy] , [rainy: 🌧 Rainy] , ...2 more... )
• temp ( nullable: true, editable: true, defaultValue: null, alias: Temperature:, type: esriFieldTypeInteger )
• wind_speed ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Wind speed:, type: esriFieldTypeString , Coded Values: [calm: Calm (0-1 km/h)] , [light: Light (1-25 km/h)] , [moderate: Moderate (25-40 km/h)] , ...2 more... )
• safety_event ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any safety events?, type: esriFieldTypeString , Coded Values: [Accident: Accident] , [Incident: Incident] , [Near Miss: Near Miss] , ...2 more... )
• safety_event_description ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: safety_event_description, type: esriFieldTypeString )
• safety_event_stc_contact ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Who did you contact from STC?, type: esriFieldTypeString )
• enviro_event ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any environmental spills during the work?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• enviro_spill_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Spill type:, type: esriFieldTypeString , Coded Values: [Level 1 (Less than 25 L) Non-reportable: Level 1 (Less than 25 L) Non-reportable] , [Level 2 (25 L - 100 L) Non-reportable: Level 2 (25 L - 100 L) Non-reportable] , [Level 3 (Over 100 L/X/sewer/water) Reportable: Level 3 (Over 100 L/X/sewer/water) Reportable] )
• enviro_event_stc_contact ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Who did you contact from STC?, type: esriFieldTypeString )
• report_submitter_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Your name:, type: esriFieldTypeString )
• log_date_time ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date and Time, type: esriFieldTypeDate )
• report_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Report Name, type: esriFieldTypeString )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• stcsub_jarr_count ( nullable: true, editable: true, defaultValue: null, alias: Number of JARR cards:, type: esriFieldTypeInteger )
• stcsub_jarr_card_count ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Number of JARR cards:, type: esriFieldTypeString , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...3 more... )
• stcsub_jarr_card_count1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: stcsub_jarr_card_count1, type: esriFieldTypeString )
• stcsub_jarr_card_int ( nullable: true, editable: true, defaultValue: null, alias: stcsub_jarr_card_int, type: esriFieldTypeInteger )
• stcsub_count_hstrainings ( nullable: true, editable: true, defaultValue: null, alias: stcsub_count_hstrainings, type: esriFieldTypeInteger )
• stcsub_count_wsmeetings ( nullable: true, editable: true, defaultValue: null, alias: stcsub_count_wsmeetings, type: esriFieldTypeInteger )
• stcsub_count_toolboxtalks ( nullable: true, editable: true, defaultValue: null, alias: stcsub_count_toolboxtalks, type: esriFieldTypeInteger )
• stcsub_count_jhsmeetings ( nullable: true, editable: true, defaultValue: null, alias: stcsub_count_jhsmeetings, type: esriFieldTypeInteger )
• stcsub_count_wpinspections ( nullable: true, editable: true, defaultValue: null, alias: stcsub_count_wpinspections, type: esriFieldTypeInteger )
• stcsub_count_jhas ( nullable: true, editable: true, defaultValue: null, alias: stcsub_count_jhas, type: esriFieldTypeInteger )
• count_accidents ( nullable: true, editable: true, defaultValue: null, alias: count of accidents, type: esriFieldTypeInteger )
• count_incidents ( nullable: true, editable: true, defaultValue: null, alias: count of incidents, type: esriFieldTypeInteger )
• count_nearmiss ( nullable: true, editable: true, defaultValue: null, alias: count of near misses, type: esriFieldTypeInteger )
• count_safetyopportunity ( nullable: true, editable: true, defaultValue: null, alias: count of safety opportunities, type: esriFieldTypeInteger )
• total_count_hstrainings ( nullable: true, editable: true, defaultValue: null, alias: total_count_hstrainings, type: esriFieldTypeInteger )
• total_count_wsmeetings ( nullable: true, editable: true, defaultValue: null, alias: total_count_wsmeetings, type: esriFieldTypeInteger )
• total_count_toolboxtalks ( nullable: true, editable: true, defaultValue: null, alias: total_count_toolboxtalks, type: esriFieldTypeInteger )
• total_count_jhsmeetings ( nullable: true, editable: true, defaultValue: null, alias: total_count_jhsmeetings, type: esriFieldTypeInteger )
• total_count_wpinspections ( nullable: true, editable: true, defaultValue: null, alias: total_count_wpinspections, type: esriFieldTypeInteger )
• total_count_jhas ( nullable: true, editable: true, defaultValue: null, alias: total_count_jhas, type: esriFieldTypeInteger )
• total_count_jarr ( nullable: true, editable: true, defaultValue: null, alias: total_count_jarr, type: esriFieldTypeInteger )
• stcsub_crew_breakdown ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: Crew Breakdown:, type: esriFieldTypeString )
• stcsub_work ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: Details of work performed:, type: esriFieldTypeString )
• stcsub_equipment ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: Equipment used during the work:, type: esriFieldTypeString )

Templates:

• Name: New Feature
  Description:
  Prototype:
  Drawing Tool: N/A

Relationships:

• STC_Safety_Subcontractor_Form_Management_stcsub_docs (0) -- Related To: stcsub_docs (1)
• STC_Safety_Subcontractor_Form_Management_subcon_work_details (1) -- Related To: subcon_work_details (2)
• STC_Safety_Subcontractor_Form_Management_incident_log (2) -- Related To: incident_log (4)

Capabilities: Create,Editing,Sync,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

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

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Apply Edits   Add Features   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata