Verify and update mitten crabs SQL

[ ] Term names are in lowerCamelCase
[ ] M occurrenceID does not contain duplicates
[ ] occurrenceID is globally unique (e.g. by concatenating IDs)
[ ] occurrenceID is stable (by referring to internal IDs)
[ ] M type uses an UpperCamelCase vocabulary
[ ] M language is en
[ ] M license is http://creativecommons.org/publicdomain/zero/1.0/
[ ] M rightsHolder is INBO
[ ] M accessRights is http://www.inbo.be/en/norms-for-data-use
[ ] M datasetID is of the form http://dataset.inbo.be/shortname
[ ] datasetID is the dataset DOI (after registration)
[ ] M institutionCode is INBO
[ ] M datasetName is the latest dataset title
[ ] M ownerInstitutionCode is INBO
[ ] M basisOfRecord uses this UpperCamelCase vocabulary
[ ] dynamicProperties is understandable to an outside user
[ ] dynamicProperties is valid JSON
[ ] recordedBy is of the form First name Last name, F. Last name or an anonymous unique code
[ ] M recordedBy delimits multiple values with |
[ ] individualCount are all integers
[ ] individualCount has limited outliers
[ ] individualCount has no 0 (would indicate absense data)
[ ] sex uses this lowercase vocabulary (alternative terms allowed)
[ ] sex delimits multiple values with |
[ ] lifeStage uses this lowercase vocabulary (alternative terms allowed)
[ ] lifeStage delimits multiple values with |
[ ] eventID refers to an internal ID
[ ] M samplingProtocol is a lowercase controlled vocabulary (or refers to a DOI)
[ ] samplingEffort indicates the effort as a number
[ ] samplingEffort is valid JSON
[ ] M eventDate is ISO 8601
[ ] eventDate does not contain date ranges (use verbatimEventDate)
[ ] locationID refers to an internal ID
[ ] M continent is Europe
[ ] M countryCode is BE
[ ] stateProvince is a vocabulary of English names
[ ] municipality is ideally a vocabulary of local names
[ ] verbatimLocality contains the fullest location name/description
[ ] verbatimCoordinates is used for (UTM) grid codes only
[ ] verbatimLatitude is the UTM y coordinate
[ ] verbatimLongitude is the UTM x coordinate
[ ] verbatimCoordinateSystem is Belgian Lambert 72 for coordinates or e.g. UTM 5km for grids
[ ] verbatimCoordinateSystem is only populated when there are verbatim coordinates/lat/long
[ ] verbatimSRS is Belgian Datum 1972, ED50 or WGS84
[ ] verbatimSRS is only populated when there are verbatim coordinates/lat/long
[ ] M decimalLatitude has a precision of 5 decimals
[ ] M decimalLongitude has a precision of 5 decimals
[ ] The coordinates are verified on a map
[ ] M geodeticDatum is WGS84
[ ] geodeticDatum is only populated when there are decimal coordinates
[ ] M coordinateUncertaintyInMeters is the radius of a circle containing the complete area where the occurrence might have been seen, e.g. 3536 for a 5x5km grid square
[ ] coordinateUncertaintyInMeters is only populated when there are decimal coordinates
[ ] georeferenceRemarks shortly describes the coordinates calculation, e.g. coordinates are centroid of used grid square
[ ] georeferenceRemarks is only populated when there are decimal coordinates
[ ] identifiedBy is of the form First name Last name, F. Last name or an anonymous unique code
[ ] identifiedBy delimits multiple values with |, but is generally a single person
[ ] M scientificName is the accepted taxon name, without author
[ ] M kingdom is always populated, e.g. Animalia
[ ] phylum is generally populated
[ ] class can be populated
[ ] order can be populated
[ ] taxonRank uses this lowercase vocabulary
[ ] M taxonRank matches the rank of the scientificName
[ ] M scientificNameAuthorship is the author of the scientificName (not populated for forms, hybrids)
[ ] vernacularName is the English or Dutch vernacular name of the scientificName
[ ] M nomenclaturalCode is ICZN or ICBN

inbo / data-publication

Verify and update mitten crabs SQL #99