Revision 3934
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/MT/test/import.specimens.xml.ref | ||
|---|---|---|
| 37 | 37 |
<specimenreplicate> |
| 38 | 38 |
<collectioncode_dwc>$collectionCode</collectioncode_dwc> |
| 39 | 39 |
<collectionnumber><_alt><2>$collectionID</2></_alt></collectionnumber> |
| 40 |
<growthform> |
|
| 41 |
<_map> |
|
| 42 |
<tree>*</tree> |
|
| 43 |
<shrub>*</shrub> |
|
| 44 |
<liana>*</liana> |
|
| 45 |
<vine>*</vine> |
|
| 46 |
<herb>*</herb> |
|
| 47 |
<hemiepiphyte>*</hemiepiphyte> |
|
| 48 |
<epiphyte>*</epiphyte> |
|
| 49 |
<grass>*</grass> |
|
| 50 |
<forb>*</forb> |
|
| 51 |
<moss>*</moss> |
|
| 52 |
<lichen>*</lichen> |
|
| 53 |
<fungus>*</fungus> |
|
| 54 |
<floating aquatic>*</floating aquatic> |
|
| 55 |
<submerged aquatic>*</submerged aquatic> |
|
| 56 |
<*></*> |
|
| 57 |
<value>$establishmentMeans</value> |
|
| 58 |
</_map> |
|
| 59 |
</growthform> |
|
| 60 | 40 |
<institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id> |
| 61 |
<iscultivated> |
|
| 62 |
<_map> |
|
| 63 |
<cultivated>t</cultivated> |
|
| 64 |
<wild>f</wild> |
|
| 65 |
<*></*> |
|
| 66 |
<value>$establishmentMeans</value> |
|
| 67 |
</_map> |
|
| 68 |
</iscultivated> |
|
| 69 |
<isnative> |
|
| 70 |
<_map> |
|
| 71 |
<native>t</native> |
|
| 72 |
<exotic>f</exotic> |
|
| 73 |
<*></*> |
|
| 74 |
<value>$establishmentMeans</value> |
|
| 75 |
</_map> |
|
| 76 |
</isnative> |
|
| 77 | 41 |
<sourceaccessioncode>$id</sourceaccessioncode> |
| 78 | 42 |
</specimenreplicate> |
| 79 | 43 |
</plantobservation> |
| 80 | 44 |
</aggregateoccurrence> |
| 45 |
<growthform> |
|
| 46 |
<_map> |
|
| 47 |
<tree>*</tree> |
|
| 48 |
<shrub>*</shrub> |
|
| 49 |
<liana>*</liana> |
|
| 50 |
<vine>*</vine> |
|
| 51 |
<herb>*</herb> |
|
| 52 |
<hemiepiphyte>*</hemiepiphyte> |
|
| 53 |
<epiphyte>*</epiphyte> |
|
| 54 |
<grass>*</grass> |
|
| 55 |
<forb>*</forb> |
|
| 56 |
<moss>*</moss> |
|
| 57 |
<lichen>*</lichen> |
|
| 58 |
<fungus>*</fungus> |
|
| 59 |
<floating aquatic>*</floating aquatic> |
|
| 60 |
<submerged aquatic>*</submerged aquatic> |
|
| 61 |
<*></*> |
|
| 62 |
<value>$establishmentMeans</value> |
|
| 63 |
</_map> |
|
| 64 |
</growthform> |
|
| 65 |
<iscultivated> |
|
| 66 |
<_map> |
|
| 67 |
<cultivated>t</cultivated> |
|
| 68 |
<wild>f</wild> |
|
| 69 |
<*></*> |
|
| 70 |
<value>$establishmentMeans</value> |
|
| 71 |
</_map> |
|
| 72 |
</iscultivated> |
|
| 73 |
<isnative> |
|
| 74 |
<_map> |
|
| 75 |
<native>t</native> |
|
| 76 |
<exotic>f</exotic> |
|
| 77 |
<*></*> |
|
| 78 |
<value>$establishmentMeans</value> |
|
| 79 |
</_map> |
|
| 80 |
</isnative> |
|
| 81 | 81 |
<taxondetermination> |
| 82 | 82 |
<isoriginal>true</isoriginal> |
| 83 | 83 |
<iscurrent>true</iscurrent> |
| inputs/MT/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 2 | 2 |
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://rs.tdwg.org/dwc/terms/#continent,59 |
| 3 | 3 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
| 4 | 4 |
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9 |
| 5 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
| 6 | 5 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 7 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 8 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 9 | 6 |
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19 |
| 7 |
establishmentMeans,"/location/locationevent/taxonoccurrence/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
| 8 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 9 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 10 | 10 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,http://rs.tdwg.org/dwc/terms/#genus,147 |
| 11 | 11 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146 |
| 12 | 12 |
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| inputs/XAL/test/import.specimens.xml.ref | ||
|---|---|---|
| 193 | 193 |
</_alt> |
| 194 | 194 |
</collectionnumber> |
| 195 | 195 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
| 196 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 197 | 196 |
</specimenreplicate> |
| 198 | 197 |
</plantobservation> |
| 199 | 198 |
</aggregateoccurrence> |
| ... | ... | |
| 316 | 315 |
</plantconcept> |
| 317 | 316 |
</plantconcept_id> |
| 318 | 317 |
</taxondetermination> |
| 318 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 319 | 319 |
</taxonoccurrence> |
| 320 | 320 |
<waterdepth> |
| 321 | 321 |
<_avg> |
| inputs/XAL/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 21 | 21 |
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22 |
| 22 | 22 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53 |
| 23 | 23 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 24 |
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 25 | 24 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120 |
| 26 | 25 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120 |
| 27 | 26 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120 |
| ... | ... | |
| 38 | 37 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144 |
| 39 | 38 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143 |
| 40 | 39 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142 |
| 40 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 41 | 41 |
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth; http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,40; 75 |
| 42 | 42 |
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumDepth; http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,39; 74 |
| 43 | 43 |
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| inputs/NY/test/import.specimens.xml.ref | ||
|---|---|---|
| 220 | 220 |
</collectionnumber> |
| 221 | 221 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
| 222 | 222 |
<sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode> |
| 223 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 224 | 223 |
</specimenreplicate> |
| 225 | 224 |
</plantobservation> |
| 226 | 225 |
</aggregateoccurrence> |
| ... | ... | |
| 343 | 342 |
</plantconcept> |
| 344 | 343 |
</plantconcept_id> |
| 345 | 344 |
</taxondetermination> |
| 345 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 346 | 346 |
</taxonoccurrence> |
| 347 | 347 |
<waterdepth> |
| 348 | 348 |
<_avg> |
| inputs/NY/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 24 | 24 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53 |
| 25 | 25 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 26 | 26 |
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
| 27 |
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 28 | 27 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120 |
| 29 | 28 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120 |
| 30 | 29 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120 |
| ... | ... | |
| 41 | 40 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144 |
| 42 | 41 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143 |
| 43 | 42 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142 |
| 43 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 44 | 44 |
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth; http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,40; 75 |
| 45 | 45 |
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumDepth; http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,39; 74 |
| 46 | 46 |
Locality,/location/locationnarrative/_merge/1/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| inputs/UNCC/test/import.specimens.xml.ref | ||
|---|---|---|
| 97 | 97 |
<specimenreplicate> |
| 98 | 98 |
<collectioncode_dwc>$herbarium</collectioncode_dwc> |
| 99 | 99 |
<collectionnumber><_alt><1><_alt><1>$collectno</1></_alt></1></_alt></collectionnumber> |
| 100 |
<growthform> |
|
| 101 |
<_map> |
|
| 102 |
<tree>*</tree> |
|
| 103 |
<shrub>*</shrub> |
|
| 104 |
<liana>*</liana> |
|
| 105 |
<vine>*</vine> |
|
| 106 |
<herb>*</herb> |
|
| 107 |
<hemiepiphyte>*</hemiepiphyte> |
|
| 108 |
<epiphyte>*</epiphyte> |
|
| 109 |
<grass>*</grass> |
|
| 110 |
<forb>*</forb> |
|
| 111 |
<moss>*</moss> |
|
| 112 |
<lichen>*</lichen> |
|
| 113 |
<fungus>*</fungus> |
|
| 114 |
<floating aquatic>*</floating aquatic> |
|
| 115 |
<submerged aquatic>*</submerged aquatic> |
|
| 116 |
<*></*> |
|
| 117 |
<value> |
|
| 118 |
<_map> |
|
| 119 |
<Y>cultivated</Y> |
|
| 120 |
<N>wild</N> |
|
| 121 |
<*></*> |
|
| 122 |
<value>$cultivated</value> |
|
| 123 |
</_map> |
|
| 124 |
</value> |
|
| 125 |
</_map> |
|
| 126 |
</growthform> |
|
| 127 |
<iscultivated> |
|
| 128 |
<_map> |
|
| 129 |
<cultivated>t</cultivated> |
|
| 130 |
<wild>f</wild> |
|
| 131 |
<*></*> |
|
| 132 |
<value> |
|
| 133 |
<_map> |
|
| 134 |
<Y>cultivated</Y> |
|
| 135 |
<N>wild</N> |
|
| 136 |
<*></*> |
|
| 137 |
<value>$cultivated</value> |
|
| 138 |
</_map> |
|
| 139 |
</value> |
|
| 140 |
</_map> |
|
| 141 |
</iscultivated> |
|
| 142 |
<isnative> |
|
| 143 |
<_map> |
|
| 144 |
<native>t</native> |
|
| 145 |
<exotic>f</exotic> |
|
| 146 |
<*></*> |
|
| 147 |
<value> |
|
| 148 |
<_map> |
|
| 149 |
<Y>cultivated</Y> |
|
| 150 |
<N>wild</N> |
|
| 151 |
<*></*> |
|
| 152 |
<value>$cultivated</value> |
|
| 153 |
</_map> |
|
| 154 |
</value> |
|
| 155 |
</_map> |
|
| 156 |
</isnative> |
|
| 157 | 100 |
<sourceaccessioncode>$accession</sourceaccessioncode> |
| 158 |
<verbatimcollectorname> |
|
| 159 |
<_merge> |
|
| 160 |
<1>$collector</1> |
|
| 161 |
<2>$collector1</2> |
|
| 162 |
<3>$collector2</3> |
|
| 163 |
<4>$collector3</4> |
|
| 164 |
</_merge> |
|
| 165 |
</verbatimcollectorname> |
|
| 166 | 101 |
</specimenreplicate> |
| 167 | 102 |
</plantobservation> |
| 168 | 103 |
</aggregateoccurrence> |
| 104 |
<growthform> |
|
| 105 |
<_map> |
|
| 106 |
<tree>*</tree> |
|
| 107 |
<shrub>*</shrub> |
|
| 108 |
<liana>*</liana> |
|
| 109 |
<vine>*</vine> |
|
| 110 |
<herb>*</herb> |
|
| 111 |
<hemiepiphyte>*</hemiepiphyte> |
|
| 112 |
<epiphyte>*</epiphyte> |
|
| 113 |
<grass>*</grass> |
|
| 114 |
<forb>*</forb> |
|
| 115 |
<moss>*</moss> |
|
| 116 |
<lichen>*</lichen> |
|
| 117 |
<fungus>*</fungus> |
|
| 118 |
<floating aquatic>*</floating aquatic> |
|
| 119 |
<submerged aquatic>*</submerged aquatic> |
|
| 120 |
<*></*> |
|
| 121 |
<value> |
|
| 122 |
<_map> |
|
| 123 |
<Y>cultivated</Y> |
|
| 124 |
<N>wild</N> |
|
| 125 |
<*></*> |
|
| 126 |
<value>$cultivated</value> |
|
| 127 |
</_map> |
|
| 128 |
</value> |
|
| 129 |
</_map> |
|
| 130 |
</growthform> |
|
| 131 |
<iscultivated> |
|
| 132 |
<_map> |
|
| 133 |
<cultivated>t</cultivated> |
|
| 134 |
<wild>f</wild> |
|
| 135 |
<*></*> |
|
| 136 |
<value> |
|
| 137 |
<_map> |
|
| 138 |
<Y>cultivated</Y> |
|
| 139 |
<N>wild</N> |
|
| 140 |
<*></*> |
|
| 141 |
<value>$cultivated</value> |
|
| 142 |
</_map> |
|
| 143 |
</value> |
|
| 144 |
</_map> |
|
| 145 |
</iscultivated> |
|
| 146 |
<isnative> |
|
| 147 |
<_map> |
|
| 148 |
<native>t</native> |
|
| 149 |
<exotic>f</exotic> |
|
| 150 |
<*></*> |
|
| 151 |
<value> |
|
| 152 |
<_map> |
|
| 153 |
<Y>cultivated</Y> |
|
| 154 |
<N>wild</N> |
|
| 155 |
<*></*> |
|
| 156 |
<value>$cultivated</value> |
|
| 157 |
</_map> |
|
| 158 |
</value> |
|
| 159 |
</_map> |
|
| 160 |
</isnative> |
|
| 169 | 161 |
<taxondetermination> |
| 170 | 162 |
<isoriginal>true</isoriginal> |
| 171 | 163 |
<iscurrent>true</iscurrent> |
| ... | ... | |
| 217 | 209 |
</plantconcept> |
| 218 | 210 |
</plantconcept_id> |
| 219 | 211 |
</taxondetermination> |
| 212 |
<verbatimcollectorname> |
|
| 213 |
<_merge> |
|
| 214 |
<1>$collector</1> |
|
| 215 |
<2>$collector1</2> |
|
| 216 |
<3>$collector2</3> |
|
| 217 |
<4>$collector3</4> |
|
| 218 |
</_merge> |
|
| 219 |
</verbatimcollectorname> |
|
| 220 | 220 |
</taxonoccurrence> |
| 221 | 221 |
</locationevent> |
| 222 | 222 |
<locationnarrative> |
| inputs/UNCC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 14 | 14 |
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/7/_label[label=""in or out""]/value",,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
| 15 | 15 |
herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
| 16 | 16 |
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22 |
| 17 |
cultivated,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
| 18 |
cultivated,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 19 |
cultivated,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 20 | 17 |
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
| 21 |
collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 22 |
collector1,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 23 |
collector2,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/3,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 24 |
collector3,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/4,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 18 |
cultivated,"/location/locationevent/taxonoccurrence/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
| 19 |
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 20 |
cultivated,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 25 | 21 |
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",,http://rs.tdwg.org/dwc/terms/#scientificName,134 |
| 26 | 22 |
authors,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153 |
| 27 | 23 |
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150 |
| 28 | 24 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149 |
| 29 | 25 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,http://rs.tdwg.org/dwc/terms/#genus,147 |
| 30 | 26 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146 |
| 27 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 28 |
collector1,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 29 |
collector2,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/3,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 30 |
collector3,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/4,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 31 | 31 |
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| 32 | 32 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/#habitat,52 |
| 33 | 33 |
accession,/location/sourceaccessioncode/_alt/1,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
| inputs/ACAD/test/import.specimens.xml.ref | ||
|---|---|---|
| 71 | 71 |
</collectionnumber> |
| 72 | 72 |
<institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id> |
| 73 | 73 |
<sourceaccessioncode>$id</sourceaccessioncode> |
| 74 |
<verbatimcollectorname>$recordedBy</verbatimcollectorname> |
|
| 75 | 74 |
</specimenreplicate> |
| 76 | 75 |
</plantobservation> |
| 77 | 76 |
</aggregateoccurrence> |
| ... | ... | |
| 158 | 157 |
</plantconcept> |
| 159 | 158 |
</plantconcept_id> |
| 160 | 159 |
</taxondetermination> |
| 160 |
<verbatimcollectorname>$recordedBy</verbatimcollectorname> |
|
| 161 | 161 |
</taxonoccurrence> |
| 162 | 162 |
</locationevent> |
| 163 | 163 |
<locationnarrative> |
| inputs/ACAD/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 12 | 12 |
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9 |
| 13 | 13 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 14 | 14 |
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19 |
| 15 |
recordedBy,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23 |
|
| 16 | 15 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120 |
| 17 | 16 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| 18 | 17 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| ... | ... | |
| 27 | 26 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144 |
| 28 | 27 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143 |
| 29 | 28 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142 |
| 29 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23 |
|
| 30 | 30 |
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| 31 | 31 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/#habitat,52 |
| 32 | 32 |
id,/location/sourceaccessioncode/_alt/1,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19 |
| inputs/REMIB/test/import.specimens.xml.ref | ||
|---|---|---|
| 93 | 93 |
<specimenreplicate> |
| 94 | 94 |
<collectioncode_dwc>$acronym</collectioncode_dwc> |
| 95 | 95 |
<sourceaccessioncode>$accession_number</sourceaccessioncode> |
| 96 |
<verbatimcollectorname>$collector</verbatimcollectorname> |
|
| 97 | 96 |
</specimenreplicate> |
| 98 | 97 |
</plantobservation> |
| 99 | 98 |
</aggregateoccurrence> |
| ... | ... | |
| 145 | 144 |
</plantconcept> |
| 146 | 145 |
</plantconcept_id> |
| 147 | 146 |
</taxondetermination> |
| 147 |
<verbatimcollectorname>$collector</verbatimcollectorname> |
|
| 148 | 148 |
</taxonoccurrence> |
| 149 | 149 |
</locationevent> |
| 150 | 150 |
<locationnarrative> |
| inputs/REMIB/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 9 | 9 |
coll_year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44 |
| 10 | 10 |
acronym,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
| 11 | 11 |
accession_number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
| 12 |
collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 13 | 12 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149 |
| 14 | 13 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,http://rs.tdwg.org/dwc/terms/#genus,147 |
| 15 | 14 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146 |
| 15 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 16 | 16 |
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| 17 | 17 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/#habitat,52 |
| 18 | 18 |
accession_number,/location/sourceaccessioncode/_alt/1,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
| inputs/U/test/import.specimens.xml.ref | ||
|---|---|---|
| 93 | 93 |
<catalognumber_dwc>$Barcode</catalognumber_dwc> |
| 94 | 94 |
<collectionnumber><_alt><1><_alt><2>$Number</2></_alt></1></_alt></collectionnumber> |
| 95 | 95 |
<sourceaccessioncode>$ID</sourceaccessioncode> |
| 96 |
<verbatimcollectorname> |
|
| 97 |
<_merge> |
|
| 98 |
<1>$Collector</1> |
|
| 99 |
<2>$Addcoll</2> |
|
| 100 |
</_merge> |
|
| 101 |
</verbatimcollectorname> |
|
| 102 | 96 |
</specimenreplicate> |
| 103 | 97 |
</plantobservation> |
| 104 | 98 |
</aggregateoccurrence> |
| ... | ... | |
| 179 | 173 |
</plantconcept> |
| 180 | 174 |
</plantconcept_id> |
| 181 | 175 |
</taxondetermination> |
| 176 |
<verbatimcollectorname> |
|
| 177 |
<_merge> |
|
| 178 |
<1>$Collector</1> |
|
| 179 |
<2>$Addcoll</2> |
|
| 180 |
</_merge> |
|
| 181 |
</verbatimcollectorname> |
|
| 182 | 182 |
</taxonoccurrence> |
| 183 | 183 |
</locationevent> |
| 184 | 184 |
<locationnarrative> |
| inputs/U/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 9 | 9 |
Barcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20 |
| 10 | 10 |
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22 |
| 11 | 11 |
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19 |
| 12 |
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 13 |
Addcoll,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 14 | 12 |
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120 |
| 15 | 13 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| 16 | 14 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| 17 | 15 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| 18 | 16 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,http://rs.tdwg.org/dwc/terms/#genus,147 |
| 19 | 17 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146 |
| 18 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 19 |
Addcoll,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 20 | 20 |
Gazetteer,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/1",,http://rs.tdwg.org/dwc/terms/#verbatimLocality,69 |
| 21 | 21 |
Newgazett,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row,http://rs.tdwg.org/dwc/terms/#verbatimLocality,69 |
| 22 | 22 |
Locnotes,/location/locationnarrative/_merge/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#verbatimLocality,69 |
| inputs/ARIZ/test/import.specimens.xml.ref | ||
|---|---|---|
| 206 | 206 |
</collectionnumber> |
| 207 | 207 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
| 208 | 208 |
<sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode> |
| 209 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 210 | 209 |
</specimenreplicate> |
| 211 | 210 |
</plantobservation> |
| 212 | 211 |
</aggregateoccurrence> |
| ... | ... | |
| 334 | 333 |
</plantconcept> |
| 335 | 334 |
</plantconcept_id> |
| 336 | 335 |
</taxondetermination> |
| 336 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 337 | 337 |
</taxonoccurrence> |
| 338 | 338 |
<waterdepth> |
| 339 | 339 |
<_avg> |
| inputs/ARIZ/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 26 | 26 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53 |
| 27 | 27 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 28 | 28 |
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19 |
| 29 |
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 30 | 29 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120 |
| 31 | 30 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120 |
| 32 | 31 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120 |
| ... | ... | |
| 44 | 43 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144 |
| 45 | 44 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143 |
| 46 | 45 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142 |
| 46 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 47 | 47 |
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,75 |
| 48 | 48 |
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,74 |
| 49 | 49 |
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| inputs/GBIF/test/import.specimens.xml.ref | ||
|---|---|---|
| 144 | 144 |
<catalognumber_dwc>$CatalogNO</catalognumber_dwc> |
| 145 | 145 |
<collectioncode_dwc>$CollectionCD</collectioncode_dwc> |
| 146 | 146 |
<institution_id><party><organizationname>$InstitutionCD</organizationname></party></institution_id> |
| 147 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 148 | 147 |
</specimenreplicate> |
| 149 | 148 |
</plantobservation> |
| 150 | 149 |
</aggregateoccurrence> |
| ... | ... | |
| 206 | 205 |
</plantconcept> |
| 207 | 206 |
</plantconcept_id> |
| 208 | 207 |
</taxondetermination> |
| 208 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 209 | 209 |
</taxonoccurrence> |
| 210 | 210 |
</locationevent> |
| 211 | 211 |
<locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative> |
| inputs/GBIF/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 15 | 15 |
CatalogNO,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20 |
| 16 | 16 |
CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
| 17 | 17 |
InstitutionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 18 |
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 19 | 18 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| 20 | 19 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| 21 | 20 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| ... | ... | |
| 25 | 24 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149 |
| 26 | 25 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,http://rs.tdwg.org/dwc/terms/#genus,147 |
| 27 | 26 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146 |
| 27 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 28 | 28 |
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| 29 | 29 |
InstitutionCD,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 30 | 30 |
CollectionCD,/location/sourceaccessioncode/_alt/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
| inputs/NCU-NCSC/test/import.specimens.xml.ref | ||
|---|---|---|
| 68 | 68 |
<specimenreplicate> |
| 69 | 69 |
<catalognumber_dwc>$Barcode</catalognumber_dwc> |
| 70 | 70 |
<collectioncode_dwc>$SeriesName</collectioncode_dwc> |
| 71 |
<growthform> |
|
| 72 |
<_map> |
|
| 73 |
<tree>*</tree> |
|
| 74 |
<shrub>*</shrub> |
|
| 75 |
<liana>*</liana> |
|
| 76 |
<vine>*</vine> |
|
| 77 |
<herb>*</herb> |
|
| 78 |
<hemiepiphyte>*</hemiepiphyte> |
|
| 79 |
<epiphyte>*</epiphyte> |
|
| 80 |
<grass>*</grass> |
|
| 81 |
<forb>*</forb> |
|
| 82 |
<moss>*</moss> |
|
| 83 |
<lichen>*</lichen> |
|
| 84 |
<fungus>*</fungus> |
|
| 85 |
<floating aquatic>*</floating aquatic> |
|
| 86 |
<submerged aquatic>*</submerged aquatic> |
|
| 87 |
<*></*> |
|
| 88 |
<value> |
|
| 89 |
<_map> |
|
| 90 |
<Yes>cultivated</Yes> |
|
| 91 |
<No>wild</No> |
|
| 92 |
<value>$Cultivated?</value> |
|
| 93 |
</_map> |
|
| 94 |
</value> |
|
| 95 |
</_map> |
|
| 96 |
</growthform> |
|
| 97 |
<iscultivated> |
|
| 98 |
<_map> |
|
| 99 |
<cultivated>t</cultivated> |
|
| 100 |
<wild>f</wild> |
|
| 101 |
<*></*> |
|
| 102 |
<value> |
|
| 103 |
<_map> |
|
| 104 |
<Yes>cultivated</Yes> |
|
| 105 |
<No>wild</No> |
|
| 106 |
<value>$Cultivated?</value> |
|
| 107 |
</_map> |
|
| 108 |
</value> |
|
| 109 |
</_map> |
|
| 110 |
</iscultivated> |
|
| 111 |
<isnative> |
|
| 112 |
<_map> |
|
| 113 |
<native>t</native> |
|
| 114 |
<exotic>f</exotic> |
|
| 115 |
<*></*> |
|
| 116 |
<value> |
|
| 117 |
<_map> |
|
| 118 |
<Yes>cultivated</Yes> |
|
| 119 |
<No>wild</No> |
|
| 120 |
<value>$Cultivated?</value> |
|
| 121 |
</_map> |
|
| 122 |
</value> |
|
| 123 |
</_map> |
|
| 124 |
</isnative> |
|
| 125 | 71 |
<sourceaccessioncode>$Accession Number</sourceaccessioncode> |
| 126 | 72 |
</specimenreplicate> |
| 127 | 73 |
</plantobservation> |
| 128 | 74 |
</aggregateoccurrence> |
| 75 |
<growthform> |
|
| 76 |
<_map> |
|
| 77 |
<tree>*</tree> |
|
| 78 |
<shrub>*</shrub> |
|
| 79 |
<liana>*</liana> |
|
| 80 |
<vine>*</vine> |
|
| 81 |
<herb>*</herb> |
|
| 82 |
<hemiepiphyte>*</hemiepiphyte> |
|
| 83 |
<epiphyte>*</epiphyte> |
|
| 84 |
<grass>*</grass> |
|
| 85 |
<forb>*</forb> |
|
| 86 |
<moss>*</moss> |
|
| 87 |
<lichen>*</lichen> |
|
| 88 |
<fungus>*</fungus> |
|
| 89 |
<floating aquatic>*</floating aquatic> |
|
| 90 |
<submerged aquatic>*</submerged aquatic> |
|
| 91 |
<*></*> |
|
| 92 |
<value> |
|
| 93 |
<_map> |
|
| 94 |
<Yes>cultivated</Yes> |
|
| 95 |
<No>wild</No> |
|
| 96 |
<value>$Cultivated?</value> |
|
| 97 |
</_map> |
|
| 98 |
</value> |
|
| 99 |
</_map> |
|
| 100 |
</growthform> |
|
| 101 |
<iscultivated> |
|
| 102 |
<_map> |
|
| 103 |
<cultivated>t</cultivated> |
|
| 104 |
<wild>f</wild> |
|
| 105 |
<*></*> |
|
| 106 |
<value> |
|
| 107 |
<_map> |
|
| 108 |
<Yes>cultivated</Yes> |
|
| 109 |
<No>wild</No> |
|
| 110 |
<value>$Cultivated?</value> |
|
| 111 |
</_map> |
|
| 112 |
</value> |
|
| 113 |
</_map> |
|
| 114 |
</iscultivated> |
|
| 115 |
<isnative> |
|
| 116 |
<_map> |
|
| 117 |
<native>t</native> |
|
| 118 |
<exotic>f</exotic> |
|
| 119 |
<*></*> |
|
| 120 |
<value> |
|
| 121 |
<_map> |
|
| 122 |
<Yes>cultivated</Yes> |
|
| 123 |
<No>wild</No> |
|
| 124 |
<value>$Cultivated?</value> |
|
| 125 |
</_map> |
|
| 126 |
</value> |
|
| 127 |
</_map> |
|
| 128 |
</isnative> |
|
| 129 | 129 |
<taxondetermination> |
| 130 | 130 |
<isoriginal>true</isoriginal> |
| 131 | 131 |
<iscurrent>true</iscurrent> |
| inputs/NCU-NCSC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 8 | 8 |
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate; http://rs.tdwg.org/dwc/terms/#eventDate,29; 44 |
| 9 | 9 |
Barcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20 |
| 10 | 10 |
SeriesName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
| 11 |
Cultivated?,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value/_map:[Yes=cultivated,No=wild]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
| 12 |
Cultivated?,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 13 |
Cultivated?,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 14 | 11 |
Accession Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
| 12 |
Cultivated?,"/location/locationevent/taxonoccurrence/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value/_map:[Yes=cultivated,No=wild]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
| 13 |
Cultivated?,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 14 |
Cultivated?,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 15 | 15 |
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",,http://rs.tdwg.org/dwc/terms/#scientificName,134 |
| 16 | 16 |
Accession Number,/location/sourceaccessioncode/_alt/1,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
| 17 | 17 |
SeriesName,/location/sourceaccessioncode/_alt/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
| inputs/SpeciesLink/test/import.specimens.xml.ref | ||
|---|---|---|
| 319 | 319 |
</party> |
| 320 | 320 |
</institution_id> |
| 321 | 321 |
<sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode> |
| 322 |
<verbatimcollectorname> |
|
| 323 |
<_alt> |
|
| 324 |
<0>$dwc_dwcore_Collector</0> |
|
| 325 |
<1>$conceptual_darwin_2003_1_0_Collector</1> |
|
| 326 |
<2>$dwc_terms_recordedBy</2> |
|
| 327 |
</_alt> |
|
| 328 |
</verbatimcollectorname> |
|
| 329 | 322 |
</specimenreplicate> |
| 330 | 323 |
</plantobservation> |
| 331 | 324 |
</aggregateoccurrence> |
| ... | ... | |
| 540 | 533 |
</plantconcept> |
| 541 | 534 |
</plantconcept_id> |
| 542 | 535 |
</taxondetermination> |
| 536 |
<verbatimcollectorname> |
|
| 537 |
<_alt> |
|
| 538 |
<0>$dwc_dwcore_Collector</0> |
|
| 539 |
<1>$conceptual_darwin_2003_1_0_Collector</1> |
|
| 540 |
<2>$dwc_terms_recordedBy</2> |
|
| 541 |
</_alt> |
|
| 542 |
</verbatimcollectorname> |
|
| 543 | 543 |
</taxonoccurrence> |
| 544 | 544 |
<waterdepth> |
| 545 | 545 |
<_avg> |
| inputs/SpeciesLink/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 54 | 54 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 55 | 55 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 56 | 56 |
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19 |
| 57 |
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 58 |
recordedBy,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23 |
|
| 59 | 57 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120 |
| 60 | 58 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120 |
| 61 | 59 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120 |
| ... | ... | |
| 90 | 88 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143 |
| 91 | 89 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142 |
| 92 | 90 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142 |
| 91 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 92 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23 |
|
| 93 | 93 |
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth; http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,40; 75 |
| 94 | 94 |
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,75 |
| 95 | 95 |
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,75 |
| inputs/MO/test/import.specimens.xml.ref | ||
|---|---|---|
| 178 | 178 |
<collectioncode_dwc>$CollectionCode</collectioncode_dwc> |
| 179 | 179 |
<collectionnumber><_alt><1><_alt><1>$CollectorNumber</1></_alt></1></_alt></collectionnumber> |
| 180 | 180 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
| 181 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 182 | 181 |
</specimenreplicate> |
| 183 | 182 |
</plantobservation> |
| 184 | 183 |
</aggregateoccurrence> |
| ... | ... | |
| 261 | 260 |
</plantconcept> |
| 262 | 261 |
</plantconcept_id> |
| 263 | 262 |
</taxondetermination> |
| 263 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 264 | 264 |
</taxonoccurrence> |
| 265 | 265 |
</locationevent> |
| 266 | 266 |
<locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative> |
| inputs/MO/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 18 | 18 |
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
| 19 | 19 |
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22 |
| 20 | 20 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 21 |
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 22 | 21 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| 23 | 22 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| 24 | 23 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| ... | ... | |
| 29 | 28 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,http://rs.tdwg.org/dwc/terms/#genus,147 |
| 30 | 29 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146 |
| 31 | 30 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142 |
| 31 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 32 | 32 |
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| 33 | 33 |
InstitutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 34 | 34 |
CollectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
| inputs/QMOR/test/import.specimens.xml.ref | ||
|---|---|---|
| 163 | 163 |
<collectionnumber><_alt><2>$collectionID</2></_alt></collectionnumber> |
| 164 | 164 |
<institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id> |
| 165 | 165 |
<sourceaccessioncode>$id</sourceaccessioncode> |
| 166 |
<verbatimcollectorname>$recordedBy</verbatimcollectorname> |
|
| 167 | 166 |
</specimenreplicate> |
| 168 | 167 |
</plantobservation> |
| 169 | 168 |
</aggregateoccurrence> |
| ... | ... | |
| 250 | 249 |
</plantconcept> |
| 251 | 250 |
</plantconcept_id> |
| 252 | 251 |
</taxondetermination> |
| 252 |
<verbatimcollectorname>$recordedBy</verbatimcollectorname> |
|
| 253 | 253 |
</taxonoccurrence> |
| 254 | 254 |
</locationevent> |
| 255 | 255 |
<locationnarrative> |
| schemas/vegbien.my.sql | ||
|---|---|---|
| 103 | 103 |
|
| 104 | 104 |
|
| 105 | 105 |
-- |
| 106 |
-- Name: taxondetermination_taxonoccurrence_id_fkey(); Type: FUNCTION; Schema: public; Owner: - |
|
| 107 |
-- |
|
| 108 |
|
|
| 109 |
|
|
| 110 |
|
|
| 111 |
|
|
| 112 |
-- |
|
| 113 | 106 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: - |
| 114 | 107 |
-- |
| 115 | 108 |
|
| ... | ... | |
| 2114 | 2107 |
|
| 2115 | 2108 |
|
| 2116 | 2109 |
|
| 2110 |
|
|
| 2111 |
|
|
| 2117 | 2112 |
-- |
| 2118 |
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2113 |
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2119 | 2114 |
-- |
| 2120 | 2115 |
|
| 2121 |
CREATE TABLE taxonoccurrence (
|
|
| 2116 |
CREATE TABLE specimenreplicate (
|
|
| 2122 | 2117 |
taxonoccurrence_id int(11) NOT NULL, |
| 2118 |
specimenreplicate_id int(11) NOT NULL, |
|
| 2123 | 2119 |
datasource_id int(11) NOT NULL, |
| 2124 | 2120 |
sourceaccessioncode text, |
| 2125 |
locationevent_id int(11), |
|
| 2126 |
verbatimcollectorname text, |
|
| 2127 |
growthform text, |
|
| 2128 |
iscultivated int(1), |
|
| 2129 |
cultivatedbasis text, |
|
| 2130 |
isnative int(1), |
|
| 2121 |
plantobservation_id int(11), |
|
| 2122 |
institution_id int(11), |
|
| 2123 |
collectioncode_dwc text, |
|
| 2124 |
catalognumber_dwc text, |
|
| 2125 |
collectionnumber text, |
|
| 2126 |
description text, |
|
| 2127 |
specimen_id int(11), |
|
| 2131 | 2128 |
accessioncode text |
| 2132 | 2129 |
); |
| 2130 |
ALTER TABLE specimenreplicate |
|
| 2131 |
ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 2133 | 2132 |
|
| 2134 | 2133 |
|
| 2135 |
-- |
|
| 2136 |
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: - |
|
| 2137 |
-- |
|
| 2138 | 2134 |
|
| 2139 |
|
|
| 2140 |
|
|
| 2141 |
|
|
| 2142 | 2135 |
-- |
| 2143 |
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
|
|
| 2136 |
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
|
|
| 2144 | 2137 |
-- |
| 2145 | 2138 |
|
| 2146 | 2139 |
|
| 2147 | 2140 |
|
| 2148 | 2141 |
|
| 2149 | 2142 |
-- |
| 2150 |
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 2143 |
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 2151 | 2144 |
-- |
| 2152 | 2145 |
|
| 2153 | 2146 |
|
| 2154 | 2147 |
|
| 2155 | 2148 |
|
| 2156 | 2149 |
-- |
| 2157 |
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
|
|
| 2150 |
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 2158 | 2151 |
-- |
| 2159 | 2152 |
|
| 2160 | 2153 |
|
| 2161 | 2154 |
|
| 2162 | 2155 |
|
| 2163 | 2156 |
-- |
| 2164 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2157 |
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
|
|
| 2165 | 2158 |
-- |
| 2166 | 2159 |
|
| 2167 | 2160 |
|
| 2168 | 2161 |
|
| 2169 | 2162 |
|
| 2170 | 2163 |
-- |
| 2171 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2164 |
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2172 | 2165 |
-- |
| 2173 | 2166 |
|
| 2174 | 2167 |
|
| 2175 | 2168 |
|
| 2176 | 2169 |
|
| 2177 |
|
|
| 2178 |
|
|
| 2179 | 2170 |
-- |
| 2180 |
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2171 |
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2181 | 2172 |
-- |
| 2182 | 2173 |
|
| 2183 |
CREATE TABLE specimenreplicate ( |
|
| 2184 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 2185 |
plantobservation_id int(11), |
|
| 2186 |
institution_id int(11), |
|
| 2187 |
collectioncode_dwc text, |
|
| 2188 |
catalognumber_dwc text, |
|
| 2189 |
collectionnumber text, |
|
| 2190 |
description text, |
|
| 2191 |
specimen_id int(11) |
|
| 2192 |
) |
|
| 2193 |
; |
|
| 2194 |
ALTER TABLE specimenreplicate |
|
| 2195 |
ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 2196 | 2174 |
|
| 2197 | 2175 |
|
| 2198 | 2176 |
|
| 2199 | 2177 |
-- |
| 2200 |
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: - |
|
| 2201 |
-- |
|
| 2202 |
|
|
| 2203 |
|
|
| 2204 |
|
|
| 2205 |
|
|
| 2206 |
-- |
|
| 2207 |
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: - |
|
| 2208 |
-- |
|
| 2209 |
|
|
| 2210 |
|
|
| 2211 |
|
|
| 2212 |
|
|
| 2213 |
-- |
|
| 2214 |
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 2215 |
-- |
|
| 2216 |
|
|
| 2217 |
|
|
| 2218 |
|
|
| 2219 |
|
|
| 2220 |
-- |
|
| 2221 |
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: - |
|
| 2222 |
-- |
|
| 2223 |
|
|
| 2224 |
|
|
| 2225 |
|
|
| 2226 |
|
|
| 2227 |
-- |
|
| 2228 | 2178 |
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2229 | 2179 |
-- |
| 2230 | 2180 |
|
| ... | ... | |
| 2403 | 2353 |
|
| 2404 | 2354 |
|
| 2405 | 2355 |
|
| 2356 |
|
|
| 2357 |
|
|
| 2406 | 2358 |
-- |
| 2359 |
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2360 |
-- |
|
| 2361 |
|
|
| 2362 |
CREATE TABLE taxonoccurrence ( |
|
| 2363 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 2364 |
datasource_id int(11) NOT NULL, |
|
| 2365 |
sourceaccessioncode text, |
|
| 2366 |
locationevent_id int(11), |
|
| 2367 |
verbatimcollectorname text, |
|
| 2368 |
growthform text, |
|
| 2369 |
iscultivated int(1), |
|
| 2370 |
cultivatedbasis text, |
|
| 2371 |
isnative int(1), |
|
| 2372 |
accessioncode text |
|
| 2373 |
); |
|
| 2374 |
|
|
| 2375 |
|
|
| 2376 |
-- |
|
| 2377 |
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: - |
|
| 2378 |
-- |
|
| 2379 |
|
|
| 2380 |
|
|
| 2381 |
|
|
| 2382 |
|
|
| 2383 |
-- |
|
| 2384 |
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: - |
|
| 2385 |
-- |
|
| 2386 |
|
|
| 2387 |
|
|
| 2388 |
|
|
| 2389 |
|
|
| 2390 |
-- |
|
| 2391 |
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: - |
|
| 2392 |
-- |
|
| 2393 |
|
|
| 2394 |
|
|
| 2395 |
|
|
| 2396 |
|
|
| 2397 |
-- |
|
| 2398 |
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: - |
|
| 2399 |
-- |
|
| 2400 |
|
|
| 2401 |
|
|
| 2402 |
|
|
| 2403 |
|
|
| 2404 |
-- |
|
| 2405 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2406 |
-- |
|
| 2407 |
|
|
| 2408 |
|
|
| 2409 |
|
|
| 2410 |
|
|
| 2411 |
-- |
|
| 2412 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2413 |
-- |
|
| 2414 |
|
|
| 2415 |
|
|
| 2416 |
|
|
| 2417 |
|
|
| 2418 |
|
|
| 2419 |
|
|
| 2420 |
-- |
|
| 2407 | 2421 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2408 | 2422 |
-- |
| 2409 | 2423 |
|
| ... | ... | |
| 2860 | 2874 |
|
| 2861 | 2875 |
|
| 2862 | 2876 |
-- |
| 2877 |
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2878 |
-- |
|
| 2879 |
|
|
| 2880 |
|
|
| 2881 |
|
|
| 2882 |
|
|
| 2883 |
-- |
|
| 2863 | 2884 |
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: - |
| 2864 | 2885 |
-- |
| 2865 | 2886 |
|
| ... | ... | |
| 3438 | 3459 |
-- |
| 3439 | 3460 |
|
| 3440 | 3461 |
ALTER TABLE specimenreplicate |
| 3441 |
ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (taxonoccurrence_id);
|
|
| 3462 |
ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
|
|
| 3442 | 3463 |
|
| 3443 | 3464 |
|
| 3444 | 3465 |
-- |
| ... | ... | |
| 3914 | 3935 |
|
| 3915 | 3936 |
|
| 3916 | 3937 |
-- |
| 3917 |
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: TRIGGER; Schema: public; Owner: - |
|
| 3918 |
-- |
|
| 3919 |
|
|
| 3920 |
|
|
| 3921 |
|
|
| 3922 |
|
|
| 3923 |
-- |
|
| 3924 | 3938 |
-- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 3925 | 3939 |
-- |
| 3926 | 3940 |
|
| ... | ... | |
| 4712 | 4726 |
|
| 4713 | 4727 |
|
| 4714 | 4728 |
-- |
| 4715 |
-- Name: specimenreplicate_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4716 |
-- |
|
| 4717 |
|
|
| 4718 |
ALTER TABLE specimenreplicate |
|
| 4719 |
ADD CONSTRAINT specimenreplicate_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4720 |
|
|
| 4721 |
|
|
| 4722 |
-- |
|
| 4723 | 4729 |
-- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4724 | 4730 |
-- |
| 4725 | 4731 |
|
| ... | ... | |
| 4813 | 4819 |
|
| 4814 | 4820 |
|
| 4815 | 4821 |
-- |
| 4822 |
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4823 |
-- |
|
| 4824 |
|
|
| 4825 |
ALTER TABLE taxondetermination |
|
| 4826 |
ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4827 |
|
|
| 4828 |
|
|
| 4829 |
-- |
|
| 4816 | 4830 |
-- Name: taxonoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4817 | 4831 |
-- |
| 4818 | 4832 |
|
| ... | ... | |
| 4848 | 4862 |
-- |
| 4849 | 4863 |
|
| 4850 | 4864 |
ALTER TABLE voucher |
| 4851 |
ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 4865 |
ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 4852 | 4866 |
|
| 4853 | 4867 |
|
| 4854 | 4868 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 297 | 297 |
|
| 298 | 298 |
|
| 299 | 299 |
-- |
| 300 |
-- Name: taxondetermination_taxonoccurrence_id_fkey(); Type: FUNCTION; Schema: public; Owner: - |
|
| 301 |
-- |
|
| 302 |
|
|
| 303 |
CREATE FUNCTION taxondetermination_taxonoccurrence_id_fkey() RETURNS trigger |
|
| 304 |
LANGUAGE plpgsql |
|
| 305 |
AS $$ |
|
| 306 |
BEGIN |
|
| 307 |
IF ( |
|
| 308 |
SELECT count(*) = 0 |
|
| 309 |
FROM taxonoccurrence |
|
| 310 |
WHERE taxonoccurrence_id = new.taxonoccurrence_id |
|
| 311 |
) THEN |
|
| 312 |
RAISE EXCEPTION E'insert or update on table "taxondetermination" ' |
|
| 313 |
'violates foreign key constraint "taxondetermination_taxonoccurrence_id_fkey"\n' |
|
| 314 |
'DETAIL: Key (taxondetermination_taxonoccurrence_id_fkey)=(%) is not present in' |
|
| 315 |
' table "taxonoccurrence".', new.taxonoccurrence_id |
|
| 316 |
USING ERRCODE = 'foreign_key_violation'; |
|
| 317 |
END IF; |
|
| 318 |
|
|
| 319 |
RETURN new; |
|
| 320 |
END; |
|
| 321 |
$$; |
|
| 322 |
|
|
| 323 |
|
|
| 324 |
-- |
|
| 325 | 300 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: - |
| 326 | 301 |
-- |
| 327 | 302 |
|
| ... | ... | |
| 2607 | 2582 |
ALTER SEQUENCE specimen_specimen_id_seq OWNED BY specimen.specimen_id; |
| 2608 | 2583 |
|
| 2609 | 2584 |
|
| 2610 |
-- |
|
| 2611 |
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2612 |
-- |
|
| 2613 |
|
|
| 2614 |
CREATE TABLE taxonoccurrence ( |
|
| 2615 |
taxonoccurrence_id integer NOT NULL, |
|
| 2616 |
datasource_id integer NOT NULL, |
|
| 2617 |
sourceaccessioncode text, |
|
| 2618 |
locationevent_id integer, |
|
| 2619 |
verbatimcollectorname text, |
|
| 2620 |
growthform growthform, |
|
| 2621 |
iscultivated boolean, |
|
| 2622 |
cultivatedbasis text, |
|
| 2623 |
isnative boolean, |
|
| 2624 |
accessioncode text |
|
| 2625 |
); |
|
| 2626 |
|
|
| 2627 |
|
|
| 2628 |
-- |
|
| 2629 |
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: - |
|
| 2630 |
-- |
|
| 2631 |
|
|
| 2632 |
COMMENT ON TABLE taxonoccurrence IS 'VegBank''s taxonobservation table.'; |
|
| 2633 |
|
|
| 2634 |
|
|
| 2635 |
-- |
|
| 2636 |
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: - |
|
| 2637 |
-- |
|
| 2638 |
|
|
| 2639 |
COMMENT ON COLUMN taxonoccurrence.iscultivated IS 'cultivated or wild'; |
|
| 2640 |
|
|
| 2641 |
|
|
| 2642 |
-- |
|
| 2643 |
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: - |
|
| 2644 |
-- |
|
| 2645 |
|
|
| 2646 |
COMMENT ON COLUMN taxonoccurrence.cultivatedbasis IS 'The reason why a taxonoccurrence was marked as cultivated (or not).'; |
|
| 2647 |
|
|
| 2648 |
|
|
| 2649 |
-- |
|
| 2650 |
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: - |
|
| 2651 |
-- |
|
| 2652 |
|
|
| 2653 |
COMMENT ON COLUMN taxonoccurrence.isnative IS 'native or exotic'; |
|
| 2654 |
|
|
| 2655 |
|
|
| 2656 |
-- |
|
| 2657 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2658 |
-- |
|
| 2659 |
|
|
| 2660 |
CREATE SEQUENCE taxonoccurrence_taxonoccurrence_id_seq |
|
| 2661 |
START WITH 1 |
|
| 2662 |
INCREMENT BY 1 |
|
| 2663 |
NO MINVALUE |
|
| 2664 |
NO MAXVALUE |
|
| 2665 |
CACHE 1; |
|
| 2666 |
|
|
| 2667 |
|
|
| 2668 |
-- |
|
| 2669 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2670 |
-- |
|
| 2671 |
|
|
| 2672 |
ALTER SEQUENCE taxonoccurrence_taxonoccurrence_id_seq OWNED BY taxonoccurrence.taxonoccurrence_id; |
|
| 2673 |
|
|
| 2674 |
|
|
| 2675 | 2585 |
SET default_with_oids = true; |
| 2676 | 2586 |
|
| 2677 | 2587 |
-- |
| ... | ... | |
| 2679 | 2589 |
-- |
| 2680 | 2590 |
|
| 2681 | 2591 |
CREATE TABLE specimenreplicate ( |
| 2592 |
specimenreplicate_id integer NOT NULL, |
|
| 2593 |
datasource_id integer NOT NULL, |
|
| 2594 |
sourceaccessioncode text, |
|
| 2682 | 2595 |
plantobservation_id integer, |
| 2683 | 2596 |
institution_id integer, |
| 2684 | 2597 |
collectioncode_dwc text, |
| ... | ... | |
| 2686 | 2599 |
collectionnumber text, |
| 2687 | 2600 |
description text, |
| 2688 | 2601 |
specimen_id integer, |
| 2602 |
accessioncode text, |
|
| 2689 | 2603 |
CONSTRAINT specimenreplicate_required_key CHECK ((((plantobservation_id IS NOT NULL) OR (sourceaccessioncode IS NOT NULL)) OR (catalognumber_dwc IS NOT NULL))) |
| 2690 |
) |
|
| 2691 |
INHERITS (taxonoccurrence); |
|
| 2604 |
); |
|
| 2692 | 2605 |
|
| 2693 | 2606 |
|
| 2694 | 2607 |
-- |
| ... | ... | |
| 2720 | 2633 |
|
| 2721 | 2634 |
|
| 2722 | 2635 |
-- |
| 2636 |
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2637 |
-- |
|
| 2638 |
|
|
| 2639 |
CREATE SEQUENCE specimenreplicate_specimenreplicate_id_seq |
|
| 2640 |
START WITH 1 |
|
| 2641 |
INCREMENT BY 1 |
|
| 2642 |
NO MINVALUE |
|
| 2643 |
NO MAXVALUE |
|
| 2644 |
CACHE 1; |
|
| 2645 |
|
|
| 2646 |
|
|
| 2647 |
-- |
|
| 2648 |
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2649 |
-- |
|
| 2650 |
|
|
| 2651 |
ALTER SEQUENCE specimenreplicate_specimenreplicate_id_seq OWNED BY specimenreplicate.specimenreplicate_id; |
|
| 2652 |
|
|
| 2653 |
|
|
| 2654 |
-- |
|
| 2723 | 2655 |
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2724 | 2656 |
-- |
| 2725 | 2657 |
|
| ... | ... | |
| 2923 | 2855 |
ALTER SEQUENCE taxondetermination_taxondetermination_id_seq OWNED BY taxondetermination.taxondetermination_id; |
| 2924 | 2856 |
|
| 2925 | 2857 |
|
| 2858 |
SET default_with_oids = false; |
|
| 2859 |
|
|
| 2926 | 2860 |
-- |
| 2861 |
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2862 |
-- |
|
| 2863 |
|
|
| 2864 |
CREATE TABLE taxonoccurrence ( |
|
| 2865 |
taxonoccurrence_id integer NOT NULL, |
|
| 2866 |
datasource_id integer NOT NULL, |
|
| 2867 |
sourceaccessioncode text, |
|
| 2868 |
locationevent_id integer, |
|
| 2869 |
verbatimcollectorname text, |
|
| 2870 |
growthform growthform, |
|
| 2871 |
iscultivated boolean, |
|
| 2872 |
cultivatedbasis text, |
|
| 2873 |
isnative boolean, |
|
| 2874 |
accessioncode text |
|
| 2875 |
); |
|
| 2876 |
|
|
| 2877 |
|
|
| 2878 |
-- |
|
| 2879 |
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: - |
|
| 2880 |
-- |
|
| 2881 |
|
|
| 2882 |
COMMENT ON TABLE taxonoccurrence IS 'VegBank''s taxonobservation table.'; |
|
| 2883 |
|
|
| 2884 |
|
|
| 2885 |
-- |
|
| 2886 |
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: - |
|
| 2887 |
-- |
|
| 2888 |
|
|
| 2889 |
COMMENT ON COLUMN taxonoccurrence.iscultivated IS 'cultivated or wild'; |
|
| 2890 |
|
|
| 2891 |
|
|
| 2892 |
-- |
|
| 2893 |
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: - |
|
| 2894 |
-- |
|
| 2895 |
|
|
| 2896 |
COMMENT ON COLUMN taxonoccurrence.cultivatedbasis IS 'The reason why a taxonoccurrence was marked as cultivated (or not).'; |
|
| 2897 |
|
|
| 2898 |
|
|
| 2899 |
-- |
|
| 2900 |
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: - |
|
| 2901 |
-- |
|
| 2902 |
|
|
| 2903 |
COMMENT ON COLUMN taxonoccurrence.isnative IS 'native or exotic'; |
|
| 2904 |
|
|
| 2905 |
|
|
| 2906 |
-- |
|
| 2907 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2908 |
-- |
|
| 2909 |
|
|
| 2910 |
CREATE SEQUENCE taxonoccurrence_taxonoccurrence_id_seq |
|
| 2911 |
START WITH 1 |
|
| 2912 |
INCREMENT BY 1 |
|
| 2913 |
NO MINVALUE |
|
| 2914 |
NO MAXVALUE |
|
| 2915 |
CACHE 1; |
|
| 2916 |
|
|
| 2917 |
|
|
| 2918 |
-- |
|
| 2919 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2920 |
-- |
|
| 2921 |
|
|
| 2922 |
ALTER SEQUENCE taxonoccurrence_taxonoccurrence_id_seq OWNED BY taxonoccurrence.taxonoccurrence_id; |
|
| 2923 |
|
|
| 2924 |
|
|
| 2925 |
SET default_with_oids = true; |
|
| 2926 |
|
|
| 2927 |
-- |
|
| 2927 | 2928 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2928 | 2929 |
-- |
| 2929 | 2930 |
|
| ... | ... | |
| 3400 | 3401 |
|
| 3401 | 3402 |
|
| 3402 | 3403 |
-- |
| 3404 |
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3405 |
-- |
|
| 3406 |
|
|
| 3407 |
ALTER TABLE specimenreplicate ALTER COLUMN specimenreplicate_id SET DEFAULT nextval('specimenreplicate_specimenreplicate_id_seq'::regclass);
|
|
| 3408 |
|
|
| 3409 |
|
|
| 3410 |
-- |
|
| 3403 | 3411 |
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: - |
| 3404 | 3412 |
-- |
| 3405 | 3413 |
|
| ... | ... | |
| 3978 | 3986 |
-- |
| 3979 | 3987 |
|
| 3980 | 3988 |
ALTER TABLE ONLY specimenreplicate |
| 3981 |
ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (taxonoccurrence_id);
|
|
| 3989 |
ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
|
|
| 3982 | 3990 |
|
| 3983 | 3991 |
|
| 3984 | 3992 |
-- |
| ... | ... | |
| 4451 | 4459 |
|
| 4452 | 4460 |
|
| 4453 | 4461 |
-- |
| 4454 |
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: TRIGGER; Schema: public; Owner: - |
|
| 4455 |
-- |
|
| 4456 |
|
|
| 4457 |
CREATE TRIGGER taxondetermination_taxonoccurrence_id_fkey AFTER INSERT OR UPDATE ON taxondetermination FOR EACH ROW EXECUTE PROCEDURE taxondetermination_taxonoccurrence_id_fkey(); |
|
| 4458 |
|
|
| 4459 |
|
|
| 4460 |
-- |
|
| 4461 | 4462 |
-- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4462 | 4463 |
-- |
| 4463 | 4464 |
|
| ... | ... | |
| 5274 | 5275 |
|
| 5275 | 5276 |
|
| 5276 | 5277 |
-- |
| 5277 |
-- Name: specimenreplicate_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5278 |
-- |
|
| 5279 |
|
|
| 5280 |
ALTER TABLE ONLY specimenreplicate |
|
| 5281 |
ADD CONSTRAINT specimenreplicate_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5282 |
|
|
| 5283 |
|
|
| 5284 |
-- |
|
| 5285 | 5278 |
-- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5286 | 5279 |
-- |
| 5287 | 5280 |
|
| ... | ... | |
| 5378 | 5371 |
|
| 5379 | 5372 |
|
| 5380 | 5373 |
-- |
| 5374 |
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5375 |
-- |
|
| 5376 |
|
|
| 5377 |
ALTER TABLE ONLY taxondetermination |
|
| 5378 |
ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5379 |
|
|
| 5380 |
|
|
| 5381 |
-- |
|
| 5381 | 5382 |
-- Name: taxonoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5382 | 5383 |
-- |
| 5383 | 5384 |
|
| ... | ... | |
| 5414 | 5415 |
-- |
| 5415 | 5416 |
|
| 5416 | 5417 |
ALTER TABLE ONLY voucher |
| 5417 |
ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5418 |
ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5418 | 5419 |
|
| 5419 | 5420 |
|
| 5420 | 5421 |
-- |
| mappings/for_review/DwC2-VegBIEN.specimens.csv | ||
|---|---|---|
| 23 | 23 |
recordNumber,//specimenreplicate/collectionnumber,,http://rs.tdwg.org/dwc/terms/#recordNumber,22 |
| 24 | 24 |
collectionID,//specimenreplicate/collectionnumber,,http://rs.tdwg.org/dwc/terms/#collectionID,9 |
| 25 | 25 |
fieldNumber,//specimenreplicate/collectionnumber,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53 |
| 26 |
establishmentMeans,//specimenreplicate/growthform,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 27 | 26 |
institutionCode,//party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 28 |
establishmentMeans,//specimenreplicate/iscultivated,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 29 |
establishmentMeans,//specimenreplicate/isnative,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 30 | 27 |
occurrenceID,//specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
| 31 |
recordedBy,//specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23 |
|
| 28 |
establishmentMeans,//taxonoccurrence/growthform,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 29 |
establishmentMeans,//taxonoccurrence/iscultivated,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 30 |
establishmentMeans,//taxonoccurrence/isnative,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 32 | 31 |
dateIdentified,//taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120 |
| 33 | 32 |
taxonRemarks,//taxonoccurrence/taxondetermination[role=identifier]/notes,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158 |
| 34 | 33 |
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119 |
| ... | ... | |
| 44 | 43 |
class,//plantconcept/plantname_id[rank=class]/plantname,,http://rs.tdwg.org/dwc/terms/#class,144 |
| 45 | 44 |
phylum,//plantconcept/plantname_id[rank=subkingdom]/plantname,,http://rs.tdwg.org/dwc/terms/#phylum,143 |
| 46 | 45 |
kingdom,//plantconcept/plantname_id[rank=kingdom]/plantname,,http://rs.tdwg.org/dwc/terms/#kingdom,142 |
| 46 |
recordedBy,//taxonoccurrence/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23 |
|
| 47 | 47 |
maximumDepthInMeters,//locationevent/waterdepth,,http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,75 |
| 48 | 48 |
minimumDepthInMeters,//locationevent/waterdepth,,http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,74 |
| 49 | 49 |
locality,//location/locationnarrative,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| mappings/DwC.cs-VegBIEN.specimens.csv | ||
|---|---|---|
| 40 | 40 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22 |
| 41 | 41 |
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9 |
| 42 | 42 |
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53 |
| 43 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
| 44 | 43 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
| 45 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 46 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 47 | 44 |
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19 |
| 48 | 45 |
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19 |
| 49 | 46 |
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
| 50 |
collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
|
| 51 |
recordedBy,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23 |
|
| 47 |
establishmentMeans,"/location/locationevent/taxonoccurrence/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
| 48 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 49 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
|
| 52 | 50 |
dateIdentified/_alt,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,http://rs.tdwg.org/dwc/terms/#dateIdentified,120 |
Also available in: Unified diff
schemas/vegbien.sql: Removed inheritance link between specimenreplicate and taxonoccurrence, which is not needed now that specimenreplicate is mapped via plantobservation. mappings/DwC2-VegBIEN.specimens.csv: As part of this change, moved mappings to specimenreplicate fields inherited from taxonoccurrence to go directly to taxonoccurrence.