Revision 6774
Added by Aaron Marcuse-Kubitza over 11 years ago
| mappings/VegCore.redmine | ||
|---|---|---|
| 1565 | 1565 |
|
| 1566 | 1566 |
|*Sources*|"SALVIAS:DB:stem_notes":http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#stem_notes| |
| 1567 | 1567 |
|
| 1568 |
h3. "sampleType":http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#observationType
|
|
| 1568 |
h3. "observationType":http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#observationType
|
|
| 1569 | 1569 |
|
| 1570 | 1570 |
|*Values*|plot, specimen| |
| 1571 |
|*Sources*|"BIEN2:observationType":http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#observationType, "DwC:samplingProtocol":http://rs.tdwg.org/dwc/terms/#samplingProtocol|
|
|
| 1571 |
|*Sources*|"BIEN2:observationType":http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#observationType| |
|
| 1572 | 1572 |
|
| 1573 | 1573 |
h3. "higherPlantGroup":http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#higherPlantGroup |
| 1574 | 1574 |
|
| inputs/NCU/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
NCU,VegCore,Filter,Comments |
| 2 | 2 |
:herbarium,referenceType,, |
| 3 |
:specimen,sampleType,, |
|
| 3 |
:specimen,observationType,, |
|
| inputs/TEAM/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
TEAM,VegCore,Filter,Comments |
| 2 | 2 |
:primary database,referenceType,, |
| 3 |
:plot,sampleType,, |
|
| 3 |
:plot,observationType,, |
|
| inputs/CTFS/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
CTFS,VegCore,Filter,Comments |
| 2 | 2 |
:primary database,referenceType,, |
| 3 |
:plot,sampleType,, |
|
| 3 |
:plot,observationType,, |
|
| inputs/SALVIAS/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegCore,Filter,Comments |
| 2 | 2 |
:aggregator,referenceType,, |
| 3 |
:plot,sampleType,, |
|
| 3 |
:plot,observationType,, |
|
| inputs/GBIF/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
GBIF,VegCore,Filter,Comments |
| 2 | 2 |
:aggregator,referenceType,, |
| 3 |
:specimen,sampleType,, |
|
| 3 |
:specimen,observationType,, |
|
| inputs/JBM/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
JBM,VegCore,Filter,Comments |
| 2 | 2 |
:herbarium,referenceType,, |
| 3 |
:specimen,sampleType,, |
|
| 3 |
:specimen,observationType,, |
|
| inputs/HIBG/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
HIBG,VegCore,Filter,Comments |
| 2 | 2 |
:herbarium,referenceType,, |
| 3 |
:specimen,sampleType,, |
|
| 3 |
:specimen,observationType,, |
|
| inputs/SpeciesLink/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
SpeciesLink,VegCore,Filter,Comments |
| 2 | 2 |
:aggregator,referenceType,, |
| 3 |
:specimen,sampleType,, |
|
| 3 |
:specimen,observationType,, |
|
| inputs/bien_web/observation/map.csv | ||
|---|---|---|
| 4 | 4 |
dataSourceName,institutionCode,, |
| 5 | 5 |
dataSourceNamePrimary,*dataSourceNamePrimary,, |
| 6 | 6 |
plotID,locationID,, |
| 7 |
observationType,*observationType,,
|
|
| 7 |
observationType,observationType,, |
|
| 8 | 8 |
bien2_taxonomyID,*bien2_taxonomyID,, |
| 9 | 9 |
bien2_DBPlotID,*bien2_DBPlotID,, |
| 10 | 10 |
bien2_ObservationID,*bien2_ObservationID,, |
| inputs/bien_web/observation/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
bien_web,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
observationID,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 | 3 |
dataSourceName,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 4 |
observationType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype", |
|
| 4 | 5 |
plotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1", |
| 5 | 6 |
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists", |
| 7 |
observationType,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left", |
|
| 6 | 8 |
observationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 7 | 9 |
observationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists", |
| 8 | 10 |
dataSourceName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then", |
| ... | ... | |
| 108 | 110 |
isValidLatLong_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 109 | 111 |
localityDescription,,** No join mapping for *localityDescription ** |
| 110 | 112 |
observationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 111 |
observationType,,** No join mapping for *observationType ** |
|
| 112 | 113 |
observationType_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 113 | 114 |
plotAreaHa_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 114 | 115 |
plotCode_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| inputs/bien_web/observation/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
*dataSourceID |
| 2 | 2 |
*dataSourceNamePrimary |
| 3 |
*observationType |
|
| 4 | 3 |
*bien2_taxonomyID |
| 5 | 4 |
*bien2_DBPlotID |
| 6 | 5 |
*bien2_ObservationID |
| inputs/Madidi/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
Madidi,VegCore,Filter,Comments |
| 2 | 2 |
:primary database,referenceType,, |
| 3 |
:plot,sampleType,, |
|
| 3 |
:plot,observationType,, |
|
| inputs/CVS/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
CVS,VegCore,Filter,Comments |
| 2 | 2 |
:primary database,referenceType,, |
| 3 |
:plot,sampleType,, |
|
| 3 |
:plot,observationType,, |
|
| inputs/CVS/taxonObservation_/map.csv | ||
|---|---|---|
| 107 | 107 |
Subspecies,subspecies,, |
| 108 | 108 |
Variety,variety,, |
| 109 | 109 |
Forma,forma,, |
| 110 |
:plot,sampleType,, |
|
| 110 |
:plot,observationType,, |
|
| inputs/.herbaria/herbaria/map.csv | ||
|---|---|---|
| 16 | 16 |
Index_countryStd_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation |
| 17 | 17 |
Index_countryID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation |
| 18 | 18 |
:herbarium,referenceType,, |
| 19 |
:specimen,sampleType,, |
|
| 19 |
:specimen,observationType,, |
|
| inputs/SALVIAS-CSV/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS-CSV,VegCore,Filter,Comments |
| 2 | 2 |
:aggregator,referenceType,, |
| 3 |
:plot,sampleType,, |
|
| 3 |
:plot,observationType,, |
|
| inputs/REMIB/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
REMIB,VegCore,Filter,Comments |
| 2 | 2 |
:aggregator,referenceType,, |
| 3 |
:specimen,sampleType,, |
|
| 3 |
:specimen,observationType,, |
|
| inputs/FIA/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
FIA,VegCore,Filter,Comments |
| 2 | 2 |
:primary database,referenceType,, |
| 3 |
:plot,sampleType,, |
|
| 3 |
:plot,observationType,, |
|
| inputs/NVS/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
NVS,VegCore,Filter,Comments |
| 2 | 2 |
:primary database,referenceType,, |
| 3 |
:plot,sampleType,, |
|
| 3 |
:plot,observationType,, |
|
| inputs/VASCAN/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
VASCAN,VegCore,Filter,Comments |
| 2 | 2 |
:herbarium,referenceType,, |
| 3 |
:specimen,sampleType,, |
|
| 3 |
:specimen,observationType,, |
|
| inputs/VegBank/Source/map.csv | ||
|---|---|---|
| 1 | 1 |
VegBank,VegCore,Filter,Comments |
| 2 | 2 |
:aggregator,referenceType,, |
| 3 |
:plot,sampleType,, |
|
| 3 |
:plot,observationType,, |
|
| inputs/VegBank/taxonobservation_/map.csv | ||
|---|---|---|
| 76 | 76 |
Subspecies,subspecies,, |
| 77 | 77 |
Variety,variety,, |
| 78 | 78 |
Forma,forma,, |
| 79 |
:plot,sampleType,, |
|
| 79 |
:plot,observationType,, |
|
| mappings/VegCore.csv | ||
|---|---|---|
| 350 | 350 |
stemID,,,(4:SALVIAS)(1:DB)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#(01)stem_id,, |
| 351 | 351 |
diameterBreastHeightGentry,,,(4:SALVIAS)(1:DB)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#(07)gentry_dbh,,Expanded for clarity |
| 352 | 352 |
stemNotes,,,(4:SALVIAS)(1:DB)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#(08)stem_notes,, |
| 353 |
sampleType,,"plot, specimen","(6)(0:BIEN2)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=(0)bien_web&table=observation&target=tbl_structure.php#(06)observationType, (0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(2:Event)(01)samplingProtocol",,
|
|
| 353 |
observationType,,"plot, specimen",(6)(0:BIEN2)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=(0)bien_web&table=observation&target=tbl_structure.php#(06)observationType,,
|
|
| 354 | 354 |
higherPlantGroup,,,"(6)(0:BIEN2)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=(0)bien_web&table=observation&target=tbl_structure.php#(12)higherPlantGroup, (0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(6:Taxon)(15)higherClassification",, |
| 355 | 355 |
latLongDomainValid,Whether the coordinates are in the range of valid decimal values,,(6)(0:BIEN2)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=(0)bien_web&table=observation&target=tbl_structure.php#(38)isValidLatLong,, |
| 356 | 356 |
latLongDomainInvalid,Whether the coordinates are _not_ in the range of valid decimal values,,"(6)(0:BIEN2)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=(0)bien_web&table=observation&target=tbl_structure.php#(38)isValidLatLong, (6)(0:BIEN2)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=(2)geoscrub&table=geoscrub&target=tbl_structure.php#(21)isBadLatLong",, |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 | 3 |
occurrenceID,"/_if[@name=""if specimen""]/cond/_exists", |
| 4 | 4 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 5 |
sampleType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
|
|
| 5 |
observationType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
|
|
| 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 | 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 |
sampleType,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
|
|
| 12 |
observationType,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
|
|
| 13 | 13 |
occurrenceID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 14 | 14 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| 15 | 15 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists", |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 | 3 |
occurrenceID,"/_if[@name=""if specimen""]/cond/_exists", |
| 4 | 4 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname", |
| 5 |
sampleType,"/_if[@name=""if specimen""]/else/source/sampletype",
|
|
| 5 |
observationType,"/_if[@name=""if specimen""]/else/source/sampletype",
|
|
| 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 | 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 |
sampleType,"/location/authorlocationcode/_if[@name=""if plot""]/cond",
|
|
| 12 |
observationType,"/location/authorlocationcode/_if[@name=""if plot""]/cond",
|
|
| 13 | 13 |
occurrenceID,"/location/authorlocationcode/_if[@name=""if plot""]/else", |
| 14 | 14 |
catalogNumber,"/location/authorlocationcode/_if[@name=""if catalogNumber""]/cond/_exists", |
| 15 | 15 |
catalogNumber,"/location/authorlocationcode/_if[@name=""if specimen""]/cond/_exists", |
Also available in: Unified diff
mappings/VegCore.csv: Renamed sampleType to observationType to match the SALVIAS term it's derived from