Light Poles

Light Poles is a Point FeatureClass representing light posts distributed throughout the city. It is primarily used for identifying and tracking assets and necessary maintenance and repairs. The layer is updated as needed by the GIS division and by field staff. Light Poles has the following fields: 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'] 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 light 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: The height of the light pole type: SmallInteger, length: 2, domain: none ArmLength: The length of the light 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 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 light pole type: SmallInteger, length: 2, domain: utilLampNumberOf domain values:['1', '2', '3', '4'] LampType: Field identifying the type of lamp used in the light 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 light pole uses type: String, length: 10, domain: utilLightBase domain values:['Anchor', 'Buried'] Fixture: Field indicating which type of fixture style the light 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 light pole has a beacon type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] IsFused: Field indicating whether or not the light pole is fused type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] IsUnderground: Field indicating if the light pole is secured underground type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] IsMetered: Field indicating whether or not the light pole is metered type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] HasStencil: Field indicating whether or not the light pole has a stencil type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] HasSticker: Field indicating whether or not the light 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 light pole type: Double, length: 8, domain: none POINT_Y: The Y coordinate of the light pole type: Double, length: 8, domain: none NoVehicleHds: Field indicating the number of vehicle heads on the light pole type: SmallInteger, length: 2, domain: trafNoOfVehHeads NoPedHds: Field indicating the number of pedestrian heads on the light pole type: SmallInteger, length: 2, domain: trafNoOfPedHeads domain values:['0', '1', '2'] NoPedButtons: Field indicating the number of pedestrian buttons on the light 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 light 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 light pole has a hand pole cover type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] isStreetlight: Field indicating whether or not the light pole is designated as a streetlight type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] isSmallCell: Field indicating whether or not the light 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 light 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 light pole has a Safe Routes 2 School banner type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No']