Name: Traffic Controller

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: [20L: 2070-L] , [20N: 2070-N] , [20V: 2070-V] , ...7 more... )
• Material ( type: esriFieldTypeString, alias: Controller Material, length: 25 , Coded Values: )
• CabinetType ( type: esriFieldTypeString, alias: Cabinet Type, length: 25 , Coded Values: [332: 332] , [334: 334] , [336: 336] , ...5 more... )
• SignalType ( type: esriFieldTypeString, alias: Signal Type, length: 25 , Coded Values: [1: Signal] , [2: Pedestrian] )
• FlasherType ( type: esriFieldTypeString, alias: Flasher Type, length: 25 , Coded Values: [CABC: Activated Flashing Beacon] , [CALED: RRFB] , [PTFB: Pre-Timed Flashing Beacon] , ...4 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 20 , Coded Values: )
• ModelNumber ( type: esriFieldTypeString, alias: Model Number, length: 40 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 40 )
• CalibrationRange ( type: esriFieldTypeString, alias: Calibration Range, length: 30 )
• LSCount ( type: esriFieldTypeSmallInteger, alias: LS Count )
• FlashCount ( type: esriFieldTypeSmallInteger, alias: Flash Count )
• TRCount ( type: esriFieldTypeSmallInteger, alias: TR Count )
• IsolateCount ( type: esriFieldTypeSmallInteger, alias: Isolate Count )
• PowerSource ( type: esriFieldTypeString, alias: Power Source, length: 25 , Coded Values: [1: N/A - City] , [2: Powered Overhead] , [3: Powered Underground] , ...1 more... )
• Voltage ( type: esriFieldTypeString, alias: Voltage, length: 30 , Coded Values: )
• PowerSourceLocation ( type: esriFieldTypeString, alias: Power Source Location, length: 30 )
• FuseType ( type: esriFieldTypeString, alias: Fuse Type, length: 15 )
• PanelLightVoltage ( type: esriFieldTypeString, alias: Panel Light Voltage, length: 30 )
• PanelLightModelNumber ( type: esriFieldTypeString, alias: Panel Light Model Number, length: 30 )
• UPS ( type: esriFieldTypeString, alias: UPS Type, length: 25 , Coded Values: )
• PLC ( type: esriFieldTypeString, alias: PLC, length: 30 )
• RelatedInput ( type: esriFieldTypeString, alias: Related Input, length: 75 )
• RelatedOutput ( type: esriFieldTypeString, alias: Related Output, length: 50 )
• OM ( type: esriFieldTypeString, alias: OM, length: 15 )
• CabinetID ( type: esriFieldTypeString, alias: CabinetID, length: 40 )
• PrimaryRoad ( type: esriFieldTypeString, alias: Main Street, length: 75 )
• SecondaryRoad ( type: esriFieldTypeString, alias: Cross Street, length: 75 )
• TertiaryRoad ( type: esriFieldTypeString, alias: Tertiary Street, length: 75 )
• ComputerName ( type: esriFieldTypeString, alias: Computer Name, length: 30 )
• OpDate ( type: esriFieldTypeDate, alias: Operation Date, length: 8 )
• OpTime ( type: esriFieldTypeString, alias: Operation Time, length: 5 )
• OperatedBy ( type: esriFieldTypeString, alias: Operated By, length: 30 )
• SignalID ( type: esriFieldTypeString, alias: Signal ID, length: 40 )

Relationships:

• trController (7) -- Related To: Traffic Signal Cabinet (153)
• trController (12) -- Related To: Traffic Signal Head (119)

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

  Iteminfo   Thumbnail   Metadata