Arctos to Darwincore

From Filtered Push Wiki
Jump to: navigation, search


cat_num

  • cataloged_item.cat_num

accn_id

  • cataloged_item.accn_id

collecting_event_id

  • cataloged_item.collecting_event_id

collection_cde

  • collection.collection_cde

collection_id

  • cataloged_item.collection_id

catalognumbertext

  • to_char(cataloged_item.cat_num),

institution_acronym

  • collection.institution_acronym,

collection

  • collection.collection

began_date

  • collecting_event.began_date

ended_date

  • collecting_event.ended_date

verbatim_date

  • collecting_event.verbatim_date,

last_edit_date

  • DECODE(coll_object.last_edit_date,NULL, coll_object.coll_object_entered_date,Coll_object.last_edit_date),

individualCount

  • coll_object.lot_count

coll_obj_disposition

  • coll_object.coll_obj_disposition

collectors

  • concatColl(cataloged_item.collection_object_id)
  • Interesting case (hard to use logic formulate and implement) because of the unknown number

field_num

  • concatSingleOtherId(cataloged_item.collection_object_id, 'Field Num')

otherCatalogNumbers

  • concatOtherId(cataloged_item.collection_object_id)

genbankNum

  • concatGenbank(cataloged_item.collection_object_id)

relatedCatalogedItems

  • concatRelations(cataloged_item.collection_object_id),

typeStatus

  • concatTypeStatus(cataloged_item.collection_object_id),

sex

  • concatAttributeValue(cataloged_item.collection_object_id, 'sex'),

parts

  • concatParts(cataloged_item.collection_object_id),

partdetail

  • concatPartsDetail(cataloged_item.collection_object_id),

encumbrances

  • concatEncumbrances(cataloged_item.collection_object_id),

accession

  • accn.accn_number,

geog_auth_rec_id

  • geog_auth_rec.geog_auth_rec_id,

higher_geog

  • geog_auth_rec.higher_geog,

continent_ocean

  • geog_auth_rec.continent_ocean,

country

  • geog_auth_rec.country,

state_prov

  • geog_auth_rec.state_prov,

county

  • geog_auth_rec.county,

feature

  • geog_auth_rec.feature,

island

  • geog_auth_rec.island,

island_group

  • geog_auth_rec.island_group,

quad

  • geog_auth_rec.quad,

sea

  • geog_auth_rec.sea,

locality_id

  • locality.locality_id,

spec_locality

  • locality.spec_locality,

minimum_elevation

  • locality.minimum_elevation,

maximum_elevation

  • locality.maximum_elevation,

orig_elev_units

  • locality.orig_elev_units,

min_elev_in_m

  • to_meters(locality.minimum_elevation, locality.orig_elev_units)
  • simple function

max_elev_in_m

  • to_meters(locality.maximum_elevation, locality.orig_elev_units),

dec_lat

  • accepted_lat_long.dec_lat,

dec_long

  • accepted_lat_long.dec_long,

datum

  • accepted_lat_long.datum,

orig_lat_long_units

  • accepted_lat_long.orig_lat_long_units,

verbatimLatitude

  • decode(accepted_lat_long.orig_lat_long_units,'decimal degrees',to_char(decimalZero(accepted_lat_long.dec_lat)) || 'd','deg. min. sec.',to_char(decimalZero(accepted_lat_long.lat_deg)) || 'd ' || to_char(decimalZero(accepted_lat_long.lat_min)) || 'm ' || to_char(decimalZero(accepted_lat_long.lat_sec)) || 's ' ||accepted_lat_long.lat_dir,'degrees dec. minutes',to_char(decimalZero(accepted_lat_long.lat_deg)) || 'd ' ||to_char(decimalZero(accepted_lat_long.dec_lat_min)) || 'm ' ||Accepted_lat_long.lat_dir),

verbatimLongitude

  • decode(accepted_lat_long.orig_lat_long_units, 'decimal degrees',to_char(decimalZero(accepted_lat_long.dec_long)) || 'd', 'deg. min. sec.', to_char(decimalZero(accepted_lat_long.long_deg)) || 'd ' ||to_char(decimalZero(accepted_lat_long.long_min)) || 'm ' || to_char(decimalZero(accepted_lat_long.long_sec)) || 's ' || accepted_lat_long.long_dir, 'degrees dec. minutes', to_char(decimalZero(accepted_lat_long.long_deg)) || 'd ' ||to_char(decimalZero(accepted_lat_long.dec_long_min)) || 'm ' || Accepted_lat_long.long_dir),

lat_long_ref_source

  • accepted_lat_long.lat_long_ref_source,

coordinateUncertaintyInMeters

  • to_meters(accepted_lat_long.max_error_distance, accepted_lat_long.max_error_units),

georefMethod

  • accepted_lat_long.georefmethod,

lat_long_remarks

  • accepted_lat_long.lat_long_remarks,

lat_long_determiner

  • lldetr.agent_name,

identification_id

  • identification.identification_id,

scientific_name

  • identification.scientific_name,

identifiedby

  • concatidentifiers(cataloged_item.collection_object_id),

made_date

  • identification.made_date,

remarks

  • coll_object_remark.coll_object_remarks,

habitat

  • coll_object_remark.habitat,

associated_species

  • coll_object_remark.associated_species,

taxa_formula

  • taxa_formula,

full_taxon_name CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'full_taxon_name') ELSE full_taxon_name END phylclass

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'phylclass') ELSE phylclass END,

kingdom

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'Kingdom') ELSE kingdom END,

phylum

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'Phylum') ELSE phylum END,

phylOrder

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'phylOrder') ELSE phylOrder END,

family

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'Family') ELSE family END,

genus

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'Genus') ELSE genus END,

species

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'Species') ELSE species END,

subspecies

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'Subspecies') ELSE subspecies END,

author_text

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'author_text') ELSE author_text END,

nomenclatural_code

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'nomenclatural_code') ELSE nomenclatural_code END,

infraspecific_rank

  • CASE WHEN taxa_formula LIKE '%B' THEN get_taxonomy(cataloged_item.collection_object_id, 'infraspecific_rank') ELSE infraspecific_rank END,

identificationModifier

guid

  • collection.guid_prefix || ':' ||cataloged_item.cat_num

basisOfRecord

  • decode(coll_object.coll_object_type,'CI', 'PreservedSpecimen','HO', 'HumanObservation','OtherSpecimen'),

depth_units

  • locality.depth_units,

min_depth

  • locality.min_depth,

max_depth

  • locality.max_depth,

min_depth_in_m

  • to_meters(locality.min_depth,locality.depth_units),

max_depth_in_m

  • to_meters(locality.max_depth,locality.depth_units),

collecting_method

  • collecting_event.collecting_method,

collecting_source

  • collecting_event.collecting_source,

dayOfYear

  • 0

age_class

  • concatAttributeValue(cataloged_item.collection_object_id, 'age_class'),

attributes

  • concatattribute(cataloged_item.collection_object_id),

verificationStatus

  • accepted_lat_long.verificationstatus,

specimenDetailUrl

  • '<a href="http://arctos.database.museum/guid/' ||collection.guid_prefix || ':' ||cataloged_item.cat_num || '">' ||collection.guid_prefix || ':' ||cataloged_item.cat_num || '</a>',

imageUrl

fieldNotesUrl

collectorNumber

  • concatSingleOtherId(cataloged_item.collection_object_id,'collector number'),

verbatimElevation

  • decode(locality.orig_elev_units,NULL, NULL,locality.minimum_elevation || '-' ||locality.maximum_elevation || ' ' ||locality.orig_elev_units),

year

  • null

month

  • null

day

  • null

id_sensu