Name: Traffic Signal Head
Display Field: AssetID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN /></P><P><SPAN>gisdata.CUPERTINO.traf_SignalHead is a Point FeatureClass representing traffic signal heads in the City of Cupertino. Signal Heads are part of the traffic infrastructure. They house the red, yellow, and green lights for drivers.</SPAN></P><P><SPAN>It is primarily used as an inventory layer within Cityworks</SPAN></P><P><SPAN>The layer is updated as needed by the GIS division and Public Works departments </SPAN></P><P><SPAN>The oldest geoprocessing record has a date of: 2016-03-04. The layer was created using aerial photographs and Google Streetview</SPAN></P><P><SPAN /></P><P><SPAN>gisdata.CUPERTINO.traf_SignalHead 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>SignalHeadType:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 50, domain: trafSignalHeadType</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Advanced Indication', 'Programmed Visibility', 'Standard Flashing Beacon', 'Programmed Visibility-Advanced Indication', 'Standard']</SPAN></P><P><SPAN /></P><P><SPAN>HeadConfig:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 15, domain: trafHeadConfig</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['1-Section', '2-Section', '5-Section', '3-Section', '4-Section']</SPAN></P><P><SPAN /></P><P><SPAN>HeadCfgDetail:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 20, domain: trafHeadConfigDetail</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['YA', 'YB', 'Standard', 'RA-YA-GB', 'RA-YA-GA', 'RB-YB-GB-YA-GA', 'RB-YB-GB-GA', 'RB-TB-GB-RA']</SPAN></P><P><SPAN /></P><P><SPAN>MountDetail:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 50, domain: trafSignalHeadMount</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['TV-1', 'TV-3-T', 'SV-4-TC', 'SV-1-T', 'SV-2-TA', 'SV-2-TB', 'SV-2-TC', 'SV-2-TD', 'SV', 'TV-2', 'SV-4-TB', 'SV-2B', 'SV-2A', 'SV-4-TA', 'SV-1', 'TV-2-T', 'TV-1-T', 'TV-4-T', 'SV-3-TC', 'SV-3-TB', 'SV-3-TA']</SPAN></P><P><SPAN /></P><P><SPAN>Phase:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 15, domain: trafPhase</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['OL2', '1', 'OL1', '3', '2', '5', '4', '7', '6', '8']</SPAN></P><P><SPAN /></P><P><SPAN>NumOverlaps:</SPAN></P><P><SPAN /></P><P><SPAN>type: SmallInteger, length: 2, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>PoleID:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 50, domain: none</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>SignalHeadSize:</SPAN></P><P><SPAN /></P><P><SPAN>type: SmallInteger, length: 2, domain: trafSignalHeadSize</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['8', '12']</SPAN></P><P><SPAN /></P><P><SPAN>SignalDirection:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 5, domain: trafSignalDirection</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['WBLT', 'WB', 'SBLT', 'NB', 'NBLT', 'NBRT', 'EB', 'EBLT', 'SBRT', 'SB', 'EBRT', 'WBRT']</SPAN></P><P><SPAN /></P><P><SPAN>SignalPosition:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 12, domain: trafSignalPosition</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Upright', 'Overhead 2', 'Overhead 3', 'Overhead 1']</SPAN></P><P><SPAN /></P><P><SPAN>hasLouver:</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></DIV></DIV></DIV>
Service Item Id: 4c146f646caa4ee7a40bac2dbc92080d
Copyright Text: City of Cupertino Public Works
City of Cupertino GIS
Default Visibility: false
MaxRecordCount: 20000
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: 6105413.57455197
YMin: 1933095.3064234108
XMax: 6124530.096450701
YMax: 1949106.1394400299
Spatial Reference: 102643
(2227)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSMSCircle
Color: [64, 30, 127, 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: 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
)
-
SignalHeadType
(
type: esriFieldTypeString, alias: SignalHeadType, length: 50
, Coded Values:
[Standard: Standard]
, [ProgVis: Programmed Visibility]
, [AdvIndication: Advanced Indication]
, ...2 more...
)
-
HeadConfig
(
type: esriFieldTypeString, alias: HeadConfig, length: 15
, Coded Values:
[1Sec: 1-Section]
, [2Sec: 2-Section]
, [3Sec: 3-Section]
, ...2 more...
)
-
HeadCfgDetail
(
type: esriFieldTypeString, alias: HeadCfgDetail, length: 20
, Coded Values:
[Standard: Standard]
, [YA: YA]
, [YB: YB]
, ...5 more...
)
-
MountDetail
(
type: esriFieldTypeString, alias: MountDetail, length: 50
, Coded Values:
[SV: SV]
, [SV-1: SV-1]
, [SV-1-T: SV-1-T]
, ...18 more...
)
-
Phase
(
type: esriFieldTypeString, alias: Phase, length: 15
, Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...7 more...
)
-
NumOverlaps
(
type: esriFieldTypeSmallInteger, alias: NumOverlaps
)
-
PoleID
(
type: esriFieldTypeString, alias: PoleID, length: 50
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
SignalHeadSize
(
type: esriFieldTypeSmallInteger, alias: SignalHeadSize
, Coded Values:
[8: 8]
, [12: 12]
)
-
SignalDirection
(
type: esriFieldTypeString, alias: SignalDirection, length: 5
, Coded Values:
[NB: NB]
, [SB: SB]
, [EB: EB]
, ...9 more...
)
-
SignalPosition
(
type: esriFieldTypeString, alias: SignalPosition, length: 12
, Coded Values:
[Overhead 1: Overhead 1]
, [Overhead 2: Overhead 2]
, [Overhead 3: Overhead 3]
, ...1 more...
)
-
hasLouver
(
type: esriFieldTypeString, alias: hasLouver, length: 3
, Coded Values:
[Y: Yes]
, [N: No]
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata