Update visherintroductie SQL

[peterdesmet]

Note: Data verified for version 14.4 on 2015-10-01. 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: Set language to English #25
• Rename rights to license
• Update accessRights
• Use dataset DOI in datasetID (see DOI for VIS datasets #18)
• Update datasetName to Visherintroductie - Reintroduction of the fishes chub, dace, burbot, and brown trout in Flanders, Belgium
• Add recordedBy
• Remove verbatimDate: it is exactly the same as eventDate
• Remove field sex: Remove field sex #27
• Update verbatimCoordinateSystem to Belgian Lambert 72: Standardize verbatimSRS and verbatimCoordinateSystem #31
• Update verbatimSRS to Belgian Datum 1972: Standardize verbatimSRS and verbatimCoordinateSystem #31
• Use electrofishing (one word) in samplingProtocol: Standardize samplingProtocol #28
• Update identifiedBy to Tom Van den Neucker: it is correct
• Remove dateIdentified
• Verify taxonRank: are those all species?
• Add vernacularName
• Remove unmapped columns
• Apply changes in production

Changes to apply for measurement extension:

• Update measurementType to use lowercase: measurementType lowercase #32
• Remove modified

Questions:

• Decide on waterBody + verbatimLocality: verbatimLocality and waterBody #30
• There is no recordedBy, is this on purpose? See also Use standard delimiter for recordedBy #26
• Can we add a samplingEffort? Add samplingEffort #29
• Can we add more taxon levels, e.g. class etc.

[peterdesmet]

Installed new core and extensions and redid mapping. Changes above still need to be applied though.