Update visfauna-ijzer-occurrences SQL

[peterdesmet]

Note: Data verified for version 9.3 on 2015-10-20. Metadata has been completely verified, updated, and republished to comply with our new guidelines regarding usage norms, recourse citation, etc.

Changes to apply for occurrence core:

• Use lowerCamelCase field names
• Map occurrenceID instead of GUID
• Remove modified
• Update language to en
• Rename rights to license
• Update accessRights
• Use dataset DOI in datasetID
• Remove collectionCode
• Update datasetName (pending New title for visfauna-ijzer-occurrences #70)
• Use HumanObservation for basisOfRecord
• Remove catalogNumber
• Verify recordedBy
• Verify individualCount: all reasonable numbers (1-275), but 31 records have 0
• Lowercase samplingProtocol
• Use electrofishing (one word) in samplingProtocol
• Remove verbatimDate: it is exactly the same as eventDate
• Verify verbatimLatitude, are the numbers not missing a digit: 39235?
• Update verbatimCoordinateSystem to Belgian Lambert 72
• Update verbatimSRS to Belgian Datum 1972
• Remove dateIdentified
• Add Actinopterygii as class
• Verify taxonRank: are those all species? Yes, all species.
• Add vernacularName
• Remove unmapped columns
• Apply changes in production

Changes to apply for measurement extension:

• Update measurementType to use lowercase: length measurementType lowercase #32
• Remove modified and SwimStyle

Questions:

• What do we do with individualCount = 0 (31 records)?
• This is a dataset about juvenile fish. Shouldn't we add lifeStage? See also New title for visfauna-ijzer-occurrences #70
• Can we add a samplingEffort?
• Shouldn't we split verbatimLocality in verbatimLocality and habitat? E.g. Paaiplaats Sint Jorisput or Natuurlijk Elzendamme SO.