Project

General

Profile

« Previous | Next » 

Revision 6774

mappings/VegCore.csv: Renamed sampleType to observationType to match the SALVIAS term it's derived from

View differences:

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,,
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/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