DoWR – NIP-CAP Information System
Data Entry Table: Water Quality
| id | system_name | dwqtid | area_council | island | province | hcf_name | School ID | Sample ID | Sample Site Name | s1careacouncil | s1disland | s1eprovince | DWQT Sample Date | DWQT Sample Latitude | DWQT Sample Longitude | DWQT Sample Elevation | DWQT Sample Flow rate | DWQT Sample Location Description | Source Type | Specific Source Type | Water System Type | Conductivity (µs/m) | Turbidity (NTU) | pH | Taste/Odor | Hardness (mg/L) | Fluoride (mg/L) | Arsenic (mg/L) | Copper (mg/L) | Lead (mg/L) | Iron (mg/L) | Ecoli Test Type | E.Coli (#/100ml) | Total Coliforms (#/100ml) | Faecal Coliforms (#/100ml) | Additional Comments | Data Shared with Community |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | WS_Narango | 10,328 | West Malo | MALO | SANMA | TimFoster051 | Narango 2 | West Malo | MALO | SANMA | 27/09/2017 | -15.651899 | 167.090000 | Malo | Ground | Borehole | Indirect Gravity Feed | 1.398 | Acceptable | Compartment Bag Testing (CBT) | 0 | Handpump | Yes | ||||||||||||||
| 2 | WS_Agriculture College | 10,028 | Canal - Fanafo | SANTO | SANMA | SL17 | Agriculture college | SANTO | SANMA | 08/10/2018 | -15.487060 | 167.192600 | Ground | Borehole | Indirect Gravity Feed | 390.000 | 1.61 | 790.00 | 20 | ||||||||||||||||||
| 3 | WS_Agriculture Lenakel | 10,060 | West Tanna | TANNA | TAFEA | TIA2 | Agriculture Lenakel | West Tanna | TANNA | TAFEA | 16/01/2018 | -19.539111 | 169.278194 | Ground | Borehole | Indirect Gravity Feed | 527.000 | 2.30 | 7.33 | 0 | 34.00 | ||||||||||||||||
| 4 | WS_Aligu | 10,760 | North Pentecost | PENTECOST | PENAMA | Aligu_Pen_19_1 | Aligu Community | North East Pentecost | PENTECOST | PENAMA | 20/07/2019 | -15.561953 | 168.188338 | 10 | The spring is located near the sea with no spring box present, no outside technical support and during high tide the spring is under the sea. | Ground | Coastal Waters | Direct Gravity Feed | 463.000 | 326.00 | 7.65 | Acceptable | Compartment Bag Testing (CBT) | 101 | Spring SourceE.coli is >100 | Yes | |||||||||||
| 5 | WS_Aligu | 10,761 | North Pentecost | PENTECOST | PENAMA | Aligu_Pen_19_2 | Aligu Community | North East Pentecost | PENTECOST | PENAMA | 20/07/2019 | -15.561953 | 168.188338 | 307 | 29 | Old Existing water source system. | Ground | Spring | Direct Gravity Feed | 440.000 | 0.20 | 8.46 | Acceptable | Compartment Bag Testing (CBT) | 101 | Existing SourceE.coli is >100 | Yes | ||||||||||
| 6 | WS_Aloptora | 10,444 | West Malo | MALO | SANMA | TimFoster188 | Aloptora RWH | West Malo | MALO | SANMA | 22/08/2017 | -15.681370 | 167.088443 | Malo | Rain | Rain | Rainwater Capture | 0.138 | Acceptable | Compartment Bag Testing (CBT) | 0 | RWH | Yes | ||||||||||||||
| 7 | WS_Amalearo | 10,299 | West Malo | MALO | SANMA | TimFoster022 | Amalearo 1 | West Malo | MALO | SANMA | 27/09/2017 | -15.650596 | 167.091826 | Malo | Ground | Borehole | Indirect Gravity Feed | 0.700 | Acceptable | Compartment Bag Testing (CBT) | 0 | Handpump | Yes | ||||||||||||||
| 8 | WS_Ambilake 2 | 10,449 | West Malo | MALO | SANMA | TimFoster193 | Ambilake 2 RWT | West Malo | MALO | SANMA | 29/09/2017 | -15.685525 | 167.090827 | Malo | Rain | Rain | Rainwater Capture | 0.049 | Acceptable | Compartment Bag Testing (CBT) | 0 | RWH | Yes | ||||||||||||||
| 9 | WS_Ambilake 1 | 10,300 | West Malo | MALO | SANMA | TimFoster023 | Ambilake 1 | West Malo | MALO | SANMA | 29/09/2017 | -15.684373 | 167.090613 | Malo | Ground | Borehole | Indirect Gravity Feed | 0.662 | Acceptable | Compartment Bag Testing (CBT) | 0 | Hand pump | Yes | ||||||||||||||
| 10 | WS_Anusa | 10,392 | Canal - Fanafo | TUTUBA | SANMA | TimFoster136 | Anusa | Canal - Fanafo | TUTUBA | SANMA | 19/08/2017 | -15.573336 | 167.261447 | Tanna | Ground | Borehole | Indirect Gravity Feed | 0.828 | Acceptable | Compartment Bag Testing (CBT) | 48 | Handpump | Yes | ||||||||||||||
| id | system_name | dwqtid | area_council | island | province | hcf_name | School ID | Sample ID | Sample Site Name | s1careacouncil | s1disland | s1eprovince | DWQT Sample Date | DWQT Sample Latitude | DWQT Sample Longitude | DWQT Sample Elevation | DWQT Sample Flow rate | DWQT Sample Location Description | Source Type | Specific Source Type | Water System Type | Conductivity (µs/m) | Turbidity (NTU) | pH | Taste/Odor | Hardness (mg/L) | Fluoride (mg/L) | Arsenic (mg/L) | Copper (mg/L) | Lead (mg/L) | Iron (mg/L) | Ecoli Test Type | E.Coli (#/100ml) | Total Coliforms (#/100ml) | Faecal Coliforms (#/100ml) | Additional Comments | Data Shared with Community |