Name: Traffic Signal UPS

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: )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 25 , Coded Values: )
• ModelNumber ( type: esriFieldTypeString, alias: Model Number, length: 40 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 40 )
• kVA ( type: esriFieldTypeDouble, alias: kVA , Coded Values: )
• Load_ ( type: esriFieldTypeDouble, alias: Load )
• Runtime ( type: esriFieldTypeDouble, alias: Runtime (mins) )
• 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 )
• IntersectionID ( type: esriFieldTypeString, alias: Intersection ID, length: 40 )
• CabinetID ( type: esriFieldTypeString, alias: Cabinet ID, length: 40 )

Relationships:

• trUPS (5) -- Related To: Traffic Signal Cabinet (153)

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

  Iteminfo   Thumbnail   Metadata