Revision 4880
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/TEAM/TeamPlotMetaData/new_terms.csv | ||
|---|---|---|
| 1 |
SiteName,projectName,, |
|
| 2 |
CollectionDate,dateCollected,, |
|
| 3 |
Method,samplingProtocol,, |
|
| inputs/TEAM/TeamPlotMetaData/unmapped_terms.csv | ||
|---|---|---|
| 1 |
Name |
|
| 2 |
BlockPosition |
|
| inputs/TEAM/TeamPlotMetaData/map.csv | ||
|---|---|---|
| 1 |
TEAM,VegCore,Filter,Comments |
|
| 2 |
SiteName,projectName,, |
|
| 3 |
Name,Name,, |
|
| 4 |
BlockPosition,BlockPosition,, |
|
| 5 |
Longitude,verbatimLongitude,, |
|
| 6 |
Latitude,verbatimLatitude,, |
|
| 7 |
CollectionDate,dateCollected,, |
|
| 8 |
Method,samplingProtocol,, |
|
| inputs/TEAM/TeamPlotMetaData/test.xml.ref | ||
|---|---|---|
| 1 |
Put template: |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_simplifyPath id="-1"> |
|
| 4 |
<next>parent_id</next> |
|
| 5 |
<path> |
|
| 6 |
<location> |
|
| 7 |
<locationcoords> |
|
| 8 |
<latitude_deg> |
|
| 9 |
<_nullIf> |
|
| 10 |
<null>0</null> |
|
| 11 |
<type>float</type> |
|
| 12 |
<value>$Latitude</value> |
|
| 13 |
</_nullIf> |
|
| 14 |
</latitude_deg> |
|
| 15 |
<longitude_deg> |
|
| 16 |
<_nullIf> |
|
| 17 |
<null>0</null> |
|
| 18 |
<type>float</type> |
|
| 19 |
<value>$Longitude</value> |
|
| 20 |
</_nullIf> |
|
| 21 |
</longitude_deg> |
|
| 22 |
</locationcoords> |
|
| 23 |
<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> |
|
| 27 |
</locationevent> |
|
| 28 |
</location> |
|
| 29 |
</path> |
|
| 30 |
</_simplifyPath> |
|
| 31 |
</VegBIEN> |
|
| 32 |
Inserted 7 new rows into database |
|
| inputs/TEAM/_src/README.TXT | ||
|---|---|---|
| 1 |
e-mail from Brad Boyle on 2012-9-7: |
|
| 2 |
|
|
| 3 |
Ignore the MS Access file. That was generated during the import to BIEN2. I'm not even sure about the provenance of most of those files. |
|
| 4 |
|
|
| 5 |
All you need are the pdf (Vegetation-Metadata-1.4.pdf) and the two CSVs (VL-20100112143439_2205.csv, VT-20100112143439_2205.csv). These are what you get when you download the data from the TEAM website (http://www.teamnetwork.org/data/query). |
|
| inputs/TEAM/_src/Vegetation-Metadata-1.4.pdf | ||
|---|---|---|
| 1 |
link ci-team_extract/Vegetation-Metadata-1.4.pdf |
|
| 2 | 0 | |
| inputs/TEAM/_archive/Vegetation-Metadata-1.4.pdf | ||
|---|---|---|
| 1 |
link ci-team_extract/Vegetation-Metadata-1.4.pdf |
|
| 0 | 2 | |
| inputs/TEAM/_archive/README.TXT | ||
|---|---|---|
| 1 |
e-mail from Brad Boyle on 2012-9-7: |
|
| 2 |
|
|
| 3 |
Ignore the MS Access file. That was generated during the import to BIEN2. I'm not even sure about the provenance of most of those files. |
|
| 4 |
|
|
| 5 |
All you need are the pdf (Vegetation-Metadata-1.4.pdf) and the two CSVs (VL-20100112143439_2205.csv, VT-20100112143439_2205.csv). These are what you get when you download the data from the TEAM website (http://www.teamnetwork.org/data/query). |
|
| inputs/TEAM/VL/map.csv | ||
|---|---|---|
| 1 | 1 |
TEAM,VegCore,Filter,Comments |
| 2 | 2 |
Id,occurrenceID,, |
| 3 |
Site Name,projectName,, |
|
| 4 |
1ha Plot Number,plotName,, |
|
| 5 | 3 |
Observation Date,eventDate,, |
| 6 | 4 |
Family,family,, |
| 7 | 5 |
Genus,genus,, |
| 8 | 6 |
Species,specificEpithet,, |
| 9 | 7 |
Names of Collectors,recordedBy,, |
| 10 |
Diameter at 1.3m,diameterBreastHeight_cm,,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 6 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/ci-team_extract/Vegetation-Metadata-1.4.pdf>)"
|
|
| 8 |
Diameter at 1.3m,diameterBreastHeight_cm,,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 7 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
|
|
| 11 | 9 |
Max Diameter,Max Diameter,, |
| 12 | 10 |
Max Diameter POM,Max Diameter POM,, |
| 13 | 11 |
Condition Codes,Condition Codes,, |
| 14 | 12 |
Location Codes,Location Codes,, |
| 15 | 13 |
Sampling Period,Sampling Period,, |
| 16 | 14 |
Comments,Comments,, |
| 15 |
Data Level,Data Level,, |
|
| 17 | 16 |
Sampling Unit Name,Sampling Unit Name,, |
| 18 | 17 |
Latitude,verbatimLatitude,, |
| 19 | 18 |
Longitude,verbatimLongitude,, |
| ... | ... | |
| 22 | 21 |
1ha Plot X Coordinate,organismX,, |
| 23 | 22 |
1ha Plot Y Coordinate,organismY,, |
| 24 | 23 |
Tree Number,tag,, |
| 24 |
Site Name,projectName,, |
|
| 25 |
1ha Plot Number,plotName,, |
|
| 25 | 26 |
Protocol Version,Protocol Version,, |
| 26 |
Responsible Institution,Responsible Institution,, |
|
| 27 |
Protocol Lead Scientist,Protocol Lead Scientist,, |
|
| 28 |
Protocol Lead Scientist Institution,Protocol Lead Scientist Institution,, |
|
| 27 |
Data Set Creator Institution,Data Set Creator Institution,, |
|
| 28 |
Data Set Creator Scientist,Data Set Creator Scientist,, |
|
| 29 |
Data Set Contact,Data Set Contact,, |
|
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 13 | 13 |
Observation Date,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value, |
| 14 | 14 |
Observation Date,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value, |
| 15 | 15 |
Id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 16 |
Diameter at 1.3m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 6 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/ci-team_extract/Vegetation-Metadata-1.4.pdf>)"
|
|
| 16 |
Diameter at 1.3m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 7 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
|
|
| 17 | 17 |
Tree Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag, |
| 18 | 18 |
1ha Plot X Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m, |
| 19 | 19 |
1ha Plot Y Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m, |
| ... | ... | |
| 26 | 26 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 27 | 27 |
Comments,,** No join mapping for Comments ** |
| 28 | 28 |
Condition Codes,,** No join mapping for Condition Codes ** |
| 29 |
Data Level,,** No join mapping for Data Level ** |
|
| 30 |
Data Set Contact,,** No join mapping for Data Set Contact ** |
|
| 31 |
Data Set Creator Institution,,** No join mapping for Data Set Creator Institution ** |
|
| 32 |
Data Set Creator Scientist,,** No join mapping for Data Set Creator Scientist ** |
|
| 29 | 33 |
Location Codes,,** No join mapping for Location Codes ** |
| 30 | 34 |
Max Diameter,,** No join mapping for Max Diameter ** |
| 31 | 35 |
Max Diameter POM,,** No join mapping for Max Diameter POM ** |
| 32 |
Protocol Lead Scientist,,** No join mapping for Protocol Lead Scientist ** |
|
| 33 |
Protocol Lead Scientist Institution,,** No join mapping for Protocol Lead Scientist Institution ** |
|
| 34 | 36 |
Protocol Version,,** No join mapping for Protocol Version ** |
| 35 |
Responsible Institution,,** No join mapping for Responsible Institution ** |
|
| 36 | 37 |
Sampling Period,,** No join mapping for Sampling Period ** |
| 37 | 38 |
Sampling Unit Name,,** No join mapping for Sampling Unit Name ** |
| inputs/TEAM/VL/test.xml.ref | ||
|---|---|---|
| 57 | 57 |
</path> |
| 58 | 58 |
</_simplifyPath> |
| 59 | 59 |
</VegBIEN> |
| 60 |
Inserted 20 new rows into database |
|
| 60 |
Inserted 23 new rows into database |
|
| inputs/TEAM/VL/unmapped_terms.csv | ||
|---|---|---|
| 4 | 4 |
Location Codes |
| 5 | 5 |
Sampling Period |
| 6 | 6 |
Comments |
| 7 |
Data Level |
|
| 7 | 8 |
Sampling Unit Name |
| 8 | 9 |
Protocol Version |
| 9 |
Responsible Institution |
|
| 10 |
Protocol Lead Scientist |
|
| 11 |
Protocol Lead Scientist Institution |
|
| 10 |
Data Set Creator Institution |
|
| 11 |
Data Set Creator Scientist |
|
| 12 |
Data Set Contact |
|
| inputs/TEAM/import_order.txt | ||
|---|---|---|
| 1 |
TEAM_Sites |
|
| 2 |
VL |
|
| 3 |
VT |
|
| inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/README.txt | ||
|---|---|---|
| 1 |
TEAM DataPackage |
|
| 2 |
|
|
| 3 |
A DataPackage is a zip file that contains all of the datasets selected to download in the |
|
| 4 |
Data Query and Download section of www.teamnetwork.org. The TEAM DataPackage also contains important |
|
| 5 |
metadata documents that will help you to understand and use TEAM Protocol data. When a TEAM DataPackage |
|
| 6 |
is unzipped directories will be created for each Protocol for which you have selected to download data. For example, |
|
| 7 |
if only Avian Protocol data was selected an "Avian" directory is created. In this directory will be all the data files |
|
| 8 |
and the metadata file associated with the Avian dataset. |
|
| 9 |
|
|
| 10 |
|
|
| 11 |
File Naming Convention: |
|
| 12 |
|
|
| 13 |
Data Package |
|
| 14 |
Each DataPackage has a unique ID generated on the data and time it was created: yyyyMMddHHmmss-<4 digits id> |
|
| 15 |
Package name: TEAM-DataPackage-<package id>.zip |
|
| 16 |
|
|
| 17 |
Dataset |
|
| 18 |
Each dataset downloaded will have the unique ID included in it's file name. |
|
| 19 |
CSV file name For a TEAM Protocol: <protocol abbrev>-<protocol version>-<package id>.csv |
|
| 20 |
Tab delimited file name for a TEAM Protocol: <protocol abbrev>-<protocol version>-<package id>.tab |
|
| 21 |
|
|
| 22 |
Metadata |
|
| 23 |
Each TEAM Protocol data file will have an associated metadata document. |
|
| 24 |
Metdata file name: <Protocol Name>-Metadata-<version>.<subversion>.pdf |
|
| 25 |
|
|
| 26 |
|
|
| 27 |
Protocol Abbreviations: |
|
| 28 |
|
|
| 29 |
AV for Avian |
|
| 30 |
BT for Butterfly |
|
| 31 |
CL for Climate |
|
| 32 |
VL for Liana |
|
| 33 |
LF for Litterfall |
|
| 34 |
PR for Primate |
|
| 35 |
VT for Tree |
|
| 36 |
|
|
| 37 |
Important Information: |
|
| 38 |
|
|
| 39 |
The TEAM Network Database is constantly being updated with new data as it comes in from TEAM Sites. Data are also |
|
| 40 |
constantly undergoing QA/QC (Quality Assurance and Quality Control) measures to ensure |
|
| 41 |
TEAM Network Data are of the highest scientific value. Therefore it is important to check back frequently to ensure you |
|
| 42 |
have the latest TEAM Data. A "Dataset ID" is included in each TEAM Protocol dataset to easily track which version of data |
|
| 43 |
you have downloaded. Please refer to the Data Use Policy printed in the first 62 lines of each dataset for questions |
|
| 44 |
on the use or acknowledgement of TEAM Data. |
|
| 45 |
|
|
| 46 |
|
|
| 47 |
|
|
| inputs/TEAM/_src/TEAM_Sites.csv | ||
|---|---|---|
| 1 |
Site Name,Name,1ha Plot Coordinate,Longitude,Latitude,CollectionDate |
|
| 2 |
Barro Colorado Nature Monument - Soberania National Park,VG-BCI-6,"0,0",-79.74438574165106,9.15660995990038,2012-03-22 |
|
| 3 |
Barro Colorado Nature Monument - Soberania National Park,VG-BCI-3,"0,0",-79.77443662472069,9.200405236333609,2012-03-23 |
|
| 4 |
Barro Colorado Nature Monument - Soberania National Park,VG-BCI-1,"0,0",-79.85346715897322,9.105386976152658,2012-04-09 |
|
| 5 |
Barro Colorado Nature Monument - Soberania National Park,VG-BCI-4,"0,0",-79.74066954106092,9.168865140527487,2012-03-28 |
|
| 6 |
Barro Colorado Nature Monument - Soberania National Park,VG-BCI-2,"0,0",-79.86121916212142,9.158292459324,2012-05-01 |
|
| 7 |
Barro Colorado Nature Monument - Soberania National Park,VG-BCI-5,"0,0",-79.71263433806598,9.146816963329911,2012-03-28 |
|
| 8 |
Bukit Barisan,VG-BBS-2,"0,0",104.40137917,-5.67447863,2010-09-30 |
|
| 9 |
Bukit Barisan,VG-BBS-3,"0,0",104.40137917,-5.61628793,2010-09-30 |
|
| 10 |
Bukit Barisan,VG-BBS-4,"0,0",104.4828133,-5.64433537,2010-09-30 |
|
| 11 |
Bukit Barisan,VG-BBS-5,"0,0",104.43636926,-5.62738457,2010-09-30 |
|
| 12 |
Bukit Barisan,VG-BBS-6,"0,0",104.49453531,-5.68786293,2010-09-30 |
|
| 13 |
Bukit Barisan,VG-BBS-1,"0,0",104.41399067,-5.64635684,2010-09-30 |
|
| 14 |
Bwindi Impenetrable Forest,VG-BIF-1,"0,0",29.6970333,-0.9132334,2009-11-23 |
|
| 15 |
Bwindi Impenetrable Forest,VG-BIF-2,"0,0",29.7260666,-0.8930833,2009-11-23 |
|
| 16 |
Bwindi Impenetrable Forest,VG-BIF-3,"0,0",29.7063833,-1.0125,2009-11-23 |
|
| 17 |
Bwindi Impenetrable Forest,VG-BIF-4,"0,0",29.6390166,-1.0246833,2009-11-23 |
|
| 18 |
Bwindi Impenetrable Forest,VG-BIF-5,"0,0",29.7606833,-1.0573,2009-11-23 |
|
| 19 |
Bwindi Impenetrable Forest,VG-BIF-6,"0,0",29.7177333,-1.0953,2009-11-23 |
|
| 20 |
Caxiuanã,VG-CAX-1,"0,0",-51.45916,-1.70781,2011-05-27 |
|
| 21 |
Caxiuanã,VG-CAX-6,"0,0",-51.4309,-1.72358,2011-05-27 |
|
| 22 |
Caxiuanã,VG-CAX-5,"0,0",-51.59084,-1.78128,2011-05-27 |
|
| 23 |
Caxiuanã,VG-CAX-4,"0,0",-51.52048,-1.75391,2011-05-27 |
|
| 24 |
Caxiuanã,VG-CAX-3,"0,0",-51.51098,-1.73408,2011-05-27 |
|
| 25 |
Caxiuanã,VG-CAX-2,"0,0",-51.48499,-1.72963,2011-05-27 |
|
| 26 |
Central Suriname Nature Reserve,VG-CSN-2,"0,0",-56.1860075,4.6969741,2011-01-11 |
|
| 27 |
Central Suriname Nature Reserve,VG-CSN-1,"0,0",-56.1877726,4.7380984,2011-01-11 |
|
| 28 |
Central Suriname Nature Reserve,VG-CSN-5,"0,0",-56.20514,4.8133699,2011-01-11 |
|
| 29 |
Central Suriname Nature Reserve,VG-CSN-3,"0,0",-56.1183967,4.8128766,2011-01-11 |
|
| 30 |
Cocha Cashu - Manu National Park,VG-COU-1,"0,0",-71.3978222,-11.8870005,2011-09-13 |
|
| 31 |
Cocha Cashu - Manu National Park,VG-COU-2,"0,0",-71.4249016,-11.8993577,2011-09-13 |
|
| 32 |
Cocha Cashu - Manu National Park,VG-COU-3,"0,0",-71.2813285,-11.9371996,2011-09-13 |
|
| 33 |
Cocha Cashu - Manu National Park,VG-COU-4,"0,0",-71.4024744,-11.904708,2011-09-13 |
|
| 34 |
Cocha Cashu - Manu National Park,VG-COU-5,"0,0",-71.4086283,-11.8784896,2011-09-13 |
|
| 35 |
Cocha Cashu - Manu National Park,VG-COU-6,"0,0",-71.2692159,-11.965529,2011-09-13 |
|
| 36 |
Korup National Park,VG-KRP-1,"0,0",8.85385,5.06505,2011-11-09 |
|
| 37 |
Korup National Park,VG-KRP-2,"0,0",8.86735,5.08098,2011-11-09 |
|
| 38 |
Korup National Park,VG-KRP-3,"0,0",8.84137,5.07968,2011-11-09 |
|
| 39 |
Korup National Park,VG-KRP-4,"0,0",8.83203,5.06102,2011-11-09 |
|
| 40 |
Korup National Park,VG-KRP-5,"0,0",8.8376,5.03708,2011-11-09 |
|
| 41 |
Korup National Park,VG-KRP-6,"0,0",8.85833,5.03741,2011-11-09 |
|
| 42 |
Manaus,VG-MAS-1,"0,0",-59.9468382,-2.9289898,2010-11-30 |
|
| 43 |
Manaus,VG-MAS-2,"0,0",-59.9053463,-2.9698361,2010-11-30 |
|
| 44 |
Manaus,VG-MAS-3,"0,0",-59.9015673,-2.4066878,2010-11-30 |
|
| 45 |
Manaus,VG-MAS-4,"0,0",-59.794235,-2.4313394,2010-11-30 |
|
| 46 |
Manaus,VG-MAS-5,"0,0",-60.2098673,-2.6185037,2010-11-30 |
|
| 47 |
Manaus,VG-MAS-6,"0,0",-60.1093966,-2.5975461,2010-11-30 |
|
| 48 |
Nam Kading,VG-NAK-1,"0,0",104.27965,18.2985,2010-03-09 |
|
| 49 |
Nam Kading,VG-NAK-2,"0,0",104.27967,18.2985,2010-03-24 |
|
| 50 |
Nam Kading,VG-NAK-3,"0,0",104.15525,18.39701,2009-12-09 |
|
| 51 |
Nam Kading,VG-NAK-4,"0,0",104.16643,18.36779,2009-11-10 |
|
| 52 |
Nam Kading,VG-NAK-5,"0,0",104.10685,18.43812,2010-02-13 |
|
| 53 |
Nam Kading,VG-NAK-6,"0,0",104.12318,18.40492,2010-01-10 |
|
| 54 |
Nouabalé Ndoki,VG-NNN-4,"0,0",16.4659089,2.4014756,2010-03-11 |
|
| 55 |
Nouabalé Ndoki,VG-NNN-5,"0,0",16.4283399,2.35894,2010-03-11 |
|
| 56 |
Nouabalé Ndoki,VG-NNN-6,"0,0",16.360348,2.3551752,2010-03-11 |
|
| 57 |
Nouabalé Ndoki,VG-NNN-1,"0,0",16.6207812,2.6572454,2010-03-11 |
|
| 58 |
Nouabalé Ndoki,VG-NNN-3,"0,0",16.5348413,2.614436,2010-03-11 |
|
| 59 |
Nouabalé Ndoki,VG-NNN-2,"0,0",16.5537878,2.6397392,2010-03-11 |
|
| 60 |
Pasoh Forest Reserve,VG-PSH-1,"0,0",102.18362,2.58797,-- |
|
| 61 |
Pasoh Forest Reserve,VG-PSH-2,"0,0",102.33218,3.05078,-- |
|
| 62 |
Pasoh Forest Reserve,VG-PSH-3,"0,0",102.33264,3.09845,-- |
|
| 63 |
Pasoh Forest Reserve,VG-PSH-4,"0,0",101.97991,3.11013,-- |
|
| 64 |
Pasoh Forest Reserve,VG-PSH-6,"0,0",101.97735,3.1628,-- |
|
| 65 |
Pasoh Forest Reserve,VG-PSH-5,"0,0",101.9806,3.19189,-- |
|
| 66 |
Ranomafana,VG-RNF-1,"0,0",47.5114,-21.12295,2010-12-29 |
|
| 67 |
Ranomafana,VG-RNF-2,"0,0",47.52052,-21.17866,2010-12-29 |
|
| 68 |
Ranomafana,VG-RNF-3,"0,0",47.410841,-21.21793,2010-12-29 |
|
| 69 |
Ranomafana,VG-RNF-4,"0,0",47.4533218,-21.2219612,2010-12-29 |
|
| 70 |
Ranomafana,VG-RNF-5,"0,0",47.40719,-21.30393,2010-12-29 |
|
| 71 |
Ranomafana,VG-RNF-6,"0,0",47.4457188,-21.3658431,2010-12-29 |
|
| 72 |
Udzungwa,VG-UDZ-1,"0,0",36.8860650460001,-7.71113257399998,2009-11-27 |
|
| 73 |
Udzungwa,VG-UDZ-2,"0,0",36.873368214,-7.69493397499997,2009-11-28 |
|
| 74 |
Udzungwa,VG-UDZ-3,"0,0",36.8956057340001,-7.77724184299996,2009-11-28 |
|
| 75 |
Udzungwa,VG-UDZ-4,"0,0",36.8707778880001,-7.75978012899998,2009-11-28 |
|
| 76 |
Udzungwa,VG-UDZ-5,"0,0",36.835541747,-7.83170386299997,2009-11-26 |
|
| 77 |
Udzungwa,VG-UDZ-6,"0,0",36.8632279890001,-7.83826772199996,2009-11-26 |
|
| 78 |
Volcán Barva,VG-VB-1,"0,0",-84.0200572927,10.41687655,2009-01-28 |
|
| 79 |
Volcán Barva,VG-VB-2,"0,0",-84.037524144,10.403171239,2008-06-05 |
|
| 80 |
Volcán Barva,VG-VB-3,"0,0",-84.0476422415,10.3160400918,2008-05-08 |
|
| 81 |
Volcán Barva,VG-VB-4,"0,0",-84.0572281091,10.3447163271,2008-05-30 |
|
| 82 |
Volcán Barva,VG-VB-5,"0,0",-84.1068322137,10.1823432219,2009-05-26 |
|
| 83 |
Volcán Barva,VG-VB-6,"0,0",-84.1080677857,10.1351986936,2009-05-25 |
|
| 84 |
Volcán Barva,VG-VB-7,"0,0",-84.0552816144,10.2678697806,2008-10-21 |
|
| 85 |
Volcán Barva,VG-VB-8,"0,0",-84.0850028149,10.2403425582,2009-11-13 |
|
| 86 |
Volcán Barva,VG-VB-9,"0,0",-84.00985772,10.43214216,2010-05-28 |
|
| 87 |
Yanachaga Chimillén National Park,VG-YAN-1,"0,0",-75.2503069,-10.35049162,-- |
|
| 88 |
Yanachaga Chimillén National Park,VG-YAN-2,"0,0",-75.25653021,-10.3806513,-- |
|
| 89 |
Yanachaga Chimillén National Park,VG-YAN-3,"0,0",-75.28502173,-10.35418209,-- |
|
| 90 |
Yanachaga Chimillén National Park,VG-YAN-4,"0,0",-75.29446998,-10.37508504,-- |
|
| 91 |
Yanachaga Chimillén National Park,VG-YAN-5,"0,0",-75.32989584,-10.40999508,-- |
|
| 92 |
Yanachaga Chimillén National Park,VG-YAN-6,"0,0",-75.31577971,-10.42219729,-- |
|
| inputs/TEAM/VT/map.csv | ||
|---|---|---|
| 5 | 5 |
Genus,genus,, |
| 6 | 6 |
Species,specificEpithet,, |
| 7 | 7 |
Names of Collectors,recordedBy,, |
| 8 |
Diameter,diameterBreastHeight_cm,,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 6 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/ci-team_extract/Vegetation-Metadata-1.4.pdf>)"
|
|
| 8 |
Diameter,diameterBreastHeight_cm,,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 7 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
|
|
| 9 | 9 |
POM Height,POM Height,, |
| 10 | 10 |
New Diameter,New Diameter,, |
| 11 | 11 |
New POM Height,New POM Height,, |
| 12 | 12 |
Condition Codes,Condition Codes,, |
| 13 | 13 |
Sampling Period,Sampling Period,, |
| 14 | 14 |
Comments,Comments,, |
| 15 |
Data Level,Data Level,, |
|
| 15 | 16 |
Sampling Unit Name,Sampling Unit Name,, |
| 16 | 17 |
Latitude,verbatimLatitude,, |
| 17 | 18 |
Longitude,verbatimLongitude,, |
| 18 |
Method,samplingProtocol,, |
|
| 19 |
Spatial Method,samplingProtocol,,
|
|
| 19 | 20 |
Subplot Number,subplot,, |
| 20 | 21 |
1ha Plot X Coordinate,organismX,, |
| 21 | 22 |
1ha Plot Y Coordinate,organismY,, |
| ... | ... | |
| 23 | 24 |
Site Name,projectName,, |
| 24 | 25 |
1ha Plot Number,plotName,, |
| 25 | 26 |
Protocol Version,Protocol Version,, |
| 26 |
Responsible Institution,Responsible Institution,, |
|
| 27 |
Protocol Lead Scientist,Protocol Lead Scientist,, |
|
| 28 |
Protocol Lead Scientist Institution,Protocol Lead Scientist Institution,, |
|
| 27 |
Data Set Creator Institution,Data Set Creator Institution,, |
|
| 28 |
Data Set Creator Scientist,Data Set Creator Scientist,, |
|
| 29 |
Data Set Contact,Data Set Contact,, |
|
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
Subplot Number,/location/authorlocationcode, |
| 7 | 7 |
Latitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value", |
| 8 | 8 |
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value", |
| 9 |
Method,/location/locationevent/*_id/method/name, |
|
| 9 |
Spatial Method,/location/locationevent/*_id/method/name,
|
|
| 10 | 10 |
Site Name,/location/locationevent/*_id/project/projectname, |
| 11 | 11 |
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| 12 | 12 |
1ha Plot Number,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 13 | 13 |
Observation Date,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value, |
| 14 | 14 |
Observation Date,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value, |
| 15 | 15 |
Id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 16 |
Diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 6 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/ci-team_extract/Vegetation-Metadata-1.4.pdf>)"
|
|
| 16 |
Diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 7 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
|
|
| 17 | 17 |
Tree Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag, |
| 18 | 18 |
1ha Plot X Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m, |
| 19 | 19 |
1ha Plot Y Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m, |
| ... | ... | |
| 26 | 26 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 27 | 27 |
Comments,,** No join mapping for Comments ** |
| 28 | 28 |
Condition Codes,,** No join mapping for Condition Codes ** |
| 29 |
Data Level,,** No join mapping for Data Level ** |
|
| 30 |
Data Set Contact,,** No join mapping for Data Set Contact ** |
|
| 31 |
Data Set Creator Institution,,** No join mapping for Data Set Creator Institution ** |
|
| 32 |
Data Set Creator Scientist,,** No join mapping for Data Set Creator Scientist ** |
|
| 29 | 33 |
New Diameter,,** No join mapping for New Diameter ** |
| 30 | 34 |
New POM Height,,** No join mapping for New POM Height ** |
| 31 | 35 |
POM Height,,** No join mapping for POM Height ** |
| 32 |
Protocol Lead Scientist,,** No join mapping for Protocol Lead Scientist ** |
|
| 33 |
Protocol Lead Scientist Institution,,** No join mapping for Protocol Lead Scientist Institution ** |
|
| 34 | 36 |
Protocol Version,,** No join mapping for Protocol Version ** |
| 35 |
Responsible Institution,,** No join mapping for Responsible Institution ** |
|
| 36 | 37 |
Sampling Period,,** No join mapping for Sampling Period ** |
| 37 | 38 |
Sampling Unit Name,,** No join mapping for Sampling Unit Name ** |
| inputs/TEAM/VT/test.xml.ref | ||
|---|---|---|
| 23 | 23 |
</longitude_deg> |
| 24 | 24 |
</locationcoords> |
| 25 | 25 |
<locationevent> |
| 26 |
<method_id><method><name>$Method</name></method></method_id> |
|
| 26 |
<method_id><method><name>$Spatial Method</name></method></method_id>
|
|
| 27 | 27 |
<project_id><project><projectname>$Site Name</projectname></project></project_id> |
| 28 | 28 |
<obsenddate><_date><date><_dateRangeEnd><value>$Observation Date</value></_dateRangeEnd></date></_date></obsenddate> |
| 29 | 29 |
<obsstartdate><_date><date><_dateRangeStart><value>$Observation Date</value></_dateRangeStart></date></_date></obsstartdate> |
| inputs/TEAM/VT/unmapped_terms.csv | ||
|---|---|---|
| 4 | 4 |
Condition Codes |
| 5 | 5 |
Sampling Period |
| 6 | 6 |
Comments |
| 7 |
Data Level |
|
| 7 | 8 |
Sampling Unit Name |
| 8 | 9 |
Protocol Version |
| 9 |
Responsible Institution |
|
| 10 |
Protocol Lead Scientist |
|
| 11 |
Protocol Lead Scientist Institution |
|
| 10 |
Data Set Creator Institution |
|
| 11 |
Data Set Creator Scientist |
|
| 12 |
Data Set Contact |
|
| inputs/TEAM/TEAM_Sites/map.csv | ||
|---|---|---|
| 1 |
TEAM,VegCore,Filter,Comments |
|
| 2 |
Site Name,projectName,, |
|
| 3 |
Name,plotName,, |
|
| 4 |
1ha Plot Coordinate,1ha Plot Coordinate,, |
|
| 5 |
Longitude,verbatimLongitude,, |
|
| 6 |
Latitude,verbatimLatitude,, |
|
| 7 |
CollectionDate,eventDate,, |
|
| inputs/TEAM/TEAM_Sites/test.xml.ref | ||
|---|---|---|
| 1 |
Put template: |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_simplifyPath id="-1"> |
|
| 4 |
<next>parent_id</next> |
|
| 5 |
<path> |
|
| 6 |
<location> |
|
| 7 |
<authorlocationcode>$Name</authorlocationcode> |
|
| 8 |
<locationcoords> |
|
| 9 |
<latitude_deg> |
|
| 10 |
<_nullIf> |
|
| 11 |
<null>0</null> |
|
| 12 |
<type>float</type> |
|
| 13 |
<value>$Latitude</value> |
|
| 14 |
</_nullIf> |
|
| 15 |
</latitude_deg> |
|
| 16 |
<longitude_deg> |
|
| 17 |
<_nullIf> |
|
| 18 |
<null>0</null> |
|
| 19 |
<type>float</type> |
|
| 20 |
<value>$Longitude</value> |
|
| 21 |
</_nullIf> |
|
| 22 |
</longitude_deg> |
|
| 23 |
</locationcoords> |
|
| 24 |
<locationevent> |
|
| 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> |
|
| 28 |
</locationevent> |
|
| 29 |
</location> |
|
| 30 |
</path> |
|
| 31 |
</_simplifyPath> |
|
| 32 |
</VegBIEN> |
|
| 33 |
Inserted 8 new rows into database |
|
| inputs/TEAM/TEAM_Sites/new_terms.csv | ||
|---|---|---|
| 1 |
Site Name,projectName,, |
|
| 2 |
Name,plotName,, |
|
| 3 |
CollectionDate,eventDate,, |
|
| inputs/TEAM/TEAM_Sites/unmapped_terms.csv | ||
|---|---|---|
| 1 |
1ha Plot Coordinate |
|
Also available in: Unified diff
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.