GIS Data Catalog

Internal feature number.

Sequential unique whole numbers that are automatically generated.

Feature geometry.

Coordinates defining the features.

Unique pipe ID

1.0 to 5425.0 by

Upstream facility tag from facility_point

Text field with max length of 50 characters, consisting of flow basin name, trunk name, and maintenance hole ID. Example: RE*YARROW.R16-15

Downstream facility tag from facility_point

Text field with max length of 50 characters, consisting of flow basin name, trunk name, and maintenance hole ID. Example: RE*YARROW.R16-15

Number differentiating different pipes with the same up and downstream facility

1 to 4 by

Priority in direction of flow due to level of flow

1 to 4 by

Identify the type of pipe use - NASSCO compliance

CB - Combined: Definition of code value [CB] in CVD firs_n_use

FM - Force main: Definition of code value [FM] in CVD firs_n_use

ZZ - Other: Definition of code value [ZZ] in CVD firs_n_use

PR - Processes: Definition of code value [PR] in CVD firs_n_use

SS - Sanitary: Definition of code value [SS] in CVD firs_n_use

SW - Stormwater: Definition of code value [SW] in CVD firs_n_use

Type/function of pipe

13 - AIR JUMPER: Definition of code value [13] in CVD firs_sewer_type_text

9 - CHILLER: Definition of code value [9] in CVD firs_sewer_type_text

12 - DRAIN: Definition of code value [12] in CVD firs_sewer_type_text

4 - FORCE MAIN: Definition of code value [4] in CVD firs_sewer_type_text

1 - GRAVITY: Definition of code value [1] in CVD firs_sewer_type_text

10 - LPA GRAVITY: Definition of code value [10] in CVD firs_sewer_type_text

14 - MULTIUSE: Definition of code value [14] in CVD firs_sewer_type_text

5 - OUTFALL: Definition of code value [5] in CVD firs_sewer_type_text

6 - OVERFLOW: Definition of code value [6] in CVD firs_sewer_type_text

2 - PRESSURE: Definition of code value [2] in CVD firs_sewer_type_text

3 - SIPHON: Definition of code value [3] in CVD firs_sewer_type_text

7 - STORM DRAIN: Definition of code value [7] in CVD firs_sewer_type_text

0 - UNKNOWN: Definition of code value [0] in CVD firs_sewer_type_text

11 - VENT: Definition of code value [11] in CVD firs_sewer_type_text

8 - WATER REUSE: Definition of code value [8] in CVD firs_sewer_type_text

Material of which pipe is constructed

12 - ASBESTOS-CEMENT: Definition of code value [12] in CVD firs_material_text

5 - BRICK: Definition of code value [5] in CVD firs_material_text

8 - BRICK ARCH TUNNEL: Definition of code value [8] in CVD firs_material_text

19 - BRICK ARCH, BRICK INVERT: Definition of code value [19] in CVD firs_material_text

6 - BRICK ARCH/CONCRETE INVERT: Definition of code value [6] in CVD firs_material_text

15 - BRICK INVERT/CONCRETE ARCH: Definition of code value [15] in CVD firs_material_text

16 - BRICK W/ DOUBLE BRICK INVERT: Definition of code value [16] in CVD firs_material_text

4 - CAST IRON: Definition of code value [4] in CVD firs_material_text

24 - CLAY: Definition of code value [24] in CVD firs_material_text

32 - COATED DUCTILE IRON: Definition of code value [32] in CVD firs_material_text

22 - CONCRETE AND BRICK: Definition of code value [22] in CVD firs_material_text

25 - CONCRETE CYLINDER PIPE: Definition of code value [25] in CVD firs_material_text

9 - CONCRETE LINED BRICK: Definition of code value [9] in CVD firs_material_text

17 - CONCRETE LINED STEEL: Definition of code value [17] in CVD firs_material_text

7 - CONCRETE W/ BRICK INVERT: Definition of code value [7] in CVD firs_material_text

11 - CONCRETE W/ TILE CROWN: Definition of code value [11] in CVD firs_material_text

35 - COPPER: Definition of code value [35] in CVD firs_material_text

21 - CORRUGATED METAL PIPE: Definition of code value [21] in CVD firs_material_text

3 - DUCTILE IRON: Definition of code value [3] in CVD firs_material_text

29 - EPOXY COATING: Definition of code value [29] in CVD firs_material_text

14 - FIBERGLASS: Definition of code value [14] in CVD firs_material_text

28 - HIGH DENSITY POLYETHYLENE: Definition of code value [28] in CVD firs_material_text

36 - HOBAS/CCFRPM: Definition of code value [36] in CVD firs_material_text

31 - PCCP: Definition of code value [31] in CVD firs_material_text

23 - PLAIN CONCRETE PIPE (PCP): Definition of code value [23] in CVD firs_material_text

33 - POLYETHYLENE LINED DUCTILE IRON: Definition of code value [33] in CVD firs_material_text

34 - Polymer Concrete Pipe: Definition of code value [34] in CVD firs_material_text

30 - POLYURETHANE COATING: Definition of code value [30] in CVD firs_material_text

27 - PVC SHTS./HDPE SLIP LINED: Definition of code value [27] in CVD firs_material_text

2 - PVC/PLASTIC: Definition of code value [2] in CVD firs_material_text

10 - RCP TUNNEL: Definition of code value [10] in CVD firs_material_text

1 - REINFORCED CONCRETE: Definition of code value [1] in CVD firs_material_text

26 - STEEL: Definition of code value [26] in CVD firs_material_text

20 - STEEL PIPE: Definition of code value [20] in CVD firs_material_text

13 - TECHITE: Definition of code value [13] in CVD firs_material_text

0 - UNKNOWN: Definition of code value [0] in CVD firs_material_text

18 - WOOD: Definition of code value [18] in CVD firs_material_text

Identification of pipe lining method - NASSCO compliance

CP - Cured-in-place pipe: Definition of code value [CP] in CVD firs_n_lining

FF - Fold and Form or Deform/Reform: Definition of code value [FF] in CVD firs_n_lining

ZZ - Other: Definition of code value [ZZ] in CVD firs_n_lining

SN - Segmented panel (panels joined together to form a complete section): Definition of code value [SN] in CVD firs_n_lining

SP - Segmented pipe (complete circular sections of liner pipe): Definition of code value [SP] in CVD firs_n_lining

SW - Spiral Wound: Definition of code value [SW] in CVD firs_n_lining

Width of pipe in inches

240 - Max value: Definition of code value [240] in CVD firs_diameter

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

Height of pipe in inches

240 - Max value: Definition of code value [240] in CVD firs_diameter

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

Shape of pipe

2 - Box: Definition of code value [2] in CVD firs_shape_text

1 - Circular: Definition of code value [1] in CVD firs_shape_text

3 - Egg: Definition of code value [3] in CVD firs_shape_text

4 - Horseshoe: Definition of code value [4] in CVD firs_shape_text

0 - Unknown: Definition of code value [0] in CVD firs_shape_text

Length of pipe in feet

32767 - Max value: Definition of code value [32767] in CVD firs_length

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

Upstream invert elevation in Metro Datum (NGVD29/47 + 100')

999 - Max value: Definition of code value [999] in CVD firs_elevation

-999 - Min value: Definition of code value [-999] in CVD firs_elevation

Upstream invert elevation in NAVD88.

999 - Max value: Definition of code value [999] in CVD firs_elevation

-999 - Min value: Definition of code value [-999] in CVD firs_elevation

Downstream invert elevation in Metro Datum (NGVD29/47 + 100')

999 - Max value: Definition of code value [999] in CVD firs_elevation

-999 - Min value: Definition of code value [-999] in CVD firs_elevation

Downstream invert elevation in NAVD88.

999 - Max value: Definition of code value [999] in CVD firs_elevation

-999 - Min value: Definition of code value [-999] in CVD firs_elevation

Slope of pipe from up to downstream invert

-0.0068 to 95.38 by

Connections of other contributing local sewer agency's sewers or drains to the segment of pipe between facilities.

Short integer with max length of 2

Connections of other private sewers or drains to the segment of pipe between facilities.

Short integer with max length of 2

Year pipe was constructed

1850 to 2199 by

The year the pipe was acquired if originally built and operated by another agency. If built by Metro/King County the year acquired will match the year installed.

1880 to 2099 by

The year the pipe was modified from its original construction. If no modifications have occured since installation year modified will be NULL.

2199 - Max value: Definition of code value [2199] in CVD firs_year

1850 - Min value: Definition of code value [1850] in CVD firs_year

Agency who contracted and originally built and operated the segment of pipe.

Text field with max length of 50 characters

Indicates under what contract the facility was constructed

Text field with max length of 50 characters

The name of the trunk that this segment of pipe is associated with. Should match, loosely, the record drawings, contract, and or Onelines atlas page name.

Text field with max length of 70 characters

Subsection of a trunk as defined by KCWTD hydraulic model. Each reach identifies a unique section of conveyance between major flow inputs

Text field with max length of 70 characters

The receiving water body for flows from this facility.

Text field with max length of 50 characters

Treatment plant's name indicates final flow destination

Brightwater - Brightwater: Definition of code value [Brightwater] in CVD firs_treatment_plants

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

South Plant - South Plant: Definition of code value [South Plant] in CVD firs_treatment_plants

Vashon - Vashon: Definition of code value [Vashon] in CVD firs_treatment_plants

West Point - West Point: Definition of code value [West Point] in CVD firs_treatment_plants

Pipe's street address - NASSCO compliance

Text field with max length of 50 characters

City name - NASSCO compliance

Text field with max length of 50 characters

Year when pipe constructed - NASSCO compliance (Date type)

Date field

Pipe diameter in inches- NASSCO compliance (double type)

Double type field

Average distance from ground level to crown elevation of a pipe section in feet

Double type field with max length of 8 digits.

Date feature was modified or added in the database

2199-12-31 00:00:00 - Max value: Definition of code value [2199-12-31 00:00:00] in CVD firs_date

1850-01-01 00:00:00 - Min value: Definition of code value [1850-01-01 00:00:00] in CVD firs_date

Name of the analyst performing the last modification

Text field with max length of 25 characters

Name of the analyst performing the last quality check.

Text field with max length of 25 characters

The date of the latest quality check

2199-12-31 00:00:00 - Max value: Definition of code value [2199-12-31 00:00:00] in CVD firs_date

1850-01-01 00:00:00 - Min value: Definition of code value [1850-01-01 00:00:00] in CVD firs_date

Asset name for each pipe segment, consisting upstream ID, downstream ID and pipe number. Asset name can be use to find pipe segment in WTD CMMS.

Text field with max length of 100 characters.

Length of the geometric representation of the pipe in feet

Double type field - autogenerate by ArcGIS