Wastewater Treatment Plants

State of New York

@usgov.state_of_new_york_wastewater_treatment_plants

Table List

1 table(157.48 KB)

Table 1

@usgov.state_of_new_york_wastewater_treatment_plants.table_1

157.48 KB
2016 rows
14 columns

plant_type Plant Type	spdes_permit_number SPDES Permit Number	facility_name Facility Name	ground_or_surface Ground Or Surface	average_design_hydraulic_flow Average Design Hydraulic Flow	street Street	city City	state State	country Country	zip_code Zip Code	latitude Latitude	longitude Longitude	location_1 Location 1	georeference Georeference
Industrial	NY0264431	Byram Concrete & Supply, LLC	Ground		31 FIELDS LN	BREWSTER	NY	USA		41.36	-73.61	(41.36, -73.61)	POINT (-73.61 41.36)
Industrial	NY0231681	SYRACUSE LLC	Surface	0.17	300 BELLE ISLE RD	SOLVAY	NY	USA	13209	43.07	-76.22	(43.07, -76.22)	POINT (-76.22 43.07)
Industrial	NY0160873	NYSDOT- SUB RESIDENCY KANONA	Ground		7909 ST RTE 53	BATH	NY	USA	14810	42.39	-77.36	(42.39, -77.36)	POINT (-77.36 42.39)
Industrial	NY0226653	STOP AND WASH LAUNDROMAT CORP	Ground	0.03	432 SUFFOLK AVE	BRENTWOOD	NY	USA	11717	40.78	-73.26	(40.78, -73.26)	POINT (-73.26 40.78)
Industrial	NY0098400	FILTROS LTD	Ground		603 W COMMERCIAL ST	EAST ROCHESTER	NY	USA	14445	43.12	-77.5	(43.12, -77.5)	POINT (-77.5 43.12)
Industrial	NY0265276	AGRI-CYCLE COMPOSTING FACILITY	Surface		BELLE RD	BUSKIRK	NY	USA	12028	42.98	-73.43	(42.98, -73.43)	POINT (-73.43 42.98)
Industrial	NY0256188	X-PLO INC SAND & GRAVEL PIT	Ground		KELLY RD	SCHUYLER FALLS	NY	USA	12985	44.67	-73.52	(44.67, -73.52)	POINT (-73.52 44.67)
Municipal	NY0215198	WINDSOR ESTATES WWTP	Surface	0.02	35 BRISTOL DR	MIDDLETOWN	NY	USA	10941	41.45	-74.32	(41.45, -74.32)	POINT (-74.32 41.45)
Industrial	NY0250643	DONOVAN FIVE BMAC	Ground		8 NANCY CT	WAPPINGERS FALLS	NY	USA	12590	41.61	-73.84	(41.61, -73.84)	POINT (-73.84 41.61)
Industrial	NY0218481	HINCKLEY RESERVOIR WATER TREATMENT PLANT	Both	0.95	OLD QUARRY RD OFF PROSPECT-TRENTON FALLS RD	TRENTON	NY	USA		43.29	-75.15	(43.29, -75.15)	POINT (-75.15 43.29)


CREATE TABLE table_1 (
  "plant_type" VARCHAR,
  "spdes_permit_number" VARCHAR,
  "facility_name" VARCHAR,
  "ground_or_surface" VARCHAR,
  "average_design_hydraulic_flow" DOUBLE,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "zip_code" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location_1" VARCHAR,
  "georeference" VARCHAR
);