ES Sites
This data dictionary is mostly machine-generated and still needs to be validated by a human. If you notice issues or want to contribute to improve don’t hesitate to send an email to webifa@novel-t.ch.
| Variable | Variable name in the data entry | Description | Data type | Variable options | Variable name in the exports | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Allowed Values | Required | Envdata.Csv | Envdata.Rec | Environ.Csv | Environ.Rec | Envresult.Csv | Envresult.Rec | Pna_Es_Sites_Full_2025-09-17_18-07-55.Csv | Site.Csv | Site.Rec | ||||
| AREA_CCODE | AREA - Area (COUNTRY) | N/A | text | N/A | N/A | N/A | N/A | country | country | country | country | site.CCODE | country | country |
| AREA_COUNTRY | AREA - Area (COUNTRY) | N/A | text | N/A | N/A | country | country | N/A | N/A | N/A | N/A | site.ADMIN0 | N/A | N/A |
| AREA_PCODE | AREA - Area (PROVINCE) | N/A | text | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.PCODE | N/A | N/A |
| AREA_PROVINCE | AREA - Area (PROVINCE) | N/A | text | N/A | N/A | province | province | province | province | province | province | site.ADMIN1 | siteprov | siteprov |
| AREA_DCODE | AREA - Area (DISTRICT) | N/A | text | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.DCODE | N/A | N/A |
| AREA_DISTRICT | AREA - Area (DISTRICT) | N/A | text | N/A | N/A | district | district | district | district | DISTRICT | DISTRICT | site.ADMIN2 | sitedist | sitedist |
| SPECSITE | SPECSITE - Site number | N/A | text | N/A | Yes | specsite | specsite | specsite | specsite | N/A | N/A | site.FIELD_SPECSITE | specsite | specsite |
| SITECODE | SITECODE - Site code Country | N/A | text | N/A | Yes | N/A | N/A | N/A | N/A | N/A | N/A | site.SITECODE | N/A | N/A |
| RSITECODE | RSITECODE - Site code Region | N/A | text | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_BID_ALT | N/A | N/A |
| SITENAME | SITENAME | N/A | text | N/A | Yes | sitename | sitename | sitename | sitename | SITE | SITE | site.FIELD_SITE_NAME | sitename | sitename |
| TMPSITE | TMPSITE - Temporary site | N/A | boolean | 0 = No | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_TEMP_SITE | N/A | N/A |
| 1 = Yes | ||||||||||||||
| STATUS | STATUS - Status of the site's function | N/A | text | 1 = Active | Yes | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_STATUS | N/A | N/A |
| 2 = Postponed | ||||||||||||||
| 3 = Closed | ||||||||||||||
| 4 = Unknown | ||||||||||||||
| DEND | DEND - Date ended | N/A | datetime | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_DEND | dend | dend |
| DSTART | DSTART - Date started | N/A | datetime | N/A | Yes | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_DSTART | dstart | dstart |
| SITETYPE | SITETYPE - Type of Site | N/A | number | 1 = WASTE WATER | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_TYPE | N/A | N/A |
| 2 = WASTE WATER TREATMENT PLANT | ||||||||||||||
| 3 = SEWAGE WATER / SEWAGE | ||||||||||||||
| 4 = SEPTIC TANK | ||||||||||||||
| CANALTYPE | CANALTYPE - Type of Canal | N/A | number | 1 = Open Canal | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_TYPE_OF_CANAL | N/A | N/A |
| 2 = Closed canal | ||||||||||||||
| SITECAT | SITECAT - Category for the systematic collection schedule | N/A | text | 0 = Seasonal | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_SITECAT | N/A | N/A |
| 1 = Ad-hoc | ||||||||||||||
| 2 = Permanent | ||||||||||||||
| 3 = Tributary | ||||||||||||||
| FREQ | FREQ - Frequency of collection | N/A | text | 1 = Weekly | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_FREQUENCY | N/A | N/A |
| 3 = Monthly | ||||||||||||||
| 2 = Twice a Month | ||||||||||||||
| 4 = Undefined | ||||||||||||||
| ISOLLAB | ISOLLAB - Name of isolation Lab used for samples | N/A | text | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_ISOLLAB | N/A | N/A |
| COMPOSITE | COMPOSITE - Composite of multiple collections making one site ? | N/A | number | 2 = Yes | Yes | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_TYPE_OF_SAMPLE | N/A | N/A |
| 1 = No | ||||||||||||||
| 3 = Unknown | ||||||||||||||
| GEOLOC1_LAT | GEOLOC1 - Geolocation | Stores the latitude value | number | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_GEOLOCATION_LAT | lat | lat |
| GEOLOC1_LNG | GEOLOC1 - Geolocation | Stores the longitude value | number | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_GEOLOCATION_LNG | lon | lon |
| GEOLOC2_LAT | GEOLOC2 - Geolocation 2 | Stores the latitude value | number | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_GEOLOCATION2_LAT | N/A | N/A |
| GEOLOC2_LNG | GEOLOC2 - Geolocation 2 | Stores the longitude value | number | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_GEOLOCATION2_LNG | N/A | N/A |
| GEOLOC3_LAT | GEOLOC3 - Geolocation 3 | Stores the latitude value | number | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_GEOLOCATION3_LAT | N/A | N/A |
| GEOLOC3_LNG | GEOLOC3 - Geolocation 3 | Stores the longitude value | number | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_GEOLOCATION3_LNG | N/A | N/A |
| GEOLOCCOLL | GEOLOCCOLL - Geolocation/Coordinates collected while at site location | N/A | boolean | 0 = No | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_GEOLOCATION_STATUS | N/A | N/A |
| 1 = Yes | ||||||||||||||
| COLLECTORNAME | COLLECTORNAME - Name of main sample collector | N/A | text | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_COLLECTOR_NAME | N/A | N/A |
| COLLECTORPHONE | COLLECTORPHONE - Phone Number of Main sample collector | N/A | text | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_COLLECTOR_PHONE | N/A | N/A |
| CITY | CITY - City Name | N/A | text | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_CITY_NAME | N/A | N/A |
| VILLAGE | VILLAGE - Village / Settlement | N/A | text | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_VILLAGE | N/A | N/A |
| ESTPOP | ESTPOP - Estimated total population for the site's catchment area | N/A | number | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_ESTPOP | N/A | N/A |
| IDPPRESENT | IDPPRESENT - Internally Displaced Persons in catchment area | N/A | number | 1 = Yes | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_IDPPRESENT | N/A | N/A |
| 2 = No | ||||||||||||||
| 9 = Unknown | ||||||||||||||
| REFUGEEPRESENT | REFUGEEPRESENT - Are refugee camps set up in the catchment area? | N/A | number | 1 = Yes | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_REFUGEEPRESENT | N/A | N/A |
| 2 = No | ||||||||||||||
| 9 = Unknown | ||||||||||||||
| SCHOOLPRESENT | SCHOOLPRESENT - Schools in catchment area | N/A | number | 1 = Yes | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_SCHOOLPRESENT | N/A | N/A |
| 2 = No | ||||||||||||||
| 9 = Unknown | ||||||||||||||
| HFPRESENT | HFPRESENT - Health Facility/Centre in catchment area | N/A | number | 1 = Yes | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_HFPRESENT | N/A | N/A |
| 2 = No | ||||||||||||||
| 9 = Unknown | ||||||||||||||
| TRANSITPRESENT | TRANSITPRESENT - Transit Hub in catchment area | N/A | number | 1 = Yes | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_TRANSITPRESENT | N/A | N/A |
| 2 = No | ||||||||||||||
| 9 = Unknown | ||||||||||||||
| COMMENTS | COMMENTS | N/A | text | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | site.FIELD_SITE_COMMENTS | N/A | N/A |