Project

General

Profile

« Previous | Next » 

Revision 6374

inputs/bien_web/observation/map.csv: Mapped observationID->occurrenceID

View differences:

inputs/bien_web/observation/map.csv
1 1
bien_web,VegCore,Filter,Comments
2
observationID,*observationID,,
2
observationID,occurrenceID,,
3 3
dataSourceID,*dataSourceID,,
4 4
dataSourceName,institutionCode,,
5 5
dataSourceNamePrimary,*dataSourceNamePrimary,,
inputs/bien_web/observation/VegBIEN.csv
1 1
bien_web,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
plotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
3 3
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4
observationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
4 5
dataSourceName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1",
5 6
plotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
6 7
plotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
......
8 9
plotAreaHa,/location/area_m2/_ha_to_m2/value,
9 10
elevation_m,/location/elevation_m/_alt/1,
10 11
collectionNumber,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",
12
observationID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",
11 13
isCultivated,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/else/_alt/2",
12 14
plotMethod,/location/locationevent/*_id/method/name,
13 15
plotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
......
16 18
pctCover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,
17 19
collectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
18 20
dataSourceName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcename/name,
21
observationID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
19 22
plotCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
20 23
plotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
21 24
collectionNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
22 25
taxon,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
23 26
collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
24 27
collectionNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
28
observationID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
25 29
isCultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/2",
30
observationID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
26 31
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
27 32
taxon,"/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/2",
28 33
family,"/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/value",
......
97 102
isValidLatLong,,** No join mapping for *isValidLatLong ** 
98 103
isValidLatLong_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
99 104
localityDescription,,** No join mapping for *localityDescription ** 
100
observationID,,** No join mapping for *observationID ** 
101 105
observationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
102 106
observationType,,** No join mapping for *observationType ** 
103 107
observationType_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
inputs/bien_web/observation/test.xml.ref
16 16
                            <cover_fraction><_percent_to_fraction><value>$pctCover</value></_percent_to_fraction></cover_fraction>
17 17
                            <plantobservation>
18 18
                                <collectionnumber>$collectionNumber</collectionnumber>
19
                                <specimenreplicate><institution_id><sourcename><name>$dataSourceName</name></sourcename></institution_id></specimenreplicate>
19
                                <specimenreplicate>
20
                                    <institution_id><sourcename><name>$dataSourceName</name></sourcename></institution_id>
21
                                    <sourceaccessioncode>$observationID</sourceaccessioncode>
22
                                </specimenreplicate>
20 23
                            </plantobservation>
21 24
                        </aggregateoccurrence>
22 25
                        <authortaxoncode>$collectionNumber</authortaxoncode>
23 26
                        <collector_id><party><fullname>$collector</fullname></party></collector_id>
24 27
                        <iscultivated>$isCultivated</iscultivated>
28
                        <sourceaccessioncode>$observationID</sourceaccessioncode>
25 29
                        <taxondetermination>
26 30
                            <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
27 31
                            <taxonverbatim_id>
inputs/bien_web/observation/new_terms.csv
1
observationID,occurrenceID,,
1 2
dataSourceName,institutionCode,,
2 3
taxon,scientificName,,
3 4
taxonAuthor,scientificNameAuthorship,,
inputs/bien_web/observation/unmapped_terms.csv
1
*observationID
2 1
*dataSourceID
3 2
*dataSourceNamePrimary
4 3
*observationType

Also available in: Unified diff