Name: Traffic Cabinet

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: gisdata.CUPERTINO.traf_Cabinet is a Point FeatureClass representing traffic cabinets in the City of Cupertino. Traffic cabinets contain controls to operate traffic signals at an intersectionIt is primarily used as an inventory layer within the Cityworks application. The layer has a field for assetIDS that allow users to see an archive of work history and inspections on each cabinetThe layer is updated as needed by public works department and GIS Divisiongisdata.CUPERTINO.traf_Cabinet has the following fields: OBJECTID:Unique identifier automatically generated by Esritype: OID, length: 4, domain: noneAssetID:Cupertino maintained GIS primary keytype: String, length: 20, domain: noneLegacyID:Old identifiers used to track asset migrationtype: String, length: 20, domain: noneLocation:Description or address of locationtype: String, length: 50, domain: noneStatus:The active or construction status of the asset in the fieldtype: String, length: 20, domain: envStatusdomain values:['Proposed', 'Vacant', 'Needs Attention', 'Dead', 'Active', 'New Tree', 'Removed', 'Ground']OwnedBy:Organization which owns the assettype: String, length: 50, domain: shdOwnedBydomain values:['Cupertino', 'San Jose Water', 'CalTrans', 'PGE', 'Los Altos', 'Santa Clara', 'Private HOA', 'Saratoga', 'Other Public', 'Santa Clara County', 'San Jose', 'Santa Clara Valley Water District', 'Private', 'California Water Service', 'State Parks', 'Sunnyvale', 'Cupertino Sanitary District', 'CWA']MaintainedBy:Organization who is responsible for maintenance of assettype: String, length: 50, domain: shdOwnedBydomain values:['Cupertino', 'San Jose Water', 'CalTrans', 'PGE', 'Los Altos', 'Santa Clara', 'Private HOA', 'Saratoga', 'Other Public', 'Santa Clara County', 'San Jose', 'Santa Clara Valley Water District', 'Private', 'California Water Service', 'State Parks', 'Sunnyvale', 'Cupertino Sanitary District', 'CWA']PlanNumber:Origniating plan number if knowntype: String, length: 100, domain: nonePrimaryImage:Hyperlink to photo or DMStype: String, length: 100, domain: noneCreateBy:the name of the staff person who created the database rowtype: String, length: 50, domain: OPERATORdomain values:['MIKE', 'CURTIS', 'JAMES', 'KANE', 'JERRY', 'RICARDO', 'JOANNE', 'TERI', 'ANDY', 'JOE', 'ARCHANA', 'JONATHAN', 'ADAM', 'JAKE', 'MICHAEL', 'MAKIKO', 'PAUL', 'JEN', 'JASON', 'SHAWN', 'FRANK', 'JULIE', 'NICK', 'KEVIN', 'CLIFF']CreateDate:the date the database row was initially createdtype: Date, length: 36, domain: noneUpdateBy:The user who last updated the database rowtype: String, length: 50, domain: OPERATORdomain values:['MIKE', 'CURTIS', 'JAMES', 'KANE', 'JERRY', 'RICARDO', 'JOANNE', 'TERI', 'ANDY', 'JOE', 'ARCHANA', 'JONATHAN', 'ADAM', 'JAKE', 'MICHAEL', 'MAKIKO', 'PAUL', 'JEN', 'JASON', 'SHAWN', 'FRANK', 'JULIE', 'NICK', 'KEVIN', 'CLIFF']UpdateDate:the date the database row was last updatedtype: Date, length: 36, domain: noneDataSource:Description of what methods were used for data capture/migrationtype: String, length: 100, domain: shdDataSourcedomain values:['Digitized Plan as Reference', 'GPS SubFoot', 'Unknown Source', 'iStreetView', 'Field Verified', 'GPS SubMeter', 'Digitized Landbase as Reference', 'Legacy WO System', 'Digitized Ortho as Reference', 'Approximated Historical Source', 'Need Verification', 'Cogo from Plans']AsbuiltDate:Asbuilt datetype: Date, length: 36, domain: noneCabinetType:type: String, length: 50, domain: traffControlCabinetTypedomain values:['M Cabinet', '336', '332', 'TS2', 'TS1']NoPhases:Indicates the number of phases on an intersectiontype: SmallInteger, length: 2, domain: noneNoOverlaps:Indicates the number of overlaps on an intersection controlled by cabinettype: SmallInteger, length: 2, domain: noneHasVideo:type: String, length: 3, domain: shdBooleanYesNodomain values:['Yes', 'No']DetectionType:Detection type of videotype: String, length: 15, domain: trafVideoTypedomain values:['Iteris', 'Opticom', 'Gridsmart', 'Trafficon']HasInductionLoop:type: String, length: 3, domain: shdBooleanYesNodomain values:['Yes', 'No']Manufacturer:type: String, length: 30, domain: noneAutomatedPedType:type: String, length: 30, domain: trafAutomatedPedTypedomain values:['Campbell', 'None', 'Polara']ControllerType:type: String, length: 50, domain: trafControllerTypedomain values:['900ATC', '900', '2070']Shape:Field that stores geographic coordinates associated with featuretype: Geometry, length: 4, domain: noneGlobalID:Unique identifier automatically generated for features in enterprise databasetype: GlobalID, length: 38, domain: noneHasRedirectedPhases:type: String, length: 3, domain: shd_BooleanYesNodomain values:['Yes', 'No']ControllerNum:type: SmallInteger, length: 2, domain: none

Service Item Id: 4c146f646caa4ee7a40bac2dbc92080d

Copyright Text: Cupertino Public Works Department and GIS Division

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 6105483.334173173
YMin: 1933236.7181842178
XMax: 6123984.2690740675
YMax: 1949091.3763156086
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [142, 175, 79, 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

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: AssetID, length: 20 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 20 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• Status ( type: esriFieldTypeString, alias: Status, length: 20 , Coded Values: [Active: Active] , [Abandoned: Abandoned] , [Proposed: Proposed] , ...4 more... )
• OwnedBy ( type: esriFieldTypeString, alias: OwnedBy, length: 50 , Coded Values: [CalTrans: CalTrans] , [California Water Service: California Water Service] , [Cupertino Sanitary District: Cupertino Sanitary District] , ...16 more... )
• MaintainedBy ( type: esriFieldTypeString, alias: MaintainedBy, length: 50 , Coded Values: [CalTrans: CalTrans] , [California Water Service: California Water Service] , [Cupertino Sanitary District: Cupertino Sanitary District] , ...16 more... )
• PlanNumber ( type: esriFieldTypeString, alias: PlanNumber, length: 100 )
• PrimaryImage ( type: esriFieldTypeString, alias: PrimaryImage, length: 100 )
• DataSource ( type: esriFieldTypeString, alias: DataSource, length: 100 , Coded Values: [Approximated Historical Source: Approximated Historical Source] , [Cogo from Plans: Cogo from Plans] , [Digitized Landbase as Reference: Digitized Landbase as Reference] , ...9 more... )
• AsbuiltDate ( type: esriFieldTypeDate, alias: AsbuiltDate, length: 8 )
• CabinetType ( type: esriFieldTypeString, alias: CabinetType, length: 50 , Coded Values: [TS2: TS2] , [TS1: TS1] , [332: 332] , ...2 more... )
• NoPhases ( type: esriFieldTypeSmallInteger, alias: NoPhases )
• NoOverlaps ( type: esriFieldTypeSmallInteger, alias: Number of Overlaps )
• HasVideo ( type: esriFieldTypeString, alias: HasVideo, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• DetectionType ( type: esriFieldTypeString, alias: Video Type, length: 15 , Coded Values: [Iteris: Iteris] , [Trafficon: Trafficon] , [Opticom: Opticom] , ...3 more... )
• HasInductionLoop ( type: esriFieldTypeString, alias: HasInductionLoop, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 30 )
• AutomatedPedType ( type: esriFieldTypeString, alias: AutomatedPedType, length: 30 , Coded Values: [None: None] , [Polara: Polara] , [Campbell: Campbell] )
• ControllerType ( type: esriFieldTypeString, alias: ControllerType, length: 50 , Coded Values: [900: 900] , [900 ATC: 900ATC] , [2070: 2070] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• HasRedirectedPhases ( type: esriFieldTypeString, alias: HasRedirectedPhases, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• ControllerNum ( type: esriFieldTypeSmallInteger, alias: ControllerNum )
• HasMonitoringVideo ( type: esriFieldTypeString, alias: HasMonitoringVideo, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• DetectionVideoType ( type: esriFieldTypeString, alias: DetectionVideoType, length: 50 , Coded Values: [Iteris: Iteris] , [Trafficon: Trafficon] , [Opticom: Opticom] , ...3 more... )
• StationID ( type: esriFieldTypeString, alias: StationID, length: 50 )
• NetworkType ( type: esriFieldTypeString, alias: NetworkType, length: 50 , Coded Values: [Serial over Fiber: Serial over Fiber] , [Ethernet over Fiber: Ethernet over Fiber] , [Ethernet over Copper: Ethernet over Copper] , ...2 more... )
• NetworkSwitch ( type: esriFieldTypeString, alias: NetworkSwitch, length: 50 )
• MMU ( type: esriFieldTypeString, alias: MMU, length: 50 )
• PowerSupply ( type: esriFieldTypeString, alias: PowerSupply, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• ControllerEthernetPort ( type: esriFieldTypeString, alias: ControllerEthernetPort, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• UPS ( type: esriFieldTypeString, alias: UPS, length: 50 , Coded Values: [Tesco: Tesco] , [Clary: Clary] , [None: None] )
• EVP ( type: esriFieldTypeString, alias: EVP, length: 50 , Coded Values: [Yes: Yes] , [Yes with Railroad: Yes with Railroad] , [None: None] )
• CCTV ( type: esriFieldTypeString, alias: CCTV, length: 50 , Coded Values: [Serial: Serial] , [Ethernet: Ethernet] , [None: None] )
• Interconnect ( type: esriFieldTypeString, alias: Interconnect, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Wireless: Wireless] )
• PedPhases ( type: esriFieldTypeSmallInteger, alias: PedPhases )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata