Traffic Poles

Traffic Poles is a Point FeatureClass representing traffic poles in the City of Cupertino. It is primarily used as an inventory layer in Cityworks and as a reference layer. The layer is updated as needed by the Public Works Department and the GIS Division. Traffic Poles has the following fields: OBJECTID: Unique identifier automatically generated by Esri type: OID, length: 4, domain: none AssetID: Cupertino maintained GIS primary key type: String, length: 20, domain: none Location: Further description of the location type: String, length: 50, domain: none Status: The active or construction status of the asset in the field type: String, length: 20, domain: pwStatus domain values:['Abandoned', 'Proposed', 'Auction', 'Denied', 'Active', 'Removed', 'Not Connected'] OwnedBy: Organization which owns the asset type: String, length: 50, domain: shdOwnedBy domain 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 asset type: String, length: 50, domain: shdOwnedBy domain 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'] AsbuiltDate: The completion date listed on the plans type: Date, length: 8, domain: none Date Install: The date of the most recent maintenance on this asset type: Date, length: 8, domain: none CreateDate: The date the database row was initially created type: Date, length: 8, domain: none UpdateDate: The date the database row was last updated type: Date, length: 8, domain: none Rotation: Field used for assigning rotation degree in Maplex Labeling Engine type: Double, length: 8, domain: none BadgeNumber: The badge number assigned to the traffic pole type: String, length: 6, domain: none ServiceID: Service identification number type: String, length: 20, domain: none PoleType: Field describing the type of pole found at the location type: String, length: 20, domain: utilLightPoleType domain values:['Mast Arm Pole', 'Taper 4 Bolt', '33', 'PBP Pole', 'Taper 3 Bolt', '1A', 'Type15', '1B', 'Taper 1 Bolt', 'Top Mount', 'Flute 1 Bolt', 'Taper 2 Bolt'] PoleMaterial: Field indicating what material the pole is made of type: String, length: 20, domain: utilLightPoleMaterial domain values:['Steel', 'Concrete', 'Aluminium', 'Galvanized', 'Wood'] PoleHeight: Field indicating the height of the pole type: SmallInteger, length: 2, domain: none ArmLength: The length of the traffic pole arm - in feet type: SmallInteger, length: 2, domain: utilLightArmLength domain values:["65'", "3'", "6'", "8'", "10'", "12'", "45'", "15'", "40'", "50'", "35'", "20'", "55'", "25'", "60'", "30'"] LightFunction: Field indicating the function of the light on the pole type: String, length: 20, domain: utilLightFunction domain values:['Street Light', 'Tennis Court Light', 'Parking Lot Light', 'Park Light', 'Flood Light', 'Safety Light'] NumberofHeads: Field indicating the number of heads on the pole type: SmallInteger, length: 2, domain: utilLampNumberOf domain values:['1', '2', '3', '4'] LampType: Field identifying the type of lamp used in the light on pole type: String, length: 10, domain: utilLampType domain values:['High Pressure Sodium', 'Mercury Vapor', 'LED', 'Metal Halide', 'Inductive'] Wattage: Field indicating the number of watts type: SmallInteger, length: 2, domain: none Volts: Field indicating the number of volts type: SmallInteger, length: 2, domain: utilLampVoltage domain values:['120V', '240V', '480V', '277V'] Base: Field indicating the type of base that pole uses type: String, length: 10, domain: utilLightBase domain values:['Anchor', 'Buried'] Fixture: Field indicating which type of fixture style the pole has type: String, length: 20, domain: utilLightFixture domain values:['Park Dome', 'Ornamental', 'Cobra', 'Shoe Box'] ControlType: Field indicating what type of control method is used type: String, length: 20, domain: utilLightControlType domain values:['Time Clock', 'Photo Electronic Control'] HasBeacon: Field indicating whether or not the pole has a beacon type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] IsFused: Field indicating whether or not the pole is fused type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] IsUnderground: Field indicating if the pole is secured underground type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] IsMetered: Field indicating whether or not the pole is metered type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] HasStencil: Field indicating whether or not the pipe has a stencil type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] HasSticker: Field indicating whether or not the pole has a sticker type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] RateSchedule: type: String, length: 10, domain: utilLightRateSchedule domain values:['LS1-F1', 'LS1-F', 'LS1-E', 'LS1-B', 'LS1-C', 'LS1-A', 'LS2-A'] GlobalID: Unique identifier automatically generated for features in enterprise database type: GlobalID, length: 38, domain: none POINT_X: The X coordinate of the traffic pole type: Double, length: 8, domain: none POINT_Y: The Y coordinate of the traffic pole type: Double, length: 8, domain: none NoVehicleHds: Field indicating the number of vehicle heads on the pole type: SmallInteger, length: 2, domain: trafNoOfVehHeads NoPedHds: Field indicating the number of pedestrian heads on the pole type: SmallInteger, length: 2, domain: trafNoOfPedHeads domain values:['0', '1', '2'] NoPedButtons: Field indicating the number of pedestrian buttons on the pole type: SmallInteger, length: 2, domain: trafNoOfPedButtons domain values:['0', '1', '2', '3'] Shape: Field that stores geographic coordinates associated with feature type: Geometry, length: 4, domain: none IsTrafficSignal: Field indicating whether or not the pole is used as a traffic signal type: String, length: 3, domain: shd_BooleanYesNo domain values:['Yes', 'No'] hasHandPoleCover: Field indicating whether or not the pole has a hand pole cover type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] isStreetlight: Field indicating whether or not the pole is designated as a streetlight type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] isSmallCell: Field indicating whether or not the pole has a small cell attatched type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] SmallCellCarrier: Carrier associated with the small cell type: String, length: 50, domain: utilSmallCellCarrier domain values:['Mobilitie', 'ATT', 'Crown Castle', 'Verizon'] hasFlagHolder: Field indicating whether or not the pole has a flag holder type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] FlagHolderInstallDate: The date when the flag holder was installed type: Date, length: 8, domain: none hasSafeRouteBanner: Field indicating whether or not the pole has a Safe Routes 2 School banner type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No']