Name: TRA_SIGNS

Display Field: ContractorName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f86716d49d364788a9184f005d9bb521

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: true
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: false
Supports Query With LOD Spatial Reference: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: TRA_SIGNS
  Description:
  Prototype:
  ModifiedBy: null
  ModifiedDate: null
  AssetID: null
  PoleID: null
  FlasherID: null
  CgID: null
  MidblockID: null
  Address: null
  Location: null
  Location2: null
  Municipality: null
  Manufacturer: null
  ModelNo: null
  SerialNo: null
  Condition: null
  ConditionDate: null
  ConditionScore: null
  PurchaseCost: null
  EstimatedReplacementCost: null
  InspectedBy: null
  InspectedDate: null
  InstallDate: null
  LastMaintainedDate: null
  EstimatedReplacementDate: null
  WarrantyDate: null
  ReliabilityRating: null
  ResidualLife: null
  RevaluationRequired: null
  UnitCost: null
  InspectionYear: null
  ExpectedLife: null
  Criticality: null
  ProbabilityOfFailure: null
  AdjustedProbabilityOfFailure: null
  Risk: null
  LikelihoodOfFailure: null
  ConsequenceOfFailure: null
  EstimatedServiceLife: null
  PercentServiceLifeConsumed: null
  OperationalPerformance: null
  OwnedBy: null
  ConditionRating: null
  BarCode: null
  GraphicImage: null
  Width: null
  Height: null
  MountingHeight: null
  BackingMaterial: null
  SheetMaterial: null
  WineRoute: null
  WineRouteImage: null
  SignDirection: null
  SignPosition: null
  SignCode: null
  OnRoad: null
  AtIntersection: null
  Intersection: null
  SignLighting: null
  MountingHardware: null
  AcquisitionDate: null
  SignImage: null
  ResidualValue: null
  DepreciationMethod: null
  AssetDisposed: null
  ContractorInstalled: null
  ContractorName: null
  Comments: null
  RelatedFiles: null
  LifeCycleStatus: null
  Owner: null
  MaintainedBy: null
  GISEntryStage: null
  CreatedBy: null
  CreateDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata