API
JsonCache
classDiagram class JsonCache { ID int DisplayText nvarchar 500 LogUpdatedWhen datetime Data JSON }
This table is filled by stored procedure procFillJsonCache.
procFillJsonCache is started by trigger trgUpdTaxonName in table TaxonName
--- title: JsonCache --- graph TD; TaxonName[TaxonName] -->|Update in table| trgUpdTaxonName(trgUpdTaxonName) trgUpdTaxonName --> procFillJsonCache(procFillJsonCache) procFillJsonCache -->JsonCache[table JsonCache] JsonCache --> JsonCache_Checklist[view JsonCache_Checklist] JsonCache --> JsonCache_Project[view JsonCache_Project]
Views
Views provide a selection of the JsonCache table restricted
JsonCache_Project
Data of table JsonCache linked to project
classDiagram class JsonCache_Project { ID int DisplayText nvarchar 500 LogUpdatedWhen datetime Data JSON Project nvarchar 50 }
JsonCache_Checklist
Data of table JsonCache linked to checklist
classDiagram class JsonCache_Checklist { ID int DisplayText nvarchar 500 LogUpdatedWhen datetime Data JSON Checklist nvarchar 50 }
Expamples
Containing analysis data:
[
{
"type": "Taxon",
"id": 4403768,
"attributes": {
"FullName": "Anthrenus verbasci (Linnaeus, 1767)",
"Rank": "sp.",
"GenusOrSupragenericName": "Anthrenus",
"SpeciesEpithet": "verbasci ",
"Authors": "Linnaeus",
"Publication": "",
"Project": [ { "Project": "SNSBnames" } ],
"Checklist": {
"Analysis": [
{
"Checklist": "TaxRef_SNSB_NHC-Pests",
"Analysis": "adult"
},
{
"Checklist": "TaxRef_SNSB_NHC-Pests",
"Analysis": "larva"
},
{
"Checklist": "TaxRef_SNSB_NHC-Pests",
"Analysis": "natural specimen itself",
"Value": "present"
},
{
"Checklist": "TaxRef_SNSB_NHC-Pests",
"Analysis": "artifact",
"Value": "present"
},
{
"Checklist": "TaxRef_SNSB_NHC-Pests",
"Analysis": "botanical Collections",
"Value": "present"
}
],
"Distribution": [
{
"Checklist": "TaxRef_SNSB_NHC-Pests",
"Place": "Europe"
}
]
},
"Synonymy": [
{
"id": 4403768,
"FullName": "Anthrenus verbasci (Linnaeus, 1767)",
"Name": "Anthrenus verbasci ",
"Type": "accepted name"
}
],
"Hierarchy": [
{
"id": 4403768,
"FullName": "Anthrenus verbasci (Linnaeus, 1767)",
"Name": "Anthrenus verbasci ",
"Rank": "sp."
},
{
"id": 4403933,
"FullName": "Anthrenus Geoffroy, 1762",
"Name": "Anthrenus",
"Rank": "gen."
},
{
"id": 4403854,
"FullName": "Dermestidae",
"Name": "Dermestidae",
"Rank": "fam."
},
{
"id": 4403769,
"FullName": "Coleoptera Linneaus, 1758",
"Name": "Coleoptera",
"Rank": "ord."
},
{
"id": 4403937,
"FullName": "Insecta Linnaeus, 1758",
"Name": "Insecta",
"Rank": "cl."
},
{
"id": 4403934,
"FullName": "Arthropoda Gravenhorst, 1843",
"Name": "Arthropoda",
"Rank": "phyl.\/div."
},
{
"id": 4403805,
"FullName": "Animalia Linnaeus, 1758",
"Name": "Animalia",
"Rank": "reg."
}
],
"CommonNames": [
{
"CommonName": "varied carpet beetle",
"LanguageCode": "en",
"CountryCode": "GB"
},
{
"CommonName": "Wollkrautblütenkäfer",
"LanguageCode": "de",
"CountryCode": "DE"
}
],
"Resource": [
{
"URI": "https:\/\/pictures.snsb.info\/IPM\/Wollkrautbluetenkaefer.png",
"Title": "adult",
"Type": "preview"
},
{
"URI": "https:\/\/pictures.snsb.info\/IPM\/Wollkrautbluetenkaefer_Larve.png",
"Title": "larva",
"Type": "preview"
},
{
"URI": "https:\/\/upload.wikimedia.org\/wikipedia\/commons\/0\/04\/Anthrenus_verbasci_-_larva_side_%28aka%29.jpg",
"Title": "Wollkrautblütenkäfer (Anthrenus verbasci)",
"Type": "image"
},
{
"URI": "https:\/\/upload.wikimedia.org\/wikipedia\/commons\/thumb\/6\/64\/Anthrenus.verbasci.7060.jpg\/1280px-Anthrenus.verbasci.7060.jpg",
"Title": "Wollkrautblütenkäfer (Anthrenus verbasci)",
"Type": "image"
},
{
"URI": "https:\/\/upload.wikimedia.org\/wikipedia\/commons\/thumb\/c\/c0\/Anthrenus_verbasci_%28Linn%C3%A9%2C_1767%29_%2827853635822%29.png\/697px-Anthrenus_verbasci_%28Linn%C3%A9%2C_1767%29_%2827853635822%29.png",
"Title": "Wollkrautblütenkäfer (Anthrenus verbasci)",
"Type": "image"
},
{
"URI": "https:\/\/www.dsvonline.de\/fileadmin\/dsv\/docs\/pest-index\/wollkrautbluetenkaefer.pdf",
"Title": "Deutscher Schädlingsbekämpfer Verband e.V.: Wollkrautblütenkäfer (Anthrenus verbasci)",
"Type": "information"
}
]
}
}
]
Containing synonymy data:
[
{
"type": "Taxon",
"id": 4404053,
"attributes": {
"FullName": "Stachybotrys lobulata Berk.",
"Rank": "sp.",
"GenusOrSupragenericName": "Stachybotrys",
"SpeciesEpithet": "lobulata",
"Authors": "Berk.",
"Publication": "",
"Project": [ { "Project": "SNSBnames" } ],
"Synonymy": [
{
"id": 4404055,
"FullName": "Stachybotrys chartarum (Ehrenb.) S.Hughes",
"Name": "Stachybotrys chartarum",
"Type": "accepted name"
},
{
"id": 4404054,
"FullName": "Stachybotrys lobulatus (Berk.) Berk.",
"Name": "Stachybotrys lobulatus",
"Type": "heterotypic"
},
{
"id": 4404053,
"FullName": "Stachybotrys lobulata Berk.",
"Name": "Stachybotrys lobulata",
"Type": "orthographic variant"
}
],
"Hierarchy": [
{
"id": 4404053,
"FullName": "Stachybotrys lobulata Berk.",
"Name": "Stachybotrys lobulata",
"Rank": "sp."
},
{
"id": 4404047,
"FullName": "Stachybotrys Corda",
"Name": "Stachybotrys",
"Rank": "gen."
},
{
"id": 4404048,
"FullName": "Stachybotryaceae",
"Name": "Stachybotryaceae",
"Rank": "fam."
},
{
"id": 4404044,
"FullName": "Hypocreales",
"Name": "Hypocreales",
"Rank": "ord."
},
{
"id": 4403986,
"FullName": "Sordariomycetes",
"Name": "Sordariomycetes",
"Rank": "cl."
},
{
"id": 4403962,
"FullName": "Ascomycota",
"Name": "Ascomycota",
"Rank": "phyl.\/div."
},
{
"id": 4403961,
"FullName": "Fungi",
"Name": "Fungi",
"Rank": "reg."
}
]
}
}
]
OpenAPI
… hier kommt mal swagger hin sobald verfügbar