Neno Kukuric - IGRAC Almaty - July 2014

Data Processing & Harmonisation

Structured data

Standardised formats:

• Digital maps• Tables (excel)• Text

Data collection

• Paper maps• Paper reports

Text, tabular data, images, maps

• Digital dataTables, maps, reports

Data Processing

From ‘raw’ data to consistently structured data

17°E 18°E 19°E 20°E 21°E 22°E 23°E 24°E 25°E 26°E

-28°S

-27°S

-26°S

-25°S

-24°S

-23°S

-22°SW indhoek

Stampriet

Gochas

Gobabis

Aminius

Aroab Bokspits

HukuntsiKang

Ncojane

Tsabong

W erdaGoodhope

Mmabatho

Kuruman

Vanzylsrus

Tosca

450

1,000

2,000

5,000

10,000

20,000

50,000

TDSmg/l

From ‘technical’ maps to simplified thematic

maps

Data Processing

Harmonisation: Formations

?

Kazakhstan

Uzbekistan

Harmonisation: Formations

1 TBA

2 Countrie

s

• Countries need consensuson delineation of TBA

2 data sets•National data sets may differ

in format

Harmonised data

• Harmonised TBA map, based on national data sets.

Harmonisation: map information

Transboundary aquifer

For example information onAquifer productivity (Namibia) andGroundwater potential (Botswana)

Harmonisation: agreements on units

0 0.5 1 1.5 2 2.510Log (Yield) m 3/h

0

10

20

30

40

50

60

70

80

90

100

Pro

bab

ilit

y %

Dolom ite KanyeOlifantshoek BotswanaBasalt SAB

(69)(16)

(13)

0 0.5 1 1.5 2 2.510Log (Yield) m 3/h

0

10

20

30

40

50

60

70

80

90

100

Pro

bab

ilit

y %

Kalahari SABKalahari Botswana

(38)

(37)

Borehole yieldm3/hr (Namibia) , l/s (South

Africa)

Namibia, 1991 South Africa, 2006Group AExcellent

Group BGood

Group CLowHealthRisk

Group DUnsuitable

Class IOperational

Class IIMax allowable forlimited duration

mg/l mg/l mg/l mg/l mg/l mg/l

Harmonisation: agreements on classifications

Harmonisation is about developing a common language and terminology, i.e. agreeing on:

• classifications (suitability for water consumption, land use types, water use types, stratigraphy, etc. etc.)

•map scale and map projection• areal sub-divisions for reporting (eg report per local

municipality or per district?)

• units• table formats• report format• additions/modifications to the methodology (eg:

Groundwater community management)• ….• ….

Data processing & Harmonisation

1. Data collection (incl. data entry and digitising of relevant information)

2. Taking stock(which data are available and which not) and fine-tuning of methodology (data & indicators)

3. Structuring of data (data processing)4. Harmonising data

in a consistent way across the aquifer5. Producing outputs: Indicators, thematic maps,

overview tables, illustrative graphs, conceptual model, assessment report

Project workflow / tasks

11

Thank you