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 151538.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

Culvert - Culvert: Definition of code value [Culvert] in CVD sw_convclosedcomponent

Pipe - Pipe: Definition of code value [Pipe] in CVD sw_convclosedcomponent

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

Arch - Arch Culvert: Definition of code value [Arch] in CVD sw_closedconveycomponenttype_2

Bottomless Arch - Bottomless Arch Culvert: Definition of code value [Bottomless Arch] in CVD sw_closedconveycomponenttype_2

Bottomless Box - Bottomless Box Culvert: Definition of code value [Bottomless Box] in CVD sw_closedconveycomponenttype_2

Box - Box Culvert: Definition of code value [Box] in CVD sw_closedconveycomponenttype_2

Force Main - Force Main: Definition of code value [Force Main] in CVD sw_closedconveycomponenttype_2

Infiltration Pipe - Infiltration Pipe: Definition of code value [Infiltration Pipe] in CVD sw_closedconveycomponenttype_2

Perforated- use unknown - Perforated- use unknown: Definition of code value [Perforated- use unknown] in CVD sw_closedconveycomponenttype_2

Pipe - Pipe: Definition of code value [Pipe] in CVD sw_closedconveycomponenttype_2

Pond-Filter Drain - Pond\Filter Drain: Definition of code value [Pond-Filter Drain] in CVD sw_closedconveycomponenttype_2

Reducer - Reducer: Definition of code value [Reducer] in CVD sw_closedconveycomponenttype_2

Round - Round Culvert: Definition of code value [Round] in CVD sw_closedconveycomponenttype_2

Squash - Squash Culvert: Definition of code value [Squash] in CVD sw_closedconveycomponenttype_2

Tightline - Tightline: Definition of code value [Tightline] in CVD sw_closedconveycomponenttype_2

Underdrain - Underdrain: Definition of code value [Underdrain] in CVD sw_closedconveycomponenttype_2

Yard-Roof Drain - Yard-Roof Drain: Definition of code value [Yard-Roof Drain] in CVD sw_closedconveycomponenttype_2

Diameter is the interior diameter of the pipe or culvert, in inches. Diameter is recorded when the pipe is circular in shape.

156 - Max value: Definition of code value [156] in CVD sw_pipediameter

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

Width is the distance from one side of a pipe or culvert to the other side, measured at the widest point of the feature. Width is collected when the pipe or culvert is not circular in shape.

0.0 to 426.0 by

Height is the distance from the top of a pipe or culvert to the bottom, measured at the tallest point of the feature. Height is collected when the pipe is not circular in shape.

0.0 to 216.0 by

MeasSource is the source of the Diameter or Width/Height measurements.

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

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

Aluminum - Aluminum: Definition of code value [Aluminum] in CVD sw_closedmaterial

Clay - Clay: Definition of code value [Clay] in CVD sw_closedmaterial

Concrete - Concrete: Definition of code value [Concrete] in CVD sw_closedmaterial

CPEP - CPEP: Definition of code value [CPEP] in CVD sw_closedmaterial

DI - DI: Definition of code value [DI] in CVD sw_closedmaterial

HDPE - HDPE: Definition of code value [HDPE] in CVD sw_closedmaterial

LCPE - LCPE: Definition of code value [LCPE] in CVD sw_closedmaterial

Metal - Metal: Definition of code value [Metal] in CVD sw_closedmaterial

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

Plastic - Plastic: Definition of code value [Plastic] in CVD sw_closedmaterial

PVC - PVC: Definition of code value [PVC] in CVD sw_closedmaterial

RCP - RCP: Definition of code value [RCP] in CVD sw_closedmaterial

SRPE - SRPE: Definition of code value [SRPE] in CVD sw_closedmaterial

UpstreamMeasureDown tracks the measurement from the top of the structure’s frame to the pipe’s invert on the upstream end.

0.0, 6.65, 9.9, 13.5, 95.15, 480.0, 482.03, 493.65

DownstreamMeasureDown tracks the measurement from the top of the structure’s frame to the pipe’s invert on the downstream end.

Not Found

Not Found

Not Found

Not Found

Not Found

Surface Texture is the surface feel or appearance of the pipe interior. The difference between “spiral” and “corrugated” can be confusing. Some corrugated pipe appears to have a spiral surface texture, but is classified as corrugated. Spiral pipe is quite rare.

Corrugated - Corrugated: Definition of code value [Corrugated] in CVD sw_convsurfacetexture

Smooth - Smooth: Definition of code value [Smooth] in CVD sw_convsurfacetexture

Spiral - Spiral: Definition of code value [Spiral] in CVD sw_convsurfacetexture

Flow direction tracks the function of the pipe in terms of direction of conveyance.

Bi-Directional - Bi-Directional: Definition of code value [Bi-Directional] in CVD sw_closedflowdir

Downflow - Downflow: Definition of code value [Downflow] in CVD sw_closedflowdir

Flip flow direction - Flip flow direction: Definition of code value [Flip flow direction] in CVD sw_closedflowdir

Not Found

Not Found

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

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

Not Found

Not Found

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

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.

UNREPRESENTED DOMAIN

WDFWID tracks Washington Department of Fish & Wildlife’s fish passage site ID from their Fish Passage and Diversion Screening Inventory.

101S-07, 101S-11, 101S-14, 101S-32, 101SC-07, 101SD-02, 1320139, 920093, 934234, 934606, 982396, 983112, 983113, 983119, 994989, 995321, CLO-109230, No

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

Not Found

Feature geometry.

Coordinates defining the features.

Returns the total length of the elements in a geometry instance.

Double