Name: Street Light
Display Field: ProjectName
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The datasets provides a geographic location of street lights within the City of Redmond city limits. Initially, the locations of the street lights were derived from field measurements kept in Excel spreadsheet. At a latter date locations were manually corrected using the 1993 aerial photography. The original data was kept in ArcView and later imported into GeoMedia/MS Access warehouse</SPAN></P></DIV></DIV></DIV>
Service Item Id: ea12f1822661422b9b3766028e1d912e
Copyright Text:
Default Visibility: true
MaxRecordCount: 10000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.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: 1312582.3045412153
YMin: 231260.61109489202
XMax: 1333173.5300909728
YMax: 262776.8850044757
Spatial Reference: 2926
(2926)
VCSWkid(5702)
LatestVCSWkid(5702)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
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
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
)
-
StreetLightNo
(
type: esriFieldTypeString, alias: StreetLightNo, length: 25
)
-
ProjectName
(
type: esriFieldTypeString, alias: ProjectName, length: 50
)
-
RecordDrawing
(
type: esriFieldTypeString, alias: RecordDrawing, length: 20
)
-
RecordDrawing1
(
type: esriFieldTypeString, alias: RecordDrawing1, length: 20
)
-
RecordDrawing2
(
type: esriFieldTypeString, alias: RecordDrawing2, length: 20
)
-
d_Ownership
(
type: esriFieldTypeString, alias: d_Ownership, length: 6
, Coded Values:
[RED: City of Redmond]
, [PVT: Private]
, [KCO: King County]
, ...12 more...
)
-
d_DataSource
(
type: esriFieldTypeString, alias: d_DataSource, length: 6
, Coded Values:
[CONSTP: Paper Construction Drawing]
, [CONSTD: Digital Construction Drawing]
, [RECP: Paper Record Drawing]
, ...30 more...
)
-
d_Status
(
type: esriFieldTypeString, alias: d_Status, length: 6
, Coded Values:
[ACT: Active]
, [CONST: Construction]
, [ABN: Abandon]
, ...3 more...
)
-
d_StreetLightLocation
(
type: esriFieldTypeInteger, alias: d_StreetLightLocation
, Coded Values:
[1: Along Street]
, [2: MidBlock]
, [9: Park]
, ...1 more...
)
-
d_PoleCategory
(
type: esriFieldTypeString, alias: d_PoleCategory, length: 6
, Coded Values:
[UNK: Unknown]
, [LP: Light Pole (stand alone)]
, [PD: Pedestrian scale light pole]
, ...7 more...
)
-
X_POLE
(
type: esriFieldTypeString, alias: X_POLE, length: 6
)
-
Y_POLE
(
type: esriFieldTypeString, alias: Y_POLE, length: 6
)
-
d_PoleMaterial
(
type: esriFieldTypeString, alias: d_PoleMaterial, length: 6
, Coded Values:
[AL: Aluminum]
, [CN: Concrete]
, [CN-OCT: Concrete - Octagonal]
, ...6 more...
)
-
WATTAGE
(
type: esriFieldTypeDouble, alias: WATTAGE
)
-
HEIGHT
(
type: esriFieldTypeDouble, alias: HEIGHT
)
-
ARM_LEN
(
type: esriFieldTypeDouble, alias: ARM_LEN
)
-
d_Luminaire
(
type: esriFieldTypeString, alias: d_Luminaire, length: 7
, Coded Values:
[COBRA: Cobra]
, [SHOEBOX: Shoebox]
, [PED: Pedestrian]
, ...2 more...
)
-
LUM_NUM
(
type: esriFieldTypeInteger, alias: LUM_NUM
)
-
d_Lamp
(
type: esriFieldTypeString, alias: d_Lamp, length: 6
, Coded Values:
[MH: Metal Halide]
, [MV: MV]
, [HPS: High Pressure Sodium]
, ...2 more...
)
-
PHOTOCELL
(
type: esriFieldTypeSmallInteger, alias: PHOTOCELL
, Coded Values:
[0: No]
, [1: Yes]
, [9: Unknown]
)
-
d_BillingSchedule
(
type: esriFieldTypeString, alias: d_BillingSchedule, length: 6
, Coded Values:
[26: Redmond Owned, PSE Maintained]
, [53: PSE Owned & Maintained]
, [54: Redmond Owned & Maintained (No new lights here)]
, ...2 more...
)
-
LightOn
(
type: esriFieldTypeSmallInteger, alias: LightOn
, Coded Values:
[0: No]
, [1: Yes]
, [9: Unknown]
)
-
EnergizeDate
(
type: esriFieldTypeString, alias: EnergizeDate, length: 255
)
-
OwnershipDate
(
type: esriFieldTypeDouble, alias: OwnershipDate
)
-
d_ConstBy
(
type: esriFieldTypeString, alias: d_ConstBy, length: 6
, Coded Values:
[CIP: Capital Improvement Project]
, [DEV: Private Developer]
, [ANX: Annexation]
, ...5 more...
)
-
COMMENTS
(
type: esriFieldTypeString, alias: COMMENTS, length: 50
)
-
CreatedBy
(
type: esriFieldTypeString, alias: CreatedBy, length: 50
)
-
DateCreated
(
type: esriFieldTypeDate, alias: DateCreated, length: 8
)
-
ModifiedBy
(
type: esriFieldTypeString, alias: ModifiedBy, length: 50
)
-
DateModified
(
type: esriFieldTypeDate, alias: DateModified, length: 8
)
-
d_Lumens
(
type: esriFieldTypeInteger, alias: d_Lumens
, Coded Values:
[5100: 5100]
, [7100: 7100]
, [8800: 8800]
, ...8 more...
)
-
AssetID
(
type: esriFieldTypeString, alias: AssetID, length: 30
)
-
LucityAutoNumber
(
type: esriFieldTypeInteger, alias: LucityAutoNumber
)
-
d_AssetType
(
type: esriFieldTypeString, alias: d_AssetType, length: 30
, Coded Values:
[Aquatic: Aquatic]
, [Art: Art]
, [AssetRepair: AssetRepair]
, ...70 more...
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata