Templates

The templates are here to help users upload site and sewage data.

Site data

When uploading a file with site data (either in shapefile or GeoJSON format) you can match the data schema below if you would like to have the site show some metadata.

Metadata that has functional implications:

  • publish (i.e. consider a line for processing or not, see Editing)

Hint

Use the template xlsx file here and follow the steps indicated here to upload your sites and metadata easily. Or else, save the xlsx file as a CSV, upload it to QGIS via ‘Layer/Add layer/Add Delimited Text Layer’ (Ctrl+Shift+T) and save it in the format you prefer.

Important

If you have a custom file and you have column names that match the below but you don’t respect the expected input, your upload might fail! Note that some fields are absent in the template excel file.

Property

Type

Accepted values

Default value

Notes

publish

boolean

true

geometry2

GeoJSON Point geometry

https://datatracker.ietf.org/doc/html/rfc7946#appendix-A.1

geometry3

GeoJSON Point geometry

https://datatracker.ietf.org/doc/html/rfc7946#appendix-A.1

number

string

code

string

name

string

temporary

boolean

false

status

string

Active, Postponed, Closed, Unknown

start

date

type

string

River, Wastewater, Wastewater Treatment Plant (WWTP), Sewage, Canal, Lake/Pool, Other

canalType

string

Open, Closed

category

string

Seasonal, Ad-hoc, Permanent

collectionFrequency

string

Weekly, Twice a week, Monthly, Twice a month, Quarterly, Every two years, Other

funded

boolean

false

composite

boolean

false

geometryVerified

boolean

false

estimatedPopulation

number

popPresenceIdp

boolean

popPresenceRefugee

boolean

popPresenceSchool

boolean

popPresenceTransit

boolean

popPresenceHealthFacility

boolean

popPresenceRecentCase

boolean

popPresenceLowImmunity

boolean

pathogenTypes

string

AMR, Adenovirus, Arbovirus, Astrovirus, Bacteroides, Clostridium, Dengue, Ebola, Enterobacteria, Enterococci, Enterovirus, Escherichia coli, Giardia, Hepatitis A virus, Hepatitis E virus, Influenza virus, Leptospira, Measles, Norovirus, Polio, Rotavirus, Rubella, SARS-CoV-2, Salmonella, Sapovirus, Shigella, Vibrio cholerae, Other

Multiple values can be provided, separated by commas

description

string

closed

date

enterovirus

boolean

false

comments

string

labs

uuid

Multiple values can be provided, separated by commas

collectionSampleRemoteSource

string

WEBIFA_AFR, WEBIFA_EMR, CDC

collectionSampleRemoteId

string

Sewage line data

When uploading a file with sewage line data (either in shapefile or geojson format) you can match the data schema below if you would like to have the sewage lines behave accordingly (i.e. closed / open, trunk).

Metadata that has functional implications:

Hint

Use the template xlsx file here and follow the steps indicated here to upload your sewage easily. Or else, save the xlsx file as a CSV, upload it to QGIS via ‘Layer/Add layer/Add Delimited Text Layer’ (Ctrl+Shift+T) and save it in the format you prefer.

Important

If you use a custom file and you have column names that match the below but you don’t respect the expected input, your upload might fail! Note that some fields are absent in the template excel file.

Property

Type

Accepted values

Default value

Notes

publish

boolean

true, false

true

featureType

string

channel

type

string

open, closed

open

flowType

string

seasonal, annual

annual

constructionType

string

formal, informal, natural

formal

trunk

boolean

true, false

false

Sample collection data

Samples collection schedules can be shown. For remote site sources, this is automatically integrated. For manual sites, the data needs to first pass via xMart. The sample data can either be connected to directly via xMart (please get in touch) or else the following template can be filled out and we can upload it to xMart once filled out.

Hint

Use the template xlsx file here and once filled out get in contact with us.