Drinking Fountains
Category	Water Distribution System
Feature Dataset Name	STAND-ALONE
Item Name	DrinkingFountain
Database Type	SDE
Originator	City of Portland
Bureau	Portland Water Bureau
Publication Date
Abstract	Drinking Fountains
Purpose	To allow Bureau staff to design, construct, utilize, analyze and manage the Bureau's water supply and distribution system.
Supplemental Information
Last Dataset Update	05/14/2025 10:28
Last Source Update	05/10/2025 05:15
Maintenance/Update Frequency	As needed
Extent	City of Portland
Data Type	Vector
Shape Type	Point
Feature Count	135
Horizontal Position Accuracy
Horizontal Position Accuracy Link	Taxlots
Progress	Complete
North Bounding Coordinate	712711.703083992
South Bounding Coordinate	662965.361220479
East Bounding Coordinate	7689984.21653543
West Bounding Coordinate	7617052.98884514
Theme Keyword(s)	fountain, water, drinking, Benson
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	WATERUTILITIES.GDB
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
File(s) Add Add File File Description Cancel Add File
Images	53141.png 348.50Kb X
Lineage Add

Web Services

Service	Description	Feature Access	Layer
PWB_FacilityIDSearch		Dynamic	DrinkingFountain
Water_Utilities		Cached	DrinkingFountain
Water_Utilities_Infor_Sync	Service used by INFOR GIS SYNC	Dynamic	DrinkingFountain
CGIS_Layers		Dynamic	Drinking Fountain
Utilities_Water		Cached	DrinkingFountain

Attribute Tables & Domains

X DrinkingFountain
Table Description
Table Jurisdiction
Column Sort	Column Name	Column Alias	Column Type	Column Size	Domain Value(s)	Column Description Add
1	ACCOUNTID	ACCOUNTID	Numeric	8	Add	X
1	ADDRESSNUMBER	ADDRESSNUMBER	String	12	Add	X
1	FACILITYID	FACILITYID	Numeric	8	Add	X
1	SUBTYPE	Subtype	Integer	4	Add	X
1	TEMPUID	TEMPUID	Numeric	8	Add	X
1	COMMENTARY	COMMENTARY	String	120	Add	X
1	ENABLED	Enabled	Integer	2	Add	X
1	ANCILLARYROLE	AncillaryRole	Integer	2	Add	X
1	MODIFIEDBY	MODIFIEDBY	String	50	Add	X
1	MODIFIEDDATE	MODIFIEDDATE	Date	8	Add	X
1	STATUS	Status	String	5	Add	X
1	ANNEXATIONDATE	ANNEXATIONDATE	Date	8	Add	X
1	ANNEXED	ANNEXED	String	3	Add	X
1	COMMENTS	COMMENTS	String	100	Add	X
1	RESEARCHED	RESEARCHED	String	3	Add	X
1	FOUNTAINSTYLE	FOUNTAIN STYLE	String	50	Add	X
1	FACILITY_FOLDER	FACILITY_FOLDER	String	500	Add	X
1	PARENTASSETID	PARENT ASSETID	String	15	Add	X
1	PARENTASSETNAME	PARENT ASSET NAME	String	250	Add	X
1	PWBREFERENCENAME	PWB REFERENCE NAME	String	500	Add	X