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.

Export to XLSX

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	Site.Csv	Site.Rec	Uae_Es_Sites_Full_2025-09-17_19-28-20.Csv
AREA_CCODE	AREA - Area (COUNTRY)	N/A	text	N/A	N/A	N/A	N/A	country	country	country	country	country	country	site.CCODE
AREA_COUNTRY	AREA - Area (COUNTRY)	N/A	text	N/A	N/A	country	country	N/A	N/A	N/A	N/A	N/A	N/A	site.ADMIN0
AREA_PCODE	AREA - Area (PROVINCE)	N/A	text	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	site.PCODE
AREA_PROVINCE	AREA - Area (PROVINCE)	N/A	text	N/A	N/A	province	province	province	province	province	province	siteprov	siteprov	site.ADMIN1
AREA_DCODE	AREA - Area (DISTRICT)	N/A	text	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	site.DCODE
AREA_DISTRICT	AREA - Area (DISTRICT)	N/A	text	N/A	N/A	district	district	district	district	DISTRICT	DISTRICT	sitedist	sitedist	site.ADMIN2
SPECSITE	SPECSITE - Site number	N/A	text	N/A	Yes	specsite	specsite	specsite	specsite	N/A	N/A	specsite	specsite	site.FIELD_SPECSITE
SITECODE	SITECODE - Site code Country	N/A	text	N/A	Yes	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	site.SITECODE
RSITECODE	RSITECODE - Site code Region	N/A	text	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	site.FIELD_BID_ALT
SITENAME	SITENAME	N/A	text	N/A	Yes	sitename	sitename	sitename	sitename	SITE	SITE	sitename	sitename	site.FIELD_SITE_NAME
TMPSITE	TMPSITE - Temporary site	N/A	boolean	0 = No	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	site.FIELD_TEMP_SITE
				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	N/A	N/A	site.FIELD_SITE_STATUS
				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	dend	dend	site.FIELD_DEND
DSTART	DSTART - Date started	N/A	datetime	N/A	Yes	N/A	N/A	N/A	N/A	N/A	N/A	dstart	dstart	site.FIELD_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	N/A	N/A	site.FIELD_SITE_TYPE
				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	N/A	N/A	site.FIELD_SITE_TYPE_OF_CANAL
				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	N/A	N/A	site.FIELD_SITE_SITECAT
				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	N/A	N/A	site.FIELD_SITE_FREQUENCY
				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	N/A	N/A	site.FIELD_SITE_ISOLLAB
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	N/A	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	N/A	N/A	N/A	N/A	N/A	lat	lat	site.FIELD_GEOLOCATION_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	lon	lon	site.FIELD_GEOLOCATION_LNG
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	N/A	N/A	site.FIELD_GEOLOCATION2_LAT
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	N/A	N/A	site.FIELD_GEOLOCATION2_LNG
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	N/A	N/A	site.FIELD_GEOLOCATION3_LAT
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	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	N/A	N/A	N/A	N/A	N/A	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	N/A	N/A	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_COLLECTOR_NAME
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	N/A	N/A	site.FIELD_SITE_COLLECTOR_PHONE
CITY	CITY - City Name	N/A	text	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_CITY_NAME
VILLAGE	VILLAGE - Village / Settlement	N/A	text	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_VILLAGE
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	N/A	N/A	site.FIELD_SITE_ESTPOP
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	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	number	1 = Yes	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_REFUGEEPRESENT
				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	N/A	N/A	site.FIELD_SITE_SCHOOLPRESENT
				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	N/A	N/A	site.FIELD_SITE_HFPRESENT
				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	N/A	N/A	site.FIELD_SITE_TRANSITPRESENT
				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	N/A	N/A	site.FIELD_SITE_COMMENTS