Name: Traffic Poles (in service)

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class shows traffic poles in the City of Santa Rosa, CA. These poles are either street light or traffic signal poles. Street lights are stored in the Traffic Fixtures table.According to Dana Kutches, there are no ID numbers physically on traffic signal only poles (poles that have no light on them).Note: On poles that have 2 lights on them, like along a road, the odd numbered (LegacyID) lights are typcially on the street side. All street light poles west of Burbank Ave on Sebastopol Rd have a single light on them (per Dana Kutches on 12/08/2021).Note: Dana said that pole Leagcy ID (Hansen UNITID) that start with a "C" are City-owned poles. He said that back in the 1960’s they started adding the “C” to the pole numbers and before that they didn’t have any letter in front. This made it easier to see which poles belonged to the City. Here is information about all the letters that being the Leagcy ID and what they mean:C = City Owned PoleM = City Owned Pole - no one on the light crew, as of March 2022, knows the meaning of the "M" but they are City Owned.P = Parks Department Light Pole or StructureR = Roseland Annexation PoleNote: The City typcially does not maintain the signal poles at the railroad crossings.

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 6339889.548037559
YMin: 1903019.9039237201
XMax: 6397222.051810637
YMax: 1947568.9860852212
Spatial Reference: 102642  (2226)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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 )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 50 )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 25 )
• ParentAssetID ( type: esriFieldTypeString, alias: ParentAssetID, length: 25 )
• PoleID ( type: esriFieldTypeString, alias: PoleID, length: 25 )
• IntersectionID ( type: esriFieldTypeString, alias: IntersectionID, length: 25 )
• CabinetID ( type: esriFieldTypeString, alias: CabinetID, length: 25 )
• Name ( type: esriFieldTypeString, alias: Name, length: 75 )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 )
• Description ( type: esriFieldTypeString, alias: Description, length: 150 )
• Address ( type: esriFieldTypeString, alias: Address, length: 150 )
• District ( type: esriFieldTypeString, alias: District, length: 25 )
• PrimaryRoad ( type: esriFieldTypeString, alias: Primary Road, length: 75 )
• SecondaryRoad ( type: esriFieldTypeString, alias: Secondary Road, length: 75 )
• TertiaryRoad ( type: esriFieldTypeString, alias: Tertiary Road, length: 75 )
• PoleType ( type: esriFieldTypeString, alias: Pole Type, length: 25 , Coded Values: [SIGNALPOLE: Traffic Signal Pole] , [LIGHTPOLE: Street Light Pole] , [OTHERPOLE: Other Traffic Pole] )
• Pole_Height ( type: esriFieldTypeDouble, alias: Pole_Height , Range: [0, 0] )
• Intersection ( type: esriFieldTypeString, alias: Intersection, length: 150 )
• StreetName ( type: esriFieldTypeString, alias: Street, length: 75 )
• Cross_Street ( type: esriFieldTypeString, alias: Cross Street, length: 75 )
• Side_of_Road ( type: esriFieldTypeString, alias: Side of Road, length: 10 , Coded Values: )
• Foundation ( type: esriFieldTypeString, alias: Foundation, length: 50 )
• Struct_Height ( type: esriFieldTypeDouble, alias: Structure Height , Range: [0, 0] )
• Struct_Material ( type: esriFieldTypeString, alias: Struct_Material, length: 50 , Coded Values: [ASPH: ASPHALT] , [CON: CONCRETE] , [METAL: METAL] , ...1 more... )
• Measured_From ( type: esriFieldTypeString, alias: Measured_From, length: 50 )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 , Coded Values: )
• ModelNum ( type: esriFieldTypeString, alias: Model Number, length: 50 )
• SerialNum ( type: esriFieldTypeString, alias: SerialNum, length: 125 )
• BudgetNum ( type: esriFieldTypeString, alias: BudgetNum, length: 50 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 50 , Coded Values: [CITY: City of Santa Rosa] , [CNTY: Sonoma County] , [PGE: PG&E] , ...9 more... )
• ExpDate ( type: esriFieldTypeDate, alias: Expired Date, length: 8 )
• InstallationDate ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• LifecycleStatus ( type: esriFieldTypeString, alias: Lifecycle Status, length: 25 , Coded Values: [Under Repair: Under Repair] , [In Service: In Service] , [Out of Service: Out of Service] , ...3 more... )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 25 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• ConditionDate ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• ConditionScore ( type: esriFieldTypeDouble, alias: Condition Score )
• Img_Path ( type: esriFieldTypeString, alias: Img_Path, length: 150 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 250 )
• POF ( type: esriFieldTypeDouble, alias: POF )
• COF ( type: esriFieldTypeDouble, alias: COF )
• BRE ( type: esriFieldTypeDouble, alias: BRE )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Banner ( type: esriFieldTypeString, alias: Banner Pole, length: 3 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ParkAssetID ( type: esriFieldTypeString, alias: ParkAssetID, length: 25 )
• PrkPlng ( type: esriFieldTypeString, alias: Parks Planning, length: 1 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata