Layers:

Layer: STC_Daily_Site_Report___SCS (0)

Name: STC_Daily_Site_Report___SCS

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: cc3e5f1058784ef1983e8e39044de534

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 - SCS
Description: Survey Data Locations
Transparency: 0
Labeling Info:
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 )
• report_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Report Date:, type: esriFieldTypeDate )
• concrete_test1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: concrete_test1, type: esriFieldTypeString , Coded Values: [Acceptable: Acceptable] , [Not Acceptable: Not Acceptable] , [N/A: N/A] , ...1 more... )
• concrete_test2 ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: concrete_test2, type: esriFieldTypeString , Coded Values: [Acceptable: Acceptable] , [Not Acceptable: Not Acceptable] , [N/A: N/A] , ...1 more... )
• concrete_comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments:, type: esriFieldTypeString )
• delivered_piles ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Piles delivered:, type: esriFieldTypeString )
• delivered_concrete ( nullable: true, editable: true, defaultValue: null, alias: Quantity of concrete delivered (m³):, type: esriFieldTypeDouble )
• delivered_material_notes ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: Describe the issues:, type: esriFieldTypeString )
• completed_yn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is today's report complete?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• inprogress_pile_summary ( nullable: true, editable: true, defaultValue: null, length: 255, alias: inprogress_pile_summary, type: esriFieldTypeString )
• installed_pile_summary ( nullable: true, editable: true, defaultValue: null, length: 255, alias: installed_pile_summary, type: esriFieldTypeString )
• report_date_string ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Log date string, type: esriFieldTypeString )
• weather_scs_tavg ( nullable: true, editable: true, defaultValue: null, alias: scs avg air temp in °C, type: esriFieldTypeDouble )
• weather_scs_tmin ( nullable: true, editable: true, defaultValue: null, alias: scs min air temp in °C, type: esriFieldTypeDouble )
• weather_scs_tmax ( nullable: true, editable: true, defaultValue: null, alias: scs max air temp in °C, type: esriFieldTypeDouble )
• weather_scs_prcp ( nullable: true, editable: true, defaultValue: null, alias: scs daily precipitation total in mm, type: esriFieldTypeDouble )
• weather_scs_snow ( nullable: true, editable: true, defaultValue: null, alias: scs max snow depth in mm, type: esriFieldTypeDouble )
• weather_scs_wdir ( nullable: true, editable: true, defaultValue: null, alias: scs avg wind direction (from) in degrees (°), type: esriFieldTypeDouble )
• weather_scs_wspd ( nullable: true, editable: true, defaultValue: null, alias: scs avg wind speed in km/h, type: esriFieldTypeDouble )
• weather_scs_wpgt ( nullable: true, editable: true, defaultValue: null, alias: scs peak wind gust in km/h, type: esriFieldTypeDouble )
• weather_scs_pres ( nullable: true, editable: true, defaultValue: null, alias: scs avg sea-level air pressure in hPa, type: esriFieldTypeDouble )
• 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 )
• report_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Report Name, type: esriFieldTypeString )
Templates:
• Name: New Feature
  Description:
  Prototype:
  Drawing Tool: N/A

Relationships:

• STC_Daily_Site_Report___SCS_work_details_per_sub (0) -- Related To: work_details_per_sub (1)
• STC_Daily_Site_Report___SCS_installed_piles (1) -- Related To: installed_piles (5)
• STC_Daily_Site_Report___SCS_inprogress_piles (2) -- Related To: inprogress_piles (6)

Tables:

Table: work_details_per_sub (1)

Name: work_details_per_sub

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cc3e5f1058784ef1983e8e39044de534

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
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 company:, type: esriFieldTypeString , Coded Values: [Aecon Geomatics: Aecon Geomatics] , [Centracon: Centracon] , [CTS: CTS] , ...7 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 company (collated), 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:

• STC_Daily_Site_Report___SCS_work_details_per_sub (0) -- Related To: STC_Daily_Site_Report___SCS (0)
• work_details_per_sub_crew_log (3) -- Related To: crew_log (2)
• work_details_per_sub_equipment_log (4) -- Related To: equipment_log (3)
• work_details_per_sub_work_log (5) -- Related To: work_log (4)

Table: crew_log (2)

Name: crew_log

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cc3e5f1058784ef1983e8e39044de534

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
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_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Crew type:, type: esriFieldTypeString , Coded Values: [Workers: Workers] , [Site Staff: Site Staff] , [Crane: Crane] , ...2 more... )
• crew_type_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other., type: esriFieldTypeString )
• crew_type_collated ( nullable: true, editable: true, defaultValue: null, length: 255, alias: crew type (collated), type: esriFieldTypeString )
• crew_num ( nullable: true, editable: true, defaultValue: null, alias: crew_num, type: esriFieldTypeInteger )
• crew_hours ( nullable: true, editable: true, defaultValue: null, alias: Hours:, type: esriFieldTypeInteger )
• crew_type_hours ( nullable: true, editable: true, defaultValue: null, alias: crew_type_hours, type: esriFieldTypeInteger )
• totalcrewhours ( nullable: true, editable: true, defaultValue: null, alias: totalcrewhours, type: esriFieldTypeInteger )
• note_totalcrewhours ( nullable: true, editable: true, defaultValue: null, length: 255, alias: total hours, type: esriFieldTypeString )
• productivity ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Productivity rating:, type: esriFieldTypeString , Coded Values: [zero: zero] , [low: low] , [medium: medium] , ...1 more... )
• productivity_notes ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: Productivity:, 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:

• work_details_per_sub_crew_log (3) -- Related To: work_details_per_sub (1)

Table: equipment_log (3)

Name: equipment_log

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cc3e5f1058784ef1983e8e39044de534

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
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 )
• equipment_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Equipment type:, type: esriFieldTypeString , Coded Values: [Rig: Rig] , [Crane: Crane] , [Excavator: Excavator] , ...1 more... )
• equipment_type_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other., type: esriFieldTypeString )
• equipment_type_collated ( nullable: true, editable: true, defaultValue: null, length: 255, alias: equipment_type (collated), type: esriFieldTypeString )
• equipment_qty ( nullable: true, editable: true, defaultValue: null, alias: Equipment quantity:, type: esriFieldTypeInteger )
• 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:

• work_details_per_sub_equipment_log (4) -- Related To: work_details_per_sub (1)

Table: work_log (4)

Name: work_log

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cc3e5f1058784ef1983e8e39044de534

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
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 )
• work_area ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work area:, type: esriFieldTypeString , Coded Values: [Main Entrance: Main Entrance] , [Stair: Stair] , [Station Box: Station Box] , ...1 more... )
• work_description ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: Work performed:, 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:

• work_details_per_sub_work_log (5) -- Related To: work_details_per_sub (1)

Table: installed_piles (5)

Name: installed_piles

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cc3e5f1058784ef1983e8e39044de534

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
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 )
• installed_pile ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select a pile:, type: esriFieldTypeString )
• installed_pile_notes ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: Describe the issues:, 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:

• STC_Daily_Site_Report___SCS_installed_piles (1) -- Related To: STC_Daily_Site_Report___SCS (0)

Table: inprogress_piles (6)

Name: inprogress_piles

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cc3e5f1058784ef1983e8e39044de534

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
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 )
• inprogress_pile ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select a pile:, type: esriFieldTypeString )
• inprogress_pile_notes ( nullable: true, editable: true, defaultValue: null, length: 5000, alias: Describe the issues:, 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:

• STC_Daily_Site_Report___SCS_inprogress_piles (2) -- Related To: STC_Daily_Site_Report___SCS (0)