View In:
ArcGIS Online Map Viewer
Name: Traffic Cabinet
Display Field: AssetID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>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 intersection</SPAN></P><P><SPAN>It 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 cabinet</SPAN></P><P><SPAN>The layer is updated as needed by public works department and GIS Division</SPAN></P><P><SPAN /></P><P><SPAN>gisdata.CUPERTINO.traf_Cabinet has the following fields: </SPAN></P><P><SPAN /></P><P><SPAN>OBJECTID:</SPAN></P><P><SPAN>Unique identifier automatically generated by Esri</SPAN></P><P><SPAN>type: OID, length: 4, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>AssetID:</SPAN></P><P><SPAN>Cupertino maintained GIS primary key</SPAN></P><P><SPAN>type: String, length: 20, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>LegacyID:</SPAN></P><P><SPAN>Old identifiers used to track asset migration</SPAN></P><P><SPAN>type: String, length: 20, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>Location:</SPAN></P><P><SPAN>Description or address of location</SPAN></P><P><SPAN>type: String, length: 50, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>Status:</SPAN></P><P><SPAN>The active or construction status of the asset in the field</SPAN></P><P><SPAN>type: String, length: 20, domain: envStatus</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Proposed', 'Vacant', 'Needs Attention', 'Dead', 'Active', 'New Tree', 'Removed', 'Ground']</SPAN></P><P><SPAN /></P><P><SPAN>OwnedBy:</SPAN></P><P><SPAN>Organization which owns the asset</SPAN></P><P><SPAN>type: String, length: 50, domain: shdOwnedBy</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['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']</SPAN></P><P><SPAN /></P><P><SPAN>MaintainedBy:</SPAN></P><P><SPAN>Organization who is responsible for maintenance of asset</SPAN></P><P><SPAN>type: String, length: 50, domain: shdOwnedBy</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['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']</SPAN></P><P><SPAN /></P><P><SPAN>PlanNumber:</SPAN></P><P><SPAN>Origniating plan number if known</SPAN></P><P><SPAN>type: String, length: 100, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>PrimaryImage:</SPAN></P><P><SPAN>Hyperlink to photo or DMS</SPAN></P><P><SPAN>type: String, length: 100, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>CreateBy:</SPAN></P><P><SPAN>the name of the staff person who created the database row</SPAN></P><P><SPAN>type: String, length: 50, domain: OPERATOR</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['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']</SPAN></P><P><SPAN /></P><P><SPAN>CreateDate:</SPAN></P><P><SPAN>the date the database row was initially created</SPAN></P><P><SPAN>type: Date, length: 36, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>UpdateBy:</SPAN></P><P><SPAN>The user who last updated the database row</SPAN></P><P><SPAN>type: String, length: 50, domain: OPERATOR</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['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']</SPAN></P><P><SPAN /></P><P><SPAN>UpdateDate:</SPAN></P><P><SPAN>the date the database row was last updated</SPAN></P><P><SPAN>type: Date, length: 36, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>DataSource:</SPAN></P><P><SPAN>Description of what methods were used for data capture/migration</SPAN></P><P><SPAN>type: String, length: 100, domain: shdDataSource</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['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']</SPAN></P><P><SPAN /></P><P><SPAN>AsbuiltDate:</SPAN></P><P><SPAN>Asbuilt date</SPAN></P><P><SPAN>type: Date, length: 36, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>CabinetType:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 50, domain: traffControlCabinetType</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['M Cabinet', '336', '332', 'TS2', 'TS1']</SPAN></P><P><SPAN /></P><P><SPAN>NoPhases:</SPAN></P><P><SPAN>Indicates the number of phases on an intersection</SPAN></P><P><SPAN>type: SmallInteger, length: 2, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>NoOverlaps:</SPAN></P><P><SPAN>Indicates the number of overlaps on an intersection controlled by cabinet</SPAN></P><P><SPAN>type: SmallInteger, length: 2, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>HasVideo:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 3, domain: shdBooleanYesNo</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Yes', 'No']</SPAN></P><P><SPAN /></P><P><SPAN>DetectionType:</SPAN></P><P><SPAN>Detection type of video</SPAN></P><P><SPAN>type: String, length: 15, domain: trafVideoType</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Iteris', 'Opticom', 'Gridsmart', 'Trafficon']</SPAN></P><P><SPAN /></P><P><SPAN>HasInductionLoop:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 3, domain: shdBooleanYesNo</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Yes', 'No']</SPAN></P><P><SPAN /></P><P><SPAN>Manufacturer:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 30, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>AutomatedPedType:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 30, domain: trafAutomatedPedType</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Campbell', 'None', 'Polara']</SPAN></P><P><SPAN /></P><P><SPAN>ControllerType:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 50, domain: trafControllerType</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['900ATC', '900', '2070']</SPAN></P><P><SPAN /></P><P><SPAN>Shape:</SPAN></P><P><SPAN>Field that stores geographic coordinates associated with feature</SPAN></P><P><SPAN>type: Geometry, length: 4, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>GlobalID:</SPAN></P><P><SPAN>Unique identifier automatically generated for features in enterprise database</SPAN></P><P><SPAN>type: GlobalID, length: 38, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>HasRedirectedPhases:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 3, domain: shd_BooleanYesNo</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Yes', 'No']</SPAN></P><P><SPAN /></P><P><SPAN>ControllerNum:</SPAN></P><P><SPAN /></P><P><SPAN>type: SmallInteger, length: 2, domain: none</SPAN></P><P><SPAN /></P></DIV></DIV></DIV>
Service Item Id: ae72218467044810a10215a47e020e42
Copyright Text: Cupertino Public Works Department and GIS Division
Default Visibility: false
MaxRecordCount: 20000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: 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:
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: 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: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
created_date
(
type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
AssetID
(
type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID
)
-
LegacyID
(
type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LegacyID
)
-
Location
(
type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location
)
-
Status
(
type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: Status
, Coded Values:
[Active: Active]
, [Abandoned: Abandoned]
, [Proposed: Proposed]
, ...4 more...
)
-
OwnedBy
(
type: esriFieldTypeString, alias: OwnedBy, editable: true, nullable: true, length: 50, defaultValue: Cupertino, modelName: OwnedBy
, Coded Values:
[CalTrans: CalTrans]
, [California Water Service: California Water Service]
, [Cupertino Sanitary District: Cupertino Sanitary District]
, ...16 more...
)
-
MaintainedBy
(
type: esriFieldTypeString, alias: MaintainedBy, editable: true, nullable: true, length: 50, defaultValue: Cupertino, modelName: MaintainedBy
, Coded Values:
[CalTrans: CalTrans]
, [California Water Service: California Water Service]
, [Cupertino Sanitary District: Cupertino Sanitary District]
, ...16 more...
)
-
PlanNumber
(
type: esriFieldTypeString, alias: PlanNumber, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PlanNumber
)
-
PrimaryImage
(
type: esriFieldTypeString, alias: PrimaryImage, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PrimaryImage
)
-
DataSource
(
type: esriFieldTypeString, alias: DataSource, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DataSource
, 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, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AsbuiltDate
)
-
CabinetType
(
type: esriFieldTypeString, alias: CabinetType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type
, Coded Values:
[TS2: TS2]
, [TS1: TS1]
, [332: 332]
, ...2 more...
)
-
NoPhases
(
type: esriFieldTypeSmallInteger, alias: NoPhases, editable: true, nullable: true, defaultValue: null, modelName: NoPhases
)
-
NoOverlaps
(
type: esriFieldTypeSmallInteger, alias: Number of Overlaps, editable: true, nullable: true, defaultValue: null, modelName: NoOverlaps
)
-
HasVideo
(
type: esriFieldTypeString, alias: HasVideo, editable: true, nullable: true, length: 3, defaultValue: null, modelName: HasVideo
, Coded Values:
[Y: Yes]
, [N: No]
)
-
DetectionType
(
type: esriFieldTypeString, alias: Video Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DetectionType
, Coded Values:
[Iteris: Iteris]
, [Trafficon: Trafficon]
, [Opticom: Opticom]
, ...3 more...
)
-
HasInductionLoop
(
type: esriFieldTypeString, alias: HasInductionLoop, editable: true, nullable: true, length: 3, defaultValue: null, modelName: HasInductionLoop
, Coded Values:
[Y: Yes]
, [N: No]
)
-
Manufacturer
(
type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Manufacturer
)
-
AutomatedPedType
(
type: esriFieldTypeString, alias: AutomatedPedType, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AutomatedPedType
, Coded Values:
[None: None]
, [Polara: Polara]
, [Campbell: Campbell]
)
-
ControllerType
(
type: esriFieldTypeString, alias: ControllerType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ControllerType
, Coded Values:
[900: 900]
, [900 ATC: 900ATC]
, [2070: 2070]
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
HasRedirectedPhases
(
type: esriFieldTypeString, alias: HasRedirectedPhases, editable: true, nullable: true, length: 3, defaultValue: null, modelName: HasRedirectedPhases
, Coded Values:
[Y: Yes]
, [N: No]
)
-
ControllerNum
(
type: esriFieldTypeSmallInteger, alias: ControllerNum, editable: true, nullable: true, defaultValue: null, modelName: ControllerNum
)
-
HasMonitoringVideo
(
type: esriFieldTypeString, alias: HasMonitoringVideo, editable: true, nullable: true, length: 3, defaultValue: null, modelName: HasMonitoringVideo
, Coded Values:
[Y: Yes]
, [N: No]
)
-
DetectionVideoType
(
type: esriFieldTypeString, alias: DetectionVideoType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DetectionVideoType
, Coded Values:
[Iteris: Iteris]
, [Trafficon: Trafficon]
, [Opticom: Opticom]
, ...3 more...
)
-
StationID
(
type: esriFieldTypeString, alias: StationID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StationID
)
-
NetworkType
(
type: esriFieldTypeString, alias: NetworkType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NetworkType
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NetworkSwitch
)
-
MMU
(
type: esriFieldTypeString, alias: MMU, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MMU
)
-
PowerSupply
(
type: esriFieldTypeString, alias: PowerSupply, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PowerSupply
, Coded Values:
[Y: Yes]
, [N: No]
)
-
ControllerEthernetPort
(
type: esriFieldTypeString, alias: ControllerEthernetPort, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ControllerEthernetPort
, Coded Values:
[Y: Yes]
, [N: No]
)
-
UPS
(
type: esriFieldTypeString, alias: UPS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UPS
, Coded Values:
[Tesco: Tesco]
, [Clary: Clary]
, [None: None]
)
-
EVP
(
type: esriFieldTypeString, alias: EVP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EVP
, Coded Values:
[Yes: Yes]
, [Yes with Railroad: Yes with Railroad]
, [None: None]
)
-
CCTV
(
type: esriFieldTypeString, alias: CCTV, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CCTV
, Coded Values:
[Serial: Serial]
, [Ethernet: Ethernet]
, [None: None]
)
-
Interconnect
(
type: esriFieldTypeString, alias: Interconnect, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Interconnect
, Coded Values:
[Yes: Yes]
, [No: No]
, [Wireless: Wireless]
)
-
PedPhases
(
type: esriFieldTypeSmallInteger, alias: PedPhases, editable: true, nullable: true, defaultValue: null, modelName: PedPhases
)
Templates:
-
Name: Traffic Cabinet
Description:
Prototype:
Interconnect: null
created_date: null
last_edited_date: null
AssetID: null
LegacyID: null
Location: null
Status: Active
OwnedBy: Cupertino
MaintainedBy: Cupertino
PlanNumber: null
PrimaryImage: null
DataSource: null
AsbuiltDate: null
CabinetType: null
NoPhases: null
NoOverlaps: null
HasVideo: null
DetectionType: null
HasInductionLoop: null
Manufacturer: null
AutomatedPedType: null
ControllerType: null
PedPhases: null
HasRedirectedPhases: null
ControllerNum: null
HasMonitoringVideo: null
DetectionVideoType: null
StationID: null
NetworkType: null
NetworkSwitch: null
MMU: null
PowerSupply: null
ControllerEthernetPort: null
UPS: null
EVP: null
CCTV: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Extract
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: true
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Supported Operations:
Query
Query Analytic
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata