Project

General

Profile

« Previous | Next » 

Revision 11725

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/CVS/plot_/map.csv: documented assumptions about the units and meaning of numeric codes for fields

View differences:

inputs/CVS/plot_/map.csv
7 7 
REPLACEMENTPLOT_ID,*REPLACEMENTPLOT_ID,,
8 8 
realLatitude,UNUSED#realLatitude,,
9 9 
realLongitude,UNUSED#realLongitude,,
10 
locationAccuracy,coordinateUncertaintyInMeters,/_alt/2,
11 
confidentialityStatus,accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
12 
confidentialityStatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
10 
locationAccuracy,coordinateUncertaintyInMeters,/_alt/2,assuming units are the same as VegBank's corresponding field (http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename&params=plot#locationAccuracy)
11 
confidentialityStatus,accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",assuming values are the same as VegBank's corresponding field (http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581)
12 
confidentialityStatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",assuming values are the same as VegBank's corresponding field (http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581)
13 13 
confidentialityFieldsBlocked,*confidentialityFieldsBlocked,,
14 14 
confidentialityReason,*confidentialityReason,,
15 15 
latitude,decimalLatitude,,
inputs/CVS/plot_/VegBIEN.csv
4 4 
PLOT_ID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
5 5 
authorPlotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 6 
PLOT_ID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
7 
confidentialityStatus,"/location/accesslevel/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
7 
confidentialityStatus,"/location/accesslevel/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",assuming values are the same as VegBank's corresponding field (http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581)
8 8 
area,/location/area_m2,"""Total area of the plot in m2"" (area definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename>)"
9 9 
elevation,/location/elevation_m/_alt/1,"""The elevation of the plot origin in meters above sea level"" (elevation definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename>)"
10 10 
locationNarrative,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
......
14 14 
PLOT_ID,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
15 15 
authorPlotCode,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
16 16 
locationNarrative,/location/locationnarrative/_merge/1,
17 
confidentialityStatus,"/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
18 
locationAccuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/2,
17 
confidentialityStatus,"/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",assuming values are the same as VegBank's corresponding field (http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581)
18 
locationAccuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/2,assuming units are the same as VegBank's corresponding field (http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename&params=plot#locationAccuracy)
19 19 
shape,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
20 20 
latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
21 21 
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
inputs/CVS/plot_/new_terms.csv
1 1 
PARENT_ID,parentLocationID,,
2 
locationAccuracy,coordinateUncertaintyInMeters,/_alt/2,
3 
confidentialityStatus,accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
4 
confidentialityStatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
2 
locationAccuracy,coordinateUncertaintyInMeters,/_alt/2,assuming units are the same as VegBank's corresponding field (http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename&params=plot#locationAccuracy)
3 
confidentialityStatus,accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",assuming values are the same as VegBank's corresponding field (http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581)
4 
confidentialityStatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",assuming values are the same as VegBank's corresponding field (http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581)
5 5 
shape,footprintWKT,,
6 6 
area|country|territory,country,,
7 7 
region|state|province,stateProvince,,

Also available in: Unified diff