Revision 673
Added by Aaron Marcuse-Kubitza almost 13 years ago
| test/accepted_output/SALVIAS.organisms.VegBIEN.xml | ||
|---|---|---|
| 19 | 19 |
<aggregateoccurrence> |
| 20 | 20 |
<count>1</count> |
| 21 | 21 |
<plantobservation> |
| 22 |
<stem> |
|
| 22 |
<stemobservation>
|
|
| 23 | 23 |
<authorstemcode>8</authorstemcode> |
| 24 | 24 |
<diameter>662</diameter> |
| 25 |
</stem> |
|
| 25 |
</stemobservation>
|
|
| 26 | 26 |
<authorplantcode>607771</authorplantcode> |
| 27 | 27 |
</plantobservation> |
| 28 | 28 |
</aggregateoccurrence> |
| ... | ... | |
| 188 | 188 |
<aggregateoccurrence> |
| 189 | 189 |
<count>1</count> |
| 190 | 190 |
<plantobservation> |
| 191 |
<stem> |
|
| 191 |
<stemobservation>
|
|
| 192 | 192 |
<authorstemcode>91</authorstemcode> |
| 193 | 193 |
<diameter>215</diameter> |
| 194 |
</stem> |
|
| 194 |
</stemobservation>
|
|
| 195 | 195 |
<authorplantcode>607722</authorplantcode> |
| 196 | 196 |
</plantobservation> |
| 197 | 197 |
</aggregateoccurrence> |
| test/accepted_output/NYBG.organisms.VegBIEN.xml | ||
|---|---|---|
| 41 | 41 |
</locationevent_id> |
| 42 | 42 |
<aggregateoccurrence> |
| 43 | 43 |
<plantobservation> |
| 44 |
<stem> |
|
| 44 |
<stemobservation>
|
|
| 45 | 45 |
<definedvalue fkey="tableRecord_ID"> |
| 46 | 46 |
<userdefined_id> |
| 47 | 47 |
<userdefined> |
| 48 |
<tablename>stem</tablename> |
|
| 48 |
<tablename>stemobservation</tablename>
|
|
| 49 | 49 |
<userdefinedname>habitat</userdefinedname> |
| 50 | 50 |
</userdefined> |
| 51 | 51 |
</userdefined_id> |
| ... | ... | |
| 54 | 54 |
<definedvalue fkey="tableRecord_ID"> |
| 55 | 55 |
<userdefined_id> |
| 56 | 56 |
<userdefined> |
| 57 |
<tablename>stem</tablename> |
|
| 57 |
<tablename>stemobservation</tablename>
|
|
| 58 | 58 |
<userdefinedname>plantFungusDescription</userdefinedname> |
| 59 | 59 |
</userdefined> |
| 60 | 60 |
</userdefined_id> |
| 61 | 61 |
<definedvalue>with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</definedvalue> |
| 62 | 62 |
</definedvalue> |
| 63 |
</stem> |
|
| 63 |
</stemobservation>
|
|
| 64 | 64 |
<authorplantcode>816590</authorplantcode> |
| 65 | 65 |
</plantobservation> |
| 66 | 66 |
</aggregateoccurrence> |
| inputs/NYBG/test/VegBIEN.xml.ref | ||
|---|---|---|
| 41 | 41 |
</locationevent_id> |
| 42 | 42 |
<aggregateoccurrence> |
| 43 | 43 |
<plantobservation> |
| 44 |
<stem> |
|
| 44 |
<stemobservation>
|
|
| 45 | 45 |
<definedvalue fkey="tableRecord_ID"> |
| 46 | 46 |
<userdefined_id> |
| 47 | 47 |
<userdefined> |
| 48 |
<tablename>stem</tablename> |
|
| 48 |
<tablename>stemobservation</tablename>
|
|
| 49 | 49 |
<userdefinedname>habitat</userdefinedname> |
| 50 | 50 |
</userdefined> |
| 51 | 51 |
</userdefined_id> |
| ... | ... | |
| 54 | 54 |
<definedvalue fkey="tableRecord_ID"> |
| 55 | 55 |
<userdefined_id> |
| 56 | 56 |
<userdefined> |
| 57 |
<tablename>stem</tablename> |
|
| 57 |
<tablename>stemobservation</tablename>
|
|
| 58 | 58 |
<userdefinedname>plantFungusDescription</userdefinedname> |
| 59 | 59 |
</userdefined> |
| 60 | 60 |
</userdefined_id> |
| 61 | 61 |
<definedvalue>with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</definedvalue> |
| 62 | 62 |
</definedvalue> |
| 63 |
</stem> |
|
| 63 |
</stemobservation>
|
|
| 64 | 64 |
<authorplantcode>816590 </authorplantcode> |
| 65 | 65 |
</plantobservation> |
| inputs/NYBG/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 15 | 15 |
YearCollected,/*_id/locationevent/obsstartdate/_date/year, |
| 16 | 16 |
MaximumDepth,/*_id/locationevent/waterdepth/max, |
| 17 | 17 |
MinimumDepth,/*_id/locationevent/waterdepth/min, |
| 18 |
Habitat,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=habitat]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
|
|
| 19 |
PlantFungusDescription,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect mapping to VB, also possibly to VX; this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
|
|
| 20 |
Substrate,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=substrate]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
|
|
| 21 |
Vegetation,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?"
|
|
| 18 |
Habitat,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=habitat]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
|
|
| 19 |
PlantFungusDescription,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect mapping to VB, also possibly to VX; this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
|
|
| 20 |
Substrate,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=substrate]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
|
|
| 21 |
Vegetation,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=vegetation]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?"
|
|
| 22 | 22 |
FieldNumber,/specimenreplicate:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?" |
| 23 | 23 |
CollectorNumber,/specimenreplicate:[*_id/reference]/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX" |
| 24 | 24 |
Collector,/specimenreplicate:[*_id/reference]/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen? |
| inputs/SALVIAS/maps/VegBIEN.stems.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS:stems,VegBIEN:/stem,Comments |
| 2 |
PlotObsID,/*_id/plantobservation/authorplantcode, |
|
| 3 |
NoInd,/*_id/plantobservation/stemcount, |
|
| 4 |
stem_tag2,/authorstemcode/_alt/1, |
|
| 5 |
stem_tag1,/authorstemcode/_alt/2, |
|
| 6 |
basal_diam,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 7 |
gentry_dbh,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=gentryDiameter]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 8 |
stem_notes,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 9 |
stem_canopy_form,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyForm]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 10 |
stem_canopy_position,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyPosition]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 11 |
stem_height_first_branch_m,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemHeightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 12 |
stem_liana_infestation,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemLianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 13 |
stem_dbh,/diameter, |
|
| 14 |
stem_height_m,/height, |
|
| inputs/SALVIAS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 4 | 4 |
cover_percent,/aggregateoccurrence/cover, |
| 5 | 5 |
intercept_cm,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance." |
| 6 | 6 |
height_m,/aggregateoccurrence/plantobservation/overallheight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob |
| 7 |
tag2,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other." |
|
| 8 |
tag1,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
|
| 9 |
ht_first_branch_m,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 10 |
temp_dbh,/aggregateoccurrence/plantobservation/stem/diameter, |
|
| 11 |
x_position,/aggregateoccurrence/plantobservation/stem/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX." |
|
| 12 |
y_position,/aggregateoccurrence/plantobservation/stem/yposition,Brad: See comment above for x_position |
|
| 7 |
tag2,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
|
|
| 8 |
tag1,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
|
|
| 9 |
ht_first_branch_m,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 10 |
temp_dbh,/aggregateoccurrence/plantobservation/stemobservation/diameter,
|
|
| 11 |
x_position,/aggregateoccurrence/plantobservation/stemobservation/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."
|
|
| 12 |
y_position,/aggregateoccurrence/plantobservation/stemobservation/yposition,Brad: See comment above for x_position
|
|
| 13 | 13 |
census_no,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 14 | 14 |
Habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 15 | 15 |
Ind,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 257 | 257 |
CONSTRAINT plantobservation_aggregateoccurrence_id_1_to_1 UNIQUE (aggregateoccurrence_id ) |
| 258 | 258 |
); |
| 259 | 259 |
|
| 260 |
CREATE TABLE stem -- VegBank's stemlocation table. |
|
| 260 |
CREATE TABLE stemobservation -- VegBank's stemlocation table.
|
|
| 261 | 261 |
( |
| 262 |
stem_id int(11) NOT NULL AUTO_INCREMENT, |
|
| 262 |
stemobservation_id int(11) NOT NULL AUTO_INCREMENT,
|
|
| 263 | 263 |
plantobservation_id int(11) NOT NULL, |
| 264 | 264 |
authorstemcode character varying(20), |
| 265 | 265 |
xposition double precision, |
| 266 | 266 |
yposition double precision, |
| 267 | 267 |
health character varying(50), |
| 268 |
emb_stem int(11), |
|
| 268 |
emb_stemobservation int(11),
|
|
| 269 | 269 |
diameter double precision, |
| 270 | 270 |
height double precision, |
| 271 | 271 |
heightaccuracy double precision, |
| ... | ... | |
| 273 | 273 |
accessioncode character varying(255), |
| 274 | 274 |
diameteraccuracy double precision, |
| 275 | 275 |
sourceaccessioncode character varying(100), |
| 276 |
CONSTRAINT stem_pkey PRIMARY KEY (stem_id ),
|
|
| 277 |
CONSTRAINT stem_plantobservation_id FOREIGN KEY (plantobservation_id) |
|
| 276 |
CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id ),
|
|
| 277 |
CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id)
|
|
| 278 | 278 |
REFERENCES plantobservation (plantobservation_id) MATCH SIMPLE |
| 279 | 279 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 280 |
CONSTRAINT stem_keys_accessioncode UNIQUE (plantobservation_id , sourceaccessioncode ), |
|
| 281 |
CONSTRAINT stem_keys_code UNIQUE (plantobservation_id , authorstemcode ) |
|
| 280 |
CONSTRAINT stemobservation_keys_accessioncode UNIQUE (plantobservation_id , sourceaccessioncode ),
|
|
| 281 |
CONSTRAINT stemobservation_keys_code UNIQUE (plantobservation_id , authorstemcode )
|
|
| 282 | 282 |
); |
| 283 | 283 |
|
| 284 | 284 |
CREATE TABLE specimen -- A physical specimen collected from a plant. Used to link replicates of the same specimen together. |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 74 | 74 |
sourceaccessioncode character varying(100), |
| 75 | 75 |
); |
| 76 | 76 |
|
| 77 |
CREATE TABLE stem -- VegBank's stemlocation table. |
|
| 77 |
CREATE TABLE stemobservation -- VegBank's stemlocation table.
|
|
| 78 | 78 |
( |
| 79 |
stem_id serial NOT NULL, |
|
| 79 |
stemobservation_id serial NOT NULL,
|
|
| 80 | 80 |
plantobservation_id integer NOT NULL, |
| 81 | 81 |
authorstemcode character varying(20), |
| 82 | 82 |
xposition double precision, |
| 83 | 83 |
yposition double precision, |
| 84 | 84 |
health character varying(50), |
| 85 |
emb_stem integer, |
|
| 85 |
emb_stemobservation integer,
|
|
| 86 | 86 |
diameter double precision, |
| 87 | 87 |
height double precision, |
| 88 | 88 |
heightaccuracy double precision, |
| schemas/vegbien_empty.sql | ||
|---|---|---|
| 61 | 61 |
TRUNCATE soiltaxon CASCADE; |
| 62 | 62 |
TRUNCATE specimen CASCADE; |
| 63 | 63 |
TRUNCATE specimenreplicate CASCADE; |
| 64 |
TRUNCATE stem CASCADE; |
|
| 64 |
TRUNCATE stemobservation CASCADE;
|
|
| 65 | 65 |
TRUNCATE stratum CASCADE; |
| 66 | 66 |
TRUNCATE stratummethod CASCADE; |
| 67 | 67 |
TRUNCATE stratumtype CASCADE; |
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 257 | 257 |
CONSTRAINT plantobservation_aggregateoccurrence_id_1_to_1 UNIQUE (aggregateoccurrence_id ) |
| 258 | 258 |
); |
| 259 | 259 |
|
| 260 |
CREATE TABLE stem -- VegBank's stemlocation table. |
|
| 260 |
CREATE TABLE stemobservation -- VegBank's stemlocation table.
|
|
| 261 | 261 |
( |
| 262 |
stem_id serial NOT NULL, |
|
| 262 |
stemobservation_id serial NOT NULL,
|
|
| 263 | 263 |
plantobservation_id integer NOT NULL, |
| 264 | 264 |
authorstemcode character varying(20), |
| 265 | 265 |
xposition double precision, |
| 266 | 266 |
yposition double precision, |
| 267 | 267 |
health character varying(50), |
| 268 |
emb_stem integer, |
|
| 268 |
emb_stemobservation integer,
|
|
| 269 | 269 |
diameter double precision, |
| 270 | 270 |
height double precision, |
| 271 | 271 |
heightaccuracy double precision, |
| ... | ... | |
| 273 | 273 |
accessioncode character varying(255), |
| 274 | 274 |
diameteraccuracy double precision, |
| 275 | 275 |
sourceaccessioncode character varying(100), |
| 276 |
CONSTRAINT stem_pkey PRIMARY KEY (stem_id ),
|
|
| 277 |
CONSTRAINT stem_plantobservation_id FOREIGN KEY (plantobservation_id) |
|
| 276 |
CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id ),
|
|
| 277 |
CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id)
|
|
| 278 | 278 |
REFERENCES plantobservation (plantobservation_id) MATCH SIMPLE |
| 279 | 279 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 280 |
CONSTRAINT stem_keys_accessioncode UNIQUE (plantobservation_id , sourceaccessioncode ), |
|
| 281 |
CONSTRAINT stem_keys_code UNIQUE (plantobservation_id , authorstemcode ) |
|
| 280 |
CONSTRAINT stemobservation_keys_accessioncode UNIQUE (plantobservation_id , sourceaccessioncode ),
|
|
| 281 |
CONSTRAINT stemobservation_keys_code UNIQUE (plantobservation_id , authorstemcode )
|
|
| 282 | 282 |
); |
| 283 | 283 |
|
| 284 | 284 |
CREATE TABLE specimen -- A physical specimen collected from a plant. Used to link replicates of the same specimen together. |
| schemas/vegbien.sql | ||
|---|---|---|
| 2357 | 2357 |
SET default_with_oids = true; |
| 2358 | 2358 |
|
| 2359 | 2359 |
-- |
| 2360 |
-- Name: stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2360 |
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2361 | 2361 |
-- |
| 2362 | 2362 |
|
| 2363 |
CREATE TABLE stem ( |
|
| 2364 |
stem_id integer NOT NULL, |
|
| 2363 |
CREATE TABLE stemobservation (
|
|
| 2364 |
stemobservation_id integer NOT NULL,
|
|
| 2365 | 2365 |
plantobservation_id integer NOT NULL, |
| 2366 | 2366 |
authorstemcode character varying(20), |
| 2367 | 2367 |
xposition double precision, |
| 2368 | 2368 |
yposition double precision, |
| 2369 | 2369 |
health character varying(50), |
| 2370 |
emb_stem integer, |
|
| 2370 |
emb_stemobservation integer,
|
|
| 2371 | 2371 |
diameter double precision, |
| 2372 | 2372 |
height double precision, |
| 2373 | 2373 |
heightaccuracy double precision, |
| ... | ... | |
| 2379 | 2379 |
|
| 2380 | 2380 |
|
| 2381 | 2381 |
-- |
| 2382 |
-- Name: TABLE stem; Type: COMMENT; Schema: public; Owner: - |
|
| 2382 |
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
|
|
| 2383 | 2383 |
-- |
| 2384 | 2384 |
|
| 2385 |
COMMENT ON TABLE stem IS 'VegBank''s stemlocation table.'; |
|
| 2385 |
COMMENT ON TABLE stemobservation IS 'VegBank''s stemlocation table.';
|
|
| 2386 | 2386 |
|
| 2387 | 2387 |
|
| 2388 | 2388 |
-- |
| 2389 |
-- Name: stem_stem_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2389 |
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2390 | 2390 |
-- |
| 2391 | 2391 |
|
| 2392 |
CREATE SEQUENCE stem_stem_id_seq
|
|
| 2392 |
CREATE SEQUENCE stemobservation_stemobservation_id_seq
|
|
| 2393 | 2393 |
START WITH 1 |
| 2394 | 2394 |
INCREMENT BY 1 |
| 2395 | 2395 |
NO MINVALUE |
| ... | ... | |
| 2398 | 2398 |
|
| 2399 | 2399 |
|
| 2400 | 2400 |
-- |
| 2401 |
-- Name: stem_stem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2401 |
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2402 | 2402 |
-- |
| 2403 | 2403 |
|
| 2404 |
ALTER SEQUENCE stem_stem_id_seq OWNED BY stem.stem_id;
|
|
| 2404 |
ALTER SEQUENCE stemobservation_stemobservation_id_seq OWNED BY stemobservation.stemobservation_id;
|
|
| 2405 | 2405 |
|
| 2406 | 2406 |
|
| 2407 | 2407 |
-- |
| ... | ... | |
| 2767 | 2767 |
|
| 2768 | 2768 |
CREATE TABLE trait ( |
| 2769 | 2769 |
trait_id integer NOT NULL, |
| 2770 |
stem_id integer NOT NULL, |
|
| 2770 |
stemobservation_id integer NOT NULL,
|
|
| 2771 | 2771 |
type character varying(255) NOT NULL, |
| 2772 | 2772 |
value character varying(255) |
| 2773 | 2773 |
); |
| ... | ... | |
| 3661 | 3661 |
|
| 3662 | 3662 |
|
| 3663 | 3663 |
-- |
| 3664 |
-- Name: stem_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3664 |
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3665 | 3665 |
-- |
| 3666 | 3666 |
|
| 3667 |
ALTER TABLE stem ALTER COLUMN stem_id SET DEFAULT nextval('stem_stem_id_seq'::regclass);
|
|
| 3667 |
ALTER TABLE stemobservation ALTER COLUMN stemobservation_id SET DEFAULT nextval('stemobservation_stemobservation_id_seq'::regclass);
|
|
| 3668 | 3668 |
|
| 3669 | 3669 |
|
| 3670 | 3670 |
-- |
| ... | ... | |
| 4470 | 4470 |
|
| 4471 | 4471 |
|
| 4472 | 4472 |
-- |
| 4473 |
-- Name: stem_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4473 |
-- Name: stemobservation_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4474 | 4474 |
-- |
| 4475 | 4475 |
|
| 4476 |
ALTER TABLE ONLY stem |
|
| 4477 |
ADD CONSTRAINT stem_keys_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode); |
|
| 4476 |
ALTER TABLE ONLY stemobservation
|
|
| 4477 |
ADD CONSTRAINT stemobservation_keys_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode);
|
|
| 4478 | 4478 |
|
| 4479 | 4479 |
|
| 4480 | 4480 |
-- |
| 4481 |
-- Name: stem_keys_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4481 |
-- Name: stemobservation_keys_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4482 | 4482 |
-- |
| 4483 | 4483 |
|
| 4484 |
ALTER TABLE ONLY stem |
|
| 4485 |
ADD CONSTRAINT stem_keys_code UNIQUE (plantobservation_id, authorstemcode); |
|
| 4484 |
ALTER TABLE ONLY stemobservation
|
|
| 4485 |
ADD CONSTRAINT stemobservation_keys_code UNIQUE (plantobservation_id, authorstemcode);
|
|
| 4486 | 4486 |
|
| 4487 | 4487 |
|
| 4488 | 4488 |
-- |
| 4489 |
-- Name: stem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4489 |
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4490 | 4490 |
-- |
| 4491 | 4491 |
|
| 4492 |
ALTER TABLE ONLY stem |
|
| 4493 |
ADD CONSTRAINT stem_pkey PRIMARY KEY (stem_id);
|
|
| 4492 |
ALTER TABLE ONLY stemobservation
|
|
| 4493 |
ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
|
|
| 4494 | 4494 |
|
| 4495 | 4495 |
|
| 4496 | 4496 |
-- |
| ... | ... | |
| 5037 | 5037 |
|
| 5038 | 5038 |
|
| 5039 | 5039 |
-- |
| 5040 |
-- Name: emb_stem_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5040 |
-- Name: emb_stemobservation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5041 | 5041 |
-- |
| 5042 | 5042 |
|
| 5043 |
CREATE INDEX emb_stem_idx ON stem USING btree (emb_stem);
|
|
| 5043 |
CREATE INDEX emb_stemobservation_idx ON stemobservation USING btree (emb_stemobservation);
|
|
| 5044 | 5044 |
|
| 5045 | 5045 |
|
| 5046 | 5046 |
-- |
| ... | ... | |
| 5646 | 5646 |
|
| 5647 | 5647 |
|
| 5648 | 5648 |
-- |
| 5649 |
-- Name: stem_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5649 |
-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5650 | 5650 |
-- |
| 5651 | 5651 |
|
| 5652 |
CREATE INDEX stem_plantobservation_id_x ON stem USING btree (plantobservation_id);
|
|
| 5652 |
CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation USING btree (plantobservation_id);
|
|
| 5653 | 5653 |
|
| 5654 | 5654 |
|
| 5655 | 5655 |
-- |
| ... | ... | |
| 6656 | 6656 |
|
| 6657 | 6657 |
|
| 6658 | 6658 |
-- |
| 6659 |
-- Name: stem_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6659 |
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6660 | 6660 |
-- |
| 6661 | 6661 |
|
| 6662 |
ALTER TABLE ONLY stem |
|
| 6663 |
ADD CONSTRAINT stem_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6662 |
ALTER TABLE ONLY stemobservation
|
|
| 6663 |
ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6664 | 6664 |
|
| 6665 | 6665 |
|
| 6666 | 6666 |
-- |
| ... | ... | |
| 6792 | 6792 |
|
| 6793 | 6793 |
|
| 6794 | 6794 |
-- |
| 6795 |
-- Name: trait_stem_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6795 |
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6796 | 6796 |
-- |
| 6797 | 6797 |
|
| 6798 | 6798 |
ALTER TABLE ONLY trait |
| 6799 |
ADD CONSTRAINT trait_stem_id_fkey FOREIGN KEY (stem_id) REFERENCES stem(stem_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6799 |
ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6800 | 6800 |
|
| 6801 | 6801 |
|
| 6802 | 6802 |
-- |
| mappings/SALVIAS_db-VegBIEN.organisms.csv | ||
|---|---|---|
| 4 | 4 |
cover_percent,/aggregateoccurrence/cover, |
| 5 | 5 |
intercept_cm,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance." |
| 6 | 6 |
height_m,/aggregateoccurrence/plantobservation/overallheight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob |
| 7 |
tag2,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other." |
|
| 8 |
tag1,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
|
| 9 |
ht_first_branch_m,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 10 |
temp_dbh,/aggregateoccurrence/plantobservation/stem/diameter, |
|
| 11 |
x_position,/aggregateoccurrence/plantobservation/stem/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX." |
|
| 12 |
y_position,/aggregateoccurrence/plantobservation/stem/yposition,Brad: See comment above for x_position |
|
| 7 |
tag2,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
|
|
| 8 |
tag1,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
|
|
| 9 |
ht_first_branch_m,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 10 |
temp_dbh,/aggregateoccurrence/plantobservation/stemobservation/diameter,
|
|
| 11 |
x_position,/aggregateoccurrence/plantobservation/stemobservation/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."
|
|
| 12 |
y_position,/aggregateoccurrence/plantobservation/stemobservation/yposition,Brad: See comment above for x_position
|
|
| 13 | 13 |
census_no,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 14 | 14 |
Habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 15 | 15 |
Ind,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 55 | 55 |
/simpleUserdefined[name=interceptCm]/value,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]:[@fkey=tableRecord_ID]/definedvalue" |
| 56 | 56 |
/height,/aggregateoccurrence/plantobservation/overallheight |
| 57 | 57 |
/simpleUserdefined[name=stemHeightM]/value,/aggregateoccurrence/plantobservation/overallheight |
| 58 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/relatedItem[relationshipType=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,/aggregateoccurrence/plantobservation/stem/*_id/plantobservation/authorplantcode |
|
| 59 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=count]/value,/aggregateoccurrence/plantobservation/stem/*_id/plantobservation/stemcount |
|
| 60 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel,/aggregateoccurrence/plantobservation/stem/authorstemcode |
|
| 61 |
/*ID->/*s/individualOrganism/identificationLabel,/aggregateoccurrence/plantobservation/stem/authorstemcode |
|
| 62 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/1 |
|
| 63 |
/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/1 |
|
| 64 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/2 |
|
| 65 |
/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/2 |
|
| 66 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance/value=0]/diameter,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 67 |
/diameterBaseDistance[baseDistance/value=0]/diameter,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 68 |
/simpleUserdefined[name=stemCanopyForm]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyForm]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 69 |
/simpleUserdefined[name=stemCanopyPosition]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyPosition]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 70 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[complexUserDefined/method=Gentry]/value=1.37]/diameter,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=gentryDiameter]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 71 |
/simpleUserdefined[name=habitat]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=habitat]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 72 |
/simpleUserdefined[name=htFirstBranchM]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 73 |
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 74 |
/simpleUserdefined[name=stemLianaInfestation]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=lianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 75 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 76 |
/simpleUserdefined[name=plantFungusDescription]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 77 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyForm]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyForm]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 78 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyPosition]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyPosition]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 79 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemHeightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 80 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemLianaInfestation]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemLianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 81 |
/simpleUserdefined[name=substrate]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=substrate]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 82 |
/simpleUserdefined[name=vegetation]/value,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 83 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!complexUserDefined/method]/value=1.37]/diameter,/aggregateoccurrence/plantobservation/stem/diameter |
|
| 84 |
/diameterBaseDistance[baseDistance/value=1.37]/diameter,/aggregateoccurrence/plantobservation/stem/diameter |
|
| 85 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightM]/value,/aggregateoccurrence/plantobservation/stem/height |
|
| 86 |
/simpleUserdefined[name=xPosition]/value,/aggregateoccurrence/plantobservation/stem/xposition |
|
| 87 |
/simpleUserdefined[name=yPosition]/value,/aggregateoccurrence/plantobservation/stem/yposition |
|
| 58 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/relatedItem[relationshipType=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,/aggregateoccurrence/plantobservation/stemobservation/*_id/plantobservation/authorplantcode
|
|
| 59 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=count]/value,/aggregateoccurrence/plantobservation/stemobservation/*_id/plantobservation/stemcount
|
|
| 60 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode
|
|
| 61 |
/*ID->/*s/individualOrganism/identificationLabel,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode
|
|
| 62 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/1
|
|
| 63 |
/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/1
|
|
| 64 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/2
|
|
| 65 |
/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/2
|
|
| 66 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance/value=0]/diameter,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=basalDiameter]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 67 |
/diameterBaseDistance[baseDistance/value=0]/diameter,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=basalDiameter]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 68 |
/simpleUserdefined[name=stemCanopyForm]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 69 |
/simpleUserdefined[name=stemCanopyPosition]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 70 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[complexUserDefined/method=Gentry]/value=1.37]/diameter,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 71 |
/simpleUserdefined[name=habitat]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=habitat]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 72 |
/simpleUserdefined[name=htFirstBranchM]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 73 |
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 74 |
/simpleUserdefined[name=stemLianaInfestation]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 75 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 76 |
/simpleUserdefined[name=plantFungusDescription]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 77 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyForm]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemCanopyForm]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 78 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyPosition]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemCanopyPosition]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 79 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemHeightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 80 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemLianaInfestation]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemLianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 81 |
/simpleUserdefined[name=substrate]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=substrate]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 82 |
/simpleUserdefined[name=vegetation]/value,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=vegetation]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 83 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!complexUserDefined/method]/value=1.37]/diameter,/aggregateoccurrence/plantobservation/stemobservation/diameter
|
|
| 84 |
/diameterBaseDistance[baseDistance/value=1.37]/diameter,/aggregateoccurrence/plantobservation/stemobservation/diameter
|
|
| 85 |
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightM]/value,/aggregateoccurrence/plantobservation/stemobservation/height
|
|
| 86 |
/simpleUserdefined[name=xPosition]/value,/aggregateoccurrence/plantobservation/stemobservation/xposition
|
|
| 87 |
/simpleUserdefined[name=yPosition]/value,/aggregateoccurrence/plantobservation/stemobservation/yposition
|
|
| 88 | 88 |
/simpleUserdefined[name=censusNo]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]:[@fkey=tableRecord_ID]/definedvalue" |
| 89 | 89 |
/simpleUserdefined[name=habit]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]:[@fkey=tableRecord_ID]/definedvalue" |
| 90 | 90 |
/simpleUserdefined[name=individualCode]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue" |
| mappings/for_review/SALVIAS_db-VegBIEN.organisms.csv | ||
|---|---|---|
| 4 | 4 |
cover_percent,//aggregateoccurrence/cover, |
| 5 | 5 |
intercept_cm,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]/definedvalue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance." |
| 6 | 6 |
height_m,//plantobservation/overallheight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob |
| 7 |
tag2,//stem/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other." |
|
| 8 |
tag1,//stem/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
|
| 9 |
ht_first_branch_m,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 10 |
temp_dbh,//stem/diameter, |
|
| 11 |
x_position,//stem/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX." |
|
| 12 |
y_position,//stem/yposition,Brad: See comment above for x_position |
|
| 7 |
tag2,//stemobservation/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
|
|
| 8 |
tag1,//stemobservation/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
|
|
| 9 |
ht_first_branch_m,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 10 |
temp_dbh,//stemobservation/diameter,
|
|
| 11 |
x_position,//stemobservation/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."
|
|
| 12 |
y_position,//stemobservation/yposition,Brad: See comment above for x_position
|
|
| 13 | 13 |
census_no,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 14 | 14 |
Habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 15 | 15 |
Ind,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| mappings/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 57 | 57 |
/simpleUserdefined[name=stemHeightM]/value,//plantobservation/overallheight |
| 58 | 58 |
//taxonNameUsageConcept/voucher,//plantobservation/authorplantcode |
| 59 | 59 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=count]/value,//plantobservation/stemcount |
| 60 |
//individualOrganism/identificationLabel,//stem/authorstemcode |
|
| 61 |
//individualOrganism/identificationLabel,//stem/authorstemcode |
|
| 62 |
//individualOrganism/identificationLabel/_alt/1,//stem/authorstemcode/_alt/1 |
|
| 63 |
//individualOrganism/identificationLabel/_alt/1,//stem/authorstemcode/_alt/1 |
|
| 64 |
//individualOrganism/identificationLabel/_alt/2,//stem/authorstemcode/_alt/2 |
|
| 65 |
//individualOrganism/identificationLabel/_alt/2,//stem/authorstemcode/_alt/2 |
|
| 66 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[value=0]/diameter,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]/definedvalue"
|
|
| 67 |
/diameterBaseDistance[value=0]/diameter,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]/definedvalue"
|
|
| 68 |
/simpleUserdefined[name=stemCanopyForm]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyForm]]/definedvalue"
|
|
| 69 |
/simpleUserdefined[name=stemCanopyPosition]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyPosition]]/definedvalue"
|
|
| 70 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[method=Gentry]/value=1.37]/diameter,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=gentryDiameter]]/definedvalue"
|
|
| 71 |
/simpleUserdefined[name=habitat]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=habitat]]/definedvalue"
|
|
| 72 |
/simpleUserdefined[name=htFirstBranchM]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]/definedvalue"
|
|
| 73 |
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]/definedvalue"
|
|
| 74 |
/simpleUserdefined[name=stemLianaInfestation]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=lianaInfestation]]/definedvalue"
|
|
| 75 |
//note/text,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=notes]]/definedvalue"
|
|
| 76 |
/simpleUserdefined[name=plantFungusDescription]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=plantFungusDescription]]/definedvalue"
|
|
| 77 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyForm]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyForm]]/definedvalue"
|
|
| 78 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyPosition]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyPosition]]/definedvalue"
|
|
| 79 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightFirstBranchM]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemHeightFirstBranchM]]/definedvalue"
|
|
| 80 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemLianaInfestation]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemLianaInfestation]]/definedvalue"
|
|
| 81 |
/simpleUserdefined[name=substrate]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=substrate]]/definedvalue"
|
|
| 82 |
/simpleUserdefined[name=vegetation]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]]/definedvalue"
|
|
| 83 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,//stem/diameter |
|
| 84 |
/diameterBaseDistance[value=1.37]/diameter,//stem/diameter |
|
| 85 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightM]/value,//stem/height |
|
| 86 |
/simpleUserdefined[name=xPosition]/value,//stem/xposition |
|
| 87 |
/simpleUserdefined[name=yPosition]/value,//stem/yposition |
|
| 60 |
//individualOrganism/identificationLabel,//stemobservation/authorstemcode
|
|
| 61 |
//individualOrganism/identificationLabel,//stemobservation/authorstemcode
|
|
| 62 |
//individualOrganism/identificationLabel/_alt/1,//stemobservation/authorstemcode/_alt/1
|
|
| 63 |
//individualOrganism/identificationLabel/_alt/1,//stemobservation/authorstemcode/_alt/1
|
|
| 64 |
//individualOrganism/identificationLabel/_alt/2,//stemobservation/authorstemcode/_alt/2
|
|
| 65 |
//individualOrganism/identificationLabel/_alt/2,//stemobservation/authorstemcode/_alt/2
|
|
| 66 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[value=0]/diameter,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=basalDiameter]]/definedvalue"
|
|
| 67 |
/diameterBaseDistance[value=0]/diameter,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=basalDiameter]]/definedvalue"
|
|
| 68 |
/simpleUserdefined[name=stemCanopyForm]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]/definedvalue"
|
|
| 69 |
/simpleUserdefined[name=stemCanopyPosition]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]/definedvalue"
|
|
| 70 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[method=Gentry]/value=1.37]/diameter,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]/definedvalue"
|
|
| 71 |
/simpleUserdefined[name=habitat]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=habitat]]/definedvalue"
|
|
| 72 |
/simpleUserdefined[name=htFirstBranchM]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]/definedvalue"
|
|
| 73 |
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]/definedvalue"
|
|
| 74 |
/simpleUserdefined[name=stemLianaInfestation]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]/definedvalue"
|
|
| 75 |
//note/text,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]/definedvalue"
|
|
| 76 |
/simpleUserdefined[name=plantFungusDescription]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=plantFungusDescription]]/definedvalue"
|
|
| 77 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyForm]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemCanopyForm]]/definedvalue"
|
|
| 78 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyPosition]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemCanopyPosition]]/definedvalue"
|
|
| 79 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightFirstBranchM]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemHeightFirstBranchM]]/definedvalue"
|
|
| 80 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemLianaInfestation]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemLianaInfestation]]/definedvalue"
|
|
| 81 |
/simpleUserdefined[name=substrate]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=substrate]]/definedvalue"
|
|
| 82 |
/simpleUserdefined[name=vegetation]/value,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=vegetation]]/definedvalue"
|
|
| 83 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,//stemobservation/diameter
|
|
| 84 |
/diameterBaseDistance[value=1.37]/diameter,//stemobservation/diameter
|
|
| 85 |
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightM]/value,//stemobservation/height
|
|
| 86 |
/simpleUserdefined[name=xPosition]/value,//stemobservation/xposition
|
|
| 87 |
/simpleUserdefined[name=yPosition]/value,//stemobservation/yposition
|
|
| 88 | 88 |
/simpleUserdefined[name=censusNo]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]/definedvalue" |
| 89 | 89 |
/simpleUserdefined[name=habit]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]/definedvalue" |
| 90 | 90 |
/simpleUserdefined[name=individualCode]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]/definedvalue" |
| mappings/for_review/NYBG-VegBIEN.organisms.csv | ||
|---|---|---|
| 14 | 14 |
YearCollected,//locationevent/obsstartdate/_date/year, |
| 15 | 15 |
MaximumDepth,//waterdepth/max, |
| 16 | 16 |
MinimumDepth,//waterdepth/min, |
| 17 |
Habitat,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=habitat]]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
|
|
| 18 |
PlantFungusDescription,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=plantFungusDescription]]/definedvalue","Brad: Incorrect mapping to VB, also possibly to VX; this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
|
|
| 19 |
Substrate,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=substrate]]/definedvalue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
|
|
| 20 |
Vegetation,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?"
|
|
| 17 |
Habitat,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=habitat]]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
|
|
| 18 |
PlantFungusDescription,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=plantFungusDescription]]/definedvalue","Brad: Incorrect mapping to VB, also possibly to VX; this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
|
|
| 19 |
Substrate,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=substrate]]/definedvalue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
|
|
| 20 |
Vegetation,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=vegetation]]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?"
|
|
| 21 | 21 |
FieldNumber,//specimenreplicate/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?" |
| 22 | 22 |
CollectorNumber,//specimenreplicate/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX" |
| 23 | 23 |
Collector,//specimenreplicate/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen? |
| mappings/for_review/SALVIAS-VegBIEN.organisms.csv | ||
|---|---|---|
| 7 | 7 |
intercept_cm,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]/definedvalue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance." |
| 8 | 8 |
height_m,//plantobservation/overallheight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob |
| 9 | 9 |
stem_height_m,//plantobservation/overallheight,"Brad: Same as for height, but applies to individuals stems, not trees. Rare." |
| 10 |
stem_tag1,//stem/authorstemcode,"Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems." |
|
| 11 |
stem_tag2,//stem/authorstemcode,Brad: see above |
|
| 12 |
tag2,//stem/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other." |
|
| 13 |
tag1,//stem/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
|
| 14 |
basal_diam,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]/definedvalue",
|
|
| 15 |
stem_canopy_form,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyForm]]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 16 |
stem_canopy_position,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyPosition]]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 17 |
ht_first_branch_m,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 18 |
stem_height_first_branch_m,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]/definedvalue","Brad: Should also be userDefined for VegBank. Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
|
|
| 19 |
stem_liana_infestation,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=lianaInfestation]]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 20 |
stem_dbh,//stem/diameter, |
|
| 21 |
x_position,//stem/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX." |
|
| 22 |
y_position,//stem/yposition,Brad: See comment above for x_position |
|
| 10 |
stem_tag1,//stemobservation/authorstemcode,"Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems."
|
|
| 11 |
stem_tag2,//stemobservation/authorstemcode,Brad: see above
|
|
| 12 |
tag2,//stemobservation/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
|
|
| 13 |
tag1,//stemobservation/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
|
|
| 14 |
basal_diam,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=basalDiameter]]/definedvalue",
|
|
| 15 |
stem_canopy_form,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 16 |
stem_canopy_position,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 17 |
ht_first_branch_m,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 18 |
stem_height_first_branch_m,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]/definedvalue","Brad: Should also be userDefined for VegBank. Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
|
|
| 19 |
stem_liana_infestation,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 20 |
stem_dbh,//stemobservation/diameter,
|
|
| 21 |
x_position,//stemobservation/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."
|
|
| 22 |
y_position,//stemobservation/yposition,Brad: See comment above for x_position
|
|
| 23 | 23 |
census_no,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 24 | 24 |
habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 25 | 25 |
individual_code,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| mappings/NYBG-VegBIEN.organisms.csv | ||
|---|---|---|
| 14 | 14 |
YearCollected,/*_id/locationevent/obsstartdate/_date/year, |
| 15 | 15 |
MaximumDepth,/*_id/locationevent/waterdepth/max, |
| 16 | 16 |
MinimumDepth,/*_id/locationevent/waterdepth/min, |
| 17 |
Habitat,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=habitat]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
|
|
| 18 |
PlantFungusDescription,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect mapping to VB, also possibly to VX; this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
|
|
| 19 |
Substrate,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=substrate]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
|
|
| 20 |
Vegetation,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?"
|
|
| 17 |
Habitat,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=habitat]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
|
|
| 18 |
PlantFungusDescription,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect mapping to VB, also possibly to VX; this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
|
|
| 19 |
Substrate,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=substrate]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
|
|
| 20 |
Vegetation,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=vegetation]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?"
|
|
| 21 | 21 |
FieldNumber,/specimenreplicate:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?" |
| 22 | 22 |
CollectorNumber,/specimenreplicate:[*_id/reference]/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX" |
| 23 | 23 |
Collector,/specimenreplicate:[*_id/reference]/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen? |
| mappings/VegX-VegBIEN.stems.csv | ||
|---|---|---|
| 1 |
VegX:/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID],VegBIEN:/stem |
|
| 1 |
VegX:/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID],VegBIEN:/stemobservation
|
|
| 2 | 2 |
/relatedItem[relationshipType=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,/*_id/plantobservation/authorplantcode |
| 3 | 3 |
/simpleUserdefined[name=count]/value,/*_id/plantobservation/stemcount |
| 4 | 4 |
/*ID->/*s/individualOrganism/identificationLabel,/authorstemcode |
| 5 | 5 |
/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/authorstemcode/_alt/1 |
| 6 | 6 |
/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/authorstemcode/_alt/2 |
| 7 |
/diameterBaseDistance[baseDistance/value=0]/diameter,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]:[@fkey=tableRecord_ID]/definedvalue" |
|
| 8 |
/diameterBaseDistance[baseDistance[complexUserDefined/method=Gentry]/value=1.37]/diameter,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=gentryDiameter]]:[@fkey=tableRecord_ID]/definedvalue" |
|
| 9 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue" |
|
| 10 |
/simpleUserdefined[name=stemCanopyForm]/value,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyForm]]:[@fkey=tableRecord_ID]/definedvalue" |
|
| 11 |
/simpleUserdefined[name=stemCanopyPosition]/value,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyPosition]]:[@fkey=tableRecord_ID]/definedvalue" |
|
| 12 |
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemHeightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue" |
|
| 13 |
/simpleUserdefined[name=stemLianaInfestation]/value,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemLianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue" |
|
| 7 |
/diameterBaseDistance[baseDistance/value=0]/diameter,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=basalDiameter]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 8 |
/diameterBaseDistance[baseDistance[complexUserDefined/method=Gentry]/value=1.37]/diameter,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 9 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 10 |
/simpleUserdefined[name=stemCanopyForm]/value,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemCanopyForm]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 11 |
/simpleUserdefined[name=stemCanopyPosition]/value,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemCanopyPosition]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 12 |
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemHeightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 13 |
/simpleUserdefined[name=stemLianaInfestation]/value,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=stemLianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue"
|
|
| 14 | 14 |
/diameterBaseDistance[baseDistance[!complexUserDefined/method]/value=1.37]/diameter,/diameter |
| 15 | 15 |
/simpleUserdefined[name=stemHeightM]/value,/height |
| mappings/SALVIAS-VegBIEN.organisms.csv | ||
|---|---|---|
| 7 | 7 |
intercept_cm,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance." |
| 8 | 8 |
height_m,/aggregateoccurrence/plantobservation/overallheight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob |
| 9 | 9 |
stem_height_m,/aggregateoccurrence/plantobservation/overallheight,"Brad: Same as for height, but applies to individuals stems, not trees. Rare." |
| 10 |
stem_tag1,/aggregateoccurrence/plantobservation/stem/authorstemcode,"Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems." |
|
| 11 |
stem_tag2,/aggregateoccurrence/plantobservation/stem/authorstemcode,Brad: see above |
|
| 12 |
tag2,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other." |
|
| 13 |
tag1,/aggregateoccurrence/plantobservation/stem/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
|
| 14 |
basal_diam,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]:[@fkey=tableRecord_ID]/definedvalue",
|
|
| 15 |
stem_canopy_form,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyForm]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 16 |
stem_canopy_position,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyPosition]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 17 |
ht_first_branch_m,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 18 |
stem_height_first_branch_m,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Should also be userDefined for VegBank. Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
|
|
| 19 |
stem_liana_infestation,"/aggregateoccurrence/plantobservation/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=lianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 20 |
stem_dbh,/aggregateoccurrence/plantobservation/stem/diameter, |
|
| 21 |
x_position,/aggregateoccurrence/plantobservation/stem/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX." |
|
| 22 |
y_position,/aggregateoccurrence/plantobservation/stem/yposition,Brad: See comment above for x_position |
|
| 10 |
stem_tag1,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,"Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems."
|
|
| 11 |
stem_tag2,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,Brad: see above
|
|
| 12 |
tag2,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
|
|
| 13 |
tag1,/aggregateoccurrence/plantobservation/stemobservation/authorstemcode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
|
|
| 14 |
basal_diam,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=basalDiameter]]:[@fkey=tableRecord_ID]/definedvalue",
|
|
| 15 |
stem_canopy_form,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 16 |
stem_canopy_position,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 17 |
ht_first_branch_m,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
|
|
| 18 |
stem_height_first_branch_m,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Should also be userDefined for VegBank. Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
|
|
| 19 |
stem_liana_infestation,"/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Should also be userDefined for VegBank.
|
|
| 20 |
stem_dbh,/aggregateoccurrence/plantobservation/stemobservation/diameter,
|
|
| 21 |
x_position,/aggregateoccurrence/plantobservation/stemobservation/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."
|
|
| 22 |
y_position,/aggregateoccurrence/plantobservation/stemobservation/yposition,Brad: See comment above for x_position
|
|
| 23 | 23 |
census_no,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 24 | 24 |
habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 25 | 25 |
individual_code,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| mappings/Makefile | ||
|---|---|---|
| 44 | 44 |
env \ |
| 45 | 45 |
left_in_root='/*s/individualOrganismObservation->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]' \ |
| 46 | 46 |
left_out_root='/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]' \ |
| 47 |
right_in_root='/taxonoccurrence/aggregateoccurrence/plantobservation/stem' \ |
|
| 48 |
right_out_root='/stem' \ |
|
| 47 |
right_in_root='/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation' \
|
|
| 48 |
right_out_root='/stemobservation' \
|
|
| 49 | 49 |
$(chRoot) |
Also available in: Unified diff
VegBIEN: Renamed stem to stemobservation