GIS Data Catalog

Wastewater Treatment Facilities of King County

View in GIS Open Data

Learn how to use GIS Open Data 🗺

Use this Data

Links

How to use in ArcGIS Pro

Sharing Status Public

Summary


An inventory of all King County Wastewater Treatment Division pipes, their attributes, and their locations

Description


All of the maintenance holes, pump stations, regulator stations, and treatment plants involved in conveyance and treatment of wastewater for King County WTD


Layer information

Layer Name facility_point
Subject Category Utilities
Title Wastewater Treatment Facilities of King County
Feature Count 4624
Feature Type Point
Next Update Continually
Spatial reference EPSG:2926
Control ID 279
Place Keywords Washington State, King County, WA, Pacific NW
Theme Keywords Utility, Environment, Utilitiescommunication, Wastewater, Seattle, Pump Station, Regulator Station, Treatment Plant, Water, King County, Metro, CSO, Manhole, Sewer
Supplemental Information None

Table Preview


Attribute information

OBJECTID

From Esri

Description

Internal feature number.

Domain

Sequential unique whole numbers that are automatically generated.

Shape

From Esri

Description

Feature geometry.

Domain

Coordinates defining the features.

MID

From King County

Description

Unique ID to fulfill NASSCO compliance

Domain

Unique short integer that are generated from Object ID

FIRS_TAG

From King County - WTD

Description

Unique identifier consisting of operational flow area, trunk, and ID

Domain

String field with max length of 50 characters. Example: RE*YARROW.R16-15

FACILITY_TYPE

From King County

Description

Type of facility represented

Domain

2 - "T" TOP: Definition of code value [2] in CVD firs_facility_type_text

43 - ACCESS/PUMP: Definition of code value [43] in CVD firs_facility_type_text

28 - ADIT STRUCTURE: Definition of code value [28] in CVD firs_facility_type_text

47 - AIR RELEASE: Definition of code value [47] in CVD firs_facility_type_text

44 - AIR/VAC: Definition of code value [44] in CVD firs_facility_type_text

13 - ANGLE STRUCTURE: Definition of code value [13] in CVD firs_facility_type_text

62 - ANODE: Definition of code value [62] in CVD firs_facility_type_text

50 - BACKFLOW PREVENTER: Definition of code value [50] in CVD firs_facility_type_text

46 - BLOWOFF: Definition of code value [46] in CVD firs_facility_type_text

58 - BUBBLER: Definition of code value [58] in CVD firs_facility_type_text

59 - BUBBLER PANEL: Definition of code value [59] in CVD firs_facility_type_text

56 - BUTTERFLY VALVE: Definition of code value [56] in CVD firs_facility_type_text

8 - BYPASS STRUCTURE: Definition of code value [8] in CVD firs_facility_type_text

36 - CONNECTION POINT - NO ACCESS: Definition of code value [36] in CVD firs_facility_type_text

68 - CONTROL PANEL: Definition of code value [68] in CVD firs_facility_type_text

61 - CP STATION: Definition of code value [61] in CVD firs_facility_type_text

21 - CROSSOVER STRUCTURE: Definition of code value [21] in CVD firs_facility_type_text

6 - DIVERSION STRUCTURE: Definition of code value [6] in CVD firs_facility_type_text

20 - DROP MANHOLE: Definition of code value [20] in CVD firs_facility_type_text

24 - DROP STRUCTURE: Definition of code value [24] in CVD firs_facility_type_text

37 - EMERGENCY RELIEF STRUCTURE: Definition of code value [37] in CVD firs_facility_type_text

42 - END OF LINE - NO MANHOLE: Definition of code value [42] in CVD firs_facility_type_text

31 - ENERGY DISSIPATION: Definition of code value [31] in CVD firs_facility_type_text

67 - FLOW MONITOR: Definition of code value [67] in CVD firs_facility_type_text

17 - FLUSHING MANHOLE: Definition of code value [17] in CVD firs_facility_type_text

52 - FLUSHING STRUCTURE: Definition of code value [52] in CVD firs_facility_type_text

16 - FORCE MAIN DISCHARGE STRUCTURE: Definition of code value [16] in CVD firs_facility_type_text

65 - GATE: Definition of code value [65] in CVD firs_facility_type_text

25 - GATE STRUCTURE: Definition of code value [25] in CVD firs_facility_type_text

55 - GATE VALVE: Definition of code value [55] in CVD firs_facility_type_text

29 - GRIT CHAMBER: Definition of code value [29] in CVD firs_facility_type_text

30 - INFLUENT MANHOLE: Definition of code value [30] in CVD firs_facility_type_text

32 - INSPECTION WYE: Definition of code value [32] in CVD firs_facility_type_text

15 - JUNCTION STRUCTURE: Definition of code value [15] in CVD firs_facility_type_text

27 - LANDFALL STRUCTURE: Definition of code value [27] in CVD firs_facility_type_text

45 - LINE VALVE: Definition of code value [45] in CVD firs_facility_type_text

35 - LOW HEAD - NO ACCESS: Definition of code value [35] in CVD firs_facility_type_text

34 - LOW HEAD STRUCTURE: Definition of code value [34] in CVD firs_facility_type_text

22 - MEASURING MANHOLE: Definition of code value [22] in CVD firs_facility_type_text

9 - OUTFALL STRUCTURE: Definition of code value [9] in CVD firs_facility_type_text

7 - OVERFLOW STRUCTURE: Definition of code value [7] in CVD firs_facility_type_text

66 - PLUG: Definition of code value [66] in CVD firs_facility_type_text

3 - POURED IN PLACE: Definition of code value [3] in CVD firs_facility_type_text

4 - PRESSURE: Definition of code value [4] in CVD firs_facility_type_text

18 - PUMP STATION: Definition of code value [18] in CVD firs_facility_type_text

63 - RECTIFIER: Definition of code value [63] in CVD firs_facility_type_text

51 - REDUCER: Definition of code value [51] in CVD firs_facility_type_text

19 - REGULATOR STATION: Definition of code value [19] in CVD firs_facility_type_text

57 - SADDLE MANHOLE: Definition of code value [57] in CVD firs_facility_type_text

14 - SAND CATCHER: Definition of code value [14] in CVD firs_facility_type_text

38 - SEWAGE TREATMENT PLANT: Definition of code value [38] in CVD firs_facility_type_text

39 - SIPHON INLET SHAFT: Definition of code value [39] in CVD firs_facility_type_text

10 - SIPHON INLET STRUCTURE: Definition of code value [10] in CVD firs_facility_type_text

40 - SIPHON OUTLET SHAFT: Definition of code value [40] in CVD firs_facility_type_text

11 - SIPHON OUTLET STRUCTURE: Definition of code value [11] in CVD firs_facility_type_text

5 - SPECIAL LAKE MANHOLE: Definition of code value [5] in CVD firs_facility_type_text

1 - STANDARD: Definition of code value [1] in CVD firs_facility_type_text

41 - START OF LINE - NO MANHOLE: Definition of code value [41] in CVD firs_facility_type_text

53 - STORAGE TANK: Definition of code value [53] in CVD firs_facility_type_text

49 - TEE: Definition of code value [49] in CVD firs_facility_type_text

12 - TRANSITION STRUCTURE: Definition of code value [12] in CVD firs_facility_type_text

23 - TUNNEL ACCESS: Definition of code value [23] in CVD firs_facility_type_text

26 - TUNNEL DISCHARGE: Definition of code value [26] in CVD firs_facility_type_text

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

60 - UST: Definition of code value [60] in CVD firs_facility_type_text

33 - VENT: Definition of code value [33] in CVD firs_facility_type_text

64 - WEIR: Definition of code value [64] in CVD firs_facility_type_text

48 - WET WEATHER TREATMENT FACILITY: Definition of code value [48] in CVD firs_facility_type_text

54 - WYE: Definition of code value [54] in CVD firs_facility_type_text

YEAR_INSTALLED

From King County - WTD

Description

Year facility was constructed

Domain

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

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

YEAR_ACQUIRED

From King County - WTD

Description

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

Domain

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

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

YEAR_MODIFIED

From King County - WTD

Description

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

Domain

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

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

ORIGINAL_OWNER

From King County

Description

The agency who originally owned the facility

Domain

City of Seattle, King County, KING COUNTY

X_NAD83

From King County - WTD

Description

Easting in State Plane NAD83 coordinates, Washington North

Domain

1235915.29 to 1372973.43 by

Y_NAD83

From King County - WTD

Description

Norting in State Plane NAD83 coordinates, Washington North

Domain

101140.26 to 319486.23 by

X_NAD27

From King County - WTD

Description

Easting in State Plane NAD27 coordinates, Washington North

Domain

1595793.98 to 1732852.37 by

Y_NAD27

From King County - WTD

Description

Northing in State Plane NAD27 coordinates, Washington North

Domain

101198.91 to 319545.73 by

Latitude

From King County - WTD

Description

Latitude of facility

Domain

47.268283 to 47.866859 by

Longitude

From King County - WTD

Description

Longitude of facility

Domain

-122.387272 to 122.469478 by

LOCATION_SOURCE

From King County - WTD

Description

Source of Northing and Easting

Domain

1 - Asbuilt: Definition of code value [1] in CVD firs_source_text

2 - GPS: Definition of code value [2] in CVD firs_source_text

3 - Inspector: Definition of code value [3] in CVD firs_source_text

6 - LIDAR: Definition of code value [6] in CVD firs_source_text

4 - Local GIS: Definition of code value [4] in CVD firs_source_text

5 - Orthophoto: Definition of code value [5] in CVD firs_source_text

7 - Survey: Definition of code value [7] in CVD firs_source_text

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

MATERIAL

From King County - WTD

Description

Primary material of which facility is constructed

Domain

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

DIAMETER

From King County - WTD

Description

Diameter of facility in inches

Domain

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

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

FACILITY_DEPTH

From King County

Description

Depth of facility in feet

Domain

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

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

RIME_METRO

From King County - WTD

Description

Elevation of the facility rim in Metro Datum (NGVD29/47 + 100') from record drawings

Domain

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

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

RIME_NAVD88

From King County - WTD

Description

Elevation of the facility rim in NAVD88 Datum from record drawings

Domain

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

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

RIME_SOURCE

From King County - WTD

Description

Source of the rim elevation

Domain

1 - Asbuilt: Definition of code value [1] in CVD firs_source_text

2 - GPS: Definition of code value [2] in CVD firs_source_text

3 - Inspector: Definition of code value [3] in CVD firs_source_text

6 - LIDAR: Definition of code value [6] in CVD firs_source_text

4 - Local GIS: Definition of code value [4] in CVD firs_source_text

5 - Orthophoto: Definition of code value [5] in CVD firs_source_text

7 - Survey: Definition of code value [7] in CVD firs_source_text

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

RIME_LIDAR

From King County - WTD

Description

Elevation of the facility rim in NAVD88 Datum from LIDAR

Domain

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

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

UP_IE

From King County - WTD

Description

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

Domain

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

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

BTM_IE_METRO

From King County - WTD

Description

Bottom invert elevation (lowest point in facility) in Metro Datum (NGVD29/47 + 100') from record drawings

Domain

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

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

BTM_IE_NAVD88

From King County - WTD

Description

Bottom invert elevation (lowest point in facility) in NAVD88

Domain

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

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

DOWN_IE

From King County - WTD

Description

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

Domain

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

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

VERT_DATUM_DELTA

From King County - WTD

Description

The vertical differce at a location between NAVD88 and Metro Datum (NGVD29/47 + 100') according to the National Geodetic Survey Vertcon program (http://www.ngs.noaa.gov/TOOLS/Vertcon/vertcon.html)

Domain

Not Found

CONFIGURATION

From King County - WTD

Description

Number of pipes entering and exiting the facility

Domain

5 - INCREASING PIPE DIAMETER DOWNSTREAM: Definition of code value [5] in CVD firs_configuration_text

4 - MULTIPLE UPSTREAM AND MULTIPLE DOWNSTREAM: Definition of code value [4] in CVD firs_configuration_text

1 - ONE UPSTREAM AND ONE DOWNSTREAM: Definition of code value [1] in CVD firs_configuration_text

2 - ONE UPSTREAM AND TWO DOWNSTREAM: Definition of code value [2] in CVD firs_configuration_text

6 - PUMP STATION OR REGULATOR GATE: Definition of code value [6] in CVD firs_configuration_text

7 - THREE UPSTREAM AND ONE DOWNSTREAM: Definition of code value [7] in CVD firs_configuration_text

3 - TWO UPSTREAM AND ONE DOWNSTREAM: Definition of code value [3] in CVD firs_configuration_text

8 - UNKNOWN: Definition of code value [8] in CVD firs_configuration_text

METRO_INFLOWS

From King County - WTD

Description

Number of King County WTD pipes entering the facility

Domain

Short integer

LOCAL_INFLOWS

From King County - WTD

Description

Number of non-King County WTD (private or local sewer provided) pipes entering the facility

Domain

Shot integer

LID_TYPE

From King County - WTD

Description

Type of facility cover

Domain

6 - "CLAMSHELL" LID: Definition of code value [6] in CVD firs_lid_type_text

3 - BILCO: Definition of code value [3] in CVD firs_lid_type_text

7 - BLIND FLANGE PRESSURE: Definition of code value [7] in CVD firs_lid_type_text

4 - CONCRETE SLAB: Definition of code value [4] in CVD firs_lid_type_text

5 - CONCRETE SLAB W/ STANDARD METRO LID: Definition of code value [5] in CVD firs_lid_type_text

11 - FLAT STEEL PRESSURE: Definition of code value [11] in CVD firs_lid_type_text

12 - GIRD OR GATE: Definition of code value [12] in CVD firs_lid_type_text

2 - NO SURFACE ACCESS: Definition of code value [2] in CVD firs_lid_type_text

13 - OTHER ROUND STEEL LID: Definition of code value [13] in CVD firs_lid_type_text

8 - SQUARE FLAP PRESSURE: Definition of code value [8] in CVD firs_lid_type_text

1 - STANDARD METRO LID: Definition of code value [1] in CVD firs_lid_type_text

9 - UNDERWATER W/ SLAB: Definition of code value [9] in CVD firs_lid_type_text

10 - UNDERWATER W/O SLAB: Definition of code value [10] in CVD firs_lid_type_text

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

LID_SIZE

From King County - WTD

Description

Diameter or width of facility access in inches

Domain

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

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

SURFACE_ACCESS

From King County - WTD

Description

Quality and type of access to the facility from ground level

Domain

5 - +100' FROM ACCESS ROAD: Definition of code value [5] in CVD firs_surface_access_text

7 - DID NOT LOCATE: Definition of code value [7] in CVD firs_surface_access_text

4 - DRIVE TO WITHIN 100': Definition of code value [4] in CVD firs_surface_access_text

3 - DRIVE TO WITHIN 25': Definition of code value [3] in CVD firs_surface_access_text

2 - IN ROAD, HEAVY TRAFFIC: Definition of code value [2] in CVD firs_surface_access_text

1 - IN ROAD, LIGHT/MODERATE TRAFFIC: Definition of code value [1] in CVD firs_surface_access_text

6 - NO SURFACE ACCESS: Definition of code value [6] in CVD firs_surface_access_text

8 - UNDERWATER, NO ACCESS: Definition of code value [8] in CVD firs_surface_access_text

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

LADDER_FLAG

From King County - WTD

Description

Indicates whether a ladder is built in to the facility

Domain

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

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

CONTRACT

From King County - WTD

Description

Indicates under what contract the facility was constructed

Domain

Text field with max length of 30 characters

TRUNK

From King County - WTD

Description

The trunk for which this facility was constructed

Domain

Text field with max length of 70. Contains name of pipe/trunk

REACH

From King County - WTD

Description

Subsction of a trunk as defined by KCWTD hydraulic model. Each reach is between major flow inputs

Domain

Text field with max length of 70

DESTINATION

From King County - WTD

Description

The receiving water body for flows from this facility

Domain

Text field with max length of 50. Contains water body name.

TREATMENT_PLANT

From King County - WTD

Description

The treatment plant's name indicating the final flow destination

Domain

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

STREET_ADDRESS

From King County - WTD

Description

Facility's street address

Domain

Text field with max length of 50 characters

CITY

From King County - WTD

Description

City name where facility's located

Domain

Text field with max length of 50 characters

N_ACCESSTYPE

From NASSCO

Description

Access type for facility point - NASSCO compliance

Domain

ACB - Catch Basin: Definition of code value [ACB] in CVD firs_n_access_type

ACOH - Clean Out House: Definition of code value [ACOH] in CVD firs_n_access_type

ACOM - Clean Out Mainline: Definition of code value [ACOM] in CVD firs_n_access_type

ACOP - Clean Out Property: Definition of code value [ACOP] in CVD firs_n_access_type

AJB - Junction box: Definition of code value [AJB] in CVD firs_n_access_type

AMH - Meter: Definition of code value [AMH] in CVD firs_n_access_type

AOC - Other special chamber: Definition of code value [AOC] in CVD firs_n_access_type

AWA - Wastewater access: Definition of code value [AWA] in CVD firs_n_access_type

AWW - Wet well: Definition of code value [AWW] in CVD firs_n_access_type

N_LOCATIONCODE

From NASSCO

Description

Location code indicating the type of area where facility point's located - NASSCO compliance.

Domain

M - Airport: Definition of code value [M] in CVD firs_n_loc_code

H - Alley: Definition of code value [H] in CVD firs_n_loc_code

J - Building: Definition of code value [J] in CVD firs_n_loc_code

K - Creek: Definition of code value [K] in CVD firs_n_loc_code

I - Ditch: Definition of code value [I] in CVD firs_n_loc_code

D - Easement / Right of Way: Definition of code value [D] in CVD firs_n_loc_code

C - Light highway: Definition of code value [C] in CVD firs_n_loc_code

B - Main highway - Suburban/rural: Definition of code value [B] in CVD firs_n_loc_code

A - Main highway - Urban: Definition of code value [A] in CVD firs_n_loc_code

Z - Other: Definition of code value [Z] in CVD firs_n_loc_code

G - Parking lot: Definition of code value [G] in CVD firs_n_loc_code

L - Railway: Definition of code value [L] in CVD firs_n_loc_code

F - Sidewalk: Definition of code value [F] in CVD firs_n_loc_code

E - Woods: Definition of code value [E] in CVD firs_n_loc_code

Y - Yard: Definition of code value [Y] in CVD firs_n_loc_code

N_MH_USE

From NASSCO

Description

Use of structure - NASSCO compliance

Domain

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

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

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

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

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

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

N_SURFACETYPE

From NASSCO

Description

Surface surrounding the facility point - NASSCO compliance

Domain

A - Asphalt: Definition of code value [A] in CVD firs_n_surface_type

B - Concrete / Pavement: Definition of code value [B] in CVD firs_n_surface_type

C - Concrete Collar: Definition of code value [C] in CVD firs_n_surface_type

D - Grass / Dirt: Definition of code value [D] in CVD firs_n_surface_type

E - Gravel: Definition of code value [E] in CVD firs_n_surface_type

Z - Other: Definition of code value [Z] in CVD firs_n_surface_type

N_COVERINSERTTYPE

From NASSCO

Description

Type of material of the insert - NASSCO compliance

Domain

M - Metal: Definition of code value [M] in CVD firs_n_coverinserttype

N - None: Definition of code value [N] in CVD firs_n_coverinserttype

Z - Other: Definition of code value [Z] in CVD firs_n_coverinserttype

P - Plastic: Definition of code value [P] in CVD firs_n_coverinserttype

N_ADJUSTMENTRINGTYPE

From NASSCO

Description

Type of adjustment ring - NASSCO compliance

Domain

A - Adjustable: Definition of code value [A] in CVD firs_n_adjustmentringtype

N - None: Definition of code value [N] in CVD firs_n_adjustmentringtype

S - Solid: Definition of code value [S] in CVD firs_n_adjustmentringtype

N_CHIMNEYMATERIAL

From NASSCO

Description

Chimney material - NASSCO compliance

Domain

AL - Aluminium: Definition of code value [AL] in CVD firs_n_chimneymaterial

AC - Asbestos Cement: Definition of code value [AC] in CVD firs_n_chimneymaterial

BR - Brick: Definition of code value [BR] in CVD firs_n_chimneymaterial

CT - Clay tile: Definition of code value [CT] in CVD firs_n_chimneymaterial

CN - Concrete (non-reinforced): Definition of code value [CN] in CVD firs_n_chimneymaterial

CR - Concrete (reinforced): Definition of code value [CR] in CVD firs_n_chimneymaterial

CM - Corrugated metal: Definition of code value [CM] in CVD firs_n_chimneymaterial

FR - Firberglass reinforced: Definition of code value [FR] in CVD firs_n_chimneymaterial

XXX - Not know: Definition of code value [XXX] in CVD firs_n_chimneymaterial

ZZZ - Other: Definition of code value [ZZZ] in CVD firs_n_chimneymaterial

PSC - Plastic / Steel composite: Definition of code value [PSC] in CVD firs_n_chimneymaterial

PE - Polyethylene: Definition of code value [PE] in CVD firs_n_chimneymaterial

PP - Polypropylene: Definition of code value [PP] in CVD firs_n_chimneymaterial

PVC - Polyvinyl chloride: Definition of code value [PVC] in CVD firs_n_chimneymaterial

S - Steel: Definition of code value [S] in CVD firs_n_chimneymaterial

VC - Vitrified clay: Definition of code value [VC] in CVD firs_n_chimneymaterial

N_CONETYPE

From NASSCO

Description

Type of cone - NASSCO compliance

Domain

CC - Conical centered (Concentric): Definition of code value [CC] in CVD firs_n_cone_type

CO - Conical off centered (Eccentric): Definition of code value [CO] in CVD firs_n_cone_type

FT - Flattop: Definition of code value [FT] in CVD firs_n_cone_type

N - No cone: Definition of code value [N] in CVD firs_n_cone_type

ZZ - None of the Above: Definition of code value [ZZ] in CVD firs_n_cone_type

N_CONEMATERIAL

From NASSCO

Description

Cone material - NASSCO compliance

Domain

AL - Aluminium: Definition of code value [AL] in CVD firs_n_conematerial

CAS - Cast iron: Definition of code value [CAS] in CVD firs_n_conematerial

CN - Concrete (non-reinforced): Definition of code value [CN] in CVD firs_n_conematerial

CR - Concrete(reinforced): Definition of code value [CR] in CVD firs_n_conematerial

DI - Ductile iron: Definition of code value [DI] in CVD firs_n_conematerial

FR - Fiberglass reinforced: Definition of code value [FR] in CVD firs_n_conematerial

XXX - Not known: Definition of code value [XXX] in CVD firs_n_conematerial

ZZZ - Other: Definition of code value [ZZZ] in CVD firs_n_conematerial

PSC - Plastic / Steel composite: Definition of code value [PSC] in CVD firs_n_conematerial

PE - Polyethylene: Definition of code value [PE] in CVD firs_n_conematerial

PVC - Polyvinyl chloride: Definition of code value [PVC] in CVD firs_n_conematerial

S - Steel: Definition of code value [S] in CVD firs_n_conematerial

N_BENCHPRESENT

From NASSCO

Description

Indicates if bench present - NASSCO compliance

Domain

N - None: Definition of code value [N] in CVD firs_n_benchpresent

P - Partial: Definition of code value [P] in CVD firs_n_benchpresent

Y - Yes: Definition of code value [Y] in CVD firs_n_benchpresent

N_CHANNELINSTALLED

From NASSCO

Description

Indicates if channel was installed - NASSCO compliance

Domain

N - No: Definition of code value [N] in CVD firs_n_channelinstalled

Y - Yes: Definition of code value [Y] in CVD firs_n_channelinstalled

N_NUMBERSTEPS

From NASSCO

Description

Number of steps in underground structure - NASSCO compliance

Domain

99 - Max value: Definition of code value [99] in CVD firs_n_numbersteps

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

N_YearBuilt

From NASSCO

Description

Year & date facility was constructed - NASSCO compliance

Domain

Date data type

N_Diameter

From NASSCO

Description

Diameter of facility in inches - NASSCO compliance

Domain

Double data type

N_Depth

From NASSCO

Description

Depth of facility in feet

Domain

0.0 to 588.0 by

QAQC_Name

From King County - WTD

Description

Name of the analyst performing quality control

Domain

Text field with max length of 25 characters

QAQC_Date

From King County - WTD

Description

The date of the latest quality check

Domain

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

DB_Mod_Name

From King County - WTD

Description

Name of the analyst performing the last modification

Domain

Text field with max length of 25 characters

DB_Mod_Date

From King County - WTD

Description

The date of the last modification to the geometry or attribute

Domain

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


Contact information

Maintained by DNRP - Wastewater Treatment
Primary Shaun O'Neil

Shaun.O'Neil@kingcounty.gov


Terms of Use

Summary


An inventory of all King County Wastewater Treatment Division pipes, their attributes, and their locations

Description


All of the maintenance holes, pump stations, regulator stations, and treatment plants involved in conveyance and treatment of wastewater for King County WTD


Contact information

Maintained by DNRP - Wastewater Treatment
Primary Shaun O'Neil

Shaun.O'Neil@kingcounty.gov


Terms of use and copyright


Change history

7/29/2019

Schema updates to meet NASSCO requirements

11/14/2015

Schema updates including: Changed Facility_Type from string to small integer; Split Year_Installed into Year_Installed, Year_Acquired, and Year_modified; Added Original_Owner; Deleted X_Coordinate and Y_Coordinate; Added X_NAD83, Y_NAD83, X_NAD27, Y_NAD27, Latitude, and Longitude; Changed Location_Source from string to small integer; Changed Material from string to small integer; Deleted Rim_Elevation; Added RIME_Metro, RIME_NAVD88, and RIME_LIDAR; Changed RIME_Source from string to small integer; Renamed UP_Invert_Elevation to UP_IE; Renamed DOWN_Invert_Elevation to DOWN_IE; Deleted Bottom_Invert_Elevation; Added BTM_IE_Metro and BTM_IE_NAVD88; Added Vert_Datum_Delta; Changed Configuration from string to small integer; Added Metro_Inflows and Local_Inflows; Split Lid_Type into Lid_Type and Lid_Size; Changed Surface_Access from string to small integer; Added Trunk and Destination; Domains were updated and expanded to meet the new schema requirements.