Name: TRA_SIGNS

Display Field: ContractorName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 961987cc16b3467fbfd2b57fe2cce5dc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Time Relation: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, length: 50 )
• PoleID ( type: esriFieldTypeString, alias: Pole ID, length: 50 )
• FlasherID ( type: esriFieldTypeString, alias: Flasher ID, length: 50 )
• CgID ( type: esriFieldTypeString, alias: Cg ID, length: 50 )
• MidblockID ( type: esriFieldTypeString, alias: Midblock ID, length: 15 )
• Address ( type: esriFieldTypeString, alias: Address, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 250 )
• Location2 ( type: esriFieldTypeString, alias: Intersection Description, length: 250 )
• Municipality ( type: esriFieldTypeString, alias: Municipality, length: 50 , Coded Values: [Fort Erie: Town of Fort Erie] , [Grimsby: Town of Grimsby] , [Lincoln: Town of Lincoln] , ...24 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• ModelNo ( type: esriFieldTypeString, alias: Model No, length: 50 )
• SerialNo ( type: esriFieldTypeString, alias: Serial No, length: 50 )
• Condition ( type: esriFieldTypeSmallInteger, alias: Condition , Coded Values: [1: Very Good] , [2: Good] , [3: Average] , ...2 more... )
• ConditionDate ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• ConditionScore ( type: esriFieldTypeInteger, alias: Condition Score )
• PurchaseCost ( type: esriFieldTypeDouble, alias: Purchase Cost )
• EstimatedReplacementCost ( type: esriFieldTypeDouble, alias: Estimated Replacement Cost )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, length: 50 )
• InspectedDate ( type: esriFieldTypeDate, alias: Inspected Date, length: 8 )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• LastMaintainedDate ( type: esriFieldTypeDate, alias: Last Maintained Date, length: 8 )
• EstimatedReplacementDate ( type: esriFieldTypeDate, alias: Estimated Replacement Date, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• ReliabilityRating ( type: esriFieldTypeSmallInteger, alias: Reliability Rating , Coded Values: [1: As Specified by Manufacturer] , [3: Rare Breakdown] , [5: Occasional Breakdown but with room for improvement] , ...3 more... )
• ResidualLife ( type: esriFieldTypeDouble, alias: Residual Life )
• RevaluationRequired ( type: esriFieldTypeString, alias: Revaluation Required, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• UnitCost ( type: esriFieldTypeDouble, alias: Unit Cost Per Meter )
• InspectionYear ( type: esriFieldTypeSmallInteger, alias: Inspection Year )
• ExpectedLife ( type: esriFieldTypeSmallInteger, alias: Expected Life )
• Criticality ( type: esriFieldTypeDouble, alias: Criticality )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: Probability Of Failure )
• AdjustedProbabilityOfFailure ( type: esriFieldTypeDouble, alias: Adjusted Probability Of Failure )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• LikelihoodOfFailure ( type: esriFieldTypeSmallInteger, alias: Likelihood Of Failure , Coded Values: [1: Very High] , [2: High] , [3: Neutral] , ...2 more... )
• ConsequenceOfFailure ( type: esriFieldTypeSmallInteger, alias: Consequence Of Failure , Coded Values: [1: As Specified by Manufacturer] , [3: Rare Breakdown] , [5: Occasional Breakdown but with room for improvement] , ...3 more... )
• EstimatedServiceLife ( type: esriFieldTypeSmallInteger, alias: Estimated Service Life (years) )
• PercentServiceLifeConsumed ( type: esriFieldTypeDouble, alias: Percent Service Life Consumed )
• OperationalPerformance ( type: esriFieldTypeSmallInteger, alias: Operational Performance , Coded Values: [1: Negligible attention required] , [3: Exceeds current requirements] , [5: Meets current requirements but with room for improvement] , ...3 more... )
• OwnedBy ( type: esriFieldTypeString, alias: Owned By, length: 15 , Coded Values: [CON: Contractor] , [GM: General Motors] , [MTO: Ministry of Transportation] , ...7 more... )
• ConditionRating ( type: esriFieldTypeSmallInteger, alias: Condition , Coded Values: [1: Very Good] , [2: Good] , [3: Average] , ...2 more... )
• BarCode ( type: esriFieldTypeString, alias: Bar Code, length: 20 )
• GraphicImage ( type: esriFieldTypeString, alias: Graphic Image, length: 254 )
• Width ( type: esriFieldTypeDouble, alias: Width )
• Height ( type: esriFieldTypeDouble, alias: Height )
• MountingHeight ( type: esriFieldTypeDouble, alias: Mounting Height (cm) )
• BackingMaterial ( type: esriFieldTypeString, alias: Backing Material, length: 50 , Coded Values: [Aluminum: Aluminum] , [Coroplast: Coroplast] , [Extruded Aluminum: Extruded Aluminum] , ...4 more... )
• SheetMaterial ( type: esriFieldTypeString, alias: Sheet Material, length: 50 , Coded Values: [Diamond Grade: Diamond Grade] , [Engineering Grade: Engineering Grade] , [High Intensity Grade: High Intensity Grade] , ...3 more... )
• WineRoute ( type: esriFieldTypeString, alias: Wine Route Name, length: 100 )
• WineRouteImage ( type: esriFieldTypeString, alias: Wine Route Photo, length: 254 )
• SignDirection ( type: esriFieldTypeString, alias: Sign Direction, length: 50 , Coded Values: [Eastbound: Eastbound] , [Northbound: Northbound] , [Southbound: Southbound] , ...27 more... )
• SignPosition ( type: esriFieldTypeString, alias: Sign Position, length: 50 , Coded Values: [Median: Median] , [N/E Corner: N/E Corner] , [N/W Corner: N/W Corner] , ...3 more... )
• SignCode ( type: esriFieldTypeString, alias: Sign Code, length: 16 , Coded Values: [$$$: $$$] , [G-41: G-41] , [G-43: G-43] , ...578 more... )
• OnRoad ( type: esriFieldTypeString, alias: On Road?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• AtIntersection ( type: esriFieldTypeString, alias: At Intersection?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• Intersection ( type: esriFieldTypeString, alias: Intersection, length: 6 )
• SignLighting ( type: esriFieldTypeString, alias: Sign Lighting, length: 50 , Coded Values: [Backlit: Backlit] , [Fiber Optics: Fiber Optics] , [Luminescent Panels: Luminescent Panels] , ...4 more... )
• MountingHardware ( type: esriFieldTypeString, alias: Mounting Hardware?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• AcquisitionDate ( type: esriFieldTypeDate, alias: Acquisition Date, length: 8 )
• SignImage ( type: esriFieldTypeString, alias: Sign Image, length: 254 )
• ResidualValue ( type: esriFieldTypeDouble, alias: Residual Value )
• DepreciationMethod ( type: esriFieldTypeString, alias: Depreciation Method, length: 8 , Coded Values: [SL: Straight Line] , [RB: Reduce Balance] , [UB: User Based] )
• AssetDisposed ( type: esriFieldTypeString, alias: Asset Disposed?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ContractorInstalled ( type: esriFieldTypeString, alias: Contractor Installed, length: 50 , Coded Values: [No: No] , [Yes: Yes] )
• ContractorName ( type: esriFieldTypeString, alias: Contractor Name, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 250 )
• RelatedFiles ( type: esriFieldTypeString, alias: Related Files, length: 250 )
• LifeCycleStatus ( type: esriFieldTypeString, alias: Lifecycle Status, length: 50 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 50 , Coded Values: [CON: Contractor] , [GM: General Motors] , [MTO: Ministry of Transportation] , ...7 more... )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, length: 15 , Coded Values: [CON: Contractor] , [GM: General Motors] , [MTO: Ministry of Transportation] , ...7 more... )
• GISEntryStage ( type: esriFieldTypeString, alias: GIS Entry Stage, length: 50 , Coded Values: [Under Review: Under Review] , [In Progress: In Progress] , [Complete: Complete] )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, length: 50 , Coded Values: [AGL: AGL] , [Bilodeau, Vanessa: Bilodeau, Vanessa] , [Brown, Jodie: Brown, Jodie] , ...21 more... )
• CreateDate ( type: esriFieldTypeDate, alias: Create Date, length: 8 )
• ModifiedBy ( type: esriFieldTypeString, alias: Modified By, length: 50 , Coded Values: [AGL: AGL] , [Bilodeau, Vanessa: Bilodeau, Vanessa] , [Brown, Jodie: Brown, Jodie] , ...21 more... )
• ModifiedDate ( type: esriFieldTypeDate, alias: Modified Date, length: 8 )

Relationships:

• PoleSupports (0) -- Related To: POLE_SUPPORTS (3)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata