Verify and update mitten crabs SQL

[peterdesmet]

• 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

[peterdesmet]

@stijnvanhoey, I've just copy/pasted the checklist in this issue, I haven't verified anything yet.