Layers:

Layer: STC_Daily_Site_Report (0)

Name: STC_Daily_Site_Report

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

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 Daily Site Report
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 )
• log_date_time ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date and Time of Report:, type: esriFieldTypeDate )
• report_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: report_name, type: esriFieldTypeString )
• end_of_week ( nullable: true, editable: true, defaultValue: null, length: 255, alias: end_of_week_Sun_Sat, type: esriFieldTypeString )
• report_short_date ( nullable: true, editable: true, defaultValue: null, length: 255, alias: report_short_date, type: esriFieldTypeString )
• report_day ( nullable: true, editable: true, defaultValue: null, length: 255, alias: report_day, type: esriFieldTypeString )
• temp ( nullable: true, editable: true, defaultValue: null, alias: Temperature, type: esriFieldTypeDouble )
• wind_speed_01 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Wind Speed, type: esriFieldTypeString )
• wind_dir_01 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Wind Direction, type: esriFieldTypeString )
• wind_gusts ( nullable: true, editable: true, defaultValue: null, alias: Wind_gusts, type: esriFieldTypeDouble )
• elevation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Elevation, type: esriFieldTypeString )
• rain ( nullable: true, editable: true, defaultValue: null, alias: Rain, type: esriFieldTypeDouble )
• showers ( nullable: true, editable: true, defaultValue: null, alias: Showers, type: esriFieldTypeDouble )
• snowfall ( nullable: true, editable: true, defaultValue: null, alias: Snowfall, type: esriFieldTypeDouble )
• cloud_cover ( nullable: true, editable: true, defaultValue: null, alias: Cloud_cover, type: esriFieldTypeDouble )
• humidity ( nullable: true, editable: true, defaultValue: null, alias: Humidity, type: esriFieldTypeDouble )
• temp_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Temperature, type: esriFieldTypeString )
• wind_speed_01_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Wind Speed, type: esriFieldTypeString )
• wind_dir_01_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Wind Direction, type: esriFieldTypeString )
• wind_gusts_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Wind_gusts, type: esriFieldTypeString )
• elevation_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Elevation, type: esriFieldTypeString )
• rain_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Rain, type: esriFieldTypeString )
• showers_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Showers, type: esriFieldTypeString )
• snowfall_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Snowfall, type: esriFieldTypeString )
• cloud_cover_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cloud_cover, type: esriFieldTypeString )
• humidity_n ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Humidity, type: esriFieldTypeString )
• sky_condition ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sky_Condition, type: esriFieldTypeString , Coded Values: [clear: ☀️ Clear] , [partly cloudy: ⛅ Partly Cloudy] , [cloudy: ☁️ Cloudy] , ...1 more... )
• work_zones ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work Zones, type: esriFieldTypeString , Coded Values: [Z100: Z100] , [Z200: Z200] , [Z300: Z300] , ...2 more... )
• first_aid_cases_yn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any first aid cases?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• first_aid_cases ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Describe the first aid cases:, type: esriFieldTypeString )
• medical_aid_cases_yn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any medical aid cases?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• medical_aid_cases ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Describe the medical aid cases:, type: esriFieldTypeString )
• lost_time_accidents_yn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any lost time accidents?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• lost_time_accidents ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Describe the lost time accidents:, type: esriFieldTypeString )
• safety_items_yn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any safety items to report?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• safety_items ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Describe the safety items:, type: esriFieldTypeString )
• delays_yn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any delays to report?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• delays_desc ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Describe the delays:, type: esriFieldTypeString )
• other_comments_yn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any additional remarks/comments?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• other_comments ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Comments:, type: esriFieldTypeString )
• supporting_docs_yn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any other supporting documentation?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• review_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Report completed?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• reviewer ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Reviewed by:, type: esriFieldTypeString )
• review_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date signed:, type: esriFieldTypeDate )
• review_date_formatted ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Review date (formatted), type: esriFieldTypeDate )
• 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 )
Templates:
• Name: New Feature
  Description:
  Prototype:
  Drawing Tool: N/A

Relationships:

• STC_Daily_Site_Report_location_work_details (0) -- Related To: location_work_details (1)

Tables:

Table: location_work_details (1)

Name: location_work_details

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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 )
• worklocation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select a location:, type: esriFieldTypeString )
• entered_by ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Details entered by:, type: esriFieldTypeString )
• time_in ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Time In, type: esriFieldTypeString )
• time_out ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Time Out, type: esriFieldTypeString )
• time_in_txt ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Time In Text, type: esriFieldTypeString )
• time_out_txt ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Time Out Text, type: esriFieldTypeString )
• hours_worked ( nullable: true, editable: true, defaultValue: null, alias: Hours Worked:, type: esriFieldTypeDouble )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• 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 )

Relationships:

• STC_Daily_Site_Report_location_work_details (0) -- Related To: STC_Daily_Site_Report (0)
• location_work_details_Details (1) -- Related To: Details (2)

Table: Details (2)

Name: Details

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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 )
• sub ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subcontractor:, type: esriFieldTypeString , Coded Values: [Accuworx: Accuworx] , [Aecon Foundation: Aecon Foundation] , [Aecon Golden Mile (AGM): Aecon Golden Mile (AGM)] , ...68 more... )
• sub_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other., type: esriFieldTypeString )
• sub_collated ( nullable: true, editable: true, defaultValue: null, length: 255, alias: sub_collated, type: esriFieldTypeString )
• total_man_hrs ( nullable: true, editable: true, defaultValue: null, alias: total_man_hrs, type: esriFieldTypeDouble )
• eqpmt_hrs_total ( nullable: true, editable: true, defaultValue: null, alias: eqpmt_hrs_total, type: esriFieldTypeDouble )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• 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 )

Relationships:

• location_work_details_Details (1) -- Related To: location_work_details (1)
• Details_manpower (2) -- Related To: manpower (3)
• Details_eqpmt (3) -- Related To: eqpmt (4)
• Details_materials (4) -- Related To: materials (5)
• Details_activities (5) -- Related To: activities (6)
• Details_delays (6) -- Related To: delays (7)
• Details_env_incidents (7) -- Related To: env_incidents (8)
• Details_safety_incidents (8) -- Related To: safety_incidents (9)

Table: manpower (3)

Name: manpower

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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 )
• crew_role ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Role:, type: esriFieldTypeString , Coded Values: [Foreman: Foreman] , [Labourer: Labourer] , [Operator: Operator] , ...2 more... )
• crew_role_collated ( nullable: true, editable: true, defaultValue: null, length: 255, alias: crew_role_collated, type: esriFieldTypeString )
• crew_num ( nullable: true, editable: true, defaultValue: null, alias: Number of workers:, type: esriFieldTypeInteger )
• crew_hours ( nullable: true, editable: true, defaultValue: null, alias: Hours worked:, type: esriFieldTypeDouble )
• manpower_hrs_calc ( nullable: true, editable: true, defaultValue: null, alias: manpower_hours, type: esriFieldTypeDouble )
• manpower_comments ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Comments:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• 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 )

Relationships:

• Details_manpower (2) -- Related To: Details (2)

Table: eqpmt (4)

Name: eqpmt

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
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: esriServerHTMLPopupTypeNone

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 )
• eqpmt_choose ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Choose a machine from preset list:, type: esriFieldTypeString )
• eqpmt_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Equipment Name or Type:, type: esriFieldTypeString )
• eqpmt_make ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Equipment Make:, type: esriFieldTypeString )
• eqpmt_model ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Equipment Model:, type: esriFieldTypeString )
• eqpmt_year ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Equipment Year:, type: esriFieldTypeString )
• eqpmt_qty ( nullable: true, editable: true, defaultValue: null, alias: Equipment Quantity:, type: esriFieldTypeInteger )
• eqpmt_hrs ( nullable: true, editable: true, defaultValue: null, alias: Equipment Hours:, type: esriFieldTypeDouble )
• eqpmt_hrs_calc ( nullable: true, editable: true, defaultValue: null, alias: eqpmt_hrs_calc, type: esriFieldTypeDouble )
• eqpmt_condition ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Equipment Condition:, type: esriFieldTypeString , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• eqpmt_operator ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Operator included?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• eqpmt_comments ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Comments:, type: esriFieldTypeString )
• eqpmt_breakdown_yn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Any equipment breakdowns?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• eqpmt_breakdown_desc ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Describe the breakdown:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• 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 )

Relationships:

• Details_eqpmt (3) -- Related To: Details (2)

Table: materials (5)

Name: materials

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
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: esriServerHTMLPopupTypeNone

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 )
• material_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Material Type:, type: esriFieldTypeString )
• material_quantity ( nullable: true, editable: true, defaultValue: null, alias: Quantity:, type: esriFieldTypeDouble )
• material_unit ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Unit of measurement:, type: esriFieldTypeString , Coded Values: [meters (m): meters (m)] , [square meters (m²): square meters (m²)] , [cubic meters (m³): cubic meters (m³)] , ...3 more... )
• material_location ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Location:, type: esriFieldTypeString )
• material_comments ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Comments:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• 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 )

Relationships:

• Details_materials (4) -- Related To: Details (2)

Table: activities (6)

Name: activities

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
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: esriServerHTMLPopupTypeNone

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 )
• sub_work ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Summary of work:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• 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 )

Relationships:

• Details_activities (5) -- Related To: Details (2)

Table: delays (7)

Name: delays

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
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: esriServerHTMLPopupTypeNone

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 )
• delay_desc ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Describe the delay:, type: esriFieldTypeString )
• delay_duration ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Duration:, type: esriFieldTypeString )
• delay_impact ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Impact:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• 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 )

Relationships:

• Details_delays (6) -- Related To: Details (2)

Table: env_incidents (8)

Name: env_incidents

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
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: esriServerHTMLPopupTypeNone

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 )
• env_incident_desc ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Describe the incident/concern:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• 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 )

Relationships:

• Details_env_incidents (7) -- Related To: Details (2)

Table: safety_incidents (9)

Name: safety_incidents

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7e067f28579b4e2baa0c07ee76406116

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
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: esriServerHTMLPopupTypeNone

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 )
• safety_incident_desc ( nullable: true, editable: true, defaultValue: null, length: 2500, alias: Describe the incident/concern:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• 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 )

Relationships:

• Details_safety_incidents (8) -- Related To: Details (2)