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/2019 15:00
Last Source Update 02/14/2019 06:24
Maintenance/Update Frequency Weekly
Extent Clackamas County, Multnomah County, and Washington County, Oregon
Data Type Vector
Shape Type Point
Feature Count 62466
Horizontal Position Accuracy
Horizontal Position Accuracy Link Taxlots
Progress Complete
North Bounding Coordinate 727310.557063177
South Bounding Coordinate 649240.000000015
East Bounding Coordinate 7697812
West Bounding Coordinate 7604590.75022587
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 None
Use Constraints These data are distributed uner the terms of the City of Portland Data Distribution Policy.
Source Dataset Type File 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
Joseph Neilson
503-823-5636
Joseph.Neilson@portlandoregon.gov
1120 SW 5th Ave., Suite 800
Portland, OR 97204

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

Web Services

Service Layer Cached
Transportation Street Lights No
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 AssetID AssetID String 15
Add
X
1 LightID LightID_ Integer 4
Add
X
1 LocationID LocationID String 15
Add
X
1 ImagePath ImagePath String 255
Add
X
1 ElectricMountOID ElectricMountOID Integer 4
Add
X
1 StLightCircuitOID StLightCircuitOID Integer 4
Add
X
1 Rotation Rotation Numeric 8
Add
X
1 LIP LIP String 15
Add
X
1 Owner Owner String 15
Add
X
1 MaintResp MaintResp String 15
Add
X
1 PowerSupplier PowerSupplier String 8
Add
X
1 IsMetered IsMetered String 1
Add
X
1 Engineer Engineer String 30
Add
X
1 Electrician Electrician String 30
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 LampCodeDesc LampCodeDesc String 100
Add
X
1 MastArmLength MastArmLength Integer 2
Add
X
1 PoleNumber PoleNumber Integer 4
Add
X
1 Watts Watts String 6
Add
X
1 InspectDate InspectDate Date 8
Add
X
1 Problem Problem String 30
Add
X
1 LightSeqNo LightSeqNo Integer 4
Add
X
1 PGEMap PGEMap String 7
Add
X
1 STLLocation STLLocation String 55
Add
X
1 BillCode BillCode String 8
Add
X
1 LuminaireType LuminaireType String 15
Add
X
1 PGEAssetNum PGEAssetNum Integer 4
Add
X