Revision 1337
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/NYBG/test/import.specimens.out.ref | ||
|---|---|---|
| 1 |
Inserted 56 new rows into database |
|
| 1 |
Inserted 45 new rows into database |
|
| inputs/NYBG/test/VegBIEN.specimens.xml.ref | ||
|---|---|---|
| 40 | 40 |
</locationevent> |
| 41 | 41 |
</locationevent_id> |
| 42 | 42 |
<taxondetermination> |
| 43 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 43 |
<role>identifier</role>
|
|
| 44 | 44 |
<plantconcept_id> |
| 45 | 45 |
<plantconcept> |
| 46 | 46 |
<plantname_id> |
| ... | ... | |
| 56 | 56 |
<iscurrent>true</iscurrent> |
| 57 | 57 |
</taxondetermination> |
| 58 | 58 |
<taxondetermination> |
| 59 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 59 |
<role>identifier</role>
|
|
| 60 | 60 |
<plantconcept_id> |
| 61 | 61 |
<plantconcept> |
| 62 | 62 |
<plantname_id> |
| ... | ... | |
| 72 | 72 |
<iscurrent>true</iscurrent> |
| 73 | 73 |
</taxondetermination> |
| 74 | 74 |
<taxondetermination> |
| 75 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 75 |
<role>identifier</role>
|
|
| 76 | 76 |
<plantconcept_id> |
| 77 | 77 |
<plantconcept> |
| 78 | 78 |
<plantname_id> |
| ... | ... | |
| 88 | 88 |
<iscurrent>true</iscurrent> |
| 89 | 89 |
</taxondetermination> |
| 90 | 90 |
<taxondetermination> |
| 91 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 91 |
<role>identifier</role>
|
|
| 92 | 92 |
<plantconcept_id> |
| 93 | 93 |
<plantconcept> |
| 94 | 94 |
<plantname_id> |
| ... | ... | |
| 104 | 104 |
<iscurrent>true</iscurrent> |
| 105 | 105 |
</taxondetermination> |
| 106 | 106 |
<taxondetermination> |
| 107 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 107 |
<role>identifier</role>
|
|
| 108 | 108 |
<plantconcept_id> |
| 109 | 109 |
<plantconcept> |
| 110 | 110 |
<plantname_id> |
| ... | ... | |
| 120 | 120 |
<iscurrent>true</iscurrent> |
| 121 | 121 |
</taxondetermination> |
| 122 | 122 |
<taxondetermination> |
| 123 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 123 |
<role>identifier</role>
|
|
| 124 | 124 |
<plantconcept_id> |
| 125 | 125 |
<plantconcept> |
| 126 | 126 |
<plantname_id> |
| ... | ... | |
| 136 | 136 |
<iscurrent>true</iscurrent> |
| 137 | 137 |
</taxondetermination> |
| 138 | 138 |
<taxondetermination> |
| 139 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 139 |
<role>identifier</role>
|
|
| 140 | 140 |
<plantconcept_id> |
| 141 | 141 |
<plantconcept> |
| 142 | 142 |
<plantname_id> |
| ... | ... | |
| 195 | 195 |
</locationevent> |
| 196 | 196 |
</locationevent_id> |
| 197 | 197 |
<taxondetermination> |
| 198 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 198 |
<role>identifier</role>
|
|
| 199 | 199 |
<plantconcept_id> |
| 200 | 200 |
<plantconcept> |
| 201 | 201 |
<plantname_id> |
| ... | ... | |
| 211 | 211 |
<iscurrent>true</iscurrent> |
| 212 | 212 |
</taxondetermination> |
| 213 | 213 |
<taxondetermination> |
| 214 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 214 |
<role>identifier</role>
|
|
| 215 | 215 |
<plantconcept_id> |
| 216 | 216 |
<plantconcept> |
| 217 | 217 |
<plantname_id> |
| ... | ... | |
| 227 | 227 |
<iscurrent>true</iscurrent> |
| 228 | 228 |
</taxondetermination> |
| 229 | 229 |
<taxondetermination> |
| 230 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 230 |
<role>identifier</role>
|
|
| 231 | 231 |
<plantconcept_id> |
| 232 | 232 |
<plantconcept> |
| 233 | 233 |
<plantname_id> |
| ... | ... | |
| 243 | 243 |
<iscurrent>true</iscurrent> |
| 244 | 244 |
</taxondetermination> |
| 245 | 245 |
<taxondetermination> |
| 246 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 246 |
<role>identifier</role>
|
|
| 247 | 247 |
<plantconcept_id> |
| 248 | 248 |
<plantconcept> |
| 249 | 249 |
<plantname_id> |
| inputs/NYBG/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 46 | 46 |
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74 |
| 47 | 47 |
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74 |
| 48 | 48 |
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74 |
| 49 |
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 50 |
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 51 |
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 52 |
DateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date",,120
|
|
| 53 |
dateIdentified/_alt,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt",Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
|
|
| 54 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
|
|
| 55 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
|
|
| 56 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
|
|
| 57 |
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/2",,120
|
|
| 58 |
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 59 |
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 60 |
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 61 |
scientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 62 |
Class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 63 |
class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 64 |
Family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 65 |
family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 66 |
Genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 67 |
genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 68 |
Kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 69 |
kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 70 |
Order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 71 |
order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 72 |
Species,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 73 |
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 74 |
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 75 |
Phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 76 |
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 77 |
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 78 |
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 79 |
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 49 |
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 50 |
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 51 |
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 52 |
DateIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date",,120
|
|
| 53 |
dateIdentified/_alt,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt",Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
|
|
| 54 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
|
|
| 55 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
|
|
| 56 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
|
|
| 57 |
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/2",,120
|
|
| 58 |
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 59 |
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 60 |
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 61 |
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 62 |
Class,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 63 |
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 64 |
Family,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 65 |
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 66 |
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 67 |
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 68 |
Kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 69 |
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 70 |
Order,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 71 |
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 72 |
Species,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 73 |
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 74 |
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 75 |
Phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 76 |
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 77 |
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 78 |
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 79 |
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 80 | 80 |
CollectionCode,/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,12 |
| 81 | 81 |
collectionCode,/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,12 |
| 82 | 82 |
Sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26 |
| inputs/SALVIAS/test/VegBIEN.organisms.xml.ref | ||
|---|---|---|
| 43 | 43 |
<growthform>tree</growthform> |
| 44 | 44 |
</aggregateoccurrence> |
| 45 | 45 |
<taxondetermination> |
| 46 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 46 |
<role>computer</role>
|
|
| 47 | 47 |
<plantconcept_id> |
| 48 | 48 |
<plantconcept> |
| 49 | 49 |
<plantname_id> |
| ... | ... | |
| 58 | 58 |
<iscurrent>true</iscurrent> |
| 59 | 59 |
</taxondetermination> |
| 60 | 60 |
<taxondetermination> |
| 61 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 61 |
<role>computer</role>
|
|
| 62 | 62 |
<plantconcept_id> |
| 63 | 63 |
<plantconcept> |
| 64 | 64 |
<plantname_id> |
| ... | ... | |
| 73 | 73 |
<iscurrent>true</iscurrent> |
| 74 | 74 |
</taxondetermination> |
| 75 | 75 |
<taxondetermination> |
| 76 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 76 |
<role>computer</role>
|
|
| 77 | 77 |
<plantconcept_id> |
| 78 | 78 |
<plantconcept> |
| 79 | 79 |
<plantname_id> |
| ... | ... | |
| 88 | 88 |
<iscurrent>true</iscurrent> |
| 89 | 89 |
</taxondetermination> |
| 90 | 90 |
<taxondetermination> |
| 91 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 91 |
<role>computer</role>
|
|
| 92 | 92 |
<plantconcept_id> |
| 93 | 93 |
<plantconcept> |
| 94 | 94 |
<plantname_id> |
| ... | ... | |
| 103 | 103 |
<iscurrent>true</iscurrent> |
| 104 | 104 |
</taxondetermination> |
| 105 | 105 |
<taxondetermination> |
| 106 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 106 |
<role>identifier</role>
|
|
| 107 | 107 |
<plantconcept_id> |
| 108 | 108 |
<plantconcept> |
| 109 | 109 |
<plantname_id> |
| ... | ... | |
| 119 | 119 |
<iscurrent>true</iscurrent> |
| 120 | 120 |
</taxondetermination> |
| 121 | 121 |
<taxondetermination> |
| 122 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 122 |
<role>identifier</role>
|
|
| 123 | 123 |
<plantconcept_id> |
| 124 | 124 |
<plantconcept> |
| 125 | 125 |
<plantname_id> |
| ... | ... | |
| 178 | 178 |
<growthform>tree</growthform> |
| 179 | 179 |
</aggregateoccurrence> |
| 180 | 180 |
<taxondetermination> |
| 181 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 181 |
<role>computer</role>
|
|
| 182 | 182 |
<plantconcept_id> |
| 183 | 183 |
<plantconcept> |
| 184 | 184 |
<plantname_id> |
| ... | ... | |
| 193 | 193 |
<iscurrent>true</iscurrent> |
| 194 | 194 |
</taxondetermination> |
| 195 | 195 |
<taxondetermination> |
| 196 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 196 |
<role>computer</role>
|
|
| 197 | 197 |
<plantconcept_id> |
| 198 | 198 |
<plantconcept> |
| 199 | 199 |
<plantname_id> |
| ... | ... | |
| 208 | 208 |
<iscurrent>true</iscurrent> |
| 209 | 209 |
</taxondetermination> |
| 210 | 210 |
<taxondetermination> |
| 211 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 211 |
<role>computer</role>
|
|
| 212 | 212 |
<plantconcept_id> |
| 213 | 213 |
<plantconcept> |
| 214 | 214 |
<plantname_id> |
| ... | ... | |
| 223 | 223 |
<iscurrent>true</iscurrent> |
| 224 | 224 |
</taxondetermination> |
| 225 | 225 |
<taxondetermination> |
| 226 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 226 |
<role>computer</role>
|
|
| 227 | 227 |
<plantconcept_id> |
| 228 | 228 |
<plantconcept> |
| 229 | 229 |
<plantname_id> |
| ... | ... | |
| 238 | 238 |
<iscurrent>true</iscurrent> |
| 239 | 239 |
</taxondetermination> |
| 240 | 240 |
<taxondetermination> |
| 241 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 241 |
<role>identifier</role>
|
|
| 242 | 242 |
<plantconcept_id> |
| 243 | 243 |
<plantconcept> |
| 244 | 244 |
<plantname_id> |
| ... | ... | |
| 254 | 254 |
<iscurrent>true</iscurrent> |
| 255 | 255 |
</taxondetermination> |
| 256 | 256 |
<taxondetermination> |
| 257 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 257 |
<role>identifier</role>
|
|
| 258 | 258 |
<plantconcept_id> |
| 259 | 259 |
<plantconcept> |
| 260 | 260 |
<plantname_id> |
| inputs/SALVIAS/test/import.organisms.out.ref | ||
|---|---|---|
| 1 |
Inserted 62 new rows into database |
|
| 1 |
Inserted 50 new rows into database |
|
| inputs/SALVIAS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 26 | 26 |
coll_firstname,/aggregateoccurrence/verbatimcollectorname/_name/first,Brad: See comment above |
| 27 | 27 |
coll_lastname,/aggregateoccurrence/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick." |
| 28 | 28 |
census_date,/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate/_*/date, |
| 29 |
auth,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
|
|
| 30 |
Family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 31 |
Genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 32 |
Species,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 33 |
infra_rank_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
|
|
| 34 |
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",
|
|
| 35 |
cfaff,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
|
|
| 36 |
OrigGenus,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/first",
|
|
| 37 |
OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
|
|
| 38 |
OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
|
|
| 29 |
auth,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
|
|
| 30 |
Family,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 31 |
Genus,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 32 |
Species,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 33 |
infra_rank_1,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
|
|
| 34 |
infra_ep_1,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",
|
|
| 35 |
cfaff,"/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
|
|
| 36 |
OrigGenus,"/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/first",
|
|
| 37 |
OrigSpecies,"/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
|
|
| 38 |
OrigFamily,"/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
|
|
| 39 | 39 |
GenAuth,, |
| 40 | 40 |
IsMorpho,, |
| 41 | 41 |
OrigAuth,, |
| inputs/NYBG-CSV/test/import.specimens.out.ref | ||
|---|---|---|
| 1 |
Inserted 56 new rows into database |
|
| 1 |
Inserted 45 new rows into database |
|
| inputs/NYBG-CSV/test/VegBIEN.specimens.xml.ref | ||
|---|---|---|
| 40 | 40 |
</locationevent> |
| 41 | 41 |
</locationevent_id> |
| 42 | 42 |
<taxondetermination> |
| 43 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 43 |
<role>identifier</role>
|
|
| 44 | 44 |
<plantconcept_id> |
| 45 | 45 |
<plantconcept> |
| 46 | 46 |
<plantname_id> |
| ... | ... | |
| 56 | 56 |
<iscurrent>true</iscurrent> |
| 57 | 57 |
</taxondetermination> |
| 58 | 58 |
<taxondetermination> |
| 59 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 59 |
<role>identifier</role>
|
|
| 60 | 60 |
<plantconcept_id> |
| 61 | 61 |
<plantconcept> |
| 62 | 62 |
<plantname_id> |
| ... | ... | |
| 72 | 72 |
<iscurrent>true</iscurrent> |
| 73 | 73 |
</taxondetermination> |
| 74 | 74 |
<taxondetermination> |
| 75 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 75 |
<role>identifier</role>
|
|
| 76 | 76 |
<plantconcept_id> |
| 77 | 77 |
<plantconcept> |
| 78 | 78 |
<plantname_id> |
| ... | ... | |
| 88 | 88 |
<iscurrent>true</iscurrent> |
| 89 | 89 |
</taxondetermination> |
| 90 | 90 |
<taxondetermination> |
| 91 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 91 |
<role>identifier</role>
|
|
| 92 | 92 |
<plantconcept_id> |
| 93 | 93 |
<plantconcept> |
| 94 | 94 |
<plantname_id> |
| ... | ... | |
| 104 | 104 |
<iscurrent>true</iscurrent> |
| 105 | 105 |
</taxondetermination> |
| 106 | 106 |
<taxondetermination> |
| 107 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 107 |
<role>identifier</role>
|
|
| 108 | 108 |
<plantconcept_id> |
| 109 | 109 |
<plantconcept> |
| 110 | 110 |
<plantname_id> |
| ... | ... | |
| 120 | 120 |
<iscurrent>true</iscurrent> |
| 121 | 121 |
</taxondetermination> |
| 122 | 122 |
<taxondetermination> |
| 123 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 123 |
<role>identifier</role>
|
|
| 124 | 124 |
<plantconcept_id> |
| 125 | 125 |
<plantconcept> |
| 126 | 126 |
<plantname_id> |
| ... | ... | |
| 136 | 136 |
<iscurrent>true</iscurrent> |
| 137 | 137 |
</taxondetermination> |
| 138 | 138 |
<taxondetermination> |
| 139 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 139 |
<role>identifier</role>
|
|
| 140 | 140 |
<plantconcept_id> |
| 141 | 141 |
<plantconcept> |
| 142 | 142 |
<plantname_id> |
| ... | ... | |
| 195 | 195 |
</locationevent> |
| 196 | 196 |
</locationevent_id> |
| 197 | 197 |
<taxondetermination> |
| 198 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 198 |
<role>identifier</role>
|
|
| 199 | 199 |
<plantconcept_id> |
| 200 | 200 |
<plantconcept> |
| 201 | 201 |
<plantname_id> |
| ... | ... | |
| 211 | 211 |
<iscurrent>true</iscurrent> |
| 212 | 212 |
</taxondetermination> |
| 213 | 213 |
<taxondetermination> |
| 214 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 214 |
<role>identifier</role>
|
|
| 215 | 215 |
<plantconcept_id> |
| 216 | 216 |
<plantconcept> |
| 217 | 217 |
<plantname_id> |
| ... | ... | |
| 227 | 227 |
<iscurrent>true</iscurrent> |
| 228 | 228 |
</taxondetermination> |
| 229 | 229 |
<taxondetermination> |
| 230 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 230 |
<role>identifier</role>
|
|
| 231 | 231 |
<plantconcept_id> |
| 232 | 232 |
<plantconcept> |
| 233 | 233 |
<plantname_id> |
| ... | ... | |
| 243 | 243 |
<iscurrent>true</iscurrent> |
| 244 | 244 |
</taxondetermination> |
| 245 | 245 |
<taxondetermination> |
| 246 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 246 |
<role>identifier</role>
|
|
| 247 | 247 |
<plantconcept_id> |
| 248 | 248 |
<plantconcept> |
| 249 | 249 |
<plantname_id> |
| inputs/NYBG-CSV/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 46 | 46 |
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74 |
| 47 | 47 |
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74 |
| 48 | 48 |
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74 |
| 49 |
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 50 |
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 51 |
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 52 |
DateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date",,120
|
|
| 53 |
dateIdentified/_alt,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt",Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
|
|
| 54 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
|
|
| 55 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
|
|
| 56 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
|
|
| 57 |
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/2",,120
|
|
| 58 |
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 59 |
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 60 |
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 61 |
scientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 62 |
Class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 63 |
class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 64 |
Family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 65 |
family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 66 |
Genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 67 |
genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 68 |
Kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 69 |
kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 70 |
Order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 71 |
order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 72 |
Species,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 73 |
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 74 |
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 75 |
Phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 76 |
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 77 |
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 78 |
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 79 |
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 49 |
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 50 |
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 51 |
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 52 |
DateIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date",,120
|
|
| 53 |
dateIdentified/_alt,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt",Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
|
|
| 54 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
|
|
| 55 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
|
|
| 56 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
|
|
| 57 |
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/2",,120
|
|
| 58 |
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 59 |
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 60 |
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 61 |
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 62 |
Class,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 63 |
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 64 |
Family,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 65 |
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 66 |
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 67 |
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 68 |
Kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 69 |
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 70 |
Order,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 71 |
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 72 |
Species,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 73 |
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 74 |
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 75 |
Phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 76 |
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 77 |
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 78 |
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 79 |
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 80 | 80 |
CollectionCode,/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,12 |
| 81 | 81 |
collectionCode,/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,12 |
| 82 | 82 |
Sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26 |
| inputs/UArizona/test/import.specimens.out.ref | ||
|---|---|---|
| 1 |
Inserted 68 new rows into database |
|
| 1 |
Inserted 54 new rows into database |
|
| inputs/UArizona/test/VegBIEN.specimens.xml.ref | ||
|---|---|---|
| 32 | 32 |
</locationevent> |
| 33 | 33 |
</locationevent_id> |
| 34 | 34 |
<taxondetermination> |
| 35 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 35 |
<role>identifier</role>
|
|
| 36 | 36 |
<plantconcept_id> |
| 37 | 37 |
<plantconcept> |
| 38 | 38 |
<plantname_id> |
| ... | ... | |
| 48 | 48 |
<iscurrent>true</iscurrent> |
| 49 | 49 |
</taxondetermination> |
| 50 | 50 |
<taxondetermination> |
| 51 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 51 |
<role>identifier</role>
|
|
| 52 | 52 |
<plantconcept_id> |
| 53 | 53 |
<plantconcept> |
| 54 | 54 |
<plantname_id> |
| ... | ... | |
| 65 | 65 |
<iscurrent>true</iscurrent> |
| 66 | 66 |
</taxondetermination> |
| 67 | 67 |
<taxondetermination> |
| 68 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 68 |
<role>identifier</role>
|
|
| 69 | 69 |
<plantconcept_id> |
| 70 | 70 |
<plantconcept> |
| 71 | 71 |
<plantname_id> |
| ... | ... | |
| 81 | 81 |
<iscurrent>true</iscurrent> |
| 82 | 82 |
</taxondetermination> |
| 83 | 83 |
<taxondetermination> |
| 84 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 84 |
<role>identifier</role>
|
|
| 85 | 85 |
<plantconcept_id> |
| 86 | 86 |
<plantconcept> |
| 87 | 87 |
<plantname_id> |
| ... | ... | |
| 97 | 97 |
<iscurrent>true</iscurrent> |
| 98 | 98 |
</taxondetermination> |
| 99 | 99 |
<taxondetermination> |
| 100 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 100 |
<role>identifier</role>
|
|
| 101 | 101 |
<plantconcept_id> |
| 102 | 102 |
<plantconcept> |
| 103 | 103 |
<plantname_id> |
| ... | ... | |
| 113 | 113 |
<iscurrent>true</iscurrent> |
| 114 | 114 |
</taxondetermination> |
| 115 | 115 |
<taxondetermination> |
| 116 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 116 |
<role>identifier</role>
|
|
| 117 | 117 |
<plantconcept_id> |
| 118 | 118 |
<plantconcept> |
| 119 | 119 |
<plantname_id> |
| ... | ... | |
| 129 | 129 |
<iscurrent>true</iscurrent> |
| 130 | 130 |
</taxondetermination> |
| 131 | 131 |
<taxondetermination> |
| 132 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 132 |
<role>identifier</role>
|
|
| 133 | 133 |
<plantconcept_id> |
| 134 | 134 |
<plantconcept> |
| 135 | 135 |
<plantname_id> |
| ... | ... | |
| 180 | 180 |
</locationevent> |
| 181 | 181 |
</locationevent_id> |
| 182 | 182 |
<taxondetermination> |
| 183 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 183 |
<role>identifier</role>
|
|
| 184 | 184 |
<plantconcept_id> |
| 185 | 185 |
<plantconcept> |
| 186 | 186 |
<plantname_id> |
| ... | ... | |
| 196 | 196 |
<iscurrent>true</iscurrent> |
| 197 | 197 |
</taxondetermination> |
| 198 | 198 |
<taxondetermination> |
| 199 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 199 |
<role>identifier</role>
|
|
| 200 | 200 |
<plantconcept_id> |
| 201 | 201 |
<plantconcept> |
| 202 | 202 |
<plantname_id> |
| ... | ... | |
| 213 | 213 |
<iscurrent>true</iscurrent> |
| 214 | 214 |
</taxondetermination> |
| 215 | 215 |
<taxondetermination> |
| 216 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 216 |
<role>identifier</role>
|
|
| 217 | 217 |
<plantconcept_id> |
| 218 | 218 |
<plantconcept> |
| 219 | 219 |
<plantname_id> |
| ... | ... | |
| 229 | 229 |
<iscurrent>true</iscurrent> |
| 230 | 230 |
</taxondetermination> |
| 231 | 231 |
<taxondetermination> |
| 232 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 232 |
<role>identifier</role>
|
|
| 233 | 233 |
<plantconcept_id> |
| 234 | 234 |
<plantconcept> |
| 235 | 235 |
<plantname_id> |
| ... | ... | |
| 245 | 245 |
<iscurrent>true</iscurrent> |
| 246 | 246 |
</taxondetermination> |
| 247 | 247 |
<taxondetermination> |
| 248 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 248 |
<role>identifier</role>
|
|
| 249 | 249 |
<plantconcept_id> |
| 250 | 250 |
<plantconcept> |
| 251 | 251 |
<plantname_id> |
| ... | ... | |
| 261 | 261 |
<iscurrent>true</iscurrent> |
| 262 | 262 |
</taxondetermination> |
| 263 | 263 |
<taxondetermination> |
| 264 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 264 |
<role>identifier</role>
|
|
| 265 | 265 |
<plantconcept_id> |
| 266 | 266 |
<plantconcept> |
| 267 | 267 |
<plantname_id> |
| ... | ... | |
| 277 | 277 |
<iscurrent>true</iscurrent> |
| 278 | 278 |
</taxondetermination> |
| 279 | 279 |
<taxondetermination> |
| 280 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 280 |
<role>identifier</role>
|
|
| 281 | 281 |
<plantconcept_id> |
| 282 | 282 |
<plantconcept> |
| 283 | 283 |
<plantname_id> |
| inputs/UArizona/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 46 | 46 |
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74 |
| 47 | 47 |
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74 |
| 48 | 48 |
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74 |
| 49 |
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 50 |
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 51 |
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 52 |
DateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date",,120
|
|
| 53 |
dateIdentified/_alt,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt",Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
|
|
| 54 |
IdentifiedDate,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/0",Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
|
|
| 55 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
|
|
| 56 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
|
|
| 57 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
|
|
| 58 |
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/2",,120
|
|
| 59 |
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 60 |
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 61 |
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 62 |
scientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 63 |
Class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 64 |
class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 65 |
Family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 66 |
family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 67 |
Genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 68 |
genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 69 |
Kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 70 |
kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 71 |
Order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 72 |
order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 73 |
Species,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 74 |
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 75 |
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 76 |
Phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 77 |
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 78 |
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 79 |
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 80 |
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 49 |
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 50 |
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 51 |
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
|
|
| 52 |
DateIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date",,120
|
|
| 53 |
dateIdentified/_alt,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt",Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
|
|
| 54 |
IdentifiedDate,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/0",Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
|
|
| 55 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
|
|
| 56 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
|
|
| 57 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
|
|
| 58 |
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/determinationdate/_*/date/_alt/2",,120
|
|
| 59 |
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 60 |
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
|
| 61 |
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 62 |
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
|
|
| 63 |
Class,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 64 |
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
|
|
| 65 |
Family,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 66 |
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
|
|
| 67 |
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 68 |
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
|
|
| 69 |
Kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 70 |
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
|
|
| 71 |
Order,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 72 |
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
|
|
| 73 |
Species,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 74 |
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 75 |
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
|
|
| 76 |
Phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 77 |
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
|
|
| 78 |
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 79 |
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 80 |
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
|
|
| 81 | 81 |
GenGankNum,"/_label[label=""GenBank""]/value",This is a typo of GenBankNum from the original CSV,39 |
| 82 | 82 |
CollectionCode,/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,12 |
| 83 | 83 |
collectionCode,/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,12 |
| inputs/SALVIAS-CSV/test/VegBIEN.organisms.xml.ref | ||
|---|---|---|
| 56 | 56 |
<verbatimcollectorname>Vasquez</verbatimcollectorname> |
| 57 | 57 |
</aggregateoccurrence> |
| 58 | 58 |
<taxondetermination> |
| 59 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 59 |
<role>computer</role>
|
|
| 60 | 60 |
<plantconcept_id> |
| 61 | 61 |
<plantconcept> |
| 62 | 62 |
<plantname_id> |
| ... | ... | |
| 71 | 71 |
<iscurrent>true</iscurrent> |
| 72 | 72 |
</taxondetermination> |
| 73 | 73 |
<taxondetermination> |
| 74 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 74 |
<role>computer</role>
|
|
| 75 | 75 |
<plantconcept_id> |
| 76 | 76 |
<plantconcept> |
| 77 | 77 |
<plantname_id> |
| ... | ... | |
| 86 | 86 |
<iscurrent>true</iscurrent> |
| 87 | 87 |
</taxondetermination> |
| 88 | 88 |
<taxondetermination> |
| 89 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 89 |
<role>computer</role>
|
|
| 90 | 90 |
<plantconcept_id> |
| 91 | 91 |
<plantconcept> |
| 92 | 92 |
<plantname_id> |
| ... | ... | |
| 101 | 101 |
<iscurrent>true</iscurrent> |
| 102 | 102 |
</taxondetermination> |
| 103 | 103 |
<taxondetermination> |
| 104 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 104 |
<role>identifier</role>
|
|
| 105 | 105 |
<plantconcept_id> |
| 106 | 106 |
<plantconcept> |
| 107 | 107 |
<plantname_id> |
| ... | ... | |
| 117 | 117 |
<iscurrent>true</iscurrent> |
| 118 | 118 |
</taxondetermination> |
| 119 | 119 |
<taxondetermination> |
| 120 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 120 |
<role>identifier</role>
|
|
| 121 | 121 |
<plantconcept_id> |
| 122 | 122 |
<plantconcept> |
| 123 | 123 |
<plantname_id> |
| ... | ... | |
| 189 | 189 |
<verbatimcollectorname>Vasquez</verbatimcollectorname> |
| 190 | 190 |
</aggregateoccurrence> |
| 191 | 191 |
<taxondetermination> |
| 192 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 192 |
<role>computer</role>
|
|
| 193 | 193 |
<plantconcept_id> |
| 194 | 194 |
<plantconcept> |
| 195 | 195 |
<plantname_id> |
| ... | ... | |
| 204 | 204 |
<iscurrent>true</iscurrent> |
| 205 | 205 |
</taxondetermination> |
| 206 | 206 |
<taxondetermination> |
| 207 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 207 |
<role>computer</role>
|
|
| 208 | 208 |
<plantconcept_id> |
| 209 | 209 |
<plantconcept> |
| 210 | 210 |
<plantname_id> |
| ... | ... | |
| 219 | 219 |
<iscurrent>true</iscurrent> |
| 220 | 220 |
</taxondetermination> |
| 221 | 221 |
<taxondetermination> |
| 222 |
<role_id><role><rolecode>computer</rolecode></role></role_id>
|
|
| 222 |
<role>computer</role>
|
|
| 223 | 223 |
<plantconcept_id> |
| 224 | 224 |
<plantconcept> |
| 225 | 225 |
<plantname_id> |
| ... | ... | |
| 234 | 234 |
<iscurrent>true</iscurrent> |
| 235 | 235 |
</taxondetermination> |
| 236 | 236 |
<taxondetermination> |
| 237 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 237 |
<role>identifier</role>
|
|
| 238 | 238 |
<plantconcept_id> |
| 239 | 239 |
<plantconcept> |
| 240 | 240 |
<plantname_id> |
| ... | ... | |
| 250 | 250 |
<iscurrent>true</iscurrent> |
| 251 | 251 |
</taxondetermination> |
| 252 | 252 |
<taxondetermination> |
| 253 |
<role_id><role><rolecode>identifier</rolecode></role></role_id>
|
|
| 253 |
<role>identifier</role>
|
|
| 254 | 254 |
<plantconcept_id> |
| 255 | 255 |
<plantconcept> |
| 256 | 256 |
<plantname_id> |
| inputs/SALVIAS-CSV/test/import.organisms.out.ref | ||
|---|---|---|
| 1 |
Inserted 61 new rows into database |
|
| 1 |
Inserted 51 new rows into database |
|
| inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 31 | 31 |
intercept_cm,/aggregateoccurrence/linecover,"Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance." |
| 32 | 32 |
coll_firstname,/aggregateoccurrence/verbatimcollectorname/_name/first,Brad: See comment above |
| 33 | 33 |
coll_lastname,/aggregateoccurrence/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick." |
| 34 |
specific_authority,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
|
|
| 35 |
family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 36 |
genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 37 |
specific_epithet,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 38 |
infra_rank_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
|
|
| 39 |
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",
|
|
| 40 |
cf_aff,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
|
|
| 41 |
orig_species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
|
|
| 42 |
orig_family,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
|
|
| 34 |
specific_authority,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
|
|
| 35 |
family,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 36 |
genus,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 37 |
specific_epithet,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
|
|
| 38 |
infra_rank_1,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
|
|
| 39 |
infra_ep_1,"/taxondetermination[role=computer,*_id/plantconcept/*_id/plantname/rank=subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",
|
|
| 40 |
cf_aff,"/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
|
|
| 41 |
orig_species,"/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
|
|
| 42 |
orig_family,"/taxondetermination[role=identifier,*_id/plantconcept/*_id/plantname/rank=family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
|
|
| 43 | 43 |
collector_code,,Brad: OMIT |
| 44 | 44 |
comments,,Brad: OMIT |
| 45 | 45 |
fam_status,,Brad: OMIT. This will be determined later by using TNRS. |
| schemas/vegbien.my.sql | ||
|---|---|---|
| 39 | 39 |
|
| 40 | 40 |
|
| 41 | 41 |
-- |
| 42 |
-- Name: role; Type: TYPE; Schema: public; Owner: - |
|
| 43 |
-- |
|
| 44 |
|
|
| 45 |
|
|
| 46 |
|
|
| 47 |
|
|
| 48 |
-- |
|
| 42 | 49 |
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: - |
| 43 | 50 |
-- |
| 44 | 51 |
|
| ... | ... | |
| 172 | 179 |
classcontributor_id int(11) NOT NULL, |
| 173 | 180 |
commclass_id int(11) NOT NULL, |
| 174 | 181 |
party_id int(11) NOT NULL, |
| 175 |
role_id int(11)
|
|
| 182 |
role text
|
|
| 176 | 183 |
); |
| 177 | 184 |
|
| 178 | 185 |
|
| ... | ... | |
| 828 | 835 |
locationeventcontributor_id int(11) NOT NULL, |
| 829 | 836 |
locationevent_id int(11) NOT NULL, |
| 830 | 837 |
party_id int(11) NOT NULL, |
| 831 |
role_id int(11) NOT NULL,
|
|
| 838 |
role text NOT NULL,
|
|
| 832 | 839 |
contributiondate timestamp NULL |
| 833 | 840 |
); |
| 834 | 841 |
|
| ... | ... | |
| 856 | 863 |
synonymlocationevent_id int(11) NOT NULL, |
| 857 | 864 |
primarylocationevent_id int(11) NOT NULL, |
| 858 | 865 |
party_id int(11) NOT NULL, |
| 859 |
role_id int(11) NOT NULL,
|
|
| 866 |
role text NOT NULL,
|
|
| 860 | 867 |
synonymcomment text, |
| 861 | 868 |
classstartdate timestamp NULL NOT NULL, |
| 862 | 869 |
classstopdate timestamp NULL, |
| ... | ... | |
| 1195 | 1202 |
note_id int(11) NOT NULL, |
| 1196 | 1203 |
notelink_id int(11) NOT NULL, |
| 1197 | 1204 |
party_id int(11) NOT NULL, |
| 1198 |
role_id int(11) NOT NULL,
|
|
| 1205 |
role text NOT NULL,
|
|
| 1199 | 1206 |
notetype text NOT NULL, |
| 1200 | 1207 |
notetext text NOT NULL, |
| 1201 | 1208 |
notedate timestamp NULL, |
| ... | ... | |
| 1286 | 1293 |
partymember_id int(11) NOT NULL, |
| 1287 | 1294 |
parentparty_id int(11) NOT NULL, |
| 1288 | 1295 |
childparty_id int(11) NOT NULL, |
| 1289 |
role_id int(11),
|
|
| 1296 |
role text,
|
|
| 1290 | 1297 |
memberstart timestamp NULL NOT NULL, |
| 1291 | 1298 |
memberstop timestamp NULL |
| 1292 | 1299 |
); |
| ... | ... | |
| 1618 | 1625 |
projectcontributor_id int(11) NOT NULL, |
| 1619 | 1626 |
project_id int(11) NOT NULL, |
| 1620 | 1627 |
party_id int(11) NOT NULL, |
| 1621 |
role_id int(11),
|
|
| 1628 |
role text,
|
|
| 1622 | 1629 |
surname text, |
| 1623 | 1630 |
cheatrole text |
| 1624 | 1631 |
); |
| ... | ... | |
| 1830 | 1837 |
|
| 1831 | 1838 |
|
| 1832 | 1839 |
-- |
| 1833 |
-- Name: role; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1834 |
-- |
|
| 1835 |
|
|
| 1836 |
CREATE TABLE role ( |
|
| 1837 |
role_id int(11) NOT NULL, |
|
| 1838 |
rolecode text NOT NULL, |
|
| 1839 |
roledescription text, |
|
| 1840 |
roleproject int(11), |
|
| 1841 |
roleobservation int(11), |
|
| 1842 |
roletaxonint int(11), |
|
| 1843 |
roleclassint int(11), |
|
| 1844 |
accessioncode text |
|
| 1845 |
); |
|
| 1846 |
|
|
| 1847 |
|
|
| 1848 |
-- |
|
| 1849 |
-- Name: role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1850 |
-- |
|
| 1851 |
|
|
| 1852 |
|
|
| 1853 |
|
|
| 1854 |
|
|
| 1855 |
-- |
|
| 1856 |
-- Name: role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1857 |
-- |
|
| 1858 |
|
|
| 1859 |
|
|
| 1860 |
|
|
| 1861 |
|
|
| 1862 |
-- |
|
| 1863 | 1840 |
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1864 | 1841 |
-- |
| 1865 | 1842 |
|
| ... | ... | |
| 2263 | 2240 |
taxonoccurrence_id int(11) NOT NULL, |
| 2264 | 2241 |
plantconcept_id int(11) NOT NULL, |
| 2265 | 2242 |
party_id int(11), |
| 2266 |
role_id int(11) NOT NULL,
|
|
| 2243 |
role text NOT NULL,
|
|
| 2267 | 2244 |
determinationtype text, |
| 2268 | 2245 |
reference_id int(11), |
| 2269 | 2246 |
isoriginal int(1) DEFAULT false NOT NULL, |
| ... | ... | |
| 2769 | 2746 |
|
| 2770 | 2747 |
|
| 2771 | 2748 |
-- |
| 2772 |
-- Name: role_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2773 |
-- |
|
| 2774 |
|
|
| 2775 |
|
|
| 2776 |
|
|
| 2777 |
|
|
| 2778 |
-- |
|
| 2779 | 2749 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: - |
| 2780 | 2750 |
-- |
| 2781 | 2751 |
|
| ... | ... | |
| 3394 | 3364 |
|
| 3395 | 3365 |
|
| 3396 | 3366 |
-- |
| 3397 |
-- Name: role_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3398 |
-- |
|
| 3399 |
|
|
| 3400 |
ALTER TABLE role |
|
| 3401 |
ADD CONSTRAINT role_pkey PRIMARY KEY (role_id); |
|
| 3402 |
|
|
| 3403 |
|
|
| 3404 |
-- |
|
| 3405 | 3367 |
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3406 | 3368 |
-- |
| 3407 | 3369 |
|
| ... | ... | |
| 3616 | 3578 |
-- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3617 | 3579 |
-- |
| 3618 | 3580 |
|
| 3619 |
CREATE INDEX classcontributor_role_id_x ON classcontributor (role_id);
|
|
| 3581 |
CREATE INDEX classcontributor_role_id_x ON classcontributor (role); |
|
| 3620 | 3582 |
|
| 3621 | 3583 |
|
| 3622 | 3584 |
-- |
| ... | ... | |
| 4134 | 4096 |
-- Name: locationeventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4135 | 4097 |
-- |
| 4136 | 4098 |
|
| 4137 |
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor (role_id);
|
|
| 4099 |
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor (role); |
|
| 4138 | 4100 |
|
| 4139 | 4101 |
|
| 4140 | 4102 |
-- |
| ... | ... | |
| 4162 | 4124 |
-- Name: locationeventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4163 | 4125 |
-- |
| 4164 | 4126 |
|
| 4165 |
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym (role_id);
|
|
| 4127 |
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym (role); |
|
| 4166 | 4128 |
|
| 4167 | 4129 |
|
| 4168 | 4130 |
-- |
| ... | ... | |
| 4218 | 4180 |
-- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4219 | 4181 |
-- |
| 4220 | 4182 |
|
| 4221 |
CREATE INDEX note_role_id_x ON note (role_id);
|
|
| 4183 |
CREATE INDEX note_role_id_x ON note (role); |
|
| 4222 | 4184 |
|
| 4223 | 4185 |
|
| 4224 | 4186 |
-- |
| ... | ... | |
| 4295 | 4257 |
-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4296 | 4258 |
-- |
| 4297 | 4259 |
|
| 4298 |
CREATE INDEX partymember_role_id_x ON partymember (role_id);
|
|
| 4260 |
CREATE INDEX partymember_role_id_x ON partymember (role); |
|
| 4299 | 4261 |
|
| 4300 | 4262 |
|
| 4301 | 4263 |
-- |
| ... | ... | |
| 4463 | 4425 |
-- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4464 | 4426 |
-- |
| 4465 | 4427 |
|
| 4466 |
CREATE INDEX projectcontributor_role_id_x ON projectcontributor (role_id);
|
|
| 4428 |
CREATE INDEX projectcontributor_role_id_x ON projectcontributor (role); |
|
| 4467 | 4429 |
|
| 4468 | 4430 |
|
| 4469 | 4431 |
-- |
| ... | ... | |
| 4530 | 4492 |
|
| 4531 | 4493 |
|
| 4532 | 4494 |
-- |
| 4533 |
-- Name: role_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4534 |
-- |
|
| 4535 |
|
|
| 4536 |
CREATE UNIQUE INDEX role_accessioncode_index ON role (accessioncode); |
|
| 4537 |
|
|
| 4538 |
|
|
| 4539 |
-- |
|
| 4540 | 4495 |
-- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4541 | 4496 |
-- |
| 4542 | 4497 |
|
| ... | ... | |
| 4624 | 4579 |
-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4625 | 4580 |
-- |
| 4626 | 4581 |
|
| 4627 |
CREATE INDEX taxondetermination_role_id_x ON taxondetermination (role_id);
|
|
| 4582 |
CREATE INDEX taxondetermination_role_id_x ON taxondetermination (role); |
|
| 4628 | 4583 |
|
| 4629 | 4584 |
|
| 4630 | 4585 |
-- |
| ... | ... | |
| 4748 | 4703 |
|
| 4749 | 4704 |
|
| 4750 | 4705 |
-- |
| 4751 |
-- Name: classcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4752 |
-- |
|
| 4753 |
|
|
| 4754 |
|
|
| 4755 |
|
|
| 4756 |
|
|
| 4757 |
-- |
|
| 4758 | 4706 |
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4759 | 4707 |
-- |
| 4760 | 4708 |
|
| ... | ... | |
| 5048 | 4996 |
|
| 5049 | 4997 |
|
| 5050 | 4998 |
-- |
| 5051 |
-- Name: locationeventcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5052 |
-- |
|
| 5053 |
|
|
| 5054 |
|
|
| 5055 |
|
|
| 5056 |
|
|
| 5057 |
-- |
|
| 5058 | 4999 |
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5059 | 5000 |
-- |
| 5060 | 5001 |
|
| ... | ... | |
| 5070 | 5011 |
|
| 5071 | 5012 |
|
| 5072 | 5013 |
-- |
| 5073 |
-- Name: locationeventsynonym_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5074 |
-- |
|
| 5075 |
|
|
| 5076 |
|
|
| 5077 |
|
|
| 5078 |
|
|
| 5079 |
-- |
|
| 5080 | 5014 |
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5081 | 5015 |
-- |
| 5082 | 5016 |
|
| ... | ... | |
| 5171 | 5105 |
|
| 5172 | 5106 |
|
| 5173 | 5107 |
-- |
| 5174 |
-- Name: note_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5175 |
-- |
|
| 5176 |
|
|
| 5177 |
ALTER TABLE note |
|
| 5178 |
ADD CONSTRAINT note_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5179 |
|
|
| 5180 |
|
|
| 5181 |
-- |
|
| 5182 | 5108 |
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5183 | 5109 |
-- |
| 5184 | 5110 |
|
| ... | ... | |
| 5203 | 5129 |
|
| 5204 | 5130 |
|
| 5205 | 5131 |
-- |
| 5206 |
-- Name: partymember_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5207 |
-- |
|
| 5208 |
|
|
| 5209 |
ALTER TABLE partymember |
|
| 5210 |
ADD CONSTRAINT partymember_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5211 |
|
|
| 5212 |
|
|
| 5213 |
-- |
|
| 5214 | 5132 |
-- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5215 | 5133 |
-- |
| 5216 | 5134 |
|
| ... | ... | |
| 5374 | 5292 |
|
| 5375 | 5293 |
|
| 5376 | 5294 |
-- |
| 5377 |
-- Name: projectcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5378 |
-- |
|
| 5379 |
|
|
| 5380 |
|
|
| 5381 |
|
|
| 5382 |
|
|
| 5383 |
-- |
|
| 5384 | 5295 |
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5385 | 5296 |
-- |
| 5386 | 5297 |
|
| ... | ... | |
| 5545 | 5456 |
|
| 5546 | 5457 |
|
| 5547 | 5458 |
-- |
| 5548 |
-- Name: taxondetermination_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5549 |
-- |
|
| 5550 |
|
|
| 5551 |
|
|
| 5552 |
|
|
| 5553 |
|
|
| 5554 |
-- |
|
| 5555 | 5459 |
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5556 | 5460 |
-- |
| 5557 | 5461 |
|
| schemas/vegbien_empty.sql | ||
|---|---|---|
| 44 | 44 |
TRUNCATE referencejournal CASCADE; |
| 45 | 45 |
TRUNCATE referenceparty CASCADE; |
| 46 | 46 |
TRUNCATE revision CASCADE; |
| 47 |
TRUNCATE role CASCADE; |
|
| 48 | 47 |
TRUNCATE soilobs CASCADE; |
| 49 | 48 |
TRUNCATE soiltaxon CASCADE; |
| 50 | 49 |
TRUNCATE specimen CASCADE; |
| schemas/vegbien.sql | ||
|---|---|---|
| 61 | 61 |
|
| 62 | 62 |
|
| 63 | 63 |
-- |
| 64 |
-- Name: role; Type: TYPE; Schema: public; Owner: - |
|
| 65 |
-- |
|
| 66 |
|
|
| 67 |
CREATE TYPE role AS ENUM ( |
|
| 68 |
'collector', |
|
| 69 |
'identifier', |
|
| 70 |
'computer', |
|
| 71 |
'contributor' |
|
| 72 |
); |
|
| 73 |
|
|
| 74 |
|
|
| 75 |
-- |
|
| 64 | 76 |
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: - |
| 65 | 77 |
-- |
| 66 | 78 |
|
| ... | ... | |
| 258 | 270 |
classcontributor_id integer NOT NULL, |
| 259 | 271 |
commclass_id integer NOT NULL, |
| 260 | 272 |
party_id integer NOT NULL, |
| 261 |
role_id integer
|
|
| 273 |
role role
|
|
| 262 | 274 |
); |
| 263 | 275 |
|
| 264 | 276 |
|
| ... | ... | |
| 1004 | 1016 |
locationeventcontributor_id integer NOT NULL, |
| 1005 | 1017 |
locationevent_id integer NOT NULL, |
| 1006 | 1018 |
party_id integer NOT NULL, |
| 1007 |
role_id integer NOT NULL,
|
|
| 1019 |
role role NOT NULL,
|
|
| 1008 | 1020 |
contributiondate timestamp with time zone |
| 1009 | 1021 |
); |
| 1010 | 1022 |
|
| ... | ... | |
| 1037 | 1049 |
synonymlocationevent_id integer NOT NULL, |
| 1038 | 1050 |
primarylocationevent_id integer NOT NULL, |
| 1039 | 1051 |
party_id integer NOT NULL, |
| 1040 |
role_id integer NOT NULL,
|
|
| 1052 |
role role NOT NULL,
|
|
| 1041 | 1053 |
synonymcomment text, |
| 1042 | 1054 |
classstartdate timestamp with time zone DEFAULT now() NOT NULL, |
| 1043 | 1055 |
classstopdate timestamp with time zone, |
| ... | ... | |
| 1427 | 1439 |
note_id integer NOT NULL, |
| 1428 | 1440 |
notelink_id integer NOT NULL, |
| 1429 | 1441 |
party_id integer NOT NULL, |
| 1430 |
role_id integer NOT NULL,
|
|
| 1442 |
role role NOT NULL,
|
|
| 1431 | 1443 |
notetype text NOT NULL, |
| 1432 | 1444 |
notetext text NOT NULL, |
| 1433 | 1445 |
notedate timestamp with time zone, |
| ... | ... | |
| 1533 | 1545 |
partymember_id integer NOT NULL, |
| 1534 | 1546 |
parentparty_id integer NOT NULL, |
| 1535 | 1547 |
childparty_id integer NOT NULL, |
| 1536 |
role_id integer,
|
|
| 1548 |
role role,
|
|
| 1537 | 1549 |
memberstart timestamp with time zone DEFAULT now() NOT NULL, |
| 1538 | 1550 |
memberstop timestamp with time zone |
| 1539 | 1551 |
); |
| ... | ... | |
| 1920 | 1932 |
projectcontributor_id integer NOT NULL, |
| 1921 | 1933 |
project_id integer NOT NULL, |
| 1922 | 1934 |
party_id integer NOT NULL, |
| 1923 |
role_id integer,
|
|
| 1935 |
role role,
|
|
| 1924 | 1936 |
surname text, |
| 1925 | 1937 |
cheatrole text |
| 1926 | 1938 |
); |
| ... | ... | |
| 2167 | 2179 |
|
| 2168 | 2180 |
|
| 2169 | 2181 |
-- |
| 2170 |
-- Name: role; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2171 |
-- |
|
| 2172 |
|
|
| 2173 |
CREATE TABLE role ( |
|
| 2174 |
role_id integer NOT NULL, |
|
| 2175 |
rolecode text NOT NULL, |
|
| 2176 |
roledescription text, |
|
| 2177 |
roleproject integer, |
|
| 2178 |
roleobservation integer, |
|
| 2179 |
roletaxonint integer, |
|
| 2180 |
roleclassint integer, |
|
| 2181 |
accessioncode text |
|
| 2182 |
); |
|
| 2183 |
|
|
| 2184 |
|
|
| 2185 |
-- |
|
| 2186 |
-- Name: role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2187 |
-- |
|
| 2188 |
|
|
| 2189 |
CREATE SEQUENCE role_role_id_seq |
|
| 2190 |
START WITH 1 |
|
| 2191 |
INCREMENT BY 1 |
|
| 2192 |
NO MINVALUE |
|
| 2193 |
NO MAXVALUE |
|
| 2194 |
CACHE 1; |
|
| 2195 |
|
|
| 2196 |
|
|
| 2197 |
-- |
|
| 2198 |
-- Name: role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2199 |
-- |
|
| 2200 |
|
|
| 2201 |
ALTER SEQUENCE role_role_id_seq OWNED BY role.role_id; |
|
| 2202 |
|
|
| 2203 |
|
|
| 2204 |
-- |
|
| 2205 | 2182 |
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2206 | 2183 |
-- |
| 2207 | 2184 |
|
| ... | ... | |
| 2645 | 2622 |
taxonoccurrence_id integer NOT NULL, |
| 2646 | 2623 |
plantconcept_id integer NOT NULL, |
| 2647 | 2624 |
party_id integer, |
| 2648 |
role_id integer NOT NULL,
|
|
| 2625 |
role role NOT NULL,
|
|
| 2649 | 2626 |
determinationtype text, |
| 2650 | 2627 |
reference_id integer, |
| 2651 | 2628 |
isoriginal boolean DEFAULT false NOT NULL, |
| ... | ... | |
| 3181 | 3158 |
|
| 3182 | 3159 |
|
| 3183 | 3160 |
-- |
| 3184 |
-- Name: role_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3185 |
-- |
|
| 3186 |
|
|
| 3187 |
ALTER TABLE role ALTER COLUMN role_id SET DEFAULT nextval('role_role_id_seq'::regclass);
|
|
| 3188 |
|
|
| 3189 |
|
|
| 3190 |
-- |
|
| 3191 | 3161 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: - |
| 3192 | 3162 |
-- |
| 3193 | 3163 |
|
| ... | ... | |
| 3806 | 3776 |
|
| 3807 | 3777 |
|
| 3808 | 3778 |
-- |
| 3809 |
-- Name: role_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3810 |
-- |
|
| 3811 |
|
|
| 3812 |
ALTER TABLE ONLY role |
|
| 3813 |
ADD CONSTRAINT role_pkey PRIMARY KEY (role_id); |
|
| 3814 |
|
|
| 3815 |
|
|
| 3816 |
-- |
|
| 3817 | 3779 |
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3818 | 3780 |
-- |
| 3819 | 3781 |
|
| ... | ... | |
| 4028 | 3990 |
-- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4029 | 3991 |
-- |
| 4030 | 3992 |
|
| 4031 |
CREATE INDEX classcontributor_role_id_x ON classcontributor USING btree (role_id);
|
|
| 3993 |
CREATE INDEX classcontributor_role_id_x ON classcontributor USING btree (role); |
|
| 4032 | 3994 |
|
| 4033 | 3995 |
|
| 4034 | 3996 |
-- |
| ... | ... | |
| 4546 | 4508 |
-- Name: locationeventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4547 | 4509 |
-- |
| 4548 | 4510 |
|
| 4549 |
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor USING btree (role_id);
|
|
| 4511 |
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor USING btree (role); |
|
| 4550 | 4512 |
|
| 4551 | 4513 |
|
| 4552 | 4514 |
-- |
| ... | ... | |
| 4574 | 4536 |
-- Name: locationeventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4575 | 4537 |
-- |
| 4576 | 4538 |
|
| 4577 |
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym USING btree (role_id);
|
|
| 4539 |
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym USING btree (role); |
|
| 4578 | 4540 |
|
| 4579 | 4541 |
|
| 4580 | 4542 |
-- |
| ... | ... | |
| 4630 | 4592 |
-- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4631 | 4593 |
-- |
| 4632 | 4594 |
|
| 4633 |
CREATE INDEX note_role_id_x ON note USING btree (role_id);
|
|
| 4595 |
CREATE INDEX note_role_id_x ON note USING btree (role); |
|
| 4634 | 4596 |
|
| 4635 | 4597 |
|
| 4636 | 4598 |
-- |
| ... | ... | |
| 4707 | 4669 |
-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4708 | 4670 |
-- |
| 4709 | 4671 |
|
| 4710 |
CREATE INDEX partymember_role_id_x ON partymember USING btree (role_id);
|
|
| 4672 |
CREATE INDEX partymember_role_id_x ON partymember USING btree (role); |
|
| 4711 | 4673 |
|
| 4712 | 4674 |
|
| 4713 | 4675 |
-- |
| ... | ... | |
| 4875 | 4837 |
-- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4876 | 4838 |
-- |
| 4877 | 4839 |
|
| 4878 |
CREATE INDEX projectcontributor_role_id_x ON projectcontributor USING btree (role_id);
|
|
| 4840 |
CREATE INDEX projectcontributor_role_id_x ON projectcontributor USING btree (role); |
|
| 4879 | 4841 |
|
| 4880 | 4842 |
|
| 4881 | 4843 |
-- |
| ... | ... | |
| 4942 | 4904 |
|
| 4943 | 4905 |
|
| 4944 | 4906 |
-- |
| 4945 |
-- Name: role_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4946 |
-- |
|
| 4947 |
|
|
| 4948 |
CREATE UNIQUE INDEX role_accessioncode_index ON role USING btree (accessioncode); |
|
| 4949 |
|
|
| 4950 |
|
|
| 4951 |
-- |
|
| 4952 | 4907 |
-- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4953 | 4908 |
-- |
| 4954 | 4909 |
|
| ... | ... | |
| 5036 | 4991 |
-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5037 | 4992 |
-- |
| 5038 | 4993 |
|
| 5039 |
CREATE INDEX taxondetermination_role_id_x ON taxondetermination USING btree (role_id);
|
|
| 4994 |
CREATE INDEX taxondetermination_role_id_x ON taxondetermination USING btree (role); |
|
| 5040 | 4995 |
|
| 5041 | 4996 |
|
| 5042 | 4997 |
-- |
| ... | ... | |
| 5050 | 5005 |
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5051 | 5006 |
-- |
| 5052 | 5007 |
|
| 5053 |
CREATE UNIQUE INDEX taxondetermination_unique ON taxondetermination USING btree (taxonoccurrence_id, role_id, (COALESCE(party_id, 0)), plantconcept_id);
|
|
| 5008 |
CREATE UNIQUE INDEX taxondetermination_unique ON taxondetermination USING btree (taxonoccurrence_id, role, (COALESCE(party_id, 0)), plantconcept_id); |
|
| 5054 | 5009 |
|
| 5055 | 5010 |
|
| 5056 | 5011 |
-- |
| ... | ... | |
| 5161 | 5116 |
|
| 5162 | 5117 |
|
| 5163 | 5118 |
-- |
| 5164 |
-- Name: classcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5165 |
-- |
|
| 5166 |
|
|
| 5167 |
ALTER TABLE ONLY classcontributor |
|
| 5168 |
ADD CONSTRAINT classcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5169 |
|
|
| 5170 |
|
|
| 5171 |
-- |
|
| 5172 | 5119 |
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5173 | 5120 |
-- |
| 5174 | 5121 |
|
| ... | ... | |
| 5473 | 5420 |
|
| 5474 | 5421 |
|
| 5475 | 5422 |
-- |
| 5476 |
-- Name: locationeventcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5477 |
-- |
|
| 5478 |
|
|
| 5479 |
ALTER TABLE ONLY locationeventcontributor |
|
| 5480 |
ADD CONSTRAINT locationeventcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5481 |
|
|
| 5482 |
|
|
| 5483 |
-- |
|
| 5484 | 5423 |
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5485 | 5424 |
-- |
| 5486 | 5425 |
|
| ... | ... | |
| 5497 | 5436 |
|
| 5498 | 5437 |
|
| 5499 | 5438 |
-- |
| 5500 |
-- Name: locationeventsynonym_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5501 |
-- |
|
| 5502 |
|
|
| 5503 |
ALTER TABLE ONLY locationeventsynonym |
|
| 5504 |
ADD CONSTRAINT locationeventsynonym_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5505 |
|
|
| 5506 |
|
|
| 5507 |
-- |
|
| 5508 | 5439 |
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5509 | 5440 |
-- |
| 5510 | 5441 |
|
| ... | ... | |
| 5601 | 5532 |
|
| 5602 | 5533 |
|
| 5603 | 5534 |
-- |
| 5604 |
-- Name: note_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5605 |
-- |
|
| 5606 |
|
|
| 5607 |
ALTER TABLE ONLY note |
|
| 5608 |
ADD CONSTRAINT note_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5609 |
|
|
| 5610 |
|
|
| 5611 |
-- |
|
| 5612 | 5535 |
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5613 | 5536 |
-- |
| 5614 | 5537 |
|
Also available in: Unified diff
VegBIEN: Changed role table to a closed list