Project

General

Profile

« Previous | Next » 

Revision 12001

Added by Aaron Marcuse-Kubitza almost 11 years ago

bugfix: inputs/SALVIAS/plotMetadata_/map.csv: things mapped to project_participant: remapped to event__participant because these actually relate to the event, not the project, even though they seem like project-related fields

View differences:

trunk/inputs/SALVIAS/plotMetadata_/map.csv
65 65 
plot_administrator,*plot_administrator,,
66 66 
plot_notes,locationRemarks,,
67 67 
tmp_del,*tmp_del,,"3 plots contain ""del"" in this field and 3 in AccessCode"
68 
PrimOwnerID_name,project_participant,,
69 
plot_administrator_name,project_participant,,
68 
PrimOwnerID_name,event__participant,,
69 
plot_administrator_name,event__participant,,
70 70 
lookup_MethodCode_Description,observationMeasure,,
trunk/inputs/SALVIAS/plotMetadata_/VegBIEN.csv
14 14 
topography_desc,/location/landform,
15 15 
PlotMethod,/location/locationevent/*_id/method/name,
16 16 
lookup_MethodCode_Description,/location/locationevent/*_id/method/observationmeasure,
17 
PrimOwnerID_name,/location/locationevent/*_id/project/projectcontributor[!*_id/party]/*_id/party/fullname,use [!...] negative lookahead assertion so that multiple project_participant columns will properly map to separate projectcontributor rows
18 
plot_administrator_name,/location/locationevent/*_id/project/projectcontributor[!*_id/party]/*_id/party/fullname,use [!...] negative lookahead assertion so that multiple project_participant columns will properly map to separate projectcontributor rows
19 17 
project_id,/location/locationevent/*_id/project/sourceaccessioncode,
20 18 
date_finish,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
21 19 
date_start,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
......
29 27 
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription/_alt/4,
30 28 
PlotID,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
31 29 
SiteCode,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
30 
PrimOwnerID_name,/location/locationevent/locationeventcontributor[!*_id/party]/*_id/party/fullname,use [!...] negative lookahead assertion so that multiple event__participant columns will properly map to separate locationeventcontributor rows
31 
plot_administrator_name,/location/locationevent/locationeventcontributor[!*_id/party]/*_id/party/fullname,use [!...] negative lookahead assertion so that multiple event__participant columns will properly map to separate locationeventcontributor rows
32 32 
date_finish,/location/locationevent/obsenddate/_alt/1,
33 33 
date_start,/location/locationevent/obsstartdate/_alt/1,
34 34 
Precip,/location/locationevent/precipitation_m/_mm_to_m/value,
trunk/inputs/SALVIAS/plotMetadata_/test.xml.ref
47 47 
                                    <observationmeasure>$lookup_MethodCode_Description</observationmeasure>
48 48 
                                </method>
49 49 
                            </method_id>
50 
                            <project_id>
51 
                                <project>
52 
                                    <projectcontributor><party_id><party><fullname>$PrimOwnerID_name</fullname></party></party_id></projectcontributor>
53 
                                    <projectcontributor><party_id><party><fullname>$plot_administrator_name</fullname></party></party_id></projectcontributor>
54 
                                    <sourceaccessioncode>$project_id</sourceaccessioncode>
55 
                                </project>
56 
                            </project_id>
50 
                            <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
57 51 
                            <commclass>
58 52 
                                <commdetermination>
59 53 
                                    <commconcept_id>
......
70 64 
                                    </commconcept_id>
71 65 
                                </commdetermination>
72 66 
                            </commclass>
67 
                            <locationeventcontributor><party_id><party><fullname>$PrimOwnerID_name</fullname></party></party_id></locationeventcontributor>
68 
                            <locationeventcontributor><party_id><party><fullname>$plot_administrator_name</fullname></party></party_id></locationeventcontributor>
73 69 
                            <obsenddate>$date_finish</obsenddate>
74 70 
                            <obsstartdate>$date_start</obsstartdate>
75 71 
                            <precipitation_m><_mm_to_m><value>$Precip</value></_mm_to_m></precipitation_m>
......
191 187 
        </path>
192 188 
    </_setDefault>
193 189 
</VegBIEN>
194 
Inserted 26 new rows into database
190 
Inserted 28 new rows into database
trunk/inputs/SALVIAS/plotMetadata_/new_terms.csv
27 27 
PlotMethod,samplingProtocol,,
28 28 
date_start,startDate,,
29 29 
date_finish,endDate,,
30 
PrimOwnerID_name,project_participant,,
31 
plot_administrator_name,project_participant,,
30 
PrimOwnerID_name,event__participant,,
31 
plot_administrator_name,event__participant,,
32 32 
lookup_MethodCode_Description,observationMeasure,,

Also available in: Unified diff