GIS Data Catalog

Internal feature number.

Sequential unique whole numbers that are automatically generated.

AssetID is the unique identifier that is used to tie to Cityworks, MIS, or some other database. The AssetID is unique for each feature class and is generated by a script that runs nightly. Users should not modify the AssetID.

1.0 to 7147.0 by

DBAssetID is the unique identifier that is used to tie to Cityworks, MIS, or some other database. The DBAssetID is unique for each feature class and is generated by a script that runs nightly. Users should not modify the DBAssetID.

Not Found

Within the Puget Sound Stormwater Infrastructure Framework, Component is the broadest classification for a set of structures with a similar Function and Function Type.

Access Riser - Access Riser: A vertical maintenance access to a Vault, Tank or other similar structure. The access opening is wide enough for entry to support maintenance and inspection.

Cleanout - Cleanout: A Pipe with a cap that allows for cleaning or inspection of the Conveyance System.

Maintenance Hole - Maintenance Hole: Maintenance holes connect one Pipe to another Pipe, with an opening to the surface. Structurally, maintenance holes are cylindrical, deeper than wide, have an access opening, and without a Sump. Pipe outlet(s) are at the base of structure, with a channel and sometimes a shelf.

Ventilation Port - Ventilation Port: An opening with a removeable cap or cover that provides access for artificial ventilation (e.g. confined access blowers) to an underground feature prior to access by maintenance personnel.

Viewing Port - Viewing Port: An opening that provides view access to an underground feature for the purpose of inspection.

Within the Puget Sound Stormwater Infrastructure Framework, Component Type is the finest classification for a structure.

Type 1 - Maintenance hole Type 1: Cylindrical structure with diameter of 48, 54 or 60 inches, 8 feet min depth to bottom, including a riser cone. For Pipes needing knockout larger than 48", use Maintenance hole Type 2. For more detail see WSDOT Standard Plans (B-15.20)

Type 2 - Maintenance hole Type 2: Cylindrical structure with diameter of 72 + inches. For Pipes needing knockout larger than 48”. Max Depth 20', including a riser cone. For more detail see WSDOT Standard Plans (B-15.40).

Type 3 - Maintenance hole Type 3: Cylindrical structure with diameter of 36 + inches. For installation depths of less than 8 feet. Can accommodate any size Pipe depending on the diameter of the structure. For more detail see WSDOT Standard Plans (B-15.60).

Type 4 - Maintenance hole Type 4: Cylindrical structure with diameter of 48” concrete Maintenance hole risers, stacked to a max of 12’ on top of a 48” or greater conveyance Pipe. Utilizes the conveyance pipe as the base of the structure. For more detail see King County Roads Standards Figure 7-010).

DesignType specifies whether the structure meets a current design standard (e.g. Surface Water Design Manual or Roads Design and Construction Standards).

Non-Standard - Non-Standard: Definition of code value [Non-Standard] in CVD sw_designstandard_1

Standard - Standard: Definition of code value [Standard] in CVD sw_designstandard_1

Pipe Count is the number of pipes, of any size, that connect to a Connect feature. Tanks that connect directly to the Connect structure are not included in the Pipe Count. However, pipes tying into the Connect structure and a tank should be included in the Pipe Count.

9 - Max value: Definition of code value [9] in CVD sw_pipecount

1 - Min value: Definition of code value [1] in CVD sw_pipecount

Material tracks the primary material that the Connect feature is constructed of.

concrete, metal, 48, Aluminum, brick, Brick, Cast Iron, CMP, concrete, Concrete, concrete, Concrete, Concrete with brick riser, CPEP, DI, Ductal Iron, LCPE, metal, Metal, metal, Metal, Metal cmp, metal grade, metal grate, Metal Plate, plastic, Plastic, Plastic, pvc, PVC, Steel, Unknown

Diameter is the average interior diameter of the round Connect structure, not the opening (cover frame or slab).

=>54, 48, Null, >=54, >54, 0, 10, 108, 12, 120, 15, 17, 18, 2.5, 20, 21, 24, 25, 26, 27, 28, 3, 30, 32, 36, 38, 39, 4, 40, 42, 45, 48, 5, 54, 58, 6, 60, 70, 72, 72+, 8, 8”, 84, 9, 92, 96

WidthA is the average inner width of the non-round Connect structure, not the opening (cover frame or slab). Enter the smaller of the two widths in the WidthA column.

150 - Max value: Definition of code value [150] in CVD sw_connectwidth

0 - Min value: Definition of code value [0] in CVD sw_connectwidth

WidthB is the average inner width of the non-round Connect structure, not the opening (cover frame or slab). Enter the larger of the two widths in the WidthB column.

150 - Max value: Definition of code value [150] in CVD sw_connectwidth

0 - Min value: Definition of code value [0] in CVD sw_connectwidth

Structure Shape is the shape of the Connect feature, not the cover.

Other - Other: Definition of code value [Other] in CVD sw_connectshape

Rectangle - Rectangle: Definition of code value [Rectangle] in CVD sw_connectshape

Round - Round: Definition of code value [Round] in CVD sw_connectshape

Total depth is height from the bottom of the structure to the top at rim of the lid.

0.0 to 24.3 by

CoverSize is the dimensions of the structures cover or lid. When entering cover sizes, enter the smaller dimension, separated by an “x,” and then enter the larger dimension. e.g. 24x30.

Not Found

CoverStyle refers to the type of cover or lid.

Beehive - Beehive: Definition of code value [Beehive] in CVD sw_accesscoverstyle

Birdcage - Birdcage: Definition of code value [Birdcage] in CVD sw_accesscoverstyle

Grate - Grate: Definition of code value [Grate] in CVD sw_accesscoverstyle

Roll/Vane - Roll/Vane: Definition of code value [Roll/Vane] in CVD sw_accesscoverstyle

Solid - Solid: Definition of code value [Solid] in CVD sw_accesscoverstyle

Thru - Thru: Definition of code value [Thru] in CVD sw_accesscoverstyle

Vane - Vane: Definition of code value [Vane] in CVD sw_accesscoverstyle

Vane/Thru - Vane/Thru: Definition of code value [Vane/Thru] in CVD sw_accesscoverstyle

CoverStyle refers to the type of cover or lid.

CCTV Inspection - CCTV Inspection: Definition of code value [CCTV Inspection] in CVD sw_meassource_2

Field estimate - Field estimate: Definition of code value [Field estimate] in CVD sw_meassource_2

Field measurement - Field measurement: Definition of code value [Field measurement] in CVD sw_meassource_2

GIS Data - GIS Data: Definition of code value [GIS Data] in CVD sw_meassource_2

Laser Measurement - Laser Measurement: Definition of code value [Laser Measurement] in CVD sw_meassource_2

MIS Database - MIS Database: Definition of code value [MIS Database] in CVD sw_meassource_2

Plans - Plans: Definition of code value [Plans] in CVD sw_meassource_2

Survey - Survey: Definition of code value [Survey] in CVD sw_meassource_2

Cover Elevation tracks the height above sea level for the asset based on the cover. It is only displayed in feet.

0.0, 29.4, 262.58, 475.02, 493.8, 496.0, 496.51

Outlet elevation is elevation in feet at the base interior level (invert) of the outlet pipe.

0.0, 17.78, 149.0, 150.14, 151.0, 154.08, 257.58, 465.0, 484.29, 488.51, 489.22

LockingCover tracks whether or not the cover or lid has the ability to lock. This includes self-locking lids, and when the rim has threaded holes, even if the lid doesn’t have holes that allow the cover to be locked or instances when locking bolts are not present.

No - No: Definition of code value [No] in CVD sw_boolean

Yes - Yes: Definition of code value [Yes] in CVD sw_boolean

Jailhouse windows are found in outlet structures of ponds. They are openings with vertical bars that prevent debris from entering the outlet.

No - No: Definition of code value [No] in CVD sw_boolean

Yes - Yes: Definition of code value [Yes] in CVD sw_boolean

Intent tracks whether the infrastructure was designed primarily to convey stormwater or a natural water body.

Convey natural water body - Convey natural water body: Definition of code value [Convey natural water body] in CVD sw_intent_1

Convey stormwater - Convey stormwater: Definition of code value [Convey stormwater] in CVD sw_intent_1

Maintenance Only - Maintenance Only: Definition of code value [Maintenance Only] in CVD sw_intent_1

Not Found

Not Found

OwnerEntity tracks the owner of the asset.

Federal Govt Agency - Federal Govt Agency (Covers all federal departments and agencies): Definition of code value [Federal Govt Agency] in CVD sw_ownerentity_12

Incorporation - Incorporation: Definition of code value [Incorporation] in CVD sw_ownerentity_12

Airport - KC DES - Airport (KCIA): Definition of code value [Airport] in CVD sw_ownerentity_12

FMD - KC DES - Facilities Management Division: Definition of code value [FMD] in CVD sw_ownerentity_12

FMD BOS - KC DES FMD - Building Operations Services: Definition of code value [FMD BOS] in CVD sw_ownerentity_12

FMD RES - KC DES FMD - Real Estate Services: Definition of code value [FMD RES] in CVD sw_ownerentity_12

Roads - KC DLS - Road Services Division: Definition of code value [Roads] in CVD sw_ownerentity_12

Parks - KC DNRP - Park Division: Definition of code value [Parks] in CVD sw_ownerentity_12

SWD - KC DNRP - Solid Waste Division: Definition of code value [SWD] in CVD sw_ownerentity_12

WTD - KC DNRP - Waste Water Treatment Division: Definition of code value [WTD] in CVD sw_ownerentity_12

WLRD - KC DNRP - Water and Land Resources Division: Definition of code value [WLRD] in CVD sw_ownerentity_12

Transit - KC Metro Transit Department: Definition of code value [Transit] in CVD sw_ownerentity_12

Other Public Agency - Other Public Agency: Definition of code value [Other Public Agency] in CVD sw_ownerentity_12

Private - Private: Definition of code value [Private] in CVD sw_ownerentity_12

State Govt Agency - State Govt Agency (Covers all state departments and agencies): Definition of code value [State Govt Agency] in CVD sw_ownerentity_12

TBD - TBD: Definition of code value [TBD] in CVD sw_ownerentity_12

Jurisdiction tracks the jurisdiction that governs the land that the asset resides in.

Algona - Algona: Definition of code value [Algona] in CVD sw_jurisdiction_1

Auburn - Auburn: Definition of code value [Auburn] in CVD sw_jurisdiction_1

Beaux Arts - Beaux Arts: Definition of code value [Beaux Arts] in CVD sw_jurisdiction_1

Bellevue - Bellevue: Definition of code value [Bellevue] in CVD sw_jurisdiction_1

Black Diamond - Black Diamond: Definition of code value [Black Diamond] in CVD sw_jurisdiction_1

Bothell - Bothell: Definition of code value [Bothell] in CVD sw_jurisdiction_1

Burien - Burien: Definition of code value [Burien] in CVD sw_jurisdiction_1

Carnation - Carnation: Definition of code value [Carnation] in CVD sw_jurisdiction_1

Chelan - Chelan: Definition of code value [Chelan] in CVD sw_jurisdiction_1

Clyde Hill - Clyde Hill: Definition of code value [Clyde Hill] in CVD sw_jurisdiction_1

Covington - Covington: Definition of code value [Covington] in CVD sw_jurisdiction_1

Des Moines - Des Moines: Definition of code value [Des Moines] in CVD sw_jurisdiction_1

Duvall - Duvall: Definition of code value [Duvall] in CVD sw_jurisdiction_1

Enumclaw - Enumclaw: Definition of code value [Enumclaw] in CVD sw_jurisdiction_1

Federal - Federal: Definition of code value [Federal] in CVD sw_jurisdiction_1

Federal Way - Federal Way: Definition of code value [Federal Way] in CVD sw_jurisdiction_1

Hunts Point - Hunts Point: Definition of code value [Hunts Point] in CVD sw_jurisdiction_1

Issaquah - Issaquah: Definition of code value [Issaquah] in CVD sw_jurisdiction_1

Kenmore - Kenmore: Definition of code value [Kenmore] in CVD sw_jurisdiction_1

Kent - Kent: Definition of code value [Kent] in CVD sw_jurisdiction_1

King County - King County: Definition of code value [King County] in CVD sw_jurisdiction_1

Kirkland - Kirkland: Definition of code value [Kirkland] in CVD sw_jurisdiction_1

Kittias - Kittias: Definition of code value [Kittias] in CVD sw_jurisdiction_1

Lake Forest Park - Lake Forest Park: Definition of code value [Lake Forest Park] in CVD sw_jurisdiction_1

Maple Valley - Maple Valley: Definition of code value [Maple Valley] in CVD sw_jurisdiction_1

Medina - Medina: Definition of code value [Medina] in CVD sw_jurisdiction_1

Mercer Island - Mercer Island: Definition of code value [Mercer Island] in CVD sw_jurisdiction_1

Milton - Milton: Definition of code value [Milton] in CVD sw_jurisdiction_1

Newcastle - Newcastle: Definition of code value [Newcastle] in CVD sw_jurisdiction_1

Normandy Park - Normandy Park: Definition of code value [Normandy Park] in CVD sw_jurisdiction_1

North Bend - North Bend: Definition of code value [North Bend] in CVD sw_jurisdiction_1

Pacific - Pacific: Definition of code value [Pacific] in CVD sw_jurisdiction_1

Pierce - Pierce: Definition of code value [Pierce] in CVD sw_jurisdiction_1

Redmond - Redmond: Definition of code value [Redmond] in CVD sw_jurisdiction_1

Renton - Renton: Definition of code value [Renton] in CVD sw_jurisdiction_1

Sammamish - Sammamish: Definition of code value [Sammamish] in CVD sw_jurisdiction_1

SeaTac - SeaTac: Definition of code value [SeaTac] in CVD sw_jurisdiction_1

Seattle - Seattle: Definition of code value [Seattle] in CVD sw_jurisdiction_1

Shoreline - Shoreline: Definition of code value [Shoreline] in CVD sw_jurisdiction_1

Skykomish - Skykomish: Definition of code value [Skykomish] in CVD sw_jurisdiction_1

Snohomish - Snohomish: Definition of code value [Snohomish] in CVD sw_jurisdiction_1

State (All entities) - State (All entities): Definition of code value [State (All entities)] in CVD sw_jurisdiction_1

Tukwila - Tukwila: Definition of code value [Tukwila] in CVD sw_jurisdiction_1

Woodinville - Woodinville: Definition of code value [Woodinville] in CVD sw_jurisdiction_1

Yarrow Point - Yarrow Point: Definition of code value [Yarrow Point] in CVD sw_jurisdiction_1

DataStage tracks the status of the data as it moves through the QAQC process.

Acquire - Acquire: Definition of code value [Acquire] in CVD sw_datastage_1

Advanced Field Review - Advanced Field Review: Definition of code value [Advanced Field Review] in CVD sw_datastage_1

Approved - Approved: Definition of code value [Approved] in CVD sw_datastage_1

Field Review - Field Review: Definition of code value [Field Review] in CVD sw_datastage_1

Field Review:Photo - Field Review:Photo: Definition of code value [Field Review:Photo] in CVD sw_datastage_1

Office Review - Office Review: Definition of code value [Office Review] in CVD sw_datastage_1

Process - Process: Definition of code value [Process] in CVD sw_datastage_1

QC - QC: Definition of code value [QC] in CVD sw_datastage_1

Roads Review - Roads Review: Definition of code value [Roads Review] in CVD sw_datastage_1

Not Found

Not Found

CurrentStatus tracks the status of the data as it moves through the lifecycle of an asset.

Abandoned - Abandoned: Definition of code value [Abandoned] in CVD sw_currentstatus_1

Active - Active: Definition of code value [Active] in CVD sw_currentstatus_1

Bond - Bond: Definition of code value [Bond] in CVD sw_currentstatus_1

Delete - Data Entry Error: Definition of code value [Delete] in CVD sw_currentstatus_1

Pending - Pending: Definition of code value [Pending] in CVD sw_currentstatus_1

Removed - Removed: Definition of code value [Removed] in CVD sw_currentstatus_1

Retired - Retired: Definition of code value [Retired] in CVD sw_currentstatus_1

XYSource tracks the method in which the geographic location of the asset was recorded.

CAD - CAD: Definition of code value [CAD] in CVD sw_xysource_1

GIS Data - GIS Data: Definition of code value [GIS Data] in CVD sw_xysource_1

GPS - GPS: Definition of code value [GPS] in CVD sw_xysource_1

LIDAR - LIDAR: Definition of code value [LIDAR] in CVD sw_xysource_1

Picked from aerial - Picked from aerial: Definition of code value [Picked from aerial] in CVD sw_xysource_1

Plans - Plans: Definition of code value [Plans] in CVD sw_xysource_1

Sketch - Sketch: Definition of code value [Sketch] in CVD sw_xysource_1

Survey - Survey: Definition of code value [Survey] in CVD sw_xysource_1

DataSource tracks the group, program, or process that added the data.

DNRP Parks - KC DNRP- Parks Division Mapping: Definition of code value [DNRP Parks] in CVD sw_datasource_3

RFMS - KC DNRP - WLRD RFMS: Definition of code value [RFMS] in CVD sw_datasource_3

SWSS AMU - KC DNRP - WLRD SWSS Asset Management Unit: Definition of code value [SWSS AMU] in CVD sw_datasource_3

SWSS Mapping - KC DNRP - WLRD SWSS Mapping: Definition of code value [SWSS Mapping] in CVD sw_datasource_3

WTD LinearNetwork - KC DNRP - WTD Linear Network: Definition of code value [WTD LinearNetwork] in CVD sw_datasource_3

WTD PointNetwork - KC DNRP - WTD Point Network: Definition of code value [WTD PointNetwork] in CVD sw_datasource_3

Metro CAD - KC DOT- Metro Division CAD: Definition of code value [Metro CAD] in CVD sw_datasource_3

KCIA CAD - KC DOT - Airport Division CAD: Definition of code value [KCIA CAD] in CVD sw_datasource_3

Roads NPDES Mapping - KC DOT - Roads NPDES Mapping: Definition of code value [Roads NPDES Mapping] in CVD sw_datasource_3

Roads RNIS Mapping - KC DOT - Roads RNIS Mapping: Definition of code value [Roads RNIS Mapping] in CVD sw_datasource_3

SWD CAD - KC DOT - Solid Waste Division CAD: Definition of code value [SWD CAD] in CVD sw_datasource_3

Roads Digitized - Roads Digitized from Aerial: Definition of code value [Roads Digitized] in CVD sw_datasource_3

ROW Assessment - ROW Assessment Project: Definition of code value [ROW Assessment] in CVD sw_datasource_3

FieldVisitDate tracks the date that staff last visited the feature in the field.

Not Found

LastEditDate tracks the date that staff last edited the feature.

Not Found

FacilityID tracks the FacilityID number that the feature is a part of.

Not Found

When digital plans are available, PlanLink provides a hyperlink to plan files.

Not Found

GlobalID is a 36 character string that ArcGIS uses to uniquely identify features or table rows within a geodatabase and across geodatabases.

UNREPRESENTED DOMAIN

PAA tracks which Potential Annexation Area an asset intersects, if applicable.

East Federal Way, East Renton, Fairwood, North Highline, North Highline (White Center), Potential Annexation Areas, Redmond Ridge, West Hill (Skyway/Bryn Mawr)

Most Recent CCTV Inspection tracks the date of the most recent CCTV inspection.

Not Found

CSAccess is used to identify CBs that are used to access the control structure.

No - No: Definition of code value [No] in CVD sw_boolean

Yes - Yes: Definition of code value [Yes] in CVD sw_boolean

Feature geometry.

Coordinates defining the features.