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 | Es_Unpublished_Sites.Csv | Export Es Sites And Samples To Csv | ||||
| SITENAME | SITENAME | N/A | text | N/A | Yes | SITENAME | site.FIELD_SITE_NAME |
| ENVID | ENVID - ENV ID | Ex: ENV-AD0-AD1-AD2-SCD-YY-XXX | text | N/A | Yes | N/A | site.FIELD_BID |
| AREA_CCODE | AREA - Area (COUNTRY) | N/A | text | N/A | N/A | N/A | site.CCODE |
| AREA_COUNTRY | AREA - Area (COUNTRY) | N/A | text | N/A | N/A | N/A | site.ADMIN0 |
| AREA_STATE_CODE | AREA - Area (STATE) | N/A | text | N/A | N/A | N/A | site.STATE_CODE |
| AREA_STATE | AREA - Area (STATE) | N/A | text | N/A | N/A | N/A | site.ADMIN1 |
| AREA_COUNTY_CODE | AREA - Area (COUNTY) | N/A | text | N/A | N/A | N/A | site.COUNTY_CODE |
| AREA_COUNTY | AREA - Area (COUNTY) | N/A | text | N/A | N/A | N/A | site.ADMIN2 |
| SITECODE | SITECODE - Site code | N/A | text | N/A | Yes | SITECODE | site.FIELD_SITECODE |
| STATUS | STATUS - Status of the site's function | N/A | text | 1 = Active | Yes | N/A | site.FIELD_SITE_STATUS |
| 2 = Postponed | |||||||
| 3 = Closed | |||||||
| 4 = Unknown | |||||||
| DEND | DEND - date closed | N/A | datetime | N/A | N/A | DEND | site.FIELD_DEND |
| DSTART | DSTART - Date started (date of first sample collection) | N/A | datetime | N/A | Yes | DSTART | site.FIELD_DSTART |
| TYPESITE | TYPESITE - Type of Site | N/A | number | 1 = WASTE WATER | N/A | N/A | site.FIELD_TYPESITE |
| 2 = WASTE WATER TREATMENT PLANT | |||||||
| 3 = SEWAGE WATER / SEWAGE | |||||||
| TYPECANAL | TYPECANAL - Type of canal | N/A | number | 1 = Open Canal | N/A | N/A | site.FIELD_TYPE_OF_CANAL |
| 2 = Closed Canal | |||||||
| SITECAT | SITECAT - Category for the systematic collection schedule | N/A | text | 0 = Seasonal | N/A | N/A | site.FIELD_SITE_SITECAT |
| 1 = Ad-hoc | |||||||
| 2 = Permanent | |||||||
| FREQ | FREQ - Frequency of collection | N/A | text | 1 = Weekly | N/A | N/A | site.FIELD_SITE_FREQUENCY |
| 3 = Twice a month | |||||||
| 2 = Monthly | |||||||
| 4 = Undefined | |||||||
| EXPTIMCOLL | EXPTIMCOLL - Expected time of collection | Ex: 15:36, 02:58 | text | N/A | N/A | N/A | site.FIELD_TIMECOLL |
| FUNDED | FUNDED - Site funded by any GPEI partner &/or using GPLN | N/A | text | 1 = Yes | N/A | N/A | site.FIELD_SITE_FUNDED |
| 2 = No | |||||||
| 9 = Unknown | |||||||
| ISOLLAB | ISOLLAB - Name of isolation Lab used for samples | N/A | text | N/A | N/A | N/A | site.FIELD_SITE_ISOLLAB |
| DIGISITE | DIGISITE - Is site digitalised? | N/A | number | 1 = Yes | N/A | N/A | site.FIELD_IS_DIGITALISED |
| 2 = No | |||||||
| COMPOSITE | COMPOSITE - Composite of multiple collections making one site ? | N/A | number | 2 = Yes | Yes | N/A | site.FIELD_TYPE_OF_SAMPLE |
| 1 = No | |||||||
| 3 = Unknown | |||||||
| GEOLOC1_LAT | GEOLOC1 - Geolocation | Stores the latitude value | number | N/A | N/A | N/A | site.FIELD_GEOLOCATION_LAT |
| GEOLOC1_LNG | GEOLOC1 - Geolocation | Stores the longitude value | number | N/A | N/A | N/A | site.FIELD_GEOLOCATION_LNG |
| GEOLOC2_LAT | GEOLOC2 - Geolocation 2 | Stores the latitude value | number | N/A | N/A | N/A | site.FIELD_GEOLOCATION2_LAT |
| GEOLOC2_LNG | GEOLOC2 - Geolocation 2 | Stores the longitude value | number | N/A | N/A | N/A | site.FIELD_GEOLOCATION2_LNG |
| GEOLOC3_LAT | GEOLOC3 - Geolocation 3 | Stores the latitude value | number | N/A | N/A | N/A | site.FIELD_GEOLOCATION3_LAT |
| GEOLOC3_LNG | GEOLOC3 - Geolocation 3 | Stores the longitude value | number | N/A | N/A | N/A | site.FIELD_GEOLOCATION3_LNG |
| GEOLOCCOLL | GEOLOCCOLL - Geolocation/Coordinates collected while at site location | N/A | boolean | 0 = No | N/A | N/A | site.FIELD_GEOLOCATION_STATUS |
| 1 = Yes | |||||||
| COLLECTORNAME | COLLECTORNAME - Name of main sample collector | N/A | text | N/A | N/A | N/A | site.FIELD_COLLECTOR_NAME |
| COLLECTORPHONE | COLLECTORPHONE - Phone Number of Main sample collector | N/A | text | N/A | N/A | N/A | site.FIELD_COLLECTOR_PHONE |
| CITY | CITY - City Name | N/A | text | N/A | N/A | N/A | site.FIELD_CITY_NAME |
| VILLAGE | VILLAGE - Village/Settlement | N/A | text | N/A | N/A | N/A | site.FIELD_VILLAGE_SETTLEMENT |
| ESTPOP | ESTPOP - Estimated total population for the site's catchment area | N/A | number | N/A | N/A | N/A | site.FIELD_SITE_ESTPOP |
| IDPPRESENT | IDPPRESENT - Internally Displaced Persons in catchment area | N/A | text | 1 = Yes | N/A | N/A | site.FIELD_SITE_IDPPRESENT |
| 2 = No | |||||||
| 9 = Unknown | |||||||
| REFUGEEPRESENT | REFUGEEPRESENT - Are refugee camps set up in the catchment area ? | N/A | text | 1 = Yes | N/A | N/A | site.FIELD_SITE_REFUGEEPRESENT |
| 2 = No | |||||||
| 9 = Unknown | |||||||
| SCHOOLPRESENT | SCHOOLPRESENT - Schools in catchment area | N/A | text | 1 = Yes | N/A | N/A | site.FIELD_SITE_SCHOOLPRESENT |
| 2 = No | |||||||
| 9 = Unknown | |||||||
| TRANSITPRESENT | TRANSITPRESENT - Transit Hub in catchment area | N/A | text | 1 = Yes | N/A | N/A | site.FIELD_SITE_TRANSITPRESENT |
| 2 = No | |||||||
| 9 = Unknown | |||||||
| HFPRESENT | HFPRESENT - Health Facility/Centre in catchment area | N/A | text | 1 = Yes | N/A | N/A | site.FIELD_SITE_HFPRESENT |
| 2 = No | |||||||
| 9 = Unknown | |||||||
| HAREA | HAREA - Health area | N/A | text | N/A | N/A | N/A | site.FIELD_HEALTH_AREA |
| COMMENTS | COMMENTS | N/A | text | N/A | N/A | N/A | site.FIELD_SITE_COMMENTS |