Name: Street Light

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This point file was created from an extract from WAMS (Work and Asset Management System, Seattle City Light), and was georeferenced using DRG survey-provided data from 2009-2010. It includes Streetlight and Pole/Standard attributes, and survey photos.

Service Item Id: e4ec3444c08d47609117bb31998dbc89

Copyright Text: H. Burkett, Seattle City Light Asset Management

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.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: 1256940.6977371722
YMin: 271126.3384848237
XMax: 1281402.8324650973
YMax: 287626.38818602264
Spatial Reference: 2926  (2926)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 255, 0, 255]
Size: 7.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 35 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 30 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• Location ( type: esriFieldTypeString, alias: Location, length: 130 )
• EstimatedEffectiveLife ( type: esriFieldTypeSmallInteger, alias: EstimatedEffectiveLife )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: InstallYear )
• Condition ( type: esriFieldTypeSmallInteger, alias: Condition )
• LifeCycle ( type: esriFieldTypeString, alias: LifeCycle, length: 5 , Coded Values: [AC: Active] , [PR: Proposed] , [AB: Abandoned] , ...3 more... )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y )
• HEIGHT_1 ( type: esriFieldTypeInteger, alias: Pole Height )
• PARENT_ASSET_ID ( type: esriFieldTypeString, alias: PARENT_ASSET_ID, length: 255 )
• ASSET_ID_1 ( type: esriFieldTypeString, alias: ASSET_ID, length: 255 )
• POLE_ASSET_TYPE ( type: esriFieldTypeString, alias: POLE_ASSET_TYPE, length: 255 )
• ASSET_MOBILE_3 ( type: esriFieldTypeString, alias: ASSET_MOBILE_3, length: 255 )
• LOCATION_DETAILS ( type: esriFieldTypeString, alias: LOCATION_DETAILS, length: 255 )
• LOCATION_ON_STREET ( type: esriFieldTypeString, alias: LOCATION_ON_STREET, length: 255 )
• STREET_NUMBER ( type: esriFieldTypeString, alias: STREET_NUMBER, length: 255 )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 255 )
• LUMINAIRE_1 ( type: esriFieldTypeString, alias: LUMINAIRE, length: 255 )
• STREETLIGHT_CATEGORY ( type: esriFieldTypeString, alias: STREETLIGHT_CATEGORY, length: 255 )
• LUMINAIRE_LED_TYPE ( type: esriFieldTypeString, alias: LUMINAIRE_LED_TYPE, length: 255 )
• LED_NON_LED_SL_CATEGORY ( type: esriFieldTypeString, alias: LED_NON_LED_SL_CATEGORY, length: 255 )
• RUN ( type: esriFieldTypeString, alias: RUN, length: 255 )
• SCL_Number_1 ( type: esriFieldTypeString, alias: SCL_Number, length: 255 )
• Comments_1 ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Problem ( type: esriFieldTypeSmallInteger, alias: Problem , Coded Values: [1: Street Number or Pole Number Incorrect] , [2: Public Light should be Private] , [3: New Light Found] , ...4 more... )
• Assemble2Notes ( type: esriFieldTypeString, alias: Assemble2Notes, length: 255 )
• OperatedBy ( type: esriFieldTypeString, alias: OperatedBy, length: 25 , Coded Values: [CROW: City-ROW] , [CPAR: City-Parks] )
• OwnedBy ( type: esriFieldTypeString, alias: OwnedBy, length: 6 )
• SCL_RATECODE ( type: esriFieldTypeString, alias: SCL_RATECODE, length: 10 )
• SCL_RATE ( type: esriFieldTypeDouble, alias: SCL_RATE )
• OWNERTYPE ( type: esriFieldTypeString, alias: OWNERTYPE, length: 20 )
• Ballast ( type: esriFieldTypeString, alias: Ballast, length: 10 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• ModelNumber ( type: esriFieldTypeString, alias: ModelNumber, length: 50 )
• Wattage ( type: esriFieldTypeInteger, alias: Wattage )
• Distributor ( type: esriFieldTypeString, alias: Distributor, length: 100 )
• LightTray ( type: esriFieldTypeString, alias: LightTray, length: 50 )

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

  Iteminfo   Thumbnail   Metadata