Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
getkeywords FUNCTION SQL false SETOF record INVOKER
gettaphonomictypes FUNCTION SQL false SETOF record INVOKER
getauthors FUNCTION SQL false SETOF record INVOKER
searchsitename FUNCTION SQL false SETOF record INVOKER
getdeptenvtypesroot FUNCTION SQL false SETOF record INVOKER
getpeople FUNCTION SQL false SETOF record INVOKER
explorersearch FUNCTION PLPGSQL false SETOF record INVOKER
getelementtypes FUNCTION SQL false SETOF record INVOKER
datasetobject FUNCTION SQL false SETOF record INVOKER

Create the JSON object used to return relevant dataset metadata from a single datasetid.
sitelink FUNCTION SQL false SETOF record INVOKER
getgeochrondatasetbyassociateddatasetid FUNCTION SQL false SETOF record INVOKER
sample FUNCTION SQL false SETOF record INVOKER
siteobject FUNCTION SQL false SETOF record INVOKER
getcollectiontypes FUNCTION SQL false SETOF record INVOKER
gettaxagrouptypes FUNCTION SQL false SETOF record INVOKER
getdeptenvtypes FUNCTION SQL false SETOF record INVOKER
updategpsites FUNCTION PLPGSQL false trigger INVOKER
gettaphonomicsystems FUNCTION SQL false SETOF record INVOKER
updatequery FUNCTION PLPGSQL false trigger INVOKER
getdatasettypes FUNCTION SQL false SETOF record INVOKER
getelementtypesbytaxonid FUNCTION SQL false SETOF record INVOKER
collectionunitobject FUNCTION SQL false SETOF record INVOKER

Create the JSON object used to return relevant collectionunit metadata from a single collection unit id.