Project

General

Profile

« Previous | Next » 

Revision 6678

Added by Aaron Marcuse-Kubitza over 11 years ago

mappings/VegCore.csv: Special values: Moved comments to Comments column

View differences:

mappings/VegCore.csv
115 115 
georeferenceSources,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(3:dcterms:Location)(41)georeferenceSources,
116 116 
georeferenceVerificationStatus,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(3:dcterms:Location)(42)georeferenceVerificationStatus,
117 117 
coordinatePrecision,Whether the coordinates are in the range of valid decimal values,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(3:dcterms:Location)(42)georeferenceVerificationStatus, (6)(0:BIEN2)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=(0)bien_web&table=observation&target=tbl_structure.php#(38)isValidLatLong",
118 
latLongDomainInvalid,Whether the coordinates are not in the range of valid decimal values,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(3:dcterms:Location)(42)georeferenceVerificationStatus, (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",
118 
latLongDomainInvalid,Whether the coordinates are _not_ in the range of valid decimal values,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(3:dcterms:Location)(42)georeferenceVerificationStatus, (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",
119 119 
geovalid,,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(3:dcterms:Location)(42)georeferenceVerificationStatus, (6)(0:BIEN2)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=(0)bien_web&table=observation&target=tbl_structure.php#(39)isGeovalid",
120 120 
georeferenceRemarks,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(3:dcterms:Location)(43)georeferenceRemarks,
121 121 
geologicalContextID,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(4:GeologicalContext)(00)geologicalContextID,
......
367 367 
observationMeasure,,"(6)(1:VegBIEN)http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?subject=table&server=localhost%3A5432%3Aallow&database=vegbien&schema=public&table=method#(10)observationmeasure, (0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(2:Event)(01)samplingProtocol",
368 368 
threatened,,(7:IUCN)http://www.iucnredlist.org/initiatives/europe/publications#The_IUCN_Red_List_of_Threatened_Species,
369 369 
speciesBinomial,genus+specificEpithet,"(8:Wikipedia)http://en.wikipedia.org/wiki/Binomial_nomenclature, (0:DwC)(2:Classic)http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/(12)Species",
370 
OMIT,Special value: The field contains data but is omitted. The reason for omission should be described in the mapping's comments.,,
371 
PRIVATE,Special value: The field contains private data which should be omitted from a public database,,
372 
UNUSED,Special value: The field does not contain any data. The following query should return no rows: SELECT * FROM table WHERE field IS NOT NULL,,
370 
OMIT,The field contains data but is omitted,,The reason for omission should be described in the mapping's comments
371 
PRIVATE,The field contains private data which should be omitted from a public database,,
372 
UNUSED,The field does not contain any data,,The following query should return no rows: SELECT * FROM table WHERE field IS NOT NULL
mappings/VegCore.redmine
476 476 

  		




  477
  477
  
    
h3. "latLongDomainInvalid":http://rs.tdwg.org/dwc/terms/#georeferenceVerificationStatus


  		




  478
  478
  
    

  		




  479
  
  
    
Whether the coordinates are not in the range of valid decimal values


  		




  
  479
  
    
Whether the coordinates are _not_ in the range of valid decimal values


  		




  480
  480
  
    

  		




  481
  481
  
    
|*Sources*|"DwC:georeferenceVerificationStatus":http://rs.tdwg.org/dwc/terms/#georeferenceVerificationStatus, "BIEN2:isValidLatLong":http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#isValidLatLong, "BIEN2:isBadLatLong":http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=geoscrub&table=geoscrub&target=tbl_structure.php#isBadLatLong|


  		




  482
  482
  
    

  		




  ......




  1558
  1558
  
    

  		




  1559
  1559
  
    
h3. OMIT


  		




  1560
  1560
  
    

  		




  1561
  
  
    
Special value: The field contains data but is omitted. The reason for omission should be described in the mapping's comments.


  		




  
  1561
  
    
The field contains data but is omitted


  		




  1562
  1562
  
    

  		




  
  1563
  
    
|*Comments*|The reason for omission should be described in the mapping's comments|


  		




  1563
  1564
  
    

  		




  1564
  1565
  
    
h3. PRIVATE


  		




  1565
  1566
  
    

  		




  1566
  
  
    
Special value: The field contains private data which should be omitted from a public database


  		




  
  1567
  
    
The field contains private data which should be omitted from a public database


  		




  1567
  1568
  
    

  		




  1568
  1569
  
    

  		




  1569
  1570
  
    
h3. UNUSED


  		




  1570
  1571
  
    

  		




  1571
  
  
    
Special value: The field does not contain any data. The following query should return no rows: SELECT * FROM table WHERE field IS NOT NULL


  		




  
  1572
  
    
The field does not contain any data


  		




  1572
  1573
  
    

  		




  
  1574
  
    
|*Comments*|The following query should return no rows: SELECT * FROM table WHERE field IS NOT NULL|


  		




  1573
  1575
  
    

  		












Also available in:  Unified diff