Layers:

Layer: POLE_SUPPORTS (3)

Name: POLE_SUPPORTS

Display Field: ContractorName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 961987cc16b3467fbfd2b57fe2cce5dc

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 601518.091
YMin: 4747181.953
XMax: 670408.381
YMax: 4790940.295
Spatial Reference: 0  (0)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [50, 114, 140, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, length: 50 )
• SignalIntersectionID ( type: esriFieldTypeString, alias: Signalized Intersection ID, length: 50 )
• CgID ( type: esriFieldTypeString, alias: Cg ID, length: 50 )
• GeoID ( type: esriFieldTypeString, alias: Geo ID, length: 10 )
• Address ( type: esriFieldTypeString, alias: Address, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 250 , Coded Values: [NBD: NBD] , [EBD: EBD] , [SBD: SBD] , ...7 more... )
• ModelNo ( type: esriFieldTypeString, alias: Model No, length: 50 )
• SerialNo ( type: esriFieldTypeString, alias: Serial No, length: 50 )
• Sign ( type: esriFieldTypeString, alias: Has Sign?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• Light ( type: esriFieldTypeString, alias: Has Light?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• Meter ( type: esriFieldTypeString, alias: Has Meter?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• Power ( type: esriFieldTypeString, alias: Has Power?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• Signal ( type: esriFieldTypeString, alias: Has Signal?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• Type ( type: esriFieldTypeString, alias: Type, length: 50 , Coded Values: [2" Channel: 2" Channel] , [4 x 4: 4 x 4] , [6 x 6: 6 x 6] , ...43 more... )
• Material ( type: esriFieldTypeString, alias: Display Head Material, length: 50 , Coded Values: [Aluminum: Aluminum] , [Aluminum Pole: Aluminum Pole] , [Concrete: Concrete] , ...9 more... )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter (mm) )
• Height ( type: esriFieldTypeDouble, alias: Height )
• Direction ( type: esriFieldTypeString, alias: Direction, length: 50 , Coded Values: [Eastbound: Eastbound] , [Northbound: Northbound] , [Southbound: Southbound] , ...27 more... )
• BaseType ( type: esriFieldTypeString, alias: Base Type, length: 30 , Coded Values: [Concrete: Concrete] , [Post in Concrete: Post in Concrete] , [Type 1: Type 1] , ...8 more... )
• SupportBase ( type: esriFieldTypeString, alias: Support Base, length: 50 , Coded Values: [Base Mount: Base Mount] , [Concrete: Concrete] , [Direct Bury: Direct Bury] , ...9 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 , Coded Values: [Econolite: Econolite] , [Monatek: Monatek] , [Pelco: Pelco] , ...4 more... )
• GuyWire ( type: esriFieldTypeString, alias: Has Guy Wire?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• SetBack ( type: esriFieldTypeDouble, alias: Set Back (m) )
• SignCount ( type: esriFieldTypeSmallInteger, alias: Sign Count )
• PoleTag ( type: esriFieldTypeString, alias: Pole Tag No, length: 50 )
• PlateType ( type: esriFieldTypeString, alias: Plate Type, length: 50 )
• Antenna ( type: esriFieldTypeString, alias: Has Vehicle Pre-Emption Antenna?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• Camera ( type: esriFieldTypeString, alias: Has Camera?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DecorativePole ( type: esriFieldTypeString, alias: Decorative Pole, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DecorativePoleTreatment ( type: esriFieldTypeString, alias: Decorative Pole Treatment, length: 50 , Coded Values: [Black Coated: Black Coated] , [Decorative Skirt: Decorative Skirt] , [Banner Brackets (single): Banner Brackets (single)] , ...5 more... )
• PoleFurniture ( type: esriFieldTypeString, alias: Pole Furniture, length: 50 )
• PowderCoated ( type: esriFieldTypeString, alias: Powder Coated?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• Purpose ( type: esriFieldTypeString, alias: Purpose/Head Class, length: 30 )
• 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... )
• 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 , Coded Values: [Abandoned in Place: Abandoned in Place] , [Active: Active] , [Cut Down: Cut Down] , ...11 more... )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 50 , Coded Values: [Fort Erie: Town of Fort Erie] , [Grimsby: Town of Grimsby] , [Lincoln: Town of Lincoln] , ...24 more... )
• ManagedBy ( type: esriFieldTypeString, alias: Managed By, length: 50 , Coded Values: [Fort Erie: Town of Fort Erie] , [Grimsby: Town of Grimsby] , [Lincoln: Town of Lincoln] , ...24 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 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Relationships:

• TRASigns (0) -- Related To: TRA_SIGNS (80)

Tables:

Table: TRA_SIGNS (80)

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)