Syntax file for the ITEX metadata database. Purpose of a Syntax file: This syntax file lists the table and field names found in the ITEX metadata database and an expanded explanation of the type of data appended to each. General Syntax: A three-letter code is attached to the beginning of all table, query, form and field names. This is standard practice in database programming and aids in data management, querying and integration with other programs. Tables, Queries and Forms: tbl: Denotes a table in the database qry: Denotes a query in the database frm: Denotes a form in the database Syntax of Fields: cnt: Count data dtm: Date and time data mem: Memo data (not searchable) num: Numerical data ole: Linking field for objects such as word documents, photos, etc. str: Text data (includes numbers) ysn: Yes or no data Tables: Below is a syntax list of tables and respective table fields in the ITEX metadata database. tblClimInfo: This table includes information on climate data collected at ITEX sites. strSubSite: Subsite where climate measurements are being taken strSubSiteCode: Code of subsite where climate data measurements are being taken strSite: Site where climate measurements are being taken strSiteCode: Code of site where climate measurements are being taken strWrkGrp: Working group administering site and subsite where climate measurements are being taken strWrkGrpCode: Code of working group administering site and subsite where climate measurements are being taken memGenDesc: General climate description of the site or subsite where climate measurements are being taken strNearMetStn: Name of the nearest meteorological station numDistMetStn: Approximate distance (km) to the nearest meteorological station strHistMetStn: History of the nearest meteorological station numLvlITEXStn: level of the ITEX station at this subsite strMeasts: Climatic measurements being recorded strRecTimes: Recording times climate measurements are taken strDLogBrand: Brand of data loggers being used strSensBrand: Brand of sensors being used strClimRecHist: History of ITEX climate measurements at the subsite memprobs: Problems encountered strRefs: Reference numbers were climate data are shown memcomm: General comments olePhoto: Photograph of ITEX climate station strCapt: Caption of the photograph of the ITEX climate station ysnConf: Whether the information provided has been confirmed with the working group dtmUptd: The date when this information was last updated tblRefInfo This table includes information on references published by ITEX working groups. cntRefNo: Reference number (automatic) memRef: Reference of publication strSrnme: Surname of first author strPubType: Publication type (refereed journal article, conference presentation, poster, thesis, etc.) memAbst: Abstract of the reference strKyWords: Keywords of the reference strAuthCntry: Country of the author strAuthInstit: Institute of the author strReprint: Contact for reprints strURL: URL address of the reference numRefYr: Year the reference was published strWrkGrp: Working group represented in the reference strWrkGrpCode: Code of the working group represented in the reference strSite: ITEX sites represented in the reference strSiteCode: Code of the ITEX sites represented in the reference strSubSite: ITEX subsites represented in the reference strSubSiteCode: Code of the ITEX subsites represented in the reference strBiome: Biomes represented in the reference strVeg: Vegetation types represented in the reference strPFTs: Plant functional types (PFT) represented in the reference strPlFam: Plant families represented in the reference strPlGen: Plant genera represented in the reference strPlSpp: Plant species represented in the reference strClimParams: Climatic parameters represented in the reference strManips: Experimental manipulations represented in the reference strStats: Statistical methods represented in the reference memComm: General comments ysnConf: Whether the information provided has been confirmed with the working group dtmUptd: The date when this information was last updated tblReschrInfo This table includes information on specific ITEX researchers and their working group affiliations strName: Name of the researcher strAddrs: Address of the researcher strEmail: Email of the researcher strPh: Phone number of the researcher (include international codes) strFax: Fax number of the researcher (include international codes) strRole: Primary role of the researcher (professor, lecturer, postdoc, PhD candidate, etc.) strTitle: Title of the researcher (Dr., etc.) strWrkGrp: Working group which the researcher is associated with strWrkGrpCode: Code of the working group that the researcher is associated with strResInts: Research interests of the researcher strSppInts: Species of interest to the researcher strPFTInts: Plant functional types (PFT) of interest to the researcher strVegInts: Vegetation types of interest to the researcher strManipInts: Manipulative experiments of interest to the researcher strSystFnctInts:Systems or functional interests of the researcher strClimInt: climate interests of the researcher strProj_A: Name of project A in which the researcher is involved strProj_B: Name of project B in which the researcher is involved strProj_C: Name of project C in which the researcher is involved strProj_D: Name of project D in which the researcher is involved strProj_E: Name of project E in which the researcher is involved strGrant: ITEX related grant success - organization and amount strRefs: References in which the researcher is an author strStats: Areas of statistical competence held by the researcher memFutInts: Future interests of the researcher strIntsLnks: Other international links of the researcher (GCTE, RiSCC, etc.) strURL_A: First URL address of the researcher or researcher's organization or research links strURL_B: Second URL address of the researcher or researcher's organization or research links strURL_C: Third URL address of the researcher or researcher's organization or research links strURL_D: Fourth URL address of the researcher or researcher's organization or research links strURL_E: Fifth URL address of the researcher or researcher's organization or research links olePhoto: Photograph of the researcher memComm: General comments ysnConf: Whether the information provided has been confirmed with the working group dtmUptd: The date when this information was last updated cntReschr: Reference number (Automatic) tblSiteInfo This table contains information of specific ITEX research sites, the research history of these sites and the data collected there. strSite: Site name strWrkGrp: Name of the group administering the site strWrkGrpCode: Code of the working group administering the site strSiteCode: Code of the site strLat: Latitude of the site strLon: Longitude of the site strCnty: Country where the site is located strRegion: Region where the site is located (high Artic, low Arctic, Alpine, subantarctic, Antarctic, etc.) strBiome: Biome of the site ysnSppList: Whether there is a species list for the site ysnActive: Whether the site is currently active ysnLake: Whether lake data has been collected for this site strSubsite_A: Name of the first subsite associated with this site strSubsite_B: Name of the second subsite associated with this site strSubsite_C: Name of the third subsite associated with this site strSubsite_D: Name of the fourth subsite associated with this site strSubsite_E: Name of the fifth subsite associated with this site strSubsite_F: Name of the sixth subsite associated with this site strSubsite_G: Name of the seventh subsite associated with this site strSubsite_H: Name of the eighth subsite associated with this site strSubsite_I: Name of the ninth subsite associated with this site strSubsite_J: Name of the tenth subsite associated with this site strSubsite_K: Name of the eleventh subsite associated with this site strSubsite_L: Name of the twelfth subsite associated with this site strSubsite_M: Name of the thirteenth subsite associated with this site strSubsite_N: Name of the fourteenth subsite associated with this site strSubsite_O: Name of the fifteenth subsite associated with this site strIntLnks: Other international links to this site (GCTE, RiSCC, etc.) strRefs: References that included information on this site memComm: General comments olePhoto: Photograph of the site strCapt: Caption of the photograph of the site ysnConf: Whether the information provided has been confirmed with the working group dtmUptd: The date when this information was last updated cntSite: Reference number (automatic) tblSppInfo This table contains information on the plant species of interest to ITEX working groups. strSpp: Species name strGen: Genus strFam: Family ysnComm: Whether the species is one of the ten most common for the subsite ysnStud: Whether the species is included in community composition or response data being recorded strSubSite: Subsite where the species is found strSubSiteCode: Code of the subsite where the species is found strSite: Site where the species is found strSiteCode: Code of the site where the species is found strWrkGrp: Working group that administers the site and subsite where the species is found strWrkGrpCode: Code of the working group that administers the site and subsite where the species is found strPFT: Plant functional type of the species at this subsite strVeg: Main vegetation type at the subsite ysnAutec: Whether the species is the subject of autecological studies strManip: Manipulative experiments this species is included in strGraz: Grazing information on this species at this subsite memPalHist: Paleohistory of the species at this subsite or site strRefs: References this species is included in strLat: Latitude of the subsite or site where this species is found strLon: Longitude of the subsite or site where this species is found numElev: Elevation of the subsite or site where this species is found memResHist: Research history of the species at this subsite ysnClimAvai: Whether climate data is available for this site memComm: General comments olePhoto: Photograph of the species strCapt: Caption of the photograph of the species ysnConf: Whether the information provided has been confirmed with the working group dtmUptd: Date when this information was last updated cntSpp: Reference number (automatic) tblSppList This table contains a list of all species studied at ITEX sites and information about these species. cntSppNo: Species number (automatic) strSpp: Species name (including variety or subspecies) strGen: Genus strFam: Family strType: Plant type (monocot, dicot, fern or fern ally) strId: Who verified the identification of the species memComm: General comments ysnConf: Whether the information provided has been confirmed with the working group dtmUptd: Date when this information was last updated tblSubSiteInfo This table contains information on the subsites located within individual ITEX sites and the data collected at these subsites. strSubSite: Subsite name strSubSiteCode: Subsite code strSite: Name of the site which this subsite is part of strSiteCode: Code of the site which this subsite is part of strWrkGrp: The working group that administers this subsite strWrkGrpCode: Code of the working group that administers this subsite ysnAltGr: Whether this subsite forms a component of an altitudinal gradient ysnLatGr: Whether the subsite forms a component of a latitudinal gradient strLat: Latitude of the subsite if different from that listed for the site strLon: Latitude of the subsite if different from that listed for the site numElev: Elevation of the subsite (meters above sea level) numAsp: Aspect of the subsite (give compass bearing) numSlope: Angle of the slope of the subsite (give clinometer reading) strLform: Main landform of the subsite strVeg: Main vegetation type of the subsite ysnSppList: Whether there is a species list given for this subsite memPalHist: Paleohistory of the subsite strResHist: Research history of the subsite including non-ITEX research memYrsITEXRes: ITEX research history of the subsite ysnRegClimData: Whether regional climate data is available for the subsite ysnMicroClim: Whether microclimatic data is available for the subsite memManips: Experimental manipulations established at the subsite (warming etc.) ysnChamb: Whether there are warming chambers at this subsite strTypChamb: Type of warming chambers used at the subsite, if any strSzChamb: Size of warming chambers used at the subsite, if any ysnCommComp: Whether community composition data has been recorded at the subsite ysnSppResp: Whether species responses to manipulations have been recorded for the subsite ysnSystFnct: Whether systems or functional studies have been conducted at the subsite ysnAutec: Whether autecological studies have been conducted at the subsite ysnPhysiol: Whether physiological studies have been conducted at the subsite ysnSeedbk: Whether seed bank studies have been conducted at the subsite ysnBmass: Whether biomass measurements have been taken at the subsite ysnTranspl: Whether transplant experiments have been conducted at the subsite ysnGardExpt: Whether plants from this subsite have been collected for common garden experiments ysnFixTrans: Whether fixed transects have been established at the subsite ysnSoillData: Whether soil data has been collected at the subsite ysnActLay: Whether active layer measurements have been taken at the subsite ysnPFrst: Whether permafrost data has been collected at this subsite ysnSnwMlt: Whether snowmelt data has been collected at the subsite ysnSnwDpth: Whether snow depth data has been collected at this subsite ysnGraz: Whether grazing data has been collected at this subsite ysnGrazCont: Whether grazing controls have been established at this subsite strGrazFauna: Grazing fauna present at the subsite ysnInvert: Whether invertebrate studies have been conducted at this subsite memProbs: Problems experienced at this subsite strRefs: References that include data from this subsite memComm: General comments olePhoto: Photograph of the subsite strCapt: Caption of the photograph of the subsite ysnConf: Whether the information provided has been confirmed with the working group dtmUptd: The date when this information was last updated cntSubSiteInfo: Reference number (automatic) tblWorkGrpInfo This table contains information on the specific ITEX working groups and their contact information. strWrkGrp: Name of the working group (usually the surname of the PI followed by the institution) strWrkGrpCode: Code of the working group strCntct: Contact for the working group strCntctEml: Contact email for the working group memCntctAdd: Contact address for the working group strCntry: Country where the working group is based strNmePI_A: Name of the first principle investigator strEmailPI_A: Email of the first principle investigator strNmePI_B: Name of the second principle investigator strEmailPI_B: Email of the second principle investigator strNmePI_C: Name of the third principle investigator strEmailPI_C: Email of the third principle investigator strNmePI_D: Name of the fourth principle investigator strEmailPI_D: Email of the fourth principle investigator strNmePI_E: Name of the fifth principle investigator strEmailPI_E: Email of the fifth principle investigator strNmeAssInv_A: Name of the first associate investigator strEmailAssInv_A: Email of the first associate investigator strNmeAssInv_B: Name of the second associate investigator strEmailAssInv_B: Email of the second associate investigator strNmeAssInv_C: Name of the third associate investigator strEmailAssInv_C: Email of the third associate investigator strNmeAssInv_D: Name of the fourth associate investigator strEmailAssInv_D: Email of the fourth associate investigator strNmeAssInv_E: Name of the fifth associate investigator strEmailAssInv_E: Email of the fifth associate investigator strNmeRA_A: Name of the first research assistant strEmailRA_A: Email of the first research assistant strNmeRA_B: Name of the second research assistant strEmailRA_B: Email of the second research assistant strNmeRA_C: Name of the third research assistant strEmailRA_C: Email of the third research assistant strNmeRA_D: Name of the fourth research assistant strEmailRA_D: Email of the fourth research assistant strNmeRA_E: Name of the fifth research assistant strEmailRA_E: Email of the fifth research assistant strSite_A: Name of the first site administered by the working group strSiteCode_A: Code of the first site administered by the working group strSite_B: Name of the second site administered by the working group strSiteCode_B: Code of the second site administered by the working group strSite_C: Name of the third site administered by the working group strSiteCode_C: Code of the third site administered by the working group strSite_D: Name of the fourth site administered by the working group strSiteCode_D: Code of the fourth site administered by the working group strSite_E: Name of the fifth site administered by the working group strSiteCode_E: Code of the fifth site administered by the working group strRefs: References generated by the working group strURL_A: First URL address for the working group strURL_B: Second URL address for the working group strURL_C: Third URL address for the working group strURL_D: Fourth URL address for the working group strURL_E: Fifth URL address for the working group memcomm: General comments olePhoto: Photograph of the group strCapt: Caption of the photograph of the group ysnConf: Whether the information provided has been confirmed with the working group dtmUptd: The date this information was last updated cntWorkGrpInfo: Reference number (automatic)