Revision 4847
Added by Aaron Marcuse-Kubitza over 12 years ago
| mappings/for_review/Veg+-VegCore.csv | ||
|---|---|---|
| 2 | 2 |
realLatitude,PRIVATE,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#realLatitude, |
| 3 | 3 |
realLongitude,PRIVATE,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#realLongitude, |
| 4 | 4 |
continentOcean,continent,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean,17 |
| 5 |
CountryName,country,,CTFS#Country.CountryName,
|
|
| 5 |
countryName,country,,CTFS#Country.CountryName,
|
|
| 6 | 6 |
collectedDate,dateCollected,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate,29 |
| 7 | 7 |
identifiedDate,dateIdentified,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#IdentifiedDate,21 |
| 8 | 8 |
julianDay,day,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/JulianDay,15 |
| ... | ... | |
| 17 | 17 |
type,dcterms:type,Versions without namespace,http://rs.tdwg.org/dwc/terms/#type,0 |
| 18 | 18 |
DBH,diameterBreastHeight,Table removed because term is unique,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_dbh,36 |
| 19 | 19 |
plotEventEndDate,endDate,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" |
| 20 |
CensusID,eventID,,CTFS#Census.CensusID,
|
|
| 20 |
censusID,eventID,,CTFS#Census.CensusID,
|
|
| 21 | 21 |
plotEventID,eventID,,"http://rs.tdwg.org/dwc/terms/#eventID, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename","41, " |
| 22 | 22 |
timeOfDay,eventTime,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/TimeOfDay,27 |
| 23 | 23 |
notes,fieldNotes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes,47 |
| 24 |
PlotCensusNumber,fieldNumber,,CTFS#Census.PlotCensusNumber, |
|
| 25 | 24 |
authorObsCode,fieldNumber,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#authorObsCode,4 |
| 26 |
ShapeOfSite,footprintWKT,,CTFS#Site.ShapeOfSite,
|
|
| 25 |
plotCensusNumber,fieldNumber,,CTFS#Census.PlotCensusNumber,
|
|
| 27 | 26 |
boundingBox,footprintWKT,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/BoundingBox,33 |
| 27 |
shapeOfSite,footprintWKT,,CTFS#Site.ShapeOfSite, |
|
| 28 | 28 |
taxonFit,identificationQualifier,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=taxoninterpretation&entity=dba_tabledescription&where=where_tablename#taxonFit,12 |
| 29 |
DescriptionOfSite,locality,,CTFS#Site.DescriptionOfSite,
|
|
| 30 |
LocationName,locality,,CTFS#Site.LocationName,
|
|
| 29 |
descriptionOfSite,locality,,CTFS#Site.DescriptionOfSite,
|
|
| 30 |
locationName,locality,,CTFS#Site.LocationName,
|
|
| 31 | 31 |
locationNarrative,locality,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/locationNarrative,6 |
| 32 | 32 |
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" |
| 33 | 33 |
maximumDepth,maximumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth,40 |
| 34 | 34 |
maximumElevation,maximumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumElevation,38 |
| 35 | 35 |
minimumDepth,minimumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumDepth,39 |
| 36 | 36 |
minimumElevation,minimumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumElevation,37 |
| 37 |
ID,occurrenceID,,"ACAD#id, MT#id, QMOR#id, U#ID", |
|
| 37 | 38 |
globalUniqueIdentifier,occurrenceID,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier,0 |
| 38 |
id,occurrenceID,,"ACAD#id, MT#id, QMOR#id, U#ID", |
|
| 39 | 39 |
relativePlotX,organismX,Table added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/relativePlotPosition/relativeX,801 |
| 40 | 40 |
relativePlotY,organismY,Table added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/relativePlotPosition/relativeY,802 |
| 41 | 41 |
previousCatalogNumber,otherCatalogNumbers,,"http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/PreviousCatalogNumber, http://rs.tdwg.org/dwc/terms/history/index.htm#PreviousCatalogNumber-2003-06-13","44, " |
| ... | ... | |
| 54 | 54 |
plotEventStartDate,startDate,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#obsStartDate",", 44, 5" |
| 55 | 55 |
state,stateProvince,,"NCU-NCSC#State, REMIB#state, UNCC#state", |
| 56 | 56 |
stem_id,stemID,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#stem_id,1 |
| 57 |
QuadratName,subplot,,CTFS#Quadrat.QuadratName,
|
|
| 58 |
QuadratID,subplotID,,CTFS#Quadrat.QuadratID,
|
|
| 59 |
StartX,subplotX,,CTFS#Quadrat.StartX,
|
|
| 60 |
StartY,subplotY,,CTFS#Quadrat.StartY,
|
|
| 57 |
quadratName,subplot,,CTFS#Quadrat.QuadratName,
|
|
| 58 |
quadratID,subplotID,,CTFS#Quadrat.QuadratID,
|
|
| 59 |
startX,subplotX,,CTFS#Quadrat.StartX,
|
|
| 60 |
startY,subplotY,,CTFS#Quadrat.StartY,
|
|
| 61 | 61 |
subSpeciesName,subspecies,,CTFS#SubSpecies.SubSpeciesName, |
| 62 | 62 |
stemTag,tag,Number removed for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_tag2, |
| 63 | 63 |
speciesInvID,taxonOccurrenceID,,CTFS#SpeciesInventory.SpeciesInvID, |
| 64 | 64 |
remarks,taxonRemarks,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks,65 |
| 65 |
Elevation,verbatimElevation,,CTFS#Site.Elevation,
|
|
| 65 |
elevation,verbatimElevation,,CTFS#Site.Elevation,
|
|
| 66 | 66 |
habit,verbatimGrowthForm,,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit,28 |
| 67 | 67 |
latitude,verbatimLatitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Latitude,34 |
| 68 | 68 |
longitude,verbatimLongitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Longitude,33 |
| mappings/Veg+-VegCore.csv | ||
|---|---|---|
| 2 | 2 |
realLatitude,PRIVATE,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#realLatitude, |
| 3 | 3 |
realLongitude,PRIVATE,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#realLongitude, |
| 4 | 4 |
continentOcean,continent,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean,17 |
| 5 |
CountryName,country,,CTFS#Country.CountryName,
|
|
| 5 |
countryName,country,,CTFS#Country.CountryName,
|
|
| 6 | 6 |
collectedDate,dateCollected,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate,29 |
| 7 | 7 |
identifiedDate,dateIdentified,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#IdentifiedDate,21 |
| 8 | 8 |
julianDay,day,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/JulianDay,15 |
| ... | ... | |
| 17 | 17 |
type,dcterms:type,Versions without namespace,http://rs.tdwg.org/dwc/terms/#type,0 |
| 18 | 18 |
DBH,diameterBreastHeight,Table removed because term is unique,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_dbh,36 |
| 19 | 19 |
plotEventEndDate,endDate,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" |
| 20 |
CensusID,eventID,,CTFS#Census.CensusID,
|
|
| 20 |
censusID,eventID,,CTFS#Census.CensusID,
|
|
| 21 | 21 |
plotEventID,eventID,,"http://rs.tdwg.org/dwc/terms/#eventID, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename","41, " |
| 22 | 22 |
timeOfDay,eventTime,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/TimeOfDay,27 |
| 23 | 23 |
notes,fieldNotes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes,47 |
| 24 |
PlotCensusNumber,fieldNumber,,CTFS#Census.PlotCensusNumber, |
|
| 25 | 24 |
authorObsCode,fieldNumber,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#authorObsCode,4 |
| 26 |
ShapeOfSite,footprintWKT,,CTFS#Site.ShapeOfSite,
|
|
| 25 |
plotCensusNumber,fieldNumber,,CTFS#Census.PlotCensusNumber,
|
|
| 27 | 26 |
boundingBox,footprintWKT,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/BoundingBox,33 |
| 27 |
shapeOfSite,footprintWKT,,CTFS#Site.ShapeOfSite, |
|
| 28 | 28 |
taxonFit,identificationQualifier,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=taxoninterpretation&entity=dba_tabledescription&where=where_tablename#taxonFit,12 |
| 29 |
DescriptionOfSite,locality,,CTFS#Site.DescriptionOfSite,
|
|
| 30 |
LocationName,locality,,CTFS#Site.LocationName,
|
|
| 29 |
descriptionOfSite,locality,,CTFS#Site.DescriptionOfSite,
|
|
| 30 |
locationName,locality,,CTFS#Site.LocationName,
|
|
| 31 | 31 |
locationNarrative,locality,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/locationNarrative,6 |
| 32 | 32 |
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" |
| 33 | 33 |
maximumDepth,maximumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth,40 |
| 34 | 34 |
maximumElevation,maximumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumElevation,38 |
| 35 | 35 |
minimumDepth,minimumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumDepth,39 |
| 36 | 36 |
minimumElevation,minimumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumElevation,37 |
| 37 |
ID,occurrenceID,,"ACAD#id, MT#id, QMOR#id, U#ID", |
|
| 37 | 38 |
globalUniqueIdentifier,occurrenceID,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier,0 |
| 38 |
id,occurrenceID,,"ACAD#id, MT#id, QMOR#id, U#ID", |
|
| 39 | 39 |
relativePlotX,organismX,Table added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/relativePlotPosition/relativeX,801 |
| 40 | 40 |
relativePlotY,organismY,Table added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/relativePlotPosition/relativeY,802 |
| 41 | 41 |
previousCatalogNumber,otherCatalogNumbers,,"http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/PreviousCatalogNumber, http://rs.tdwg.org/dwc/terms/history/index.htm#PreviousCatalogNumber-2003-06-13","44, " |
| ... | ... | |
| 54 | 54 |
plotEventStartDate,startDate,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#obsStartDate",", 44, 5" |
| 55 | 55 |
state,stateProvince,,"NCU-NCSC#State, REMIB#state, UNCC#state", |
| 56 | 56 |
stem_id,stemID,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#stem_id,1 |
| 57 |
QuadratName,subplot,,CTFS#Quadrat.QuadratName,
|
|
| 58 |
QuadratID,subplotID,,CTFS#Quadrat.QuadratID,
|
|
| 59 |
StartX,subplotX,,CTFS#Quadrat.StartX,
|
|
| 60 |
StartY,subplotY,,CTFS#Quadrat.StartY,
|
|
| 57 |
quadratName,subplot,,CTFS#Quadrat.QuadratName,
|
|
| 58 |
quadratID,subplotID,,CTFS#Quadrat.QuadratID,
|
|
| 59 |
startX,subplotX,,CTFS#Quadrat.StartX,
|
|
| 60 |
startY,subplotY,,CTFS#Quadrat.StartY,
|
|
| 61 | 61 |
subSpeciesName,subspecies,,CTFS#SubSpecies.SubSpeciesName, |
| 62 | 62 |
stemTag,tag,Number removed for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_tag2, |
| 63 | 63 |
speciesInvID,taxonOccurrenceID,,CTFS#SpeciesInventory.SpeciesInvID, |
| 64 | 64 |
remarks,taxonRemarks,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks,65 |
| 65 |
Elevation,verbatimElevation,,CTFS#Site.Elevation,
|
|
| 65 |
elevation,verbatimElevation,,CTFS#Site.Elevation,
|
|
| 66 | 66 |
habit,verbatimGrowthForm,,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit,28 |
| 67 | 67 |
latitude,verbatimLatitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Latitude,34 |
| 68 | 68 |
longitude,verbatimLongitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Longitude,33 |
Also available in: Unified diff
mappings/Veg+-VegCore.csv: Standardized the capitalization of names, by camel-casing each name except for acronyms and "ID", which are made all uppercase