Revision 7101
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv | ||
|---|---|---|
| 42 | 42 |
Warnings,*Warnings,, |
| 43 | 43 |
Accepted_name_lsid,*Accepted_name_lsid,, |
| 44 | 44 |
:computer,identificationType,, |
| 45 |
:0,taxonOccurrenceID,,Enables the taxonoccurrence CHECK constraint to pass |
|
| inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
TNRS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 |
:0,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass |
|
| 2 | 3 |
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3", |
| 4 |
:0,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass |
|
| 5 |
:0,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,Enables the taxonoccurrence CHECK constraint to pass |
|
| 3 | 6 |
:computer,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/determinationtype, |
| 4 | 7 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists", |
| 5 | 8 |
Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1", |
| inputs/.TNRS/public.unscrubbed_taxondetermination_view/test.xml.ref | ||
|---|---|---|
| 9 | 9 |
<location> |
| 10 | 10 |
<locationevent> |
| 11 | 11 |
<taxonoccurrence> |
| 12 |
<sourceaccessioncode>0</sourceaccessioncode> |
|
| 12 | 13 |
<taxondetermination> |
| 13 | 14 |
<determinationtype_id><determinationtype>computer</determinationtype></determinationtype_id> |
| 14 | 15 |
<taxonverbatim_id> |
Also available in: Unified diff
inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv: Set taxonOccurrenceID to dummy value 0 to enable the taxonoccurrence CHECK constraint to pass. This is needed because the constraint must pass before the pkey (which should already exist) is even checked.