Name: Traffic Signal Head

Display Field: SurveyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: f9fee8785fd74733b3d6fc793426670a

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID or Asset ID, length: 40 )
• LegacyID ( type: esriFieldTypeString, alias: Legacy ID, length: 40 )
• Address ( type: esriFieldTypeString, alias: Address, length: 130 )
• Location ( type: esriFieldTypeString, alias: Location, length: 250 )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• PurchaseDate ( type: esriFieldTypeDate, alias: Purchase Date, length: 8 )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• AssetCost ( type: esriFieldTypeDouble, alias: Asset Cost )
• Condition ( type: esriFieldTypeDouble, alias: Condition )
• ConditionDate ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, length: 10 , Coded Values: [AB: Abandoned] , [DISP: Disposed] , [IS: In Service] , ...4 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 250 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 7 , Coded Values: [-1: Private] , [-2: Other] , [1: City of Santa Ana] , ...14 more... )
• UsefulLife ( type: esriFieldTypeDouble, alias: Useful Life )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, length: 25 , Coded Values: [-1: Private] , [-2: Other] , [1: City of Santa Ana] , ...14 more... )
• ContractorID ( type: esriFieldTypeString, alias: Contractor Number/Name, length: 25 , Coded Values: )
• ImagePath ( type: esriFieldTypeString, alias: ImagePath, length: 100 )
• SurveyDate ( type: esriFieldTypeDate, alias: Survey Date, length: 8 )
• SurveyName ( type: esriFieldTypeString, alias: Surveyor Name, length: 25 )
• EditDate ( type: esriFieldTypeDate, alias: Date and Time Edit Was Made, length: 8 )
• EditorName ( type: esriFieldTypeString, alias: Name of Editor, length: 25 )
• Source ( type: esriFieldTypeString, alias: Source, length: 25 , Coded Values: [-1: Consultant] , [-2: Other] , [1: City of Santa Ana PWA] , ...2 more... )
• DataSourceType ( type: esriFieldTypeString, alias: Data Source Type, length: 50 , Coded Values: [ASBUILT: As-built Record Plan] , [AUTOCADDRAWING: AutoCAD Drawing] , [ESTIMATED: Estimated Feature Location] , ...16 more... )
• DataSourceReference ( type: esriFieldTypeString, alias: Data Source Reference, length: 250 )
• Type ( type: esriFieldTypeString, alias: Type, length: 25 , Coded Values: [1: Signal] , [2: Pedestrian] )
• Material ( type: esriFieldTypeString, alias: Material, length: 25 , Coded Values: [CONC: Concrete] , [FBLT: Fiberlyte] , [OTH: Other] , ...1 more... )
• Height ( type: esriFieldTypeDouble, alias: Height )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 25 , Coded Values: )
• Phase ( type: esriFieldTypeString, alias: Phase, length: 2 , Coded Values: [C: Current Project] , [F: Future Project] , [T1: Immediate Priority Project] , ...1 more... )
• PowerSource ( type: esriFieldTypeString, alias: Power Source, length: 25 , Coded Values: [1: N/A - City] , [2: Powered Overhead] , [3: Powered Underground] , ...1 more... )
• PowerType ( type: esriFieldTypeString, alias: Power Type, length: 25 , Coded Values: [1: Distribution] , [2: Standalone] , [-99: Unknown] )
• ModelNumber ( type: esriFieldTypeString, alias: Model Number, length: 40 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 40 )
• Orientation ( type: esriFieldTypeString, alias: Orientation, length: 10 , Coded Values: [N: North] , [S: South] , [E: East] , ...7 more... )
• HeadSize ( type: esriFieldTypeDouble, alias: Head Size )
• CabinetType ( type: esriFieldTypeString, alias: Cabinet Type, length: 25 , Coded Values: [332: 332] , [334: 334] , [336: 336] , ...5 more... )
• CabinetSize ( type: esriFieldTypeString, alias: Cabinet Size, length: 14 )
• CabinetLocation ( type: esriFieldTypeString, alias: Cabinet Location, length: 250 )
• CabinetID ( type: esriFieldTypeString, alias: Cabinet ID, length: 40 )
• ControllerType ( type: esriFieldTypeString, alias: Controller Type, length: 25 , Coded Values: [20L: 2070-L] , [20N: 2070-N] , [20V: 2070-V] , ...7 more... )
• CameraType ( type: esriFieldTypeString, alias: Camera Type, length: 25 , Coded Values: [AXQE: Axis Q6035-E] , [HDCM: Cohu Helios 3920 HD] , [IDOM: Cohu Idome 3920 Analog] , ...2 more... )
• SwitchType ( type: esriFieldTypeString, alias: Switch Type, length: 25 , Coded Values: [ED1: EtherWan ED3141] , [ED2: EtherWan ED3175] , [EX1: EtherWan EX71620] , ...8 more... )
• SwitchConfiguration ( type: esriFieldTypeString, alias: Switch, length: 50 )
• Maintenance ( type: esriFieldTypeString, alias: Maintenance, length: 500 )
• MountType ( type: esriFieldTypeString, alias: Mount Type, length: 10 , Coded Values: )
• LampType ( type: esriFieldTypeString, alias: Lamp Type, length: 10 , Coded Values: [1: HIGH PRESSURE SODIUM] , [2: METAL HALIDE] , [0: OTHER] , ...2 more... )
• IndicatorColor ( type: esriFieldTypeString, alias: Indicator Color, length: 25 , Coded Values: [1: Red] , [2: Yellow] , [3: White] , ...5 more... )
• DisplayType ( type: esriFieldTypeString, alias: Display Type (Pedestrian Only), length: 10 )
• DetectionType ( type: esriFieldTypeString, alias: Detection Type, length: 25 , Coded Values: [0: Other] , [1: Pedestrian Push Button] , [2: Video Detection] , ...3 more... )
• FlashingType ( type: esriFieldTypeString, alias: Flashing Type, length: 25 , Coded Values: [CABC: Activated Flashing Beacon] , [CALED: RRFB] , [PTFB: Pre-Timed Flashing Beacon] , ...4 more... )
• LaneNum ( type: esriFieldTypeDouble, alias: Lane Number )
• BackPlate ( type: esriFieldTypeString, alias: BackPlate, length: 10 , Coded Values: [CONC: Concrete] , [FBLT: Fiberlyte] , [OTH: Other] , ...1 more... )
• StructType ( type: esriFieldTypeString, alias: StructType, length: 50 , Coded Values: [1: Sign Pole] , [10: Mastarm] , [2: Signal Pole] , ...7 more... )
• StructHeight ( type: esriFieldTypeDouble, alias: StructHeight )
• StructID ( type: esriFieldTypeString, alias: StructID, length: 20 )
• PrimaryRoad ( type: esriFieldTypeString, alias: Main Street, length: 75 )
• SecondaryRoad ( type: esriFieldTypeString, alias: Cross Street, length: 75 )
• TertiaryRoad ( type: esriFieldTypeString, alias: Tertiary Street, length: 75 )
• DistanceinFeet ( type: esriFieldTypeDouble, alias: Distance in Feet )
• MeasureFrom ( type: esriFieldTypeString, alias: Measure From, length: 50 )
• Rotation ( type: esriFieldTypeDouble, alias: Map Symbol Rotation )
• OpDate ( type: esriFieldTypeDate, alias: Operation Date, length: 8 )
• OpTime ( type: esriFieldTypeString, alias: Operation Time, length: 5 )
• OperatedBy ( type: esriFieldTypeString, alias: Operated By, length: 30 )
• ComputerName ( type: esriFieldTypeString, alias: Computer Name, length: 30 )

Relationships:

• trSignalHead (9) -- Related To: Traffic Signal Conduit (151)
• trSignalHead (12) -- Related To: Traffic Controller (122)
• trSignalHead (13) -- Related To: Traffic Signal MMU (121)

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

  Iteminfo   Thumbnail   Metadata