Revision 4579
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/CVS/Organism/map.csv | ||
|---|---|---|
| 1 | 1 |
CVS,Veg+,Comments |
| 2 | 2 |
authorObsCode,fieldNumber, |
| 3 | 3 |
obsStartDate,plotEventStartDate, |
| 4 |
realLatitude,decimalLatitude/_alt/1,
|
|
| 5 |
realLongitude,decimalLongitude/_alt/1,
|
|
| 4 |
realLatitude,OMIT,
|
|
| 5 |
realLongitude,OMIT,
|
|
| 6 | 6 |
locationAccuracy-m,coordinateUncertaintyInMeters, |
| 7 |
publicLatitude,decimalLatitude/_alt/2,
|
|
| 8 |
publicLongitude,decimalLongitude/_alt/2,
|
|
| 7 |
publicLatitude,decimalLatitude, |
|
| 8 |
publicLongitude,decimalLongitude, |
|
| 9 | 9 |
confidentialityStatus,, |
| 10 | 10 |
state,stateProvince, |
| 11 | 11 |
county,county, |
| inputs/CVS/Organism/map.full.csv | ||
|---|---|---|
| 1 | 1 |
CVS,Veg+,Comments |
| 2 |
realLatitude,OMIT, |
|
| 3 |
realLongitude,OMIT, |
|
| 2 | 4 |
locationAccuracy-m,coordinateUncertaintyInMeters, |
| 3 | 5 |
county,county, |
| 4 | 6 |
%cover,coverPercent, |
| 5 |
realLatitude,decimalLatitude/_alt/1, |
|
| 6 |
publicLatitude,decimalLatitude/_alt/2, |
|
| 7 |
realLongitude,decimalLongitude/_alt/1, |
|
| 8 |
publicLongitude,decimalLongitude/_alt/2, |
|
| 7 |
publicLatitude,decimalLatitude, |
|
| 8 |
publicLongitude,decimalLongitude, |
|
| 9 | 9 |
authorObsCode,fieldNumber, |
| 10 | 10 |
obsStartDate,plotEventStartDate, |
| 11 | 11 |
currentTaxonName sec Weakley 2006,scientificName, |
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
CVS,VegBIEN:,Comments |
| 2 | 2 |
authorObsCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else", |
| 3 | 3 |
locationAccuracy-m,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1, |
| 4 |
realLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/1", |
|
| 5 |
publicLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2", |
|
| 6 |
realLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/1", |
|
| 7 |
publicLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2", |
|
| 4 |
publicLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 5 |
publicLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 8 | 6 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 9 | 7 |
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 10 | 8 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode", |
| ... | ... | |
| 14 | 12 |
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 15 | 13 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
| 16 | 14 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname", |
| 15 |
realLatitude,,** No join mapping for OMIT ** |
|
| 16 |
realLongitude,,** No join mapping for OMIT ** |
|
| inputs/CVS/Organism/test.xml.ref | ||
|---|---|---|
| 8 | 8 |
<_nullIf> |
| 9 | 9 |
<null>0</null> |
| 10 | 10 |
<type>float</type> |
| 11 |
<value> |
|
| 12 |
<_alt> |
|
| 13 |
<1>$realLatitude</1> |
|
| 14 |
<2>$publicLatitude</2> |
|
| 15 |
</_alt> |
|
| 16 |
</value> |
|
| 11 |
<value>$publicLatitude</value> |
|
| 17 | 12 |
</_nullIf> |
| 18 | 13 |
</latitude> |
| 19 | 14 |
<longitude> |
| 20 | 15 |
<_nullIf> |
| 21 | 16 |
<null>0</null> |
| 22 | 17 |
<type>float</type> |
| 23 |
<value> |
|
| 24 |
<_alt> |
|
| 25 |
<1>$realLongitude</1> |
|
| 26 |
<2>$publicLongitude</2> |
|
| 27 |
</_alt> |
|
| 28 |
</value> |
|
| 18 |
<value>$publicLongitude</value> |
|
| 29 | 19 |
</_nullIf> |
| 30 | 20 |
</longitude> |
| 31 | 21 |
<namedplace_id> |
Also available in: Unified diff
inputs/CVS/Organism/map.csv: Omit realLatitude/realLongitude because private data should not be placed in a public database. Keeping VegBIEN free of restricted-access data allows anyone to run arbitrary queries on the database, without needing an entire security mechanism/front end just to manage users' read-only access to the data (as VegBank has). Note that the private coordinates are still accessible in the staging tables, so they will need to be locked down in order to make VegBIEN secure to public access.