Layers:

Layer: Form_28 (0)

Name: Form_28

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326



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: Form 28
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, 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 )
• job_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Job Type, type: esriFieldTypeString , Coded Values: [ENI Brownfield_: ENI Brownfield] , [NP: NP] , [MDU: MDU] , ...6 more... )
• network ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Network#, type: esriFieldTypeString )
• _network_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Network # Type, type: esriFieldTypeString , Coded Values: [UC: UC] , [UCX: UCX] , [LINE: LINE] , ...1 more... )
• exchange ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Exchange, type: esriFieldTypeString )
• completion_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Completion Date, type: esriFieldTypeDate )
• job_completion ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Job Completion, type: esriFieldTypeString , Coded Values: [Final: Final] , [Partial: Partial] )
• road_block_code ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Road Block Code, type: esriFieldTypeString )
• pitleftopen ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Pit Left Open?, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• backfillleftonsite ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Back Fill Left On Site, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• open_pit_dates ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Open Pit Dates, type: esriFieldTypeDate )
• closed_pit_dates ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Closed Pit Dates, type: esriFieldTypeDate )
• addresspitlocation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Address of Pit Location, type: esriFieldTypeString )
• dimentionpit ( nullable: true, editable: true, defaultValue: null, alias: Dimention Pit, type: esriFieldTypeDouble )
• comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• clean_up ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Clean Up, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• hard_surface_cut ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Hard Surface Cut, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• commentspage1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• aecon_foreman ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Aecon Foreman, type: esriFieldTypeString )
• bill_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BILL NO, type: esriFieldTypeString )
• hsr_sheet ( nullable: true, editable: true, defaultValue: null, length: 255, alias: HSR SHEET, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• date_received ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: DATE RECEIVED, type: esriFieldTypeDate )
• po ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PO#, type: esriFieldTypeString )
• cag ( nullable: true, editable: true, defaultValue: null, length: 255, alias: CAG, type: esriFieldTypeString )
• inspector ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Inspector, type: esriFieldTypeString )
• network2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Network#, type: esriFieldTypeString )
• plan_ ( nullable: true, editable: true, defaultValue: null, alias: Plan #, type: esriFieldTypeDouble )
• sc ( nullable: true, editable: true, defaultValue: null, length: 255, alias: S.C., type: esriFieldTypeString )
• work_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work Location, type: esriFieldTypeString )
• contractor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contractor, type: esriFieldTypeString )
• _date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date, type: esriFieldTypeDate )
• comment1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Note, type: esriFieldTypeString )
• comment2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Note, type: esriFieldTypeString )
• additionalwork_billed ( nullable: true, editable: true, defaultValue: null, length: 255, alias: ADDITIONAL WORK TO BE BILLED AT, type: esriFieldTypeString , Coded Values: [UNIT COST: UNIT COST] , [COST PLUS: COST PLUS] )
• bellform ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Bell form 1441 is needed?, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Type, type: esriFieldTypeString )
• inspected ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Inspected, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• inspectorname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Inspector's Name, type: esriFieldTypeString )
• man_equip ( nullable: true, editable: true, defaultValue: null, alias: MAN & EQUIPMENT, type: esriFieldTypeDouble )
• reason ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Reason, type: esriFieldTypeString )
• additonalwork ( nullable: true, editable: true, defaultValue: null, length: 255, alias: ADDITIONAL WORK TO BE BILLED AT, type: esriFieldTypeString , Coded Values: [UNIT COST: UNIT COST] , [COST PLUS: COST PLUS] )
• is_this_requirement ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is this requirement based on orginal scope of work ?, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• vendor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Vendor, type: esriFieldTypeString )
• clli ( nullable: true, editable: true, defaultValue: null, length: 255, alias: CLLI, type: esriFieldTypeString )
• echange1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Exchange, type: esriFieldTypeString )
• note ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Note, type: esriFieldTypeString )
• is_restoration_required ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is Restoration Required?, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• mc_permit ( nullable: true, editable: true, defaultValue: null, alias: MC Permit #, type: esriFieldTypeDouble )
• as_built_submitted ( nullable: true, editable: true, defaultValue: null, length: 255, alias: As Built Submitted, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• hard_surface_cut_bell ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Hard Surface Cut, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• soft_surface_cut_bell ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Soft Surface Cut, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• keyhole ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Keyhole, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
• foreman_bell ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Foreman, type: esriFieldTypeString )
• date_bell ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date, type: esriFieldTypeDate )
• date_1 ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date, type: esriFieldTypeDate )
• company ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Company, type: esriFieldTypeString )
• contract ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contract, type: esriFieldTypeString )
• customer_contact ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Customer Contact, type: esriFieldTypeString )
• area_zone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Area/ Zone, type: esriFieldTypeString )
• type1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Type, type: esriFieldTypeString , Coded Values: [Metro: Metro] , [Regional Road: Regional Road] )
• address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
• phone_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Phone Number, type: esriFieldTypeString )
• city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: City, type: esriFieldTypeString )
• work_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work Type, type: esriFieldTypeString )
• restoration_requirements ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Restoration Requirements, type: esriFieldTypeString , Coded Values: [Winter Work Restoration: Winter Work Restoration] , [Regular Cleanup: Regular Cleanup] , [Cost Plus: Cost Plus] )
• materialtype ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Type, type: esriFieldTypeString , Coded Values: [asphalt: Asphalt] , [concrete: Concrete] , [sod_topsoil: Sod/Topsoil] , ...2 more... )
• 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:

• Form_28_sku (0) -- Related To: sku (1)
• Form_28_restorationtype (1) -- Related To: restorationtype (2)

Tables:

Table: sku (1)

Name: sku

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• skucategory ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SKU Type, type: esriFieldTypeString , Coded Values: [place strand _ cable _ wire: Place Strand / Cable / Wire] , [move_cable: Move Cable] , [remove strand_cable_wire: Remove Strand / Cable / Wire] , ...14 more... )
• short_description ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SKU short Description, type: esriFieldTypeString )
• sku_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SKU Number, type: esriFieldTypeString )
• sku_description ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SKU description, type: esriFieldTypeString )
• unit ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Unit#, type: esriFieldTypeString )
• changed_quantity ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Changed Quantity, type: esriFieldTypeString )
• plan_no ( nullable: true, editable: true, defaultValue: null, alias: Plan no, type: esriFieldTypeDouble )
• arbno ( nullable: true, editable: true, defaultValue: null, alias: ARB no, type: esriFieldTypeDouble )
• comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• completiondate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Completion Date, type: esriFieldTypeDate )
• 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:

• Form_28_sku (0) -- Related To: Form_28 (0)

Table: restorationtype (2)

Name: restorationtype

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• cutest ( nullable: true, editable: true, defaultValue: null, alias: No of Cuts (Est), type: esriFieldTypeDouble )
• cutact ( nullable: true, editable: true, defaultValue: null, alias: No of Cuts (Act), type: esriFieldTypeDouble )
• cutsizeest ( nullable: true, editable: true, defaultValue: null, alias: Cut Sizes to be Restored (Est), type: esriFieldTypeDouble )
• cutsizeact ( nullable: true, editable: true, defaultValue: null, alias: Cut Sizes to be Restored (Act), type: esriFieldTypeDouble )
• datecomp ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Completed, type: esriFieldTypeDate )
• foreman_restor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Foreman Completed the 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:

• Form_28_restorationtype (1) -- Related To: Form_28 (0)