1. Scope of Analysis and Target Future State
The General Company for Water and Wastewater was established in its national form under Law No. 8 of 1997 and was subsequently reorganised and reconstituted under Decision No. 923 of 2007 as a public company with legal personality, financial independence, and administrative and financial autonomy.
The Company’s headquarters are located in Tripoli. It carries out its activities through a central structure and geographically distributed operational regions, Offices and service centres.
The Company’s general mandates include:
- Operating and maintaining water transmission and distribution systems.
- Operating and maintaining pumping and treatment plants.
- Operating reservoirs and monitoring and control centres.
- Implementing water connections for consumers.
- Managing customer, meter, consumption and collection data.
- Operating and maintaining wastewater networks and plants.
- Implementing projects and works associated with water and wastewater services.
The WP2 analysis focuses on data management needs relating to sources, production, pumping, networks, facilities, assets, maintenance, water quality, customers, meters, complaints, billing, water losses, documents and reports.
The scope of the analysis includes:
- Headquarters.
- Operational regions.
- Offices.
- Service centres.
- Plants and operational sites.
The functional areas presented in this chapter are not used as official organisational titles unless confirmed in an approved institutional document. A local response received from an Office, centre or region is also not generalised to the entire Company without an institutional basis permitting such generalisation.
Table (6.1): Scope of the Analysis of the Company’s Needs
| Element | Scope |
|---|
| Entity | General Company for Water and Wastewater |
| Institutional status | Public company with legal personality and financial independence |
| Operational field | Production, pumping, transmission and distribution of water and provision of wastewater services |
| Levels covered | Headquarters, regions, Offices, service centres and operational sites |
| Principal data | Sources, networks, plants, assets, maintenance, quality and customers |
| Sources of results | WP2 responses and supporting WP1 findings |
| Analysis outputs | Needs, objectives, priorities and preliminary requirements |
| Limitations of the analysis | Does not include detailed design or final selection of software products |
The WP2 results showed that the Company requires an interconnected national environment for managing water and wastewater service data. This environment should organise operational, technical and service-related data and link headquarters to the regions, Offices, service centres and operational sites.
The principal needs include:
- Unified reference registers for sources, networks, facilities, assets and customers.
- Periodic recording of production, pumping and distribution data.
- A spatial database for networks, assets and service areas.
- Management of failures, notifications, work orders and maintenance.
- Organisation of water samples and analysis results.
- Organisation of customer, connection, meter and consumption data.
- A unified complaints register and follow-up until closure.
- Linking production, distribution, consumption and billing.
- Supporting the preparation of the water balance and analysis of water losses.
- Organising maps, plans, documents and historical records.
- Preparing reports, indicators and monitoring dashboards.
- Organising responsibilities, permissions, backup and restoration.
- Training users and operation and support teams.
- Implementing the system gradually in a manner appropriate to the geographic scope and level of readiness.
Table (6.3): Summary of the Company’s Needs
| Theme | Principal Need | Purpose |
|---|
| Sources and production | Unified register and periodic operational data | Monitoring supply, production and pumping |
| Networks | Spatial database | Managing pipelines, networks and their components |
| Facilities and assets | Unified reference register | Linking assets to location, condition and maintenance |
| Maintenance | Notifications and work orders | Monitoring preventive and corrective maintenance |
| Water quality | Sample and result database | Monitoring quality spatially and over time |
| Customers and meters | Unified and updated database | Supporting service, consumption and billing |
| Complaints | Central register | Monitoring complaints until closure |
| Water losses | Linking production, distribution and consumption | Preparing the water balance and analysing losses |
| Reports | Reports and monitoring dashboards | Supporting central Management and the regions |
| Governance | Responsibilities, permissions and backup | Protecting data and ensuring continuity |
2. Principal Datasets
The Company deals with a broad range of operational, technical, spatial, service-related and commercial data.
Table (6.2): Functional Areas and Datasets
| Functional Area | Principal Datasets |
|---|
| Sources, production and pumping | Wells, water received, production, pumping, quantities and quality |
| Transmission and distribution | Trunk pipelines, distribution networks, pressures, flows and service areas |
| Reservoirs and plants | Reservoirs, pumping and treatment plants, capacities and operational status |
| Assets and maintenance | Assets, failures, notifications, work orders and maintenance |
| Water quality | Samples, analyses, conformity, non-conformity and corrective actions |
| Customers and services | Connections, meters, readings, consumption and billing |
| Complaints | Complaints, notifications, referrals, follow-up and closure |
| Water balance and losses | Water produced, received, distributed, consumed and billed |
| Wastewater | Networks, pumping and treatment plants, flows, loads and discharge |
| Projects and planning | Expansions, rehabilitation, projects, priorities and costs |
| Spatial information | Maps, asset locations, service areas and GIS databases |
| Documents and reports | Plans, technical records, operational reports and archives |
| Governance and protection | Responsibilities, permissions, data exchange and backup |
The Company’s scope includes drinking-water and wastewater-service data, including wastewater networks, pumping and treatment plants, flows, loads, discharge, maintenance and blockages. However, the level of detail available in the WP2 results varies among the functional areas. Not all topics included in the study tool should therefore be converted into final requirements without verification.
3. Principal Needs
The general needs are as follows:
- Establish a unified reference register of water sources.
- Assign a permanent identifier to each source, well, plant, reservoir, network and asset.
- Organise data on water produced, received, pumped and distributed.
- Preserve production, pumping and distribution data historically.
- Establish a geographic database for networks and facilities.
- Link networks to sources, reservoirs, plants and service areas.
- Establish a unified register of assets and equipment.
- Record failures, notifications and work orders.
- Organise preventive and corrective maintenance.
- Establish a unified database of water samples and results.
- Link quality results to the source, reservoir, network and region.
- Record non-conformities and corrective actions.
- Establish a unified database of customers, connections and meters.
- Link meters to readings, consumption and billing.
- Establish a central register of complaints and notifications.
- Link each complaint to the customer, location, network or asset.
- Link production, distribution, consumption and billing data.
- Support preparation of the water balance and analysis of water losses.
- Organise data on wastewater networks and plants.
- Organise maps, plans, documents and their versions.
- Prepare central and regional reports and indicators.
- Define responsibilities for data entry, review and approval.
- Organise user permissions and track amendments.
- Provide backup and restoration.
- Support sites experiencing weak or interrupted connectivity.
- Digitise priority records and maps.
- Train users and operation and support teams.
- Support gradual implementation and scalability.
4. Data Management System Objectives
Table (6.6): Company Objectives Register
| Objective Code | Objective |
|---|
| GWWC-OBJ-01 | Standardise water-source, production and pumping data |
| GWWC-OBJ-02 | Establish a spatial database for networks, facilities and service areas |
| GWWC-OBJ-03 | Link sources, reservoirs, plants and distribution networks |
| GWWC-OBJ-04 | Provide a unified reference register of assets |
| GWWC-OBJ-05 | Organise failure and maintenance-order data |
| GWWC-OBJ-06 | Organise water samples and analysis results |
| GWWC-OBJ-07 | Standardise customer, connection and meter data |
| GWWC-OBJ-08 | Support complaint registration and follow-up until closure |
| GWWC-OBJ-09 | Support preparation of the water balance and analysis of losses |
| GWWC-OBJ-10 | Link operational, technical and service-related data |
| GWWC-OBJ-11 | Provide central and regional reports and monitoring dashboards |
| GWWC-OBJ-12 | Organise permissions and traceability of amendments |
| GWWC-OBJ-13 | Ensure backup, restoration and continuity of access |
| GWWC-OBJ-14 | Digitise priority maps, documents and records |
| GWWC-OBJ-15 | Support data exchange among headquarters, regions and Offices |
| GWWC-OBJ-16 | Develop the capacities of users and operation and support teams |
| GWWC-OBJ-17 | Support phased and scalable implementation |
These objectives are consistent with the detailed Objectives Register in the WP2 report. The technical annex presents four consolidated objectives: standardising operational and service-related data; spatially managing networks and assets; supporting maintenance, quality and customer service; and supporting the water balance and water-loss analysis.
5. Required Practical Result
| Department / Functional Area | Required Practical Result |
|---|
| Water-Source, Production and Pumping Data | The Company should be able to determine: • The quantity of water produced from its sources. • The quantity of water received from producing entities. • The quantity of water pumped. • The status of each source or plant. • Changes in production and pumping over time. • Reasons for declines or shutdowns. • The WP2 results confirm the need to record production and pumping data according to the approved operational frequency, preserve them historically and make them available at regional and central levels. |
| Transmission, Distribution, Network and Facility Data | The spatial database should provide a unified reference showing the location, characteristics, condition and service areas of networks and facilities and linking them to assets, failures, maintenance and customers. • Geographic Information Systems (GIS) are a fundamental component because networks, facilities, assets, customers and failures must be linked to specific locations. |
| Reservoir and Plant Data | Provide an integrated electronic file for each reservoir or plant showing its operational status, technical data, associated assets, failures, maintenance and related quality results. |
| Asset, Failure and Maintenance Data | The Company should be able to determine: • The location and condition of the asset. • Previous failures. • Maintenance activities performed. • Open work orders. • Response and repair duration. • Materials and spare parts used. • Assets requiring replacement or rehabilitation. |
| Water-Quality and Analysis Data | The Company should be able to determine the water-quality status at each source, reservoir, network or service area and monitor non-conformities and the associated corrective actions. |
| Complaint and Customer-Service Data | The Company should be able to determine: • The number of open and closed complaints. • Locations where complaints are concentrated. • Types of recurring problems. • Average response and resolution times. • The relationship between complaints, failures, interruptions and maintenance. |
| Water Balance and Loss Analysis | Provide a traceable water balance showing the source of each value, its calculation method and level of accuracy, and supporting identification of areas requiring measurement, maintenance or data improvement. • Calculation formulae, balance areas and indicator definitions will be determined in coordination with the Company under WP3. |
