Metadata: Drinking Fountains

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
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
Add

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