_id	CLASS	CREST	DAMS_ID	DAM_HEIGHT	DAM_NAME	DAM_NO	DRAIN_AREA	EAST	EASTING	FID	NORTH	NORTHING	PERIMETER	PERMITTEE	PURPOSE	QUAD_NAME	STORAGE_NO	STORAGE_TO	STREAM	SURFACE_NO	SURFACE_TO	TYPE	ZONE	geometry
1	C-2	1125	60	18.0	THORN HILL PARK DETENTION BASIN	02-071	126.0	2.0	575180	1	8.05	4502260	0	MARSHALL TOWNSHIP	STORMWATER DETENTION	MARS	0.0	29.0	TRIBUTARY BRUSH CREEK	0.0	3.0	EARTH	17	POINT (575194.1845965468091890 4502483.0253338748589158)
2	C-2	450	78	12.5	SUTULA/STROUD DAM	02-092	0.3	0.75	584960	2	7.8	4502210	0	JOHN SUTULA/HILARY STROUD	RECREATION	VALENCIA	10.0	18.0	TRIBUTARY TO BREAKNECK CREEK	1.5	2.0	EARTH	17	POINT (584986.8240911806933582 4502433.8931794026866555)
3	C-3	210	39	18.0	SARANDRIA DAM	02-040	0.6	11.9	581160	3	6.3	4500510	0	JOSEPH D. SARANDRIA		MARS	18.0	18.0	NORTH FORK PINE CREEK	2.0	0.0	EARTH	17	POINT (581177.7273109422530979 4500726.2699323929846287)
4	C-2	280	34	11.0	KAPPEL DAM	02-025	2.4	13.7	582320	4	0.9	4497930	0	ROBERT LAWTON	STORMWATER DETENTION	MARS	10.0	15.0	NORTH FORK PINE CREEK	3.0	3.0	EARTH	17	POINT (582333.8971898795571178 4498148.9272018196061254)
5	C-3	300	42	15.0	OXFORD DEVELOPMENT CO. DAM	02-048	0.4	10.8	580740	5	0.5	4497660	0	OXFORD DEVELOPMENT COMPANY	STORMWATER DETENTION	MARS	1.0	19.0	TRIBUTARY N. BRANCH PINE CREEK	0.0	0.0	EARTH	17	POINT (580762.1942679734202102 4497884.8312000315636396)
6	B-3	435	40	43.0	SPRING VALLEY LAKE DAM	02-045	0.1	1.8	585710	6	22.4	4497410	0	SPRING VALLEY LAKE-INC.	RECREATION	GLENSHAW	31.0	43.0	TRIBUTARY MONTOUR RUN	3.0	0.0	EARTH	17	POINT (585723.3523940921295434 4497631.7124809864908457)
7	C-2	140	64	21.0	ORCHARD PARK MEADOWS RETENTION BAS	02-075	0.3	10.1	590750	7	22.1	4497100	0	FIFTY-FIVE FIFTY INC	STORMWATER DETENTION	GLENSHAW	0.0	8.0	TRIBUTARY WEST BR. DEER CREEK	0.0	1.0	EARTH	17	POINT (590755.4023226265562698 4497321.2073745308443904)
8	C-3	0	32	14.0	MARSHALL LAKE	02-023	7.6	14.6	583050	8	20.4	4495900	0	ALLEGHENY CO. DEPT. OF ENG.		EMSWORTH	9.0	10.0	NORTH FORK PINE CREEK	7.0	0.0	EARTH	17	POINT (583061.2629377784905955 4496121.7222320428118110)
9	C-2	160	58	20.0	HUNTINGTON WOODS RETENTION POND	02-068	0.48	5.8	577520	9	19.9	4495580	0	FRANKLIN PARK BOROUGH	STORMWATER DETENTION	EMSWORTH	0.0	23.0	TRIBUTARY PINE CREEK	0.0	3.0	EARTH	17	POINT (577541.9765332716051489 4495784.2444045478478074)
10	B-3	954	74	29.0	ALLEGHENY RIVER LOCK AND DAM 4	02-088	0.0	4.3	608420	10	20.7	4496600	0	U.S. ARMY COE	NAVIGATION	NEW KENSINGTON EAST	9000.0	9000.0	ALLEGHENY RIVER	0.0	0.0	GRAVITY	17	POINT (608435.5787948914803565 4496818.1279466887935996)
11	C-2	0	80	17.0	SECHLERS LAKE	02-098	0.45	1.6	575020	11	18.5	4494760	0	JOSEPH E. FARINA	RECREATION	EMSWORTH	10.0	0.0	RIPPLING RUN	2.2	0.0	EARTH	17	POINT (575035.0885162422200665 4494987.8245085831731558)
12	C-2	205	55	24.0	NORTHMONT FARMS BASIN #1	02-065	262.0	4.9	576980	12	18.1	4494520	0	BOROUGH OF FRANKLIN PARK	STORMWATER DETENTION	EMSWORTH	0.0	42.0	FISH RUN CREEK	0.0	3.0	EARTH	17	POINT (576988.7027858148794621 4494730.2460495736449957)
13	C-2	180	56	21.0	NORTHMONT BASIN DAM #2	02-066	339.0	5.15	577160	13	17.9	4494460	0	BOROUGH OF FRANKLIN PARK	STORMWATER DETENTION	EMSWORTH	0.0	42.0	FISH RUN CREEK	0.0	2.0	EARTH	17	POINT (577177.1652926820097491 4494670.6804388640448451)
14	B-1	1130	35	33.0	PINE CREEK	02-026	25.0	0.5	584750	14	17.7	4494440	0	COUNTY OF ALLEGHENY	RECREATION	GLENSHAW	570.0	1950.0	PINE CREEK	75.0	190.0	EARTH	17	POINT (584769.7952307638479397 4494660.1300085512921214)
15	C-3	150	82	16.0	POTTER PARK LAKE DAM	02-100	0.2	8.8	579350	15	15.9	4493140	0	McCANDLESS TOWNSHIP	RECREATION	EMSWORTH	1.3	3.0	TRIBUTARY TO PINE CREEK	0.56	1.0	EARTH	17	POINT (579377.1138611308997497 4493367.6964808395132422)
16	C-2	120	68	28.0	DETENTION BASIN	02-080	112.0	9.3	590350	16	14.3	4492330	0	HAMPTON-GLADE JOINT VENTURE	STORMWATER DETENTION	GLENSHAW	0.0	7.0	TRIB TO GOURDHEAD RUN	0.0	1.0	EARTH	17	POINT (590366.9043535897508264 4492536.5997270727530122)
17	C-2	120	67	28.0	WILDWOOD GOLF CLUB POND NO 2	02-078	0.12	2.65	586320	17	14.1	4492160	0	WILDWOOD GOLF CLUB	RECREATION/IRRIGATION	GLENSHAW	5.0	6.0	TRIB PINE CRK	1.0	1.0	EARTH	17	POINT (586324.6649895267328247 4492365.4412054177373648)
18	C-3	120	66	24.0	WILDWOOD GOLF CLUB POND NO.1	02-077	0.0	2.0	585860	18	13.5	4491780	0	WILDWOOD GOLF CLUB	RECREATION/IRRIGATION	GLENSHAW	5.0	6.0	TRIB PINE CRK	1.0	1.0	EARTH	17	POINT (585882.0561990542337298 4491990.2350212289020419)
19	C-2	180	70	25.0	WITTMER ROAD DET. DAM	02-082	0.25	10.9	580730	19	12.3	4490970	0	TOWN OF McCANDLESS	FLOOD CONTROL	EMSWORTH	0.0	14.4	WITTMER RUN	0.0	1.7	EARTH	17	POINT (580741.2742257870268077 4491192.8084770701825619)
20	C-2	270	63	18.0	LaROCHE COLLEGE DETENTION BASIN	02-074	0.24	15.15	583300	20	12.2	4491000	0	THE TOWNSHIP OF McCANDLESS	STORMWATER DETENTION	EMSWORTH	0.0	12.0	TRIBUTARY LITTLE PINE CREEK	0.0	2.0	EARTH	17	POINT (583327.8722258113557473 4491221.3150004902854562)
21	C-2	120	85	8.0	DETENTION BASIN	02-104	0.2	15.75	583770	21	12.2	4490980	0	TOWN OF MCCANDLESS	STORMWATER DETENTION	EMSWORTH	0.0	5.0	TRIB TO LITTLE PINE CREEK	0.0	1.4	EARTH	17	POINT (583680.8223298992961645 4491194.3842329187318683)
22	C-3	1799	77	39.0	DASHFIELDS LOCK AND DAM	02-091	0.0	6.2	567030	22	8.9	4488710	0	U.S. ARMY COE	NAVIGATION	AMBRIDGE	17000.0	17000.0	OHIO RIVER	0.0	0.0	GRAVITY	17	POINT (567051.0689707403071225 4488929.2787015261128545)
23	C-3	150	27	14.0	UPPER DAM	02-006	2.6	11.9	570710	23	7.5	4488000	0	SEWICKLEY WTR. WORKS		AMBRIDGE	6.0	6.0	LONG RUN	0.0	0.0	GRAVITY	17	POINT (570727.5184279949171469 4488223.3117119278758764)
24	B-2	200	81	42.0	14-NORTH IMPOUNDMENT	02-099	0.14	0.6	595790	24	8.5	4488890	0	CONSOLIDATION COAL COMPANY	WATER SUPPLY	NEW KENSINGTON WEST	17.5	25.0	UNNAMED TRIB. TO CAMPBELL RUN	1.4	1.68	EARTH	17	POINT (595795.9647716418839991 4489119.5233525410294533)
25	A-1	495	53	107.0	CHESWICK EMERGENCY ASH POND	02-063	0.14	11.15	602060	25	8.75	4489100	0	DUQUESNE LIGHT COMPANY, WM. J. HELD P.E.	SEDIMENT BASIN	NEW KENSINGTON WEST	0.0	284.0	TRIBUTARY TOWNEY RUN	0.0	13.0	EARTH	17	POINT (602074.5614768703235313 4489326.3629809152334929)
26	C-3	0	26	19.0	LOWER DAM	02-004	0.02	11.3	570430	26	7.2	4487820	0	SEWICKLEY WATER AUTHORITY	WATER SUPPLY	AMBRIDGE	10.0	15.0	LONG RUN	3.0	3.0	EARTH	17	POINT (570446.9383895263308659 4488035.5150867057964206)
27	C-2	340	37	19.0	CAMPBELLS POND	02-032	0.7	15.1	594000	27	7.3	4488630	0	G. KEITH TURNBULL	RECREATION	GLENSHAW	17.0	34.0	SQUAW RUN	5.0	5.4	EARTH	17	POINT (594011.4407885668333620 4488850.2803242951631546)
28	A-3	860	44	153.0	RUSSELTON SLURRY POND NO.3	02-052	0.15	4.5	597650	28	18.2	4488580	0	BCNR MINING CORPORATION	SEDIMENT BASIN	NEW KENSINGTON WEST	24.0	290.0	TRIBUTARY LITTLE DEER CREEK	26.0	0.0	EARTH	17	POINT (597658.4661981674144045 4488804.7126162378117442)
29	A-1	900	45	410.0	HARMAR REFUSE BANK	02-053	0.14	4.0	597700	29	8.0	4488600	0	MINERAL TECHNOLOGY, INC.	TAILINGS	NEW KENSINGTON WEST	146.0	1578.0	TRIBUTARY GUYS RUN	15.0	42.0	OTHER	17	POINT (597705.5957076156046242 4488805.2769846720620990)
30	B-3	2114	73	36.0	ALLEGHENY RIVER LOCK AND DAM 3	02-087	0.0	8.3	600360	30	6.6	4487970	0	U.S. ARMY COE	NAVIGATION	NEW KENSINGTON WEST	16800.0	16800.0	ALLEGHENY RIVER	0.0	0.0	GRAVITY	17	POINT (600372.3494094961788505 4488193.1195950470864773)
31	C-2	950	47	39.0	HARMAR STORAGE POND NO 4	02-055	0.1	4.0	597700	31	6.55	4487700	0	MINERALS TECHNOLOGY INC	SLURRY IMPOUNDMENT	NEW KENSINGTON WEST	32.38	54.2	TRIBUTARY GUYS RUN	1.91	2.4	EARTH	17	POINT (597717.3573259079130366 4487910.8264062143862247)
32	C-3	0	33	14.0	GLADE LAKE	02-024	2.0	15.9	594300	32	4.85	4486780	0	FOX CHAPEL GOLF CLUB		GLENSHAW	0.0	10.0	GLADE RUN	2.0	0.0	EARTH	17	POINT (594317.2125701021868736 4487003.4403817579150200)
33	C-3	1928	61	25.0	EMSWORTH LOCK AND DAM	02-072	0.0	5.1	577280	33	0.9	4483960	0	TOWNSHIP OF POTTER	HYDROELECTRIC	EMSWORTH	42700.0	42700.0	OHIO RIVER	0.0	3070.0	GRAVITY	17	POINT (577285.8325295343529433 4484187.0195138296112418)
34	B-2	203	62	54.0	MONTOUR HEIGHTS COUNTRY CLUB DAM	02-073	0.04	8.3	568600	34	0.1	4483460	0	MONTOUR HEIGHTS COUNTRY CLUB	RECREATION/IRRIGATION	AMBRIDGE	28.0	34.0	TRIBUTARY MEEKS RUN	1.0	2.0	EARTH	17	POINT (568604.7562314658425748 4483670.5454548895359039)
35	C-3	145	49	13.0	GREATER PITTSBURGH AIRPORT DAM	02-059	0.3	5.2	566730	35	22.45	4483120	0	ALLEGHENY CO. DEPT OF AVIATION		OAKDALE	0.0	1.0	TRIBUTARY MCCLARONS RUN CREEK	0.0	0.0		17	POINT (566748.2163982396014035 4483345.3113591242581606)
36	C-2	360	54	39.5	ALLEGHENY DEPT OF AVIATION	02-064	2.7	0.7	564000	36	19.2	4481220	0	ALLEGHENY COUNTY DEPARTMENT OF AVIATION	STORMWATER DETENTION	OAKDALE	80.0	374.5	TRIBUTARY MONTOUR RUN	12.0	17.8	EARTH	17	POINT (564010.1870200268458575 4481440.4224729212000966)
37	B-3	1473	72	58.0	ALLEGHENY RIVER LOCK AND DAM 2	02-086	0.0	11.5	591960	37	20.4	4482130	0	U.S. ARMY COE	NAVIGATION	PITTSBURGH EAST	14500.0	14500.0	ALLEGHENY RIVER	0.0	0.0	GRAVITY	17	POINT (591974.0506198923103511 4482348.8890517167747021)
38	B-2	900	59	65.0	BALD KNOB	02-070	0.26	8.32	558060	38	14.48	4478210	0	ALOE COAL COMPANY	SEDIMENT BASIN	CLINTON	31.0	625.0	TRIBUTARY POTATO GARDEN RUN	4.0	24.0	EARTH	17	POINT (558076.6255626298952848 4478431.9423732822760940)
39	C-2	150	79	14.0	LAKE STEUBEN DAM	02-093	0.3	17.05	574000	39	14.8	4478590	0	WILLIS L. PETRIE	RECREATION	OAKDALE	8.0	20.0	MOON RUN	2.0	4.4	EARTH	17	POINT (574020.4183699993882328 4478819.3138052122667432)
40	C-2	140	43	22.0	WALDENWOODS	02-049	0.4	3.95	566000	40	12.95	4477350	0	JOHN N. HALL, PARTNER	STORMWATER DETENTION	OAKDALE	0.0	6.0	TRIB MONTOUR RUN	0.0	0.0	EARTH	17	POINT (566022.6515811291756108 4477572.2212864644825459)
41	C-1	0	71	25.0	JOHNSTON POND	02-083	0.18	4.63	608950	41	13.7	4478900	0	MR. RAY P. JOHNSTON	RECREATION	MURRYSVILLE	0.0	8.0	TRIBUTARY ABERS CREEK	0.0	0.0	EARTH	17	POINT (608975.9008669209433720 4479123.1681344099342823)
42	C-3	160	65	16.0	BELMONT RIDGE	02-076	0.3	13.55	603720	42	10.3	4476180	0	BELMONT EQUITIES INC	STORMWATER DETENTION	BRADDOCK	0.0	6.0	TRIBUTARY TO TURTLE CREEK	0.0	1.0	EARTH	17	POINT (603736.2546603921800852 4476396.5676630735397339)
43	C-3	90	48	14.0	CARING 1 DAM	02-057	0.2	0.85	606550	43	8.5	4475120	0	CARING 1, A LIMITED PARTNERSHI		MURRYSVILLE	0.0	2.0	TRIBUTARY TURTTLE CREEK	0.0	0.0		17	POINT (606556.1971974534681067 4475325.3902675313875079)
44	B-3	960	75	33.0	MONONGAHELA RIVER LOCK AND DAM 2	02-089	0.0	2.1	596900	44	3.1	4471640	0	U.S. ARMY COE	NAVIGATION	BRADDOCK	13700.0	13700.0	MONONGAHELA RIVER	0.0	0.0	GRAVITY	17	POINT (596913.6690542389405891 4471864.1376120615750551)
45	B-3	832	76	16.0	MONONGAHELA RIVER LOCK AND DAM 3	02-090	0.0	14.0	593680	45	2.6	4457540	0	U.S. ARMY COE	NAVIGATION	GLASSPORT	16300.0	16300.0	MONONGAHELA RIVER	0.0	0.0	GRAVITY	17	POINT (593693.6877327129477635 4457761.2249630726873875)
46	C-1	435	36	30.0	BUTLER'S LAKE	02-029	0.3	7.65	600200	46	2.45	4457630	0	BUTLERS GOLF COURSE	RECREATION/IRRIGATION	MCKEESPORT	94.0	100.0	TRIBUTARY TO BOYDS HOLLOW RUN	9.0	10.0	EARTH	17	POINT (600212.4326619752682745 4457844.8523959703743458)