Metadata: Street Lights

Street Lights

Category Transportation - Assets
Feature Dataset Name STAND-ALONE
Item Name STREET_LIGHT_PDX
Database Type SDE
Originator City of Portland
Bureau Bureau of Transportation
Publication Date
Abstract Points representing the location of street lights in the City of Portland. Attribute information includes Asset ID, owner, maintainer, location ID, power supplier, and other relevant details.
Purpose For mapping and analysis of street lights in Portland.
Supplemental Information For information on the LED Street Light Conversion plan, visit https://www.portlandoregon.gov/transportation/66147.
Last Dataset Update 02/14/2025 19:49
Last Source Update 02/14/2025 05:00
Maintenance/Update Frequency Weekly
Extent Clackamas County, Multnomah County, and Washington County, Oregon
Data Type Vector
Shape Type Point
Feature Count 64392
Horizontal Position Accuracy
Horizontal Position Accuracy Link Taxlots
Progress Complete
North Bounding Coordinate 727310.571632828
South Bounding Coordinate 649239.9870152
East Bounding Coordinate 7697812.15395624
West Bounding Coordinate 7604590.59823626
Theme Keyword(s) transportation, assets, street lights, LED
Theme Keyword Thesaurus None
Place Keyword(s) Portland, Multnomah County, Washington County, Clackamas County, Oregon
Place Keyword Thesaurus None
Access Constraints Available for Public Use
Use Constraints These data are distributed under the terms of the City of Portland Data Distribution Policy. Care was taken in the creation of this data but it is provided "as is".

The City of Portland cannot accept any responsibility for errors, omissions, or positional accuracy.
Source Dataset Type Enterprise Geodatabase
Output Geodatabase ASSETS_PDOT
Distribution Grid: State plane coordinate system 1983(91).
Units: International feet
Datum: North American Datum of 1983/1991 (HPGN)
Liability: The information in this file was derived from digital databases on the City of Portland GIS. Care was taken in the creation of this file. The City cannot accept any responsibility for errors, omissions, or positional accuracy. There are no warranties, expressed or implied.
Format: Shapefile or File Geodatabase Feature Class - Data will be provided via City of Portland FTP Site.
Online Resource: http://portlandmaps.com/opendata
Online Instructions: City of Portland Public/Open Data is distributed via the PortlandMaps Open Data Site - http://portlandmaps.com/opendata. Data not available on the PortlandMaps Open Data site can be requested by contacting the City of Portland CGIS Group - maps@portlandoregon.gov
Transfer Size: varies
SPCS Zone Identifier: 5076
Contact(s)
Add
PBOT GIS Support
503-823-5185
PBOTGISSupport@portlandoregon.gov
1120 SW Fifth Ave., Suite 1331
Portland, OR 97204

City of Portland - PBOT
503-823-5185
PBOTFrontDesk@portlandoregon.gov
File(s)
Add
Images
52801.png 97.99Kb X
Lineage
Add

Web Services

Service Description Feature Access Layer
PBOT_DefaultLayers This service includes an array of asset, permitting, planning and project data to serve as a general reference for PBOT staff working remotely. Dynamic Street Lights
PBOT_Assets This service includes an array of asset data to serve as a general reference for public-facing web applications. Dynamic Street Lights
Transportation Transportation Layers Dynamic Street Lights
Add

Attribute Tables & Domains

X
street_light_pdx
Table Description
Table Jurisdiction
Column Sort Column Name Column Alias Column Type Column Size Domain Value(s) Column Description
Add
1 PowerSupplier PowerSupplier String 8
Add
X
1 IsMetered IsMetered String 1
Add
X
1 SupplyVoltage SupplyVoltage String 12
Add
X
1 Manufacturer Manufacturer String 24
Add
X
1 SerialNumber SerialNumber String 50
Add
X
1 LampCode LampCode String 4
Add
X
1 MastArmLength MastArmLength Integer 2
Add
X
1 LuminaireType LuminaireType String 15
Add
X
1 PGEAssetNum PGEAssetNum String 255
Add
X
1 LampHeight LampHeight Numeric 8
Add
X
1 ColorTemp ColorTemp String 10
Add
X
1 ServiceLocation ServiceLocation String 100
Add
X
1 Lumen Lumen String 10
Add
X
1 CompanyPoleID CompanyPoleID String 50
Add
X
1 LuminaireColor LuminaireColor String 15
Add
X
1 LuminaireModelNumber LuminaireModelNumber String 100
Add
X
1 BillCode BillCode String 8
Add
X
1 STLLocation STLLocation String 100
Add
X
1 PGEMap PGEMap String 7
Add
X
1 LightSeqNo LightSeqNo Integer 4
Add
X
1 Watts Watts String 6
Add
X
1 MaintResp MaintResp String 15
Add
X
1 Owner Owner String 15
Add
X
1 LIP LIP String 15
Add
X
1 Rotation Rotation Numeric 8
Add
X
1 StLightCircuitOID StLightCircuitOID Integer 4
Add
X
1 ElectricMountOID ElectricMountOID Integer 4
Add
X
1 ImagePath ImagePath String 255
Add
X
1 LocationID LocationID String 15
Add
X
1 AssetID AssetID String 15
Add
X