Skip to content

Instantly share code, notes, and snippets.

@timrobertson100
Created August 27, 2015 14:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timrobertson100/2918d4ff77e5636a1c20 to your computer and use it in GitHub Desktop.
Save timrobertson100/2918d4ff77e5636a1c20 to your computer and use it in GitHub Desktop.
Fields
There are verbatim and interpreted fields shown below:
Verbatim:
v_abstract,
v_accessrights,
v_accrualmethod,
v_accrualperiodicity,
v_accrualpolicy,
v_alternative,
v_audience,
v_available,
v_bibliographiccitation,
v_conformsto,
v_contributor,
v_coverage,
v_created,
v_creator,
v_date,
v_dateaccepted,
v_datecopyrighted,
v_datesubmitted,
v_description,
v_educationlevel,
v_extent,
v_format,
v_hasformat,
v_haspart,
v_hasversion,
v_identifier,
v_instructionalmethod,
v_isformatof,
v_ispartof,
v_isreferencedby,
v_isreplacedby,
v_isrequiredby,
v_isversionof,
v_issued,
v_language,
v_license,
v_mediator,
v_medium,
v_modified,
v_provenance,
v_publisher,
v_references,
v_relation,
v_replaces,
v_requires,
v_rights,
v_rightsholder,
v_source,
v_spatial,
v_subject,
v_tableofcontents,
v_temporal,
v_title,
v_type,
v_valid,
v_acceptednameusage,
v_acceptednameusageid,
v_associatedmedia,
v_associatedoccurrences,
v_associatedreferences,
v_associatedsequences,
v_associatedtaxa,
v_basisofrecord,
v_bed,
v_behavior,
v_catalognumber,
v_class,
v_collectioncode,
v_collectionid,
v_continent,
v_coordinateprecision,
v_coordinateuncertaintyinmeters,
v_country,
v_countrycode,
v_county,
v_datageneralizations,
v_datasetid,
v_datasetname,
v_dateidentified,
v_day,
v_decimallatitude,
v_decimallongitude,
v_disposition,
v_dynamicproperties,
v_earliestageorloweststage,
v_earliesteonorlowesteonothem,
v_earliestepochorlowestseries,
v_earliesteraorlowesterathem,
v_earliestperiodorlowestsystem,
v_enddayofyear,
v_establishmentmeans,
v_eventdate,
v_eventid,
v_eventremarks,
v_eventtime,
v_family,
v_fieldnotes,
v_fieldnumber,
v_footprintsrs,
v_footprintspatialfit,
v_footprintwkt,
v_formation,
v_genus,
v_geodeticdatum,
v_geologicalcontextid,
v_georeferenceddate,
v_georeferenceprotocol,
v_georeferenceremarks,
v_georeferencesources,
v_georeferenceverificationstatus,
v_georeferencedby,
v_group,
v_habitat,
v_higherclassification,
v_highergeography,
v_highergeographyid,
v_highestbiostratigraphiczone,
v_identificationid,
v_identificationqualifier,
v_identificationreferences,
v_identificationremarks,
v_identificationverificationstatus,
v_identifiedby,
v_individualcount,
v_individualid,
v_informationwithheld,
v_infraspecificepithet,
v_institutioncode,
v_institutionid,
v_island,
v_islandgroup,
v_kingdom,
v_latestageorhigheststage,
v_latesteonorhighesteonothem,
v_latestepochorhighestseries,
v_latesteraorhighesterathem,
v_latestperiodorhighestsystem,
v_lifestage,
v_lithostratigraphicterms,
v_locality,
v_locationaccordingto,
v_locationid,
v_locationremarks,
v_lowestbiostratigraphiczone,
v_materialsampleid,
v_maximumdepthinmeters,
v_maximumdistanceabovesurfaceinmeters,
v_maximumelevationinmeters,
v_member,
v_minimumdepthinmeters,
v_minimumdistanceabovesurfaceinmeters,
v_minimumelevationinmeters,
v_month,
v_municipality,
v_nameaccordingto,
v_nameaccordingtoid,
v_namepublishedin,
v_namepublishedinid,
v_namepublishedinyear,
v_nomenclaturalcode,
v_nomenclaturalstatus,
v_occurrenceid,
v_occurrenceremarks,
v_occurrencestatus,
v_order,
v_originalnameusage,
v_originalnameusageid,
v_othercatalognumbers,
v_ownerinstitutioncode,
v_parentnameusage,
v_parentnameusageid,
v_phylum,
v_pointradiusspatialfit,
v_preparations,
v_previousidentifications,
v_recordnumber,
v_recordedby,
v_reproductivecondition,
v_samplingeffort,
v_samplingprotocol,
v_scientificname,
v_scientificnameauthorship,
v_scientificnameid,
v_sex,
v_specificepithet,
v_startdayofyear,
v_stateprovince,
v_subgenus,
v_taxonconceptid,
v_taxonid,
v_taxonrank,
v_taxonremarks,
v_taxonomicstatus,
v_typestatus,
v_verbatimcoordinatesystem,
v_verbatimcoordinates,
v_verbatimdepth,
v_verbatimelevation,
v_verbatimeventdate,
v_verbatimlatitude,
v_verbatimlocality,
v_verbatimlongitude,
v_verbatimsrs,
v_verbatimtaxonrank,
v_vernacularname,
v_waterbody,
v_year
Interpreted:
abstract,
accessrights,
accrualmethod,
accrualperiodicity,
accrualpolicy,
alternative,
audience,
available,
bibliographiccitation,
conformsto,
contributor,
coverage,
created,
creator,
date_,
dateaccepted,
datecopyrighted,
datesubmitted,
description,
educationlevel,
extent,
format_,
hasformat,
haspart,
hasversion,
identifier,
instructionalmethod,
isformatof,
ispartof,
isreferencedby,
isreplacedby,
isrequiredby,
isversionof,
issued,
language,
license,
mediator,
medium,
toISO8601(modified) AS modified,
provenance,
publisher,
references,
relation,
replaces,
requires,
rights,
rightsholder,
source,
spatial,
subject,
tableofcontents,
temporal,
title,
type,
valid,
acceptednameusage,
acceptednameusageid,
associatedoccurrences,
associatedreferences,
associatedsequences,
associatedtaxa,
basisofrecord,
bed,
behavior,
catalognumber,
class,
collectioncode,
collectionid,
continent,
countrycode,
county,
datageneralizations,
datasetid,
datasetname,
toISO8601(dateidentified) AS dateidentified,
day,
decimallatitude,
decimallongitude,
disposition,
dynamicproperties,
earliestageorloweststage,
earliesteonorlowesteonothem,
earliestepochorlowestseries,
earliesteraorlowesterathem,
earliestperiodorlowestsystem,
enddayofyear,
establishmentmeans,
toISO8601(eventdate) AS eventdate,
eventid,
eventremarks,
eventtime,
family,
fieldnotes,
fieldnumber,
footprintsrs,
footprintspatialfit,
footprintwkt,
formation,
genus,
geologicalcontextid,
georeferenceddate,
georeferenceprotocol,
georeferenceremarks,
georeferencesources,
georeferenceverificationstatus,
georeferencedby,
group_,
habitat,
higherclassification,
highergeography,
highergeographyid,
highestbiostratigraphiczone,
identificationid,
identificationqualifier,
identificationreferences,
identificationremarks,
identificationverificationstatus,
identifiedby,
individualcount,
individualid,
informationwithheld,
infraspecificepithet,
institutioncode,
institutionid,
island,
islandgroup,
kingdom,
latestageorhigheststage,
latesteonorhighesteonothem,
latestepochorhighestseries,
latesteraorhighesterathem,
latestperiodorhighestsystem,
lifestage,
lithostratigraphicterms,
locality,
locationaccordingto,
locationid,
locationremarks,
lowestbiostratigraphiczone,
materialsampleid,
maximumdistanceabovesurfaceinmeters,
member,
minimumdistanceabovesurfaceinmeters,
month,
municipality,
nameaccordingto,
nameaccordingtoid,
namepublishedin,
namepublishedinid,
namepublishedinyear,
nomenclaturalcode,
nomenclaturalstatus,
occurrenceid,
occurrenceremarks,
occurrencestatus,
order_,
originalnameusage,
originalnameusageid,
othercatalognumbers,
ownerinstitutioncode,
parentnameusage,
parentnameusageid,
phylum,
pointradiusspatialfit,
preparations,
previousidentifications,
recordnumber,
recordedby,
reproductivecondition,
samplingeffort,
samplingprotocol,
scientificname,
scientificnameid,
sex,
specificepithet,
startdayofyear,
stateprovince,
subgenus,
taxonconceptid,
taxonid,
taxonrank,
taxonremarks,
taxonomicstatus,
typestatus,
verbatimcoordinatesystem,
verbatimdepth,
verbatimelevation,
verbatimeventdate,
verbatimlocality,
verbatimsrs,
verbatimtaxonrank,
vernacularname,
waterbody,
year,
datasetkey,
publishingcountry,
coordinateaccuracy,
elevation,
elevationaccuracy,
depth,
depthaccuracy,
distanceabovesurface,
distanceabovesurfaceaccuracy,
if(issue IS NULL,'',joinArray(issue,'\\;')) AS issue,
if(mediatype IS NULL,'',joinArray(mediatype,'\\;')) AS mediatype,
hascoordinate,
hasgeospatialissues,
taxonkey,
kingdomkey,
phylumkey,
classkey,
orderkey,
familykey,
genuskey,
subgenuskey,
specieskey,
species,
genericname,
typifiedname,
protocol,
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment