Layers:

Layer: Inspection_Daily_Report (0)

Name: Inspection_Daily_Report

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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: Inspection Daily Report Form
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• today_text ( nullable: true, editable: true, defaultValue: null, length: 255, alias: today_text, type: esriFieldTypeString )
• description ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Complete all Fields - Add remarks to remarks section. One report for each contract or location - separate work forces for general and subcontractor., type: esriFieldTypeString )
• contract ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contract Number, type: esriFieldTypeString )
• pull_contract_details ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: pull_contract_details, type: esriFieldTypeString )
• contract_administrator ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contract Administrator, type: esriFieldTypeString )
• contractor_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contractor, type: esriFieldTypeString )
• add_elements_rowid ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Add_elements_rowid, type: esriFieldTypeString )
• sub_contractor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sub-Contractor, type: esriFieldTypeString )
• inspector_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Inspector Name, type: esriFieldTypeString , Coded Values: [Kevin_Harrison: Kevin Harrison] , [Warren_Kilpatrick: Warren Kilpatrick] )
• inspection_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Inspection Date, type: esriFieldTypeDate )
• select_weather ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Weather, type: esriFieldTypeString )
• weather_observations ( nullable: true, editable: true, defaultValue: null, length: 200, alias: Other weather observations, type: esriFieldTypeString )
• temperature ( nullable: true, editable: true, defaultValue: null, alias: Temperature, type: esriFieldTypeInteger )
• working_days ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Working Days, type: esriFieldTypeString )
• inspector_time_in ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Inspector Time in, type: esriFieldTypeString )
• inspector_time_out ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Inspector Time out, type: esriFieldTypeString )
• granular_test ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Granular Test, type: esriFieldTypeString )
• asphalt_test ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Asphalt Test, type: esriFieldTypeString )
• concrete_test ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Concrete Test, type: esriFieldTypeString )
• sample_completed_by ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Test/Sample Completed By:, type: esriFieldTypeString )
• remarks ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Remarks, type: esriFieldTypeString )
• time_signs_barricades ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Time Signs and Barricades Checked, type: esriFieldTypeString )
• contractor_time_in ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contractor's time in:, type: esriFieldTypeString )
• contractor_time_out ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contractor's time out:, 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 )
• location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Location, type: esriFieldTypeString )
• reset_times ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select Yes to reset all date, time and hour questions, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• x ( nullable: true, editable: true, defaultValue: null, alias: X, type: esriFieldTypeDouble )
• y ( nullable: true, editable: true, defaultValue: null, alias: Y, type: esriFieldTypeDouble )
• recalc_inspector_in ( nullable: true, editable: true, defaultValue: null, length: 255, alias: recalc_inspector_in, type: esriFieldTypeString )
• recalc_inspector_out ( nullable: true, editable: true, defaultValue: null, length: 255, alias: recalc_inspector_out, type: esriFieldTypeString )
• unique_contract_date ( nullable: true, editable: true, defaultValue: null, length: 255, alias: unique_contract_date, type: esriFieldTypeString )
Templates:
• Name: New Feature
  Description:
  Prototype:
  Drawing Tool: N/A

Relationships:

• Inspection_Daily_Report_labour_repeat_begin (0) -- Related To: labour_repeat_begin (1)
• Inspection_Daily_Report_workvisited_repeat_begin (1) -- Related To: workvisited_repeat_begin (2)
• Inspection_Daily_Report_equipment_repeat_begin (2) -- Related To: equipment_repeat_begin (3)
• Inspection_Daily_Report_material_repeat_begin (3) -- Related To: material_repeat_begin (4)
• Inspection_Daily_Report_images_begin_repeat (4) -- Related To: images_begin_repeat (5)

Tables:

Table: labour_repeat_begin (1)

Name: labour_repeat_begin

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

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, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• labourer_number ( nullable: true, editable: true, defaultValue: null, alias: Number, type: esriFieldTypeInteger )
• labourer_duty ( nullable: true, editable: true, defaultValue: null, length: 200, alias: Duty, type: esriFieldTypeString )
• labourer_hours ( nullable: true, editable: true, defaultValue: null, alias: Hours, type: esriFieldTypeInteger )
• total_hours ( nullable: true, editable: true, defaultValue: null, alias: Total Hours, 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 )
• labourer_subcontractor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subcontractors, type: esriFieldTypeString )

Relationships:

• Inspection_Daily_Report_labour_repeat_begin (0) -- Related To: Inspection_Daily_Report (0)

Table: workvisited_repeat_begin (2)

Name: workvisited_repeat_begin

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

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, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• title ( nullable: true, editable: true, defaultValue: null, length: 200, alias: Title, type: esriFieldTypeString )
• name ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Name, type: esriFieldTypeString )
• visited_time_in ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Time in, type: esriFieldTypeString )
• visited_time_out ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Time out, 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:

• Inspection_Daily_Report_workvisited_repeat_begin (1) -- Related To: Inspection_Daily_Report (0)

Table: equipment_repeat_begin (3)

Name: equipment_repeat_begin

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

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, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• unit_number ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Unit Number, type: esriFieldTypeString )
• unit_make ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Make, type: esriFieldTypeString )
• unit_model ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Model, type: esriFieldTypeString )
• equipment_hours ( nullable: true, editable: true, defaultValue: null, alias: Hours, 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:

• Inspection_Daily_Report_equipment_repeat_begin (2) -- Related To: Inspection_Daily_Report (0)

Table: material_repeat_begin (4)

Name: material_repeat_begin

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

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, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• materials_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Material Type, type: esriFieldTypeString )
• materials_other ( nullable: true, editable: true, defaultValue: null, length: 200, alias: Other Material, type: esriFieldTypeString )
• materials_quantity ( nullable: true, editable: true, defaultValue: null, alias: Quantity, type: esriFieldTypeDouble )
• materials_paynonpay ( nullable: true, editable: true, defaultValue: null, alias: Pay or Non Pay Item, 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:

• Inspection_Daily_Report_material_repeat_begin (3) -- Related To: Inspection_Daily_Report (0)

Table: images_begin_repeat (5)

Name: images_begin_repeat

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

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, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• 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 )
• images_caption ( nullable: true, editable: true, defaultValue: null, length: 500, alias: Caption, type: esriFieldTypeString )

Relationships:

• Inspection_Daily_Report_images_begin_repeat (4) -- Related To: Inspection_Daily_Report (0)