16 |
16 |
canopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_canopy_form,40
|
17 |
17 |
canopyPosition,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_canopy_position,41
|
18 |
18 |
carbon,/location/locationevent/soilobs/carbon,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_C,37
|
19 |
|
catalogNumber,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
|
20 |
19 |
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
|
21 |
20 |
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
|
|
21 |
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
|
22 |
22 |
catalogNumber,/location/sourceaccessioncode/_alt/2/_merge/3,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
|
23 |
23 |
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,Expanded for clarity,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#exchangeCapacity, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_cation_cap","13, 44"
|
24 |
24 |
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",Expanded for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.census_no,3
|
25 |
|
class,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
|
26 |
25 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
|
27 |
26 |
clay,/location/locationevent/soilobs/clay,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilClay,10
|
28 |
|
collectionCode,/location/locationevent/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/#collectionCode,12
|
|
27 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/#collectionCode,12
|
29 |
28 |
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#collectionCode,12
|
30 |
|
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
|
|
29 |
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
|
31 |
30 |
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,Table shortened for standardization,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/communityDeterminations/communityDetermination/communityConcepts/communityConcept, http://rs.tdwg.org/dwc/terms/#occurrenceID",", 0"
|
32 |
31 |
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Table shortened for standardization,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/communityDeterminations/communityDetermination/communityConcepts/communityConcept/name,0
|
33 |
32 |
computer.family,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,"https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/schemas/vegbien.sql#role.computer, http://rs.tdwg.org/dwc/terms/#family","2, 146"
|
... | ... | |
48 |
47 |
dataGeneralizations,,,http://rs.tdwg.org/dwc/terms/#dataGeneralizations,17
|
49 |
48 |
datasetID,,,http://rs.tdwg.org/dwc/terms/#datasetID,10
|
50 |
49 |
datasetName,,,http://rs.tdwg.org/dwc/terms/#datasetName,13
|
51 |
|
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
|
|
50 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
|
52 |
51 |
day,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/#day,50
|
53 |
52 |
dcterms:accessRights,,,http://rs.tdwg.org/dwc/terms/#dcterms:accessRights,5
|
54 |
53 |
dcterms:bibliographicCitation,,,http://rs.tdwg.org/dwc/terms/#dcterms:bibliographicCitation,6
|
... | ... | |
72 |
71 |
earliestEraOrLowestErathem,,,http://rs.tdwg.org/dwc/terms/#earliestEraOrLowestErathem,103
|
73 |
72 |
earliestPeriodOrLowestSystem,,,http://rs.tdwg.org/dwc/terms/#earliestPeriodOrLowestSystem,105
|
74 |
73 |
endDayOfYear,,,http://rs.tdwg.org/dwc/terms/#endDayOfYear,47
|
75 |
|
establishmentMeans,"/location/locationevent/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
76 |
|
establishmentMeans,"/location/locationevent/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
77 |
|
establishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
74 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
75 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
|
76 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
|
78 |
77 |
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
79 |
78 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
80 |
|
eventDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
81 |
|
eventDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
79 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
82 |
80 |
eventID,,,http://rs.tdwg.org/dwc/terms/#eventID,41
|
83 |
81 |
eventRemarks,,,http://rs.tdwg.org/dwc/terms/#eventRemarks,55
|
84 |
82 |
eventTime,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/#eventTime,45
|
85 |
|
family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146
|
86 |
83 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146
|
87 |
|
fieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
|
88 |
84 |
fieldNotes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
|
89 |
85 |
fieldNotes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
|
90 |
|
fieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
|
|
86 |
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
|
91 |
87 |
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#fieldNumber,53
|
|
88 |
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
|
92 |
89 |
fieldNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#fieldNumber,53
|
93 |
90 |
footprintSRS,,,http://rs.tdwg.org/dwc/terms/#footprintSRS,92
|
94 |
91 |
footprintSpatialFit,,,http://rs.tdwg.org/dwc/terms/#footprintSpatialFit,93
|
95 |
92 |
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,,http://rs.tdwg.org/dwc/terms/#footprintWKT,91
|
96 |
93 |
formation,,,http://rs.tdwg.org/dwc/terms/#formation,115
|
97 |
|
genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,http://rs.tdwg.org/dwc/terms/#genus,147
|
98 |
94 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,http://rs.tdwg.org/dwc/terms/#genus,147
|
99 |
95 |
geodeticDatum,,,http://rs.tdwg.org/dwc/terms/#geodeticDatum,87
|
100 |
96 |
geologicalContextID,,,http://rs.tdwg.org/dwc/terms/#geologicalContextID,100
|
... | ... | |
121 |
117 |
identificationReferences,,,http://rs.tdwg.org/dwc/terms/#identificationReferences,121
|
122 |
118 |
identificationRemarks,,,http://rs.tdwg.org/dwc/terms/#identificationRemarks,123
|
123 |
119 |
identificationVerificationStatus,,,http://rs.tdwg.org/dwc/terms/#identificationVerificationStatus,122
|
124 |
|
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
|
125 |
|
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
|
126 |
|
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
|
|
120 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
|
|
121 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
|
|
122 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
|
127 |
123 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,,http://rs.tdwg.org/dwc/terms/#individualCount,25
|
128 |
124 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,,http://rs.tdwg.org/dwc/terms/#individualCount,25
|
129 |
125 |
individualCount,,,http://rs.tdwg.org/dwc/terms/#individualCount,25
|
130 |
126 |
individualID,,,http://rs.tdwg.org/dwc/terms/#individualID,24
|
131 |
127 |
informationWithheld,,,http://rs.tdwg.org/dwc/terms/#informationWithheld,16
|
132 |
|
infraspecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
|
133 |
128 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
|
134 |
|
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
|
|
129 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
|
|
130 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
|
135 |
131 |
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
|
136 |
132 |
institutionID,,,http://rs.tdwg.org/dwc/terms/#institutionID,8
|
137 |
133 |
island,,,http://rs.tdwg.org/dwc/terms/#island,62
|
138 |
134 |
islandGroup,,,http://rs.tdwg.org/dwc/terms/#islandGroup,61
|
139 |
|
kingdom,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
|
140 |
135 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
|
141 |
136 |
landform,/location/landform,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/landform,18
|
142 |
137 |
latestAgeOrHighestStage,,,http://rs.tdwg.org/dwc/terms/#latestAgeOrHighestStage,110
|
... | ... | |
187 |
182 |
nitrogen,/location/locationevent/soilobs/nitrogen,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/nitrogen,5
|
188 |
183 |
nomenclaturalCode,,,http://rs.tdwg.org/dwc/terms/#nomenclaturalCode,155
|
189 |
184 |
nomenclaturalStatus,,,http://rs.tdwg.org/dwc/terms/#nomenclaturalStatus,157
|
190 |
|
occurrenceID,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
|
191 |
185 |
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#occurrenceID,19
|
|
186 |
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
|
192 |
187 |
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#occurrenceID,19
|
193 |
188 |
occurrenceID,/location/sourceaccessioncode/_alt/1,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
|
194 |
189 |
occurrenceRemarks,,,http://rs.tdwg.org/dwc/terms/#occurrenceRemarks,21
|
195 |
190 |
occurrenceStatus,,,http://rs.tdwg.org/dwc/terms/#occurrenceStatus,31
|
196 |
|
order,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
|
197 |
191 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
|
198 |
192 |
organic,/location/locationevent/soilobs/organic,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilOrganic,6
|
199 |
193 |
originalNameUsage,,,http://rs.tdwg.org/dwc/terms/#originalNameUsage,137
|
... | ... | |
210 |
204 |
parentPlotName,/location/sourceaccessioncode/_merge/1/_alt/2,,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#PARENT_ID, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName","3, 1"
|
211 |
205 |
ph,/location/locationevent/soilobs/ph,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/ph,6
|
212 |
206 |
phosphorus,/location/locationevent/soilobs/phosphorus,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/phosphorus,2
|
213 |
|
phylum,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
|
214 |
207 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
|
215 |
208 |
plotArea,/location/area,Table added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/area,11
|
216 |
209 |
plotEventEndDate,/location/locationevent/obsenddate,Table added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsEndDate",", 44, 6"
|
... | ... | |
228 |
221 |
previousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,Number replaced with named prefix for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.tag1,8
|
229 |
222 |
projectID,/location/locationevent/*_id/project/sourceaccessioncode,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://rs.tdwg.org/dwc/terms/#occurrenceID",", 0"
|
230 |
223 |
projectName,/location/locationevent/*_id/project/projectname,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName",", 1"
|
231 |
|
recordNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
|
232 |
|
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
|
|
224 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
|
|
225 |
recordedBy,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
|
233 |
226 |
recordedBy.givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,,"http://rs.tdwg.org/dwc/terms/#recordedBy, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/parties/party/individualName/givenName","23, 01"
|
234 |
227 |
recordedBy.surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,,"http://rs.tdwg.org/dwc/terms/#recordedBy, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/parties/party/individualName/surName","23, 02"
|
235 |
228 |
relatedResourceID,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/#relatedResourceID,161
|
... | ... | |
246 |
239 |
samplingProtocol,/location/locationevent/*_id/method/name,,http://rs.tdwg.org/dwc/terms/#samplingProtocol,42
|
247 |
240 |
samplingProtocol,,,http://rs.tdwg.org/dwc/terms/#samplingProtocol,42
|
248 |
241 |
sand,/location/locationevent/soilobs/sand,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSand,8
|
249 |
|
scientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",,http://rs.tdwg.org/dwc/terms/#scientificName,134
|
250 |
242 |
scientificName,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,,http://rs.tdwg.org/dwc/terms/#scientificName,134
|
|
243 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",,http://rs.tdwg.org/dwc/terms/#scientificName,134
|
251 |
244 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_name/first",,http://rs.tdwg.org/dwc/terms/#scientificName,134
|
252 |
|
scientificNameAuthorship,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
|
253 |
245 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
|
254 |
246 |
scientificNameID,,,http://rs.tdwg.org/dwc/terms/#scientificNameID,127
|
255 |
|
sex,"/location/locationevent/specimenreplicate/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",http://rs.tdwg.org/dwc/terms/#sex,26
|
|
247 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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",http://rs.tdwg.org/dwc/terms/#sex,26
|
256 |
248 |
silt,/location/locationevent/soilobs/silt,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSilt,9
|
257 |
249 |
slopeAspect,/location/slopeaspect/_compass/value,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeAspect,15
|
258 |
250 |
slopeGradient,/location/slopegradient,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeGradient,16
|
259 |
251 |
sodium,/location/locationevent/soilobs/sodium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41
|
260 |
|
specificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
|
261 |
252 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
|
262 |
253 |
startDayOfYear,,,http://rs.tdwg.org/dwc/terms/#startDayOfYear,46
|
263 |
254 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/#stateProvince,65
|
... | ... | |
267 |
258 |
taxonConceptID,,,http://rs.tdwg.org/dwc/terms/#taxonConceptID,133
|
268 |
259 |
taxonID,,,http://rs.tdwg.org/dwc/terms/#taxonID,126
|
269 |
260 |
taxonRank,,,http://rs.tdwg.org/dwc/terms/#taxonRank,151
|
270 |
|
taxonRemarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
|
|
261 |
taxonRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/2,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
|
271 |
262 |
taxonomicStatus,,,http://rs.tdwg.org/dwc/terms/#taxonomicStatus,156
|
272 |
263 |
temperature,/location/locationevent/temperature,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plotObservations/plotObservation/observationConditions/temperature,1900
|
273 |
264 |
texture,/location/locationevent/soilobs/texture,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilTexture,7
|
schemas/vegbien.sql: Moved collectiondate from specimenreplicate to aggregateoccurrence because it's actually the SALVIAS census_date, which is the date the plant was sampled, rather than the DwC eventDate, which is the date the specimen was collected