Feedback
2 results found
  1. a

    Light Poles

    • data-cupertino.opendata.arcgis.com
    Published Nov 26, 2015
  2. a

    Traffic Poles

    • data-cupertino.opendata.arcgis.com
    Published Apr 27, 2016
  3. Not seeing a result you expected?
    Learn how you can add new datasets to our index.

Share
Facebook
Twitter
Email
Click to copy link
Link copied

Light Poles

  • Dataset published Nov 26, 2015
License
The City of Cupertino does not guarantee the accuracy, adequacy, completeness or usefulness of any information. The City does not warrant the positional or thematic accuracy of the GIS data. The GIS data and cartographic digital files are not legal representations of the depicted data. Information shown on these layers is derived from public records that are constantly undergoing change. Under no circumstances shall GIS mapping be used for final design purposes. While every effort has been made to ensure the content, sequence, accuracy, timeliness or completeness of materials presented within these pages, the City of Cupertino assumes no responsibility for errors or omissions, and explicitly disclaims any representations and warranties, including, without limitation, the implied warranties of merchantability and fitness for a particular purpose.
Area covered
McClellan Groundwater Recharge Pond, Los Altos, Stevens Creek Reservoir, San Jose, Cupertino, Santa Clara, Saratoga, Sunnyvale
Description

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:

Search
Clear search
Close search
Google apps
Main menu