20240102
15160500
1.0
FALSE
ETS_Street_Lighting
7499995.849869
7628257.927653
618518.487672
723586.776488
1
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot (0.304800)
NAD_1983_HARN_StatePlane_Oregon_North_FIPS_3601_Feet_Intl
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WKT>PROJCS["NAD_1983_HARN_StatePlane_Oregon_North_FIPS_3601_Feet_Intl",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",8202099.737532808],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-120.5],PARAMETER["Standard_Parallel_1",44.33333333333334],PARAMETER["Standard_Parallel_2",46.0],PARAMETER["Latitude_Of_Origin",43.66666666666666],UNIT["Foot",0.3048],AUTHORITY["EPSG",2913]]</WKT><XOrigin>-111333600</XOrigin><YOrigin>-98152500</YOrigin><XYScale>3047.9939040000022</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808464567060333</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2913</WKID><LatestWKID>2913</LatestWKID></ProjectedCoordinateSystem>
20240102
15160600
20240103
11402900
150000000
5000
NAP
Street Lighting
vector digital data
2016-01-01T00:00:00
Traffic Engineering GIS Analyst
Washington County, Oregon
'Streetlight
street light
luminaire
lighting
Road Engineering
ETS
traffic
traffic engineering'
This point layer represents streetlights along Washington County maintained right-of-ways for the purpose of asset management.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Streetlight points are digitized at the pole base and are attributed with information about physical characteristics, ownership and maintenance responsibility.</SPAN></P></DIV></DIV></DIV>
Washington County, Oregon
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The geographic data layers produced by the Government of Washington County, Oregon (“Washington County”), and any associated maps and applications, are provided as a public resource. While every reasonable effort is made to ensure the accuracy and completeness of the data, Washington County makes no warranties, expressed or implied, including but not limited to any warranties of merchantability and fitness for a particular purpose concerning the accuracy, completeness or suitability of its data, and this data should not be construed or used as a legal description of any parcel of real property. Washington County will not assume any liability for errors, omissions, or inaccuracies in the data. Any determination of topography or contours, or any depiction of physical improvements, property lines or boundaries, parcel size or shape is for general information only and shall not be used for the design, modification, purchase, lease, development or construction of real property or improvements to real property, for flood plain or wetlands determination or as evidence in any legal proceeding. Copyright by Washington County. Except as provided herein, all rights are reserved. Authorization to reproduce material for internal or personal use by any user of this information is granted by Washington County, the copyright owner. Please email GISAppSupport@co.washington.or.us to report any errors or issues or to get more information about Washington County’s geospatial data, maps or applications.</SPAN></P></DIV></DIV></DIV>
Esri ArcGIS 12.9.4.32739
1
-123.244560
-122.732118
45.629540
45.330676
external
45717b49813b376fe1d020b3889a6a83e3d55b22
Traffic Engineering GIS Analyst
Washington County, Oregon
True
Traffic Engineering GIS Analyst
external
45717b49813b376fe1d020b3889a6a83e3d55b22
Traffic Engineering GIS Analyst
Washington County, Oregon
True
Traffic Engineering GIS Analyst
Enterprise Geodatabase Feature Class
dataset
EPSG
6.3(9.0.0)
21432
Simple
FALSE
21432
TRUE
FALSE
Street Lighting
Feature Class
21432
AssetID
AssetID
String
50
0
0
The unique identifier used to link asset to the enterprise asset management system.
Location
Location
String
255
0
0
A description of the streetlight's physical location.
LightStatus
Status
String
50
0
0
The status of the streetlight indicates where the asset is in it's life cycle.
Proposed: A streetlight has a status of "Proposed" when the plans have been approved, but construction has not yet occurred. Pending: A streetlight has a status of "Pending" when the streetlight has been installed but has not been energized by PGE.
Energized: A streetlight has the status of "Energized" when the Letter of Authorization (LOA) has been signed by the County's Transportation Engineer and PGE's installation team.
Out of Service: A streetlight has the status of "Out of Service" when a streetlight is no longer energized but has not been physically removed.
Removed: A streetlight point has the status of "Removed" when the physical asset no longer exists, but the point is kept for historical records.
Unknown
Delete: A streetlight has the status of "Delete" when the asset should be removed from the dataset.
InstallDate
InstallDate
Date
8
0
0
The date of energization.
DecommissionedDate
DecommissionedDate
Date
8
0
0
Date of de-energization.
Condition
Condition
SmallInteger
2
5
0
This field is required as part of the Enterprise Asset Management System. This field is currently not being utilized. A rating of 1-100 that describe the condition of the light.
ConditionDate
ConditionDate
Date
8
0
0
This field is required as part of the Enterprise Asset Management System. This field is currently not being utilized. The date when the Condition field is populated/updated.
InServiceDate
InServiceDate
Date
8
0
0
This field is required as part of the Enterprise Asset Management System. This field is currently not being utilized.
ExpectedLife
ExpectedLife
Double
8
9
4
This field is required as part of the Enterprise Asset Management System. This field is currently not being utilized.
AcquisitionCost
AcquisitionCost
Double
8
9
4
This field is required as part of the Enterprise Asset Management System. This field is currently not being utilized.
ReplacementCost
ReplacementCost
Double
8
9
4
This field is required as part of the Enterprise Asset Management System. This field is currently not being utilized.
WarrantyDate
WarrantyDate
Date
8
0
0
This field is required as part of the Enterprise Asset Management System. This field is currently not being utilized.
LegacyID
LegacyID
String
30
0
0
This field is required as part of the Enterprise Asset Management System. This field is currently not being utilized.
RoadNumber
RoadNumber
String
30
0
0
The County designated Road Number for unique identification.
BeginMilepost
BeginMilepost
Double
8
8
4
The milepost at which the streetlight is located along the County road.
EndMilepost
EndMilepost
Double
8
8
4
This field is required as part of the Enterprise Asset Management System. This field is currently not being utilized.
LightOwner
Owner
String
50
0
0
This streetlight Owner. Domain options include: PGE
Washington County
ODOT
ODOT-Washington County
Beaverton
Cornelius
Forest Grove
Hillsboro
King City
North Plains
Portland
Sherwood
Tigard
Tualatin
Hillsboro Fire
Beaverton School District
Hillsboro School District
Portland Community College
THPRD
TriMet
private
Unknown
TVF&R
Banks
LightMaintainer
Maintainer
String
50
0
0
The organization responsible for the streetlight's maintenance and end of life replacement.
AssessmentArea
Assessment Area
SmallInteger
2
5
0
The Assessment Area is the SDL area the streetlight is billed to. This field is used only for the Service District Lights (SDL) and their billing.
COMMENT
Comment
String
1000
0
0
Unique or additional information about the streetlight.
PGE_ID
POLEPGEDB
Double
8
16
0
This field is used to correlate the streetlight point with the corresponding PGE streetlight data point. PGE calls this their MAXASSETID.
PGE_BillCode
PGE Bill Code
Integer
4
10
0
This is used for electrical billing from PGE. 46200 - SDL (Service District Lighting)
46500 - Road Fund
PoleHeight
Pole Height
SmallInteger
2
5
0
The height in feet of the streetlight pole. This field is not always filled in.
PoleCode
Pole Code
String
50
0
0
The PGE designated Pole Code. Domain values include: 1 - 35 ft or less SLO Wood Pole owned by PGE
2 - 30 Bill as SLO (Code 1) Aluminum Post owned by PGE
3 - 40' to 55' SLO Wood Pole owned by PGE
4 - 25 ft Ameron Post Top Concrete Pole owned by PGE
5 - 25 ft Ameron Post Top Concrete Pole owned by Customer
6 - 30' Davit Type Aluminum Pole owned by PGE
7 - 25' Regular Type Painted Steel Pole owned by Customer
8 - 25' Regular Type Aluminum Pole owned by Customer
9 - Srvc prior to 7/1/60; Underground service Ornamental Post owned by Customer
10 - 11 - 35' Painted Wood Pole owned by PGE
12 - 30' Davit Type Aluminum Pole owned by Customer
13 - 25' Davit Type Aluminum Pole owned by Customer
14 - 30' Double Davit Type Aluminum Pole owned by Customer
15 - Twin Luminaires Ornamental Post owned by Customer
16 - 35' Gray Anchor base Mast Arm Fiberglass Pole owned by PGE
17 - 35' Gray Anchor base Fiberglass Pole owned by Customer
18 - 25' Davit Type Aluminum Pole owned by PGE
19 - Pole or Post Maintained by Customer Other than Standard Wood owned by Customer
20 - owned by Customer, This value is used by Washington County for lights on Signal Poles
21 - 30' Unpainted Steel Pole owned by Customer
22 - 35' Billed as (Code 1) - SLO Wood Pole Painted Wood Pole owned by PGE
23 - 20' No Mast Arm Laminated Wood Post owned by Customer
24 - 20' Billed as (Code 1) - SLO Wood Pole Laminated Wood Post owned by PGE
25 - 35' or less Billed as (Code 8) Ornamental Concrete Pole owned by Customer
26 - 35' or less Underground Painted Wood Pole owned by Customer
27 - 30' or less Double Davit Type Aluminum Pole owned by PGE
28 - 35' Regular Aluminum Pole owned by PGE
29 - 35' DAVIT Aluminum Pole owned by PGE
30 - 35' or less Billed as (Code 32) Ornamental Concrete Pole owned by PGE
31 - 16' Regular, post top Aluminum Post owned by PGE
32 - 25 ft Regular Type Aluminum Pole owned by PGE
33 - 30' Regular Type Aluminum Pole owned by PGE
34 - 16' Regular Type Aluminum Post owned by Customer
35 - 18' Direct bury with shroud Fiberglass Pole owned by PGE
36 - 18' Black Direct bury with shroud Fiberglass Pole owned by Customer
37 - 25' Regular Type Painted Steel Pole owned by PGE
38 - 30' Regular Type Painted Steel Pole owned by PGE
39 - 20' or less No Mast Arm Laminated Wood Post owned by PGE
40 - 35' 8 ' mast arm Unpainted Steel Pole owned by Customer
41 - 30' or less Curved Laminated Wood Pole owned by PGE
42 - 35' 8' DAVIT ARM Unpainted Steel Pole owned by Customer
43 - 35' Painted Ornamental Aluminum Pole owned by PGE
44 - 35' Painted Ornamental Aluminum Pole owned by Customer
45 - 30' or less Curved Laminated Wood Pole owned by Customer
46 - 30 and 35' or less SLO Wood Pole owned by Customer
47 - 40'- 55' SLO Wood Pole owned by Customer
48 - 30' Regular Type Aluminum Pole owned by Customer
49 - 30' Regular Type Painted Steel Pole owned by Customer
50 - 51 - 30' 6' Davit Type Unpainted Steel Pole owned by Customer
52 - 53 - 35' Davit Type Aluminum Pole owned by Customer
54 - 35' Regular Aluminum Pole owned by Customer
55 - 12' Bronze Octagonal Bronze alloy GardCo Post owned by Customer
56 - 30 Bronze Fiberglass Pole owned by PGE
57 - 20' Black DB black, post top, color may vary Fiberglass Pole owned by PGE
58 - 20' Black DB Black, post top, color may vary Fiberglass Pole owned by Customer
59 - 30' Bronze Bronze fiberglass pole Fiberglass Pole owned by PGE
60 - 30' Bronze Fiberglass Pole, Mast Arm Fiberglass Pole owned by Customer
61 - 30' Gray Fiberglass Pole owned by PGE
62 - 30' Gray Gray Aluminum Fiberglass Pole owned by Customer
63 - 14' Black Fluted HADCO, post top Ornemental Fiberglass Pole owned by PGE
64 - 14' Black Fluted HADCO, post top Ornemental Fiberglass Pole owned by Customer
65 - 14' Fluted HADCO, post top Ornamental Aluminum Pole owned by PGE
66 - 16' Fluted HADCO, post top Ornamental Aluminum Pole owned by PGE
67 - 22' Black Regular Type, color may vary Fiberglass Pole owned by PGE
68 - 35' Gray or Bronze Regular Type, color may vary Fiberglass Pole owned by PGE
69 - 18' Non-Fluted HADCO, Techtra Ornamental Aluminum Pole owned by PGE
70 - 40' Davit Type 8 ft. Mast arm Aluminum Pole owned by PGE
71 - 14' Fluted HADCO, post top Ornamental Aluminum Pole owned by Customer
72 - 16' Fluted HADCO Ornamental Aluminum Pole owned by Customer
73 - 22' Regular Type, color may vary Fiberglass Pole owned by Customer
74 - 35' Regular Type, color may vary Fiberglass Pole owned by Customer
75 - 18' Non-Fluted HADCO, Techtra Ornamental Aluminum Pole owned by Customer
76 - 40' Davit Type 8 ft. arm Aluminum Pole owned by Customer
77 - 16' Non-Fluted HADCO. Ornamental Aluminum Pole owned by PGE
78 - Non-fluted HADCO Ornamental Aluminum Pole owned by Customer
79 - 18' HADCO Fluted Westbrooke Aluminum Pole owned by PGE
80 - 18' FLUTED Westbrooke Aluminum Pole owned by Customer
81 - 18' HADCO Non-fluted Ornamental Westbrooke Ornamental Aluminum Pole owned by PGE
82 - 18' HADCO Non-fluted Ornamental Westbrooke Ornamental Aluminum Pole owned by Customer
83 - 18' Fibergalss, smooth Fiberglass Pole owned by PGE
84 - 18' Fiberglass, smooth Fiberglass Pole owned by Customer
85 - 20 Concrete, Decorative Ameron Concrete Pole owned by Customer
86 - 20 Concrete, Decorative Ameron Concrete Pole owned by Customer
87 - Fiberglass, Portland Rd Fiberglass Pole owned by PGE
88 - Fiberglass, Portland Rd Fiberglass Pole owned by Customer
30' Fiberglass, ANCHOR BASE, Color may vary
35' Aluminum, Regular with Breakaway Base
35' Aluminum, Regular with Breakaway Base
25' Aluminum, Double-Davit Smooth
25' Aluminum, Double-Davit Smooth
0 - No Charge Pole owned by PGE
PoleColor
Pole Color
String
15
0
0
The color of the pole. No value indicates typical color. Domain values inclue:
Unpainted
Grey
Bronze
Black
White
Voltage
Voltage
Integer
4
10
0
The luminaire's voltage. This field is inconsistently used.
MountHeight
MountHeight
Integer
4
10
0
The height of the light on the pole. This field is inconsistently used.
PGElightID
PGElightID
String
15
0
0
This field is used to correlate the streetlight point with the corresponding PGE streetlight data point. This is the PGE ID number that can be found on the pole tag if the light is Owned or Maintained by PGE.
LampOption
Light Option
String
15
0
0
The option of the streetlight is based on the Owner and Maintainer fields.
A - Owned and Maintained by PGE
B - Owned by Washington County, Maintained by PGE
C - Owned and Maintained by Washington County
None
C32 - This value is being phased out. These are metered lights, Owned and Maintained by Washington County.
LampCode
Lamp Code
String
5
0
0
The PGE designated lamp code. Domains include:
0 - No Light 1 - 165 watt Q. I. Icandescent SPECIAL ACORN Special Acorn Type 12000 lumens
2 - 85 watt Q. I. Icandescent SPECIAL ACORN FIXTURE Special Acorn Type 6000 lumens
3 - 165 watt Q. I. Icandescent SPECIAL TECHTRA, 12000 lumens
4 - Icandescent 5 - Icandescent INCANDESCENT 1000 lumens
6 - Icandescent INCANDESCENT 2500 lumens
7 - 28 watt Compact Flourescent Comp Flourescent Bollard 9 - 150 watt HPS HPS COBRA MONGOOSE Cobra Head 16000 lumens
10 - 250 watt HPS Cobra Mongoose Cobra Head 29000 lumens
11 - 400 watt HPS 50000 lumens
12 - 100 watt HPS HADCO Independence Town and Country Post Top 9500 lumens
13 - 150 watt HADCO Independence Town and Country Post Top 16000 lumens
14 - 100 watt HPS All Fixture Types 9500 lumens
15 - 100 watt HPS All Fixture Types Twin Ornamental 9500 lumens
18 - 85 watt Q. I. Icandescent Acorn Twin Ornamental 9600 lumens
19 - 100 watt Mercury Vapor Deluxe white cobra head 4000 lumens
20 - 55 watt Q. I. Icandescent Ornamental Acorn Special Acorn Type 2800 lumens
21 - 175 watt Mercury Vapor Deluxe White Cobra Head 7000 lumens
22 - 250 watt Mercury Vapor Deluxe White Cobra Head 10000 lumens
23 - 400 watt Mercury Vapor Deluxe White Cobra Head 21000 lumens
24 - 1000 watt Mercury Vapor Deluxe White Cobra Head 55000 lumens
25 - 70 watt HPS Town and Country Post Top 6300 lumens
26 - 55 watt Q. I. Icandescent Acorn Twin Ornamental 5600 lumens
27 - 70 watt HPS Not Assigned. Cobra Head or Flood 6300 lumens
29 - 175 watt Mercury Vapor Town and Country Post Top 7000 lumens
30 - 100 watt HPS Floodlight 9500 lumens
31 - 250 watt HPS Floodlight 27500 lumens
32 - 400 watt HPS Floodlight 50000 lumens
33 - 70 watt HPS Cobra Head or Flood 6300 lumens
34 - 100 watt HPS Cobra Head or Flood 9500 lumens
35 - 150 watt HPS Cobra Head 16000 lumens
36 - 250 watt HPS Cobra Head 27500 lumens
37 - 400 watt HPS Cobra Head 50000 lumens
38 - 200 watt HPS Floodlight 22000 lumens
39 - 200 watt HPS Cobra Head or Flood 22000 lumens
40 - 100 watt HPS GE Town and Country Post Top 9500 lumens
41 - 310 watt HPS Power Door Cobra Head 37000 lumens
43 - 200 watt HPS KIM ET Rectangular Box 22000 lumens
44 - 140 watt Twin Ornamental 6815 lumens
45 - 175 watt Twin Ornamental 9815 lumens
46 - 175 watt Mercury Vapor Rectangular Space Glow 7000 lumens
47 - 750 watt HPS Floodlight 110000 lumens
48 - 175 watt Metal Halide Cobra Head 12000 lumens
49 - 200 watt HPS HADCO Victorian Special Acorn Type 22000 lumens
50 - 70 watt HPS Rectangular Space Glow 6300 lumens
51 - 70 watt HPS All Twin Fixture Types Twin Ornamental 6300 lumens
52 - 70 watt HPS All Fixture Types Rectangular 6300 lumens
53 - 100 watt HPS GardCo Hub Rectangular 9500 lumens
54 - 150 watt HPS GardCo Hub Rectangular 16000 lumens
55 - 250 watt HPS HADCO Hub Rectangular 27500 lumens
56 - 400 watt HPS HADCO Hub Rectangular 50000 lumens
58 - 250 watt Metal Halide GardCo Hub Rectangular Pos. Socket, Arch Lamp 20500 lumens
59 - 400 watt Metal Halide GardCo Hub Rectangular Pos. Socket, Arch Lamp 40000 lumens
60 - 400 watt Metal Halide Floodlight 40000 lumens
61 - 350 watt Metal Halide Floodlight 62 - 150 watt Metal Halide Cobra Head or Flood 10000 lumens
64 - 100 watt HPS HADCO Capital Acorn Special Acorn Type 9500 lumens
65 - 200 watt HPS HADCO Capital Acorn Special Acorn Type 22000 lumens
66 - 250 watt HPS HADCO Capital Acorn Special Acorn Type 27500 lumens
67 - 150 watt HPS HADCO Capital Acorn Special Acorn Type 16000 lumens
69 - 70 watt HPS Dual Wattage Cobra Head 70 - 100 watt HPS Dual Wattage Cobra Head 71 - 150 watt HPS Dual Wattage Cobra Head 72 - 175 watt Mercury Vapor GardCo 42 inch Oct. Form 5 Post Top 7000 lumens
73 - 70 watt HPS GardCo, Bronze Aluminium 42 inch Oct. Form 5 Post Top 6300 lumens
74 - 400 watt Mercury Vapor Acrylic Sphere 21000 lumens
76 - 70 watt HPS PGE approved manufacturers only Rectangular Box 6300 lumens
77 - 100 watt HPS Rectangular Box 9500 lumens
78 - 150 watt HPS Rectangular Box 16000 lumens
79 - 70 watt HPS Powerdoor Cobra Head 6300 lumens
80 - 70 watt HPS Special Acorn Type 6300 lumens
81 - 100 watt HPS Special Acorn Type 9500 lumens
82 - 150 watt HPS HADCO Victorian Special Acorn Type 16000 lumens
83 - 250 watt HPS HADCO Victorian Special Acorn Type 27500 lumens
84 - 100 watt HPS Power Door Cobra Head 9500 lumens
85 - 150 watt HPS Power Door Cobra Head 16000 lumens
86 - 250 watt HPS Power Door Cobra Head 27500 lumens
87 - 400 watt HPS Power Door Cobra Head 50000 lumens
88 - 250 watt HPS HADCO Techtra Special Decorative Type 27500 lumens
89 - 200 watt HPS Power Door Cobra Head 22000 lumens
90 - 70 watt HADCO Westbrooke Special Acorn Type 6300 lumens
91 - 100 watt HPS HADCO Westbrooke Special Acorn Type 9500 lumens
92 - 150 watt HPS HADCO Westbrooke Special Acorn Type 16000 lumens
93 - 200 watt HPS HADCO Westbrooke Special Acorn Type 22000 lumens
94 - 250 watt HPS HADCO Westbrooke Special Acorn Type 29000 lumens
95 - 150 watt HPS KIM SBC Architectural Box 16000 lumens
96 - 250 watt HPS KIM Archetype Architectural Box 27500 lumens
97 - 400 watt HPS KIM Archetype Architectural Box 50000 lumens
98 - 100 watt HPS HADCO Techtra Special Decorative Type 9500 lumens
99 - 100 watt HPS HPS Techtra AA - 36 watt LED 2530-2665 Lumens Roadway Fixture AB - 49 watt LED 3391-3730 Lumens Roadway Fixture AC - 53 watt LED 3913-4432 Lumens Roadway Fixture AD - 67 watt LED 5220-5921 lumens Roadway Fixture AE - 106 watt LED 8195-8766 Lumens Roadway Fixture AF - 134 watt LED Leotek Cobra Cobra Head or Flood 14200 lumens
AG - 156 watt LED Leotek Cobra Cobra Head or Flood 16300 lumens
AH - 176 watt LED Leotek Cobra Cobra Head or Flood 18300 lumens
AI - 201 watt LED 201W led Leoteck Cobra Cobra Head or Flood 21400 lumens
AJ - 111-120W LED ROADWAY
AK - 121-130W LED ROADWAY
AL - 141-150W LED ROADWAY
AM - 161-170W LED ROADWAY
AN - 181-190W LED ROADWAY
AP - 36-40W LED ROADWAY
AQ - 56-60W LED Roadway
AR - 61-65W LED ROADWAY
AS - 71-75W LED ROADWAY
AT - 76-80W LED ROADWAY
AU - 81-85W LED ROADWAY
AV - 91-95W LED ROADWAY
AW - 96-100W LED ROADWAY
BA - 60 watt LED 60W LED Acrylic Washington Postlite Acorn 5489 lumens
BB - 70 watt LED LED Washington Postlite FCO (Globeless) Roadway Fixture 4332 lumens
BC - 53 watt LED LED Westbrooke (non-flare) Roadway Fixture 5079 lumens
BD - 69 watt LED 69W led Westbrooke (Non-flare) 6661 lumens
BE - 85 watt LED LED Westbrooke Roadway Fixture 8153 lumens
BF - 136 watt LED 136W LED Westbrooke (Non-flare) 12687 lumens
BG - 206 watt LED 206W LED Westbrooke (Non-flare) 18159 lumens
BH - 53 watt LED 5,079 Lumens Westbrooke Roadway Fixture 5079 lumens
BI - 69 watt LED 69w LED Westbrooke (Flare) 6,661 lumens 6661 lumens
BJ - 85 watt LED 85W LED Westbrooke (Flare) 8153 lumens
BK - 41-45W LED ROADWAY
BL - 51-55W LED ROADWAY
BM - 61-65W LED ROADWAY
CA - 136 watt LED 136W LED Westbrooke (Flare) 12687 lumens
CB - 206 watt LED 206W LED Westbrooke (Flare) 18159 lumens
CH - 36 watt LED 36W LED Westbrooke (Non-flare) 3369 lumens
CI - 36 watt LED 36w LED Flared Westbrooke style Roadway Fixture 3369 lumens
CJ - 45 watt LED 39W LED Town & Country 3,395 Lumens 3395 lumens
CK - 41-45W LED ROADWAY
CL - 46-50W LED ROADWAY
CM - 56-60W LED ROADWAY
CN - 61-65W LED ROADWAY
CO - 71-75W LED ROADWAY
CP - 76-80W LED ROADWAY
DA - 72 watt LED 72w LED Post top American Revolution style luminaire Roadway Fixture 4409 lumens
DB - 70 watt LED Hadco Acorn Special Acorn Type 5120 lumens
DC - 160 watt LED 160W LED Roadway 18700 lumens, 3000k, 7 pin
DD - 29 watt LED 29W LED ROADWAY, 3470 LUMENS, 3000K, 7 PIN
DE - 45 watt LED 45W LED ROADWAY, 5020 LUMENS, 3000K, 7 PIN
DF - 88 watt LED 88W LED ROADWAY, 10230 LUMENS, 3000K, 7 PIN
DH - 38 watt LED 38W LED ACORN, 3000K 7 PIN, GLOBELESS (HOLOPHANE) Special Acorn Type DI - 60 watt LED 60W LED ACORN, 3000K, 7 PIN GLOBELESS (YARMOUTH) Special Acorn Type DJ - 75 watt LED 75W LED ACORN, 3000K, 7 PIN, GLOBELESS (YARMOUTH) Special Acorn Type EA - 128 watt LED LED FLOOD, DIRECTIONAL, BRONZE, 4000K, 7 PIN Floodlight EB - 184 watt LED LED FLOOD, DIRECTIONAL, BRONZE, 4000K, 7 PIN Floodlight EC - 371 watt LED LED FLOOD, DIRECTIONAL, BRONZE, 4000K, 7 PIN Floodlight ED - 85 watt LED LED FLOOD, DIRECTIONAL BRONZE, 4000K, 7 PIN Floodlight EF - 5-10W LED Option C
EG - 10-15W LED Option C
EH - 15-20W LED Option C
EI - 25 watt LED Energy Use Only (Option C) EJ - 30 watt LED Energy Use Only (Option C) FA - 35 watt LED Energy Use Only (Option C) FB - 40 watt LED Energy Use Only (Option C) FC - 45 watt LED Energy Use Only (Option C) FD - 50 watt LED Energy Use Only (Option C) FE - 55 watt LED Energy Use Only (Option C) FF - 60 watt LED Energy Use Only (Option C) FG - 65 watt LED Energy Use Only (Option C) FH - 70 watt LED Energy Use Only (Option C) FI - 75 watt LED Energy Use Only (Option C) FJ - 80 watt LED Energy Use Only (Option C) GA - 85 watt LED Energy Use Only (Option C) GB - 90 watt LED Energy Use Only (Option C) GC - 95 watt LED Energy Use Only (Option C) GD - 100 watt LED Energy Use Only (Option C) GE - 110 watt LED Energy Use Only (Option C) GF - 120 watt LED Energy Use Only (Option C) GG - 130 watt LED Energy Use Only (Option C) GH - 140 watt LED Energy Use Only (Option C) GI - 150 watt LED Energy Use Only (Option C) GJ - 160 watt LED Energy Use Only (Option C) HA - 170 watt LED Energy Use Only (Option C) HB - 180 watt LED Energy Use Only (Option C) HC - 190 watt LED Energy Use Only (Option C) HD - 200 watt LED Energy Use Only (Option C) HE - 210 watt LED Energy Use Only (Option C) HF - 220 watt LED Energy Use Only (Option C) HG - 230 watt LED Energy Use Only (Option C) HH - 240 watt LED Energy Use Only (Option C) HI - 250 watt LED Energy Use Only (Option C) HJ - 260 watt LED Energy Use Only (Option C) IA - 270 watt LED Energy Use Only (Option C) IB - 280 watt LED Energy Use Only (Option C) IC - 290 watt LED Energy Use Only (Option C) ID - 300 watt LED Energy Use Only (Option C)
Cabinet_Num
Cabinet_Num
String
15
0
0
The service cabinet that powers the streetlight.
PGE_MeterNumber
PGE_MeterNumber
Integer
4
10
0
If the service cabinet is metered, this is the associated meter number.
PGE_AccountNumber
PGE_Account
String
30
0
0
The PGE Account Number that the streetlight is billed under.
LampInstallDate
LampInstall
Date
8
0
0
This field is replaced by the InstallDate field and is no longer maintained.
MountLength
Mount Length (ft)
Double
8
16
3
The length of the mast arm on a cobra head streetlight in feet
Lamp_ProductNumber
Lamp_ProductNumber
String
100
0
0
When possible, this field is being populated with the luminaire's model number.
Lamp_SerialNumber
Lamp_SerialNumber
String
100
0
0
When possible, this field is being populated with the luminaire's serial code.
Rotation
Rotation
Integer
4
10
0
This field indicates the direction with respect to the pole that the light is mounted. This field is currently being maintained inconsistently.
IGA
IGA
String
50
0
0
Information will be entered here if the streetlight is part of an Intergovernmental Agreement (IGA), owned by another jurisdiction and maintained by Washington County.
ProjectID
ProjectID
String
55
0
0
The number of the development project that installed the streetlight. This field is used to link to the Asbuilt plans.
ProjectIDPg
ProjectIDPg
String
10
0
0
The page number of the asbuilt.
PGESchedule
LightSchedule
SmallInteger
2
5
0
This field defines the light tariff schedule for PGE. PGE assigns a rate based on the a combination of factors (light type, pole type, light option, and tariff schedule). The tariff schedule part of the rate is determined by the type of light (only if it is being billed as unmetered). For the purposes of this field it can only be 3 options:
91 - Schedule 91 - UNMETERED HPS lights (Option A, B, or C)
95 - Schedule 95 - UNMETERED LED lights (Option A or C)
32 - Schedule 32 - ALL METERED lights regardless if they are HPS or LED
PedScaleLighting
PedScaleLighting
String
25
0
0
This field indicates if the streetlight is used for pedestrian walkway lighting instead of roadways.
MicrowaveTower
MicrowaveTower
String
25
0
0
This field indicates if the streetlight pole has a Microwave Tower on it. This field is currently not being filled in.
SignalPole_AssetID
SignalPole_AssetID
String
50
0
0
The signal pole asset id number if the light is mounted on a signal pole. This field is currently not being filled in.
Signal_AssetID
Signal_AssetID
String
50
0
0
If the streetlight is on a signal pole, this field is for the signal asset ID.
RF_FixtureColorTemp
RF_FixtureColorTemp
String
50
0
0
This field is for tracking the fixture color temperature in Road Fund Lights. This field is currently not being filled in.
RF_FixtureHousingColor
RF_FixtureHousingColor
String
50
0
0
This field is for tracking the Fixture Housing Color in Road Fund streetlights. This field is currently not being filled in.
RoadName
Road Name
String
60
0
0
This is the name of the Road that the streetlight is located along.
20240103
670BE3A2-CCFF-4571-8268-FE3BD76BD869
external
45717b49813b376fe1d020b3889a6a83e3d55b22
Traffic Engineering GIS Analyst
Washington County, Oregon
True
Traffic Engineering GIS Analyst