vespa-db Field Definitions

There are more fields in the vespa-db database than are returned by the API. This page provides a complete overview of all fields in the database.

title	type	readOnly	field	description	format	x-nullable	maxLength	maximum	minimum	minLength	enum	required	r_type
Admin notes	string	NA	admin_notes	Admin notes for the observation	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Anb	boolean	NA	anb	Flag indicating if the observation is in ANB area	NA	NA	NA	NA	NA	NA	NULL	FALSE	logical
Created by	integer	NA	created_by	User who created the observation	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	integer
Created by first name	string	TRUE	created_by_first_name	NA	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Created datetime	string	NA	created_datetime	Datetime when the observation was created	date-time	NA	NA	NA	NA	NA	NULL	TRUE	character
Duplicate nest	boolean	NA	duplicate_nest	Shows if the nest is a duplicate	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	logical
Eradication aftercare	string	NA	eradication_aftercare	Aftercare result of the eradication	NA	TRUE	NA	NA	NA	NA	nest_volledig_verwijderd , nest_gedeeltelijk_verwijderd, nest_laten_hangen	FALSE	character
Eradication date	string	NA	eradication_date	Date when the nest was eradicated	date	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Eradication duration	integer	NA	eradication_duration	Duration of the eradication in minutes	NA	TRUE	NA	2147483647	0	NA	NULL	FALSE	integer
Eradication method	string	NA	eradication_method	Method used for the eradication	NA	TRUE	NA	NA	NA	NA	diepvries , telescoopsteel , doos , vloeistofverstuiver, poederverstuiver , stofzuiger	FALSE	character
Eradication notes	string	NA	eradication_notes	Notes about the eradication	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Eradication persons	integer	NA	eradication_persons	Number of persons involved in the eradication	NA	TRUE	NA	2147483647	-2147483648	NA	NULL	FALSE	integer
Eradication problems	string	NA	eradication_problems	Problems encountered during the eradication	NA	TRUE	NA	NA	NA	NA	steken , nest_gevallen, duizeligheid , gif_spuiten	FALSE	character
Eradication product	string	NA	eradication_product	Product used for the eradication	NA	TRUE	NA	NA	NA	NA	spray_spuitbus , permas_d , vloeibare_stikstof , ficam_d , topscore_pal , diatomeeenaarde , ether_aceton_ethyl_acetaat, vespa , andere	FALSE	character
Eradication result	string	NA	eradication_result	Result of the eradication	NA	TRUE	NA	NA	NA	NA	successful , unsuccessful, untreated , untreatable , unknown	FALSE	character
Eradicator name	string	NA	eradicator_name	Name of the person who eradicated the nest	NA	TRUE	255	NA	NA	NA	NULL	FALSE	character
Id	integer	TRUE	id	NA	NA	NA	NA	NA	NA	NA	NULL	FALSE	integer
Images	object	NA	images	List of images associated with the observation	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	list
Location	string	NA	location	NA	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Modified by	integer	NA	modified_by	User who last modified the observation	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	integer
Modified by first name	string	TRUE	modified_by_first_name	NA	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Modified datetime	string	TRUE	modified_datetime	Datetime when the observation was last modified	date-time	NA	NA	NA	NA	NA	NULL	FALSE	character
Moth present	boolean	NA	moth_present	Shows if moths were present during the eradication	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	logical
Municipality	integer	NA	municipality	Municipality where the observation was made	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	integer
Municipality name	string	TRUE	municipality_name	NA	NA	NA	NA	NA	NA	1	NULL	FALSE	character
Nest height	string	NA	nest_height	Height of the nest	NA	TRUE	NA	NA	NA	NA	lager_dan_4_meter, hoger_dan_4_meter	FALSE	character
Nest location	string	NA	nest_location	Location of the nest	NA	TRUE	NA	NA	NA	NA	buiten_onbedekt_op_gebouw , buiten_onbedekt_in_boom_of_struik , buiten_maar_overdekt_door_constructie, buiten_natuurlijk_overdekt , binnen_in_gebouw_of_constructie	FALSE	character
Nest size	string	NA	nest_size	Size of the nest	NA	TRUE	NA	NA	NA	NA	kleiner_dan_25_cm, groter_dan_25_cm	FALSE	character
Nest status	string	TRUE	nest_status	NA	NA	NA	NA	NA	NA	NA	NULL	FALSE	character
Nest type	string	NA	nest_type	Type of the nest	NA	TRUE	NA	NA	NA	NA	actief_embryonaal_nest, actief_primair_nest , actief_secundair_nest , inactief_leeg_nest	FALSE	character
Notes	string	NA	notes	Notes about the observation	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Observation datetime	string	NA	observation_datetime	Datetime when the observation was made	date-time	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Observer email	string	NA	observer_email	Email of the observer	email	TRUE	254	NA	NA	NA	NULL	FALSE	character
Observer name	string	NA	observer_name	Name of the observer	NA	TRUE	255	NA	NA	NA	NULL	FALSE	character
Observer phone number	string	NA	observer_phone_number	Phone number of the observer	NA	TRUE	200	NA	NA	NA	NULL	FALSE	character
Observer received email	boolean	NA	observer_received_email	Flag indicating if observer received email	NA	NA	NA	NA	NA	NA	NULL	FALSE	logical
Other species nest	boolean	NA	other_species_nest	Shows if the nest belongs to another species	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	logical
Province	integer	NA	province	Province where the observation was made	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	integer
Public domain	boolean	NA	public_domain	Flag indicating if the observation is in the public domain	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	logical
Queen present	boolean	NA	queen_present	Shows if the queen was present during the eradication	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	logical
Reserved by	integer	NA	reserved_by	User who reserved the observation	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	integer
Reserved by first name	string	TRUE	reserved_by_first_name	NA	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Reserved datetime	string	NA	reserved_datetime	Datetime when the observation was reserved	date-time	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Source	string	NA	source	Source of the observation	NA	TRUE	255	NA	NA	NA	NULL	FALSE	character
Source id	integer	NA	source_id	Original identifier when importing data	NA	TRUE	NA	2147483647	-2147483648	NA	NULL	FALSE	integer
Visible	boolean	NA	visible	Flag indicating if the observation is visible	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	logical
Wn admin notes	string	NA	wn_admin_notes	Admin notes about the observation	NA	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Wn cluster id	integer	NA	wn_cluster_id	Cluster ID of the observation	NA	TRUE	NA	2147483647	-2147483648	NA	NULL	FALSE	integer
Wn created datetime	string	NA	wn_created_datetime	Datetime when the observation was created in the source system	date-time	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Wn id	integer	NA	wn_id	Unique ID for the observation	NA	TRUE	NA	2147483647	-2147483648	NA	NULL	FALSE	integer
Wn modified datetime	string	NA	wn_modified_datetime	Datetime when the observation was modified in the source system	date-time	TRUE	NA	NA	NA	NA	NULL	FALSE	character
Wn validation status	string	NA	wn_validation_status	Validation status of the observation	NA	TRUE	NA	NA	NA	NA	onbekend , goedgekeurd_met_bewijs , goedgekeurd_door_admin , goedgekeurd_automatische_validatie, in_behandeling , afgewezen , nog_niet_te_beoordelen	FALSE	character

Pieter Huybrechts

2025-08-12