Facilities

Table FACILITIES belongs to the class of station tables.

The table below shows just a small selection of records. Currently, there are about 218 records in the table, which encompasses both industrial plants and wastewater treatment plants. Therefore, this table is both needed by the industrial demand and the wastewater resources module.

FACILITY_ID	NAME	TREATMENT _UNIT	YEAR	POC	PHONE	ADDRESS	SIC _CODE	PLANT _LOAD	PLANT _CAPACITY	PLANT _CONNECT	BASIN _CODE	VILLAGE _TOWN_CODE	GOVERNORATE _CODE	COMMENTS	LAST_DATE _UPDATED	USER_NAME	SERVICE _ZONE_ID	OWNER _ID	WWTP _TYPE	JORDAN _NORTH	JORDAN _EAST
INAQ01	AQABA THERMAL POWER STATION	BIOLOGICAL TREATMENT	1986	ENG. NASER, OR MOH'D	2014077	P.O.Box 1416	4010			n	ED	406	AQ	X	07/02/2001	ABDEL_KHALEQ	K001	PRV	0	252219	303172
INAQ02	JORDAN PHOSPHATE MINES (FERTIL	Not Known	1977	TALA'T ZUREIKAT-ACTING MANAGER	032014151	P.O.Box 409 Aqaba	1421			n	ED	406	AQ	NO DISCGARGE-REUSE ON PROCESS- CLOSED LOOP	04/11/2002	ABDEL_KHALEQ	K001	PRV	0	251556	303953
TPNQA01	NORTH QUEEN ALIA AIRPORT	Activated Sludge	2005	Abu Arqoub	5680101	MWI	9000	20000	20000	N	CD	5	AM		27/01/2002	TAHA	CD11	WAJ	2	518308	406681

The most important fields are:

FACILITY_ID (for linking monitoring data)
SIC_CODE :The ISIC classes give a rather precise classification of the type of industry. There are about 300 different classes stored in look-up table ISIC_CLASS_CODES.
PLANT_CONNECT: Connected to sewer yes/no
SERVICE_ZONE_ID for linking to a wastewater service zone
OWNER_ID (c.f. look-up table WWTP_OWNERSHIP) indicates if the facility is privately owned or belonging to one of the Agencies.
WWTP_TYPE (Type of WWTP; 0 means, that it is not a WWTP)

Note: for better readability, the following irrelevant fields of table FACILITIES are not shown:

UTM_ZONE, UTM_NORTH, UTM_EAST HORIZONTAL_ACCURACY, COORDINATE_METHOD, HORIZONTAL_DATUM_CODE, MAP_SCALE, PALESTINE_NORTH, PALESTINE_EAST, ALTITUDE VERTICAL_ACCURACY, VERTICAL_DATUM_CODE, BENCH_MARK_CODE