Revision 6542
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/TEAM/VL/map.csv | ||
|---|---|---|
| 22 | 22 |
1ha Plot Y Coordinate,organismY_m,,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
|
| 23 | 23 |
Tree Number,tag,, |
| 24 | 24 |
Site Name,projectName,, |
| 25 |
1ha Plot Number,plotName,,
|
|
| 25 |
1ha Plot Number,locationName,,
|
|
| 26 | 26 |
Protocol Version,*Protocol Version,, |
| 27 | 27 |
Data Set Creator Institution,*Data Set Creator Institution,, |
| 28 | 28 |
Data Set Creator Scientist,*Data Set Creator Scientist,, |
| inputs/TEAM/VL/new_terms.csv | ||
|---|---|---|
| 7 | 7 |
1ha Plot Y Coordinate,organismY_m,,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
|
| 8 | 8 |
Tree Number,tag,, |
| 9 | 9 |
Site Name,projectName,, |
| 10 |
1ha Plot Number,plotName,, |
|
| 10 |
1ha Plot Number,locationName,, |
|
| inputs/TEAM/VT/map.csv | ||
|---|---|---|
| 22 | 22 |
1ha Plot Y Coordinate,organismY_m,,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
|
| 23 | 23 |
Tree Number,tag,, |
| 24 | 24 |
Site Name,projectName,, |
| 25 |
1ha Plot Number,plotName,,
|
|
| 25 |
1ha Plot Number,locationName,,
|
|
| 26 | 26 |
Protocol Version,*Protocol Version,, |
| 27 | 27 |
Data Set Creator Institution,*Data Set Creator Institution,, |
| 28 | 28 |
Data Set Creator Scientist,*Data Set Creator Scientist,, |
| inputs/TEAM/VT/new_terms.csv | ||
|---|---|---|
| 7 | 7 |
1ha Plot Y Coordinate,organismY_m,,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
|
| 8 | 8 |
Tree Number,tag,, |
| 9 | 9 |
Site Name,projectName,, |
| 10 |
1ha Plot Number,plotName,, |
|
| 10 |
1ha Plot Number,locationName,, |
|
| inputs/TEAM/TEAM_Sites/map.csv | ||
|---|---|---|
| 1 | 1 |
TEAM,VegCore,Filter,Comments |
| 2 | 2 |
Site Name,projectName,, |
| 3 |
Name,plotName,,
|
|
| 3 |
Name,locationName,,
|
|
| 4 | 4 |
1ha Plot Coordinate,*1ha Plot Coordinate,, |
| 5 | 5 |
Longitude,decimalLongitude,, |
| 6 | 6 |
Latitude,decimalLatitude,, |
| inputs/TEAM/TEAM_Sites/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
Site Name,projectName,, |
| 2 |
Name,plotName,,
|
|
| 2 |
Name,locationName,,
|
|
| 3 | 3 |
CollectionDate,eventDate,, |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
referenceType,"/_if[@name=""if specimen""]/else/source/sourcetype", |
| 7 | 7 |
subplot,"/location/_if[@name=""if subplot""]/cond/_exists", |
| 8 | 8 |
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists", |
| 9 |
plotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode",
|
|
| 9 |
locationName,"/location/_if[@name=""if subplot""]/else/authorlocationcode",
|
|
| 10 | 10 |
locationID,"/location/authorlocationcode/_if[@name=""if locationID""]/cond/_exists", |
| 11 | 11 |
fieldNumber,"/location/authorlocationcode/_if[@name=""if locationID""]/else", |
| 12 | 12 |
occurrenceID,"/location/_if[@name=""if subplot""]/else/authorlocationcode", |
| ... | ... | |
| 21 | 21 |
geovalid,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
| 22 | 22 |
latLongInCountry,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
| 23 | 23 |
locationID,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/else", |
| 24 |
plotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
|
|
| 24 |
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
|
|
| 25 | 25 |
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 26 | 26 |
dcterms:accessRights,//location/accesslevel, |
| 27 | 27 |
plotArea_m2,//location/area_m2, |
| ... | ... | |
| 60 | 60 |
startDate,"//location/locationevent/_if[@name=""if has event""]/cond/_exists", |
| 61 | 61 |
subplotID,"//location/locationevent/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond", |
| 62 | 62 |
subplot,"//location/locationevent/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond", |
| 63 |
plotName,"//location/locationevent/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
|
|
| 63 |
locationName,"//location/locationevent/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
|
|
| 64 | 64 |
subplotID,"//location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
| 65 | 65 |
subplot,"//location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
| 66 | 66 |
locationID,"//location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| ... | ... | |
| 138 | 138 |
eventID,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 139 | 139 |
fieldNumber,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 140 | 140 |
locationID,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 141 |
plotName,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
|
|
| 141 |
locationName,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
|
|
| 142 | 142 |
recordNumber,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then", |
| 143 | 143 |
tag,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then", |
| 144 | 144 |
originalTaxonName,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then", |
| ... | ... | |
| 388 | 388 |
subplotID,//location/sourceaccessioncode, |
| 389 | 389 |
subplot,"//location/sourceaccessioncode/_if[@name=""if subplot and unique only within parent""]/cond/_exists", |
| 390 | 390 |
locationID,"//location/sourceaccessioncode/_if[@name=""if subplot and unique only within parent""]/then", |
| 391 |
plotName,"//location/sourceaccessioncode/_if[@name=""if subplot and unique only within parent""]/then",
|
|
| 391 |
locationName,"//location/sourceaccessioncode/_if[@name=""if subplot and unique only within parent""]/then",
|
|
| 392 | 392 |
subplot,//location/sourceaccessioncode, |
| 393 | 393 |
subplotX,//location/sublocationxposition_m, |
| 394 | 394 |
subplotY,//location/sublocationyposition_m, |
| inputs/CTFS/Plot/map.csv | ||
|---|---|---|
| 1 | 1 |
CTFS,VegCore,Filter,Comments |
| 2 | 2 |
CountryID,*CountryID,, |
| 3 | 3 |
PlotID,locationID,, |
| 4 |
PlotName,plotName,,
|
|
| 4 |
PlotName,locationName,,
|
|
| 5 | 5 |
LocationName,locality,, |
| 6 | 6 |
Latitude,decimalLatitude,, |
| 7 | 7 |
Longitude,decimalLongitude,, |
| inputs/SALVIAS/plotObservations/map.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegCore,Filter,Comments |
| 2 | 2 |
PlotObsID,individualID,,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 3 | 3 |
PlotID,locationID,, |
| 4 |
PlotCode,plotName,,
|
|
| 4 |
PlotCode,locationName,,
|
|
| 5 | 5 |
census_no,censusNumber,,"Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 6 | 6 |
census_date,eventDate,,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows: |
| 7 | 7 |
----- |
| inputs/SALVIAS/plotObservations/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
PlotObsID,individualID,,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 2 |
PlotCode,plotName,,
|
|
| 2 |
PlotCode,locationName,,
|
|
| 3 | 3 |
census_no,censusNumber,,"Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 4 | 4 |
census_date,eventDate,,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows: |
| 5 | 5 |
----- |
| inputs/SALVIAS/plotMetadata_/map.csv | ||
|---|---|---|
| 5 | 5 |
AccessCode,dcterms:accessRights,"/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del" |
| 6 | 6 |
project_id,projectID,, |
| 7 | 7 |
PrimOwnerID,*PrimOwnerID,, |
| 8 |
SiteCode,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 8 |
SiteCode,locationName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 9 | 9 |
SiteName,*SiteName,, |
| 10 | 10 |
new_world,*new_world,, |
| 11 | 11 |
MajorGeo,continent,, |
| inputs/SALVIAS/plotMetadata_/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
MethodCode,OMIT,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod |
| 2 | 2 |
AccessCode,dcterms:accessRights,"/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del" |
| 3 |
SiteCode,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 3 |
SiteCode,locationName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 4 | 4 |
MajorGeo,continent,, |
| 5 | 5 |
PolDiv1,stateProvince,,Brad: No; pol1=stateProvince |
| 6 | 6 |
pol2,county,,Brad: No pol2=countyParish |
| inputs/bien_web/observation/map.csv | ||
|---|---|---|
| 30 | 30 |
collectionNumber,recordNumber,, |
| 31 | 31 |
identifiedBy,identifiedBy,, |
| 32 | 32 |
observationDate,dateCollected,, |
| 33 |
plotCode,plotName,,
|
|
| 33 |
plotCode,locationName,,
|
|
| 34 | 34 |
plotAreaHa,plotArea_ha,, |
| 35 | 35 |
plotMinDbh,*plotMinDbh,, |
| 36 | 36 |
plotMethod,samplingProtocol,, |
| inputs/bien_web/observation/new_terms.csv | ||
|---|---|---|
| 6 | 6 |
countyParish,county,, |
| 7 | 7 |
collectionNumber,recordNumber,, |
| 8 | 8 |
observationDate,dateCollected,, |
| 9 |
plotCode,plotName,,
|
|
| 9 |
plotCode,locationName,,
|
|
| 10 | 10 |
plotMethod,samplingProtocol,, |
| 11 | 11 |
elevation_m,elevationInMeters,, |
| 12 | 12 |
isCultivated,cultivated,, |
| inputs/Madidi/Organism/map.csv | ||
|---|---|---|
| 1 | 1 |
Madidi,VegCore,Filter,Comments |
| 2 | 2 |
Expedition,projectName,, |
| 3 |
Inventory name,plotName,,
|
|
| 3 |
Inventory name,locationName,,
|
|
| 4 | 4 |
Number of inventory (general),*Number of inventory (general),, |
| 5 | 5 |
Number of inventory (expedition),*Number of inventory (expedition),, |
| 6 | 6 |
"Type Inventory (C, PP, TP)","*Type Inventory (C, PP, TP)",, |
| inputs/Madidi/Organism/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
Expedition,projectName,, |
| 2 |
Inventory name,plotName,,
|
|
| 2 |
Inventory name,locationName,,
|
|
| 3 | 3 |
Inventory code,locationID,, |
| 4 | 4 |
Tag number,tag,, |
| 5 | 5 |
Tree number,recordNumber,, |
| inputs/Madidi/Plot/map.csv | ||
|---|---|---|
| 3 | 3 |
Expedition number,projectID,,Consistent (globally unique) between PPM and PT data |
| 4 | 4 |
Expedition name,projectName,,Consistent (globally unique) between PPM and PT data |
| 5 | 5 |
Number of inventory (expedition),*Number of inventory (expedition),,The number of the event within the project |
| 6 |
Inventory name,plotName,,
|
|
| 6 |
Inventory name,locationName,,
|
|
| 7 | 7 |
Inventory code,locationID,, |
| 8 | 8 |
First evaluation,eventDate,, |
| 9 | 9 |
Installed and evaluated by,*Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party" |
| inputs/Madidi/Plot/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
Expedition number,projectID,,Consistent (globally unique) between PPM and PT data |
| 2 | 2 |
Expedition name,projectName,,Consistent (globally unique) between PPM and PT data |
| 3 |
Inventory name,plotName,,
|
|
| 3 |
Inventory name,locationName,,
|
|
| 4 | 4 |
Inventory code,locationID,, |
| 5 | 5 |
First evaluation,eventDate,, |
| 6 | 6 |
Area,plotArea_ha,,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"
|
| inputs/SALVIAS-CSV/Organism/map.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS-CSV,VegCore,Filter,Comments |
| 2 | 2 |
OBSERVATION_ID,individualID,,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 3 | 3 |
PLOT_ID,locationID,, |
| 4 |
plot_code,plotName,,
|
|
| 4 |
plot_code,locationName,,
|
|
| 5 | 5 |
census_no,censusNumber,,"Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 6 | 6 |
census_date,eventDate,,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows: |
| 7 | 7 |
----- |
| inputs/SALVIAS-CSV/Organism/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
OBSERVATION_ID,individualID,,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 2 |
plot_code,plotName,,
|
|
| 2 |
plot_code,locationName,,
|
|
| 3 | 3 |
census_no,censusNumber,,"Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 4 | 4 |
census_date,eventDate,,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows: |
| 5 | 5 |
----- |
| inputs/SALVIAS-CSV/Plot/map.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS-CSV,VegCore,Filter,Comments |
| 2 | 2 |
project,projectName,, |
| 3 | 3 |
PLOT_ID,locationID,,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
| 4 |
plot_code,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 4 |
plot_code,locationName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 5 | 5 |
major_geo,continent,, |
| 6 | 6 |
country,country,, |
| 7 | 7 |
pol1,stateProvince,,Brad: No; pol1=stateProvince |
| inputs/SALVIAS-CSV/Plot/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
project,projectName,, |
| 2 |
plot_code,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 2 |
plot_code,locationName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 3 | 3 |
major_geo,continent,, |
| 4 | 4 |
pol1,stateProvince,,Brad: No; pol1=stateProvince |
| 5 | 5 |
pol2,county,,Brad: No pol2=countyParish |
| inputs/VegBank/plot_/map.csv | ||
|---|---|---|
| 1 | 1 |
VegBank,VegCore,Filter,Comments |
| 2 | 2 |
plot_id,locationID,, |
| 3 |
authorplotcode,plotName,,
|
|
| 3 |
authorplotcode,locationName,,
|
|
| 4 | 4 |
reference_id,*reference_id,, |
| 5 | 5 |
parent_id,parentLocationID,, |
| 6 | 6 |
locationaccuracy,coordinateUncertaintyInMeters,, |
| inputs/VegBank/plot_/new_terms.csv | ||
|---|---|---|
| 1 |
authorplotcode,plotName,,
|
|
| 1 |
authorplotcode,locationName,,
|
|
| 2 | 2 |
parent_id,parentLocationID,, |
| 3 | 3 |
locationaccuracy,coordinateUncertaintyInMeters,, |
| 4 | 4 |
confidentialitystatus,dcterms:accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription¶ms=1581>
|
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
referenceType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype", |
| 7 | 7 |
subplot,"/location/_if[@name=""if subplot""]/cond/_exists", |
| 8 | 8 |
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists", |
| 9 |
plotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
|
|
| 9 |
locationName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
|
|
| 10 | 10 |
locationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists", |
| 11 | 11 |
fieldNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else", |
| 12 | 12 |
occurrenceID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| ... | ... | |
| 21 | 21 |
geovalid,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
| 22 | 22 |
latLongInCountry,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
| 23 | 23 |
locationID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else", |
| 24 |
plotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
|
|
| 24 |
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
|
|
| 25 | 25 |
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 26 | 26 |
dcterms:accessRights,/location/accesslevel, |
| 27 | 27 |
plotArea_m2,/location/area_m2, |
| ... | ... | |
| 60 | 60 |
startDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists", |
| 61 | 61 |
subplotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/1", |
| 62 | 62 |
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/2", |
| 63 |
plotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
|
|
| 63 |
locationName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
|
|
| 64 | 64 |
subplotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/1", |
| 65 | 65 |
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/2", |
| 66 | 66 |
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| ... | ... | |
| 138 | 138 |
eventID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 139 | 139 |
fieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 140 | 140 |
locationID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 141 |
plotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
|
|
| 141 |
locationName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
|
|
| 142 | 142 |
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1", |
| 143 | 143 |
tag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 144 | 144 |
originalTaxonName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1", |
| ... | ... | |
| 388 | 388 |
subplotID,/location/sourceaccessioncode, |
| 389 | 389 |
subplot,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists", |
| 390 | 390 |
locationID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1", |
| 391 |
plotName,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",
|
|
| 391 |
locationName,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",
|
|
| 392 | 392 |
subplot,/location/sourceaccessioncode/_join/2, |
| 393 | 393 |
subplotX,/location/sublocationxposition_m, |
| 394 | 394 |
subplotY,/location/sublocationyposition_m, |
| mappings/VegCore.csv | ||
|---|---|---|
| 156 | 156 |
locality,,http://rs.tdwg.org/dwc/terms/#locality,68 |
| 157 | 157 |
locationAccordingTo,,http://rs.tdwg.org/dwc/terms/#locationAccordingTo,78 |
| 158 | 158 |
locationID,,http://rs.tdwg.org/dwc/terms/#locationID,56 |
| 159 |
locationName,,"http://rs.tdwg.org/dwc/terms/#locationID, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName","56, 1" |
|
| 159 | 160 |
locationRemarks,,http://rs.tdwg.org/dwc/terms/#locationRemarks,79 |
| 160 | 161 |
lowestBiostratigraphicZone,,http://rs.tdwg.org/dwc/terms/#lowestBiostratigraphicZone,111 |
| 161 | 162 |
maximumDepthInMeters,,http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,75 |
| ... | ... | |
| 342 | 343 |
plotArea_m2,Table added for clarity. Added units.,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/area,11 |
| 343 | 344 |
landform,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/landform,18 |
| 344 | 345 |
plotNotes,Table added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/note, http://rs.tdwg.org/dwc/terms/#fieldNotes","4, 54" |
| 345 |
plotName,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName,1 |
|
| 346 | 346 |
slopeAspect,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeAspect,15 |
| 347 | 347 |
slopeGradient,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeGradient,16 |
| 348 | 348 |
projectID,,"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" |
| mappings/Veg+-VegCore.csv | ||
|---|---|---|
| 44 | 44 |
shapeOfSite,footprintWKT,,CTFS#Site.ShapeOfSite, |
| 45 | 45 |
taxonFit,identificationQualifier,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=taxoninterpretation&entity=dba_tabledescription&where=where_tablename#taxonFit,12 |
| 46 | 46 |
descriptionOfSite,locality,,CTFS#Site.DescriptionOfSite, |
| 47 |
locationName,locality,,CTFS#Site.LocationName, |
|
| 48 | 47 |
locationNarrative,locality,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/locationNarrative,6 |
| 49 | 48 |
plotID,locationID,,"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/#occurrenceID",", 0" |
| 49 |
plotName,locationName,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName,1 |
|
| 50 | 50 |
maximumDepth,maximumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth,40 |
| 51 | 51 |
maximumElevation,maximumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumElevation,38 |
| 52 | 52 |
minimumDepth,minimumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumDepth,39 |
Also available in: Unified diff
mappings/VegCore.csv: Renamed plotName to locationName because this term also applies to the location of a specimen. This replaces CTFS's definition of locationName as locality.