Project

General

Profile

« Previous | Next » 

Revision 4880

inputs/TEAM/: Obtained new download of TEAM data. (Note that the new download has a slightly different schema.) Archived old data in _archive/. Added tables to import_order.txt. Renamed TeamPlotMetaData/ to TEAM_Sites/ to correspond with the section header in Vegetation-Tree-and-Liana-Metadata-1.5.pdf. Fixed TEAM_Sites mappings: Remapped CollectionDate to eventDate because it relates to the plot, not the organism. Mapped Name to plotName so TEAM_Sites data will match up with VL, VT data.

View differences:

test.xml.ref
4 4
        <next>parent_id</next>
5 5
        <path>
6 6
            <location>
7
                <authorlocationcode>$Name</authorlocationcode>
7 8
                <locationcoords>
8 9
                    <latitude_deg>
9 10
                        <_nullIf>
......
21 22
                    </longitude_deg>
22 23
                </locationcoords>
23 24
                <locationevent>
24
                    <method_id><method><name>$Method</name></method></method_id>
25
                    <project_id><project><projectname>$SiteName</projectname></project></project_id>
26
                    <taxonoccurrence><aggregateoccurrence><collectiondate><_date><date>$CollectionDate</date></_date></collectiondate></aggregateoccurrence></taxonoccurrence>
25
                    <project_id><project><projectname>$Site Name</projectname></project></project_id>
26
                    <obsenddate><_date><date><_dateRangeEnd><value>$CollectionDate</value></_dateRangeEnd></date></_date></obsenddate>
27
                    <obsstartdate><_date><date><_dateRangeStart><value>$CollectionDate</value></_dateRangeStart></date></_date></obsstartdate>
27 28
                </locationevent>
28 29
            </location>
29 30
        </path>
30 31
    </_simplifyPath>
31 32
</VegBIEN>
32
Inserted 7 new rows into database
33
Inserted 8 new rows into database

Also available in: Unified diff