Name: Traffic Controller

Display Field: SurveyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: de73effa61484703b7120fe733135131

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

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: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID or Asset ID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: FacilityID )
• LegacyID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LegacyID )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 130, defaultValue: null, modelName: Address )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• PurchaseDate ( type: esriFieldTypeDate, alias: Purchase Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PurchaseDate )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• AssetCost ( type: esriFieldTypeDouble, alias: Asset Cost, editable: true, nullable: true, defaultValue: null, modelName: AssetCost )
• Condition ( type: esriFieldTypeDouble, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: Condition )
• ConditionDate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConditionDate )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LifecycleStatus , Coded Values: [AB: Abandoned] , [DISP: Disposed] , [IS: In Service] , ...4 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Owner , Coded Values: [-1: Private] , [-2: Other] , [1: City of Santa Ana] , ...14 more... )
• UsefulLife ( type: esriFieldTypeDouble, alias: Useful Life, editable: true, nullable: true, defaultValue: null, modelName: UsefulLife )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaintainedBy , Coded Values: [-1: Private] , [-2: Other] , [1: City of Santa Ana] , ...14 more... )
• ContractorID ( type: esriFieldTypeString, alias: Contractor Number/Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ContractorID , Coded Values: )
• ImagePath ( type: esriFieldTypeString, alias: ImagePath, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ImagePath )
• SurveyDate ( type: esriFieldTypeDate, alias: Survey Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SurveyDate )
• SurveyName ( type: esriFieldTypeString, alias: Surveyor Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SurveyName )
• EditDate ( type: esriFieldTypeDate, alias: Date and Time Edit Was Made, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• EditorName ( type: esriFieldTypeString, alias: Name of Editor, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EditorName )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Source , Coded Values: [-1: Consultant] , [-2: Other] , [1: City of Santa Ana PWA] , ...2 more... )
• DataSourceType ( type: esriFieldTypeString, alias: Data Source Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DataSourceType , Coded Values: [ASBUILT: As-built Record Plan] , [AUTOCADDRAWING: AutoCAD Drawing] , [ESTIMATED: Estimated Feature Location] , ...16 more... )
• DataSourceReference ( type: esriFieldTypeString, alias: Data Source Reference, editable: true, nullable: true, length: 250, defaultValue: null, modelName: DataSourceReference )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Type , Coded Values: [20L: 2070-L] , [20N: 2070-N] , [20V: 2070-V] , ...7 more... )
• Material ( type: esriFieldTypeString, alias: Controller Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Material , Coded Values: )
• CabinetType ( type: esriFieldTypeString, alias: Cabinet Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CabinetType , Coded Values: [332: 332] , [334: 334] , [336: 336] , ...5 more... )
• SignalType ( type: esriFieldTypeString, alias: Signal Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SignalType , Coded Values: [1: Signal] , [2: Pedestrian] )
• FlasherType ( type: esriFieldTypeString, alias: Flasher Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FlasherType , Coded Values: [CABC: Activated Flashing Beacon] , [CALED: RRFB] , [PTFB: Pre-Timed Flashing Beacon] , ...4 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Manufacturer , Coded Values: )
• ModelNumber ( type: esriFieldTypeString, alias: Model Number, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ModelNumber )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SerialNumber )
• CalibrationRange ( type: esriFieldTypeString, alias: Calibration Range, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CalibrationRange )
• LSCount ( type: esriFieldTypeSmallInteger, alias: LS Count, editable: true, nullable: true, defaultValue: null, modelName: LSCount )
• FlashCount ( type: esriFieldTypeSmallInteger, alias: Flash Count, editable: true, nullable: true, defaultValue: null, modelName: FlashCount )
• TRCount ( type: esriFieldTypeSmallInteger, alias: TR Count, editable: true, nullable: true, defaultValue: null, modelName: TRCount )
• IsolateCount ( type: esriFieldTypeSmallInteger, alias: Isolate Count, editable: true, nullable: true, defaultValue: null, modelName: IsolateCount )
• PowerSource ( type: esriFieldTypeString, alias: Power Source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PowerSource , Coded Values: [1: N/A - City] , [2: Powered Overhead] , [3: Powered Underground] , ...1 more... )
• Voltage ( type: esriFieldTypeString, alias: Voltage, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Voltage , Coded Values: )
• PowerSourceLocation ( type: esriFieldTypeString, alias: Power Source Location, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PowerSourceLocation )
• FuseType ( type: esriFieldTypeString, alias: Fuse Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FuseType )
• PanelLightVoltage ( type: esriFieldTypeString, alias: Panel Light Voltage, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PanelLightVoltage )
• PanelLightModelNumber ( type: esriFieldTypeString, alias: Panel Light Model Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PanelLightModelNumber )
• UPS ( type: esriFieldTypeString, alias: UPS Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UPS , Coded Values: )
• PLC ( type: esriFieldTypeString, alias: PLC, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PLC )
• RelatedInput ( type: esriFieldTypeString, alias: Related Input, editable: true, nullable: true, length: 75, defaultValue: null, modelName: RelatedInput )
• RelatedOutput ( type: esriFieldTypeString, alias: Related Output, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RelatedOutput )
• OM ( type: esriFieldTypeString, alias: OM, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OM )
• CabinetID ( type: esriFieldTypeString, alias: CabinetID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CabinetID )
• PrimaryRoad ( type: esriFieldTypeString, alias: Main Street, editable: true, nullable: true, length: 75, defaultValue: null, modelName: PrimaryRoad )
• SecondaryRoad ( type: esriFieldTypeString, alias: Cross Street, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SecondaryRoad )
• TertiaryRoad ( type: esriFieldTypeString, alias: Tertiary Street, editable: true, nullable: true, length: 75, defaultValue: null, modelName: TertiaryRoad )
• ComputerName ( type: esriFieldTypeString, alias: Computer Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ComputerName )
• OpDate ( type: esriFieldTypeDate, alias: Operation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OpDate )
• OpTime ( type: esriFieldTypeString, alias: Operation Time, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OpTime )
• OperatedBy ( type: esriFieldTypeString, alias: Operated By, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OperatedBy )
• SignalID ( type: esriFieldTypeString, alias: Signal ID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SignalID )

Templates:

• Name: Traffic Controller
  Description:
  Prototype:
  OperatedBy: null
  SignalID: null
  FacilityID: null
  LegacyID: null
  Address: null
  Location: null
  WarrantyDate: null
  PurchaseDate: null
  InstallDate: null
  AssetCost: null
  Condition: null
  ConditionDate: null
  LifecycleStatus: null
  Comments: null
  Owner: null
  UsefulLife: null
  MaintainedBy: null
  ContractorID: null
  ImagePath: null
  SurveyDate: null
  SurveyName: null
  EditDate: null
  EditorName: null
  Source: null
  DataSourceType: null
  DataSourceReference: null
  Type: null
  Material: null
  CabinetType: null
  SignalType: null
  FlasherType: null
  Manufacturer: null
  ModelNumber: null
  SerialNumber: null
  CalibrationRange: null
  LSCount: null
  FlashCount: null
  TRCount: null
  IsolateCount: null
  PowerSource: null
  Voltage: null
  PowerSourceLocation: null
  FuseType: null
  PanelLightVoltage: null
  PanelLightModelNumber: null
  UPS: null
  PLC: null
  RelatedInput: null
  RelatedOutput: null
  OM: null
  CabinetID: null
  PrimaryRoad: null
  SecondaryRoad: null
  TertiaryRoad: null
  ComputerName: null
  OpDate: null
  OpTime: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata