{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Database Name","Projects","SurveyAreaPolygons","Conditions (input - table)","Observations (input - point FC)","Observers (lookup - table)","Species (lookup - table)","Coded Value Domains","Relationship Classes","Plots BMDE (output - table)","Relational Diagram"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Database Name","index":0,"n_rows":3,"n_cols":3,"rows_kept":3}
["Language","Acronyn","Name"]
["French","QSC","Base de données sur la Quantification de la Sauvagine au Canada"]
["English","QWAC","Quantifying Waterfowl Across Canada database"]

{"sheet":"Projects","index":1,"n_rows":25,"n_cols":11,"rows_kept":25}
["Alias French","Alias English","Field name","Data type","Mandatory at entry","Automated","Rule","Default","Domain","Description English","Description French"]
["Identificateur du projet","Project short form ID","projID","varchar (8)","yes",{"$nulls":4},"Project name shortform (e.g. EWS25)","Identificateur correspondant à la forme courte du nom du projet (p. ex. EWS25)"]
["Nom complet du projet","Project full name","projName","varchar (150)","yes",{"$nulls":4},"Project full name (e.g. Eastern Waterfowl Survey aerial 25km-square plots)","Nom complet du projet (p. ex. Eastern Waterfowl Survey aerial 25km-square plots)."]
["Code de l'organisme qui administre le projet","Code of administering institution","instCode","char (3)","yes",{"$nulls":4},"Always \"CWS\" as the institution administering the project.","Toujours \"SCF\" en tant qu'organisme administrant le projet."]
["Régions du SCF","CWS regions","CWSRegs","char (30)","yes",{"$nulls":4},"Region (or regions separated by semi-colons) in which project took place, using 3-letter codes in CWSRegions domain","Région (ou régions séparées par un ou des points-virgules) dans laquelle le projet a lieu/a eu lieu, selon le code de 3 lettres tiré du domaine CWSRegions."]
["Codes des provinces et des territoires","Province and territory codes","provTerrs","char (30)","yes",{"$nulls":4},"Standard two letter province or territory codes","Code de deux lettres standard  des provinces et des territoires."]
["Responsables des données du projet","Project data stewards","projDataStew","text","yes",{"$nulls":4},"Names of individuals responsible for stewarding project data and fielding inquiries regarding project, can be multiple seperated by semi-colons and can specify CWS Region if a multi-region project","Noms des personnes responsables de gérer les données du projet et de répondre aux requêtes liées au projet; peut contenir plusieurs noms séparés par des points-virgules et peut spécifier la région du SCF s'il s'agit d'un projet multi-régions."]
["Courriel des responsables des données du projet","Project data stewards emails","projDataStewEm","text","yes",{"$nulls":4},"Emails of ProjectDataStewards","Courriel des responsables des données du projet."]
["Année du début du projet","Start year of project","startYr","smallint","yes",null,"YYYY",null,null,"First year of data collection for the project","Première année de la collecte de données du projet."]
["Année de la fin du projet","End year of project","endYr","smallint","no",null,"YYYY",null,null,"Last year of data collection for the project, NA if project is on-going","Dernière année de la collecte de données du projet, NA  si le projet est en continu."]
["Permission de publication","Publication permissions","pubPerm","smallint","yes",{"$nulls":3},"YesNo","Indicates whether permission has been granted by the Project Data Stewards to publish the data online (1 = yes, 0 = no). ","Indique si la permission a été donnée par le ou les responsable(s) des données du projet pour que les données soient publiées en ligne (1 = oui, 0 = non). "]
["Détails de la permission de publication","Publication permissions details","pubPermDet","text","yes",{"$nulls":4},"Details of publication permissions if PublicationPermissions is \"no\", including for example whether observations include sensitive species, if project data stewards request  time to publish results of analyses prior to data publication (include date of publication permission), or if project partners do not wish for data to be published","Détails de la permission de publication si pubPerm est \"non\"; par exemple, si les données comportent des espèces sensibles, si les responsables du projet ont besoin de temps pour publier les résultats d'analyses avant que ne soient publiées les données (indiquer la date de la permission de publication) ou si les partenaires du projet ne veulent pas que les données soient publiées."]
["Type de protocole général","General protocol type","proType","varchar (20)","yes",{"$nulls":3},"ProtocolTypes","Broad category of protocol employed to make observations in this project (e.g. EWS25 is plot-based and is thus \"area search\")","Catégorie large du protocole utilisé pour faire les observations de ce projet (p. ex. le EWS25 est effectué au-dessus de quadrats, ce qui correspond à \"recherche par secteur\")."]
["Type de protocole d'inventaire","Survey protocol type","survType","varchar (30)","yes",{"$nulls":3},"SurveyTypes","Specific category of protocol employed to make observations in this project (e.g. EWS25 is aerial, plot-based area search and is thus \"plot aerial area search\")","Catégorie spécifique du protocole utilisé pour faire les observations de ce projet (p. ex. le EWS25 est un inventaire aérien, utilisant la recherche par secteur, au-dessus de quadrat, ce qui correspond à \"recherche par secteur aérien quadrat\")."]
["Nom de la table de la superficie d'inventaire correspondante","Name of corresponding survey area table","survArTab","varchar (20)","yes",{"$nulls":3},"SurveyAreaTables","Names the table in which the survey area is described (e.g. Plots for plot-based surveys, or Transects for transect-based surveys, or Tracks for general area-search surveys, or Points for stationary point-based surveys)","Identifie la table dans laquelle le secteur d'inventaire est décrit (p. ex. Quadrats pour les inventaires réalisés dans des quadrats, ou Transects pour les inventaires réalisés dans des transects, ou Tracés pour les inventaires généraux de recherche par secteur, ou Points pour les inventaires réalisés à partir d'une position stationnaire)."]
["Espèce(s) ou groupe(s) taxonomique(s) ciblé(e)(s)","Species or taxonomic group targeted","spTarg","varchar (50)","yes",{"$nulls":4},"A short description of the species or taxonomic group(s) targeted by the project survey protocol (e.g. EWS25 is \"waterfowl\")","Courte description de l'/des espèce(s) ou du/des groupe(s) taxonomique(s) visé(e)(s) par le protocole d'inventaire du projet (p. ex. \"sauvagine\" pour le EWS)."]
["Est-ce que toutes les espèces ciblées ont été rapportées?","Were all targeted species reported?","allSpRep","smallint","yes",{"$nulls":3},"YesNo","Whether the protocol includes all individuals that have been detected within the spTarg field. \"No\" should be used to indicate that sampling events should not be used to infer negative observations (1 = yes, 0 = no).","Le protocole inclut-il toutes les détections d'individus entrés dans le champ spTarg. \"Non\" devrait être utilisé pour indiquer que cette séance d'inventaire ne devrait pas être utilisée pour inférer l'absence d'observations (1 = oui, 0 = non)."]
["Référence du protocole publié","Reference to published protocol","proRef","text","no",{"$nulls":4},"A published reference describing the protocol used to collect the observation data (e.g. EWS25 could be \"Bordage, D. Bateman, M.C. Ross, R.K. Lepage, C. (editors). 2017. Helicopter-based waterfowl breeding pair survey in eastern Canada and related studies. Black Duck Joint Venture Special Publication. 236 pp\" or could link to protocol published on ECCC open data portal)","Une référence publiée décrivant le protocole utilisé pour la collecte de données du projet (p. ex. pour le EWS25, pourrait être \"Bordage, D. Bateman, M.C. Ross, R.K. Lepage, C. (editors). 2017. Helicopter-based waterfowl breeding pair survey in eastern Canada and related studies. Black Duck Joint Venture Special Publication. 236 pp\" ou un lien vers un protocole publié sur le portail du gouvernement ouvert)."]
["URL du protocole publié","URL of published protocol","proURL","text","no",{"$nulls":4},"The URL of the ProtocolReference (e.g. EWS25 could be researchgate.net/profile/Daniel-Bordage/publication/315654492_Helicopter-based_Waterfowl_Breeding_Pair_Survey_in_Eastern_Canada_and_Related_Studies/links/58d81d6fa6fdcc1baeb8eb36/Helicopter-based-Waterfowl-Breeding-Pair-Survey-in-Eastern-Canada-and-Related-Studies.pdf)","L'URL de la référence du protocole (p. ex. pour le EWS25, pourrait être researchgate.net/profile/Daniel-Bordage/publication/315654492_Helicopter-based_Waterfowl_Breeding_Pair_Survey_in_Eastern_Canada_and_Related_Studies/links/58d81d6fa6fdcc1baeb8eb36/Helicopter-based-Waterfowl-Breeding-Pair-Survey-in-Eastern-Canada-and-Related-Studies.pdf)."]
["Nom du champ dans Conditions servant à identifier la séance d'inventaire","Field name in Conditions for survey event identifier","survEvID","varchar (20)","yes",{"$nulls":4},"Names the field in Conditions which describes the survey or \"sampling\" event, where a survey event is defined as an attempt to observe birds during a specified amount of time at a location (e.g. EWS25 is SurveyID)","Identifie le champ dans Conditions qui décrit la séance d'inventaire ou d'échantillonnage, où une séance d'inventaire est définie comme une tentative d'observer des oiseaux pendant une période de temps définie à une position (p. ex. EWS25 est SurveyID)."]
["Structure du champ dans Conditions pour la séance d'inventaire","Structure of field in Conditions for survey event","survEvStr","varchar (20)","yes",{"$nulls":4},"Describes the structure of the survey observation (i.e. sampling) events (e.g., EWS25 is \"SurveyAreaID_Year\")","Décrit la structure de la séance d'inventaire (c.-à-d. échantillonnage) (p. ex. EWS25 est \"SurveyAreaID_Year\")"]
["Nom du champ dans Observations pour la superficie de l'inventaire","Field name in Observations for survey area","survArField","varchar (20)","yes",{"$nulls":4},"Names the field in Observations which identifies the geographic site at which the observation was made (e.g. EWS25 is SurveyAreaID)","Identifie le champ dans Observations qui décrit le lieu géographique où l'observation a été faite (p. ex. EWS25 est SurveyAreaID)"]
["Portée géographique des coordonnées de l'aire de l'inventaire","Geographic scope of survey area coordinates","survArScope","varchar (20)","yes",{"$nulls":4},"The geographic scope of the coordinates associated with the SurveyAreaIdentifier (e.g. EWS25 is \"SurveyArea (centroid)\")","La portée géographique des coordonnées associées à SurveyAreaIdentifier (p. ex. EWS25 est \"SurveyArea (centroid)\")."]
["Coordonnées du système de référence géodésique","Geodetic datum of coordinates","geoDat","varchar (10)","yes",{"$nulls":4},"The geodetic datum to which the latitude and longitude of SurveyAreaIdentifier and observations refer, should always be \"WGS1984\" for QWAC data","Le système de référence géodésique auquel la latitude et la longitude de SurveyAreaIdentifier et les observations réfèrent, devrait toujours être \"WGS1984\" pour les données dans QWAC."]
["Information supplémentaire à propos de l'inventaire","Additional information about project","addInfo","text","no",{"$nulls":4},"Any additional information useful at a glance","Toute information supplémentaire utile."]

{"sheet":"SurveyAreaPolygons","index":2,"n_rows":20,"n_cols":11,"rows_kept":20}
["Alias French","Alias English","Field name","Data type","Mandatory at entry","Automated","Rule","Default","Domain","Description English","Description French"]
["Identificateur (ID) du projet","Project short form ID","projID","varchar (8)","yes",{"$nulls":4},"Project name shortform (e.g. EWS25), must match an entry in projID in Projects table","Identificateur correspondant à la forme courte du nom du projet (p. ex. EWS25), doit correspondre à une entrée sous le champ projID de la table Projects (Projets)."]
["Identificateur (ID) du secteur d'inventaire","Survey area ID","survArID","varchar (20)","yes",{"$nulls":4},"Unique standardized identifier describing the locale of the survey, concatenating ProjectCode with unique identifier for survey area within the project (e.g., for EWS25, a plot-based survey project, EWS25_76002)","Identificateur unique normalisé décrivant le lieu de l'inventaire, concaténant le ProjectCode avec l'identificateur unique du secteur d'inventaire à l'intérieur du projet (p. ex. pour le EWS25, qui est un projet d'inventaire par quadrats, EWS25_76002)"]
["Identificateur (ID) d'origine du secteur d'inventaire","Original survey area ID","origID","varchar (20)","yes",{"$nulls":4},"Original survey area ID used by the Project (not always unique within or across Projects)","Identificateur d'origine du secteur d'inventaire (pas toujours unique pour un même projet ou entre les projets)"]
["Pays","Country","country","varchar (20)","yes",{"$nulls":4},"Full country name","Nom complet du pays"]
["Code de la province ou du territoire","Province or territory code","provTerr","char (2)","yes",{"$nulls":4},"Two letter province or territory code","Code de deux lettres des provinces et des territoires."]
["Nom complet de la province ou du territoire","Province or territory full name","provTerrFull","varchar (25)","yes",{"$nulls":4},"Full province or territory name","Nom complet de la province ou du territoire"]
["Région du SCF","CWS region","CWSReg","char (3)","yes",{"$nulls":3},"CWSRegionCodes","Three letter CWS region code","Code de 3 lettres des régions du Service canadien de la faune."]
["Latitude du centroïde du secteur d'inventaire","Latitude of centroid of survey area","cenLat","decimal (8,6)","yes",null,"Value between -90 and 90",null,null,"Latitude of the survey area centroid, WGS1984","Latitude du centroïde du secteur d'inventaire, WGS1984"]
["Longitude du centroïde du secteur d'inventaire","Longitude of centroid of survey area","cenLon","decimal (9,6)","yes",null,"Value between -180 and 180",null,null,"Longitude of the survey area centroid, WGS1984","Longitude du centroïde du secteur d'inventaire, WGS1984"]
["Zone UTM du centroïde du secteur d'inventaire","UTM zone of survey area centroid","utmZone","smallint","yes",{"$nulls":4},"Numeric UTM zone of the survey area centroid","Zone UTM numérique du centroïde du secteur d'inventaire"]
["Fuseau horaire du centroïde du secteur d'inventaire","Time zone of survey area centroid","timeZone","varchar (25)","yes",{"$nulls":4},"Time zone of the survey area centroid for UTC time conversions","Fuseau horaire du centroïde du secteur d'inventaire servant à la conversion en temps UTC"]
["Superficie du secteur d'inventaire (m2)","Area of survey area (m-squared)","areaM2","int","yes",{"$nulls":4},"m-squared","Superficie du secteur d'inventaire en mètres carrés"]
["Superficie du secteur d'inventaire (ha)","Area of survey area (ha)","areaHa","int","yes",{"$nulls":4},"Area converted to ha","Superficie convertie en hectares"]
["Longueur de l'axe long du secteur d'inventaire (m)","Length of long axis of survey area (m)","longAxLen","smallint","yes",{"$nulls":4},"Long axis length of the survey area in m","Longueur de l'axe long du secteur d'inventaire en mètres"]
["Longueur de l'axe court du secteur d'inventaire (m)","Length of short axis of survey area (m)","shortAxLen","smallint","yes",{"$nulls":4},"Short axis length of the survey area in m","Longueur de l'axe court du secteur d'inventaire en mètres"]
["Distance du centroïde au coin le plus proche (m)","Distance from centroid to furthest corner (m)","cen2Corn","smallint","yes",{"$nulls":4},"The upper limit of the distance (in m) from the survArID centroid describing a circle within which the whole of the described locality must lie","Distance maximale (en mètres) du centroïde du survArID décrivant un cercle dans lequel l'entièreté de l'endroit décrit se trouve."]
["Forme du secteur d'inventaire","Shape of survey area","plotShape","varchar (20)","yes",{"$nulls":3},"SurveyAreaShapes","Describes survey area shape (e.g. \"square\" or \"hexagon\")","Description de la forme du secteur d'inventaire (p. ex. \"carré\" ou \"hexagone\")"]
["Description du secteur d'inventaire","Description of survey area","descr","text","no",{"$nulls":4},"Additional information about survArID name, history, etc, content varies by region and project","Information supplémentaire à propos du nom, de l'historique, etc. de survArID; le contenu varie par région et projet"]
["Géométrie des limites du secteur d'inventaire","Survey area boundaries geometry","SHAPE","Polygon","yes",{"$nulls":4},"Spatial data field for plot polygon geometry","Champ comportant les données spatiales de la géométrie du polygone du quadrat"]

{"sheet":"Conditions (input - table)","index":3,"n_rows":33,"n_cols":11,"rows_kept":33}
["Alias French","Alias English","Field name","Data type","Mandatory at entry","Automated","Rule","Default","Domain","Description English","Description French"]
["Identificateur (ID) du secteur d'inventaire","Survey area ID","survArID","varchar (20)","yes",{"$nulls":4},"Standardized identifier describing the locale of the survey, concatenating ProjectCode with unique identifier for survey area within the project (e.g., for EWS25, a plot-based survey project, EWS25_76002)","Identificateur unique normalisé décrivant le lieu de l'inventaire, concaténant le ProjectCode avec l'identificateur unique du secteur d'inventaire à l'intérieur du projet (p. ex. pour le EWS25, qui est un projet d'inventaire par quadrats, EWS25_76002)"]
["Année","Year","yr","smallint","yes",null,"YYYY",null,null,"Year of the survey","Année de l'inventaire"]
["Identificateur (ID) de l'inventaire","Survey ID","survID","varchar (20)","yes",{"$nulls":4},"Unique identifier for each survey that shows survey area identifier, year and project  as \"SurveyAreaID_Year\" (e.g., for EWS25 in 2025, a plot-based survey project, EWS25_76002_2025). In cases where a unique SurveyArea (e.g. a plot) was surveyed more than once in a given year, the survID will have an additional identifier (e.g., EWS25_76002_2025_1 for the first survey in that year, and EWS25_76002_2025_2 for the second, and so on. ","Identificateur unique pour chaque inventaire qui a un identificateur du secteur d'inventaire, année et projet en tant que \"SurveyAreaID_Year\" (p. ex., pour le EWS25 en 2025, un projet d'inventaire par quadrats, EWS25_76002_2025). Dans les cas où un unique SurveyArea (p. ex. un quadrat) serait inventorié plus d'une fois au cours d'une même année, le survID aurait un identificateur additionnel (p. ex., EWS25_76002_2025_1 pour le premier inventaire cette année-là, et EWS25_76002_2025_2 pour le deuxième, et ainsi de suite). "]
["Date","Date","date","date","yes",null,"YYYY-MM-DD",null,null,"Date of the survey","Date de l'inventaire"]
["Mois","Month","month","smallint","yes",null,"Value between 1 and 12",null,null,"Month of the survey in numeric format (e.g. 1 = January, 12 = December)","Mois de l'inventaire en format numérique (p. ex. 1 = Janvier, 12 = Décembre)"]
["Jour","Day","day","smallint","yes",null,"Value between 1 and 31",null,null,"Day of the month of the survey ","Jour du mois de l'inventaire"]
["Heure de début (heure locale)","Start time in local time zone","startLocal","time","no",null,"HH:MM:SS (local time zone)","NA",null,"Time the survey started (local time zone); default cannot be 9999 because special timestamp field, so NA indicates unknown","Heure à laquelle l'inventaire a commencé (heure locale); la valeur par défaut ne peut pas être 9999 car il s'agit d'un champ d'horodatage spécial, donc NA signifie que l'heure était inconnue."]
["Heure de fin (heure locale)","End time in local time zone","endLocal","time","no",null,"HH:MM:SS (local time zone)","NA",null,"Time the survey ended (local time zone); default cannot be 9999 because special timestamp field, so NA indicates unknown","Heure à laquelle l'inventaire a fini (heure locale); la valeur par défaut ne peut pas être 9999 car il s'agit d'un champ d'horodatage spécial, donc NA signifie que l'heure était inconnue."]
["Heure de début (UTC)","Start time in UTC","startUTC","time","no",null,"HH:MM:SS (UTC)","NA",null,"Time the survey started (UTC); default cannot be 9999 because special timestamp field, so NA indicates unknown","Heure à laquelle l'inventaire a commencé (UTC); la valeur par défaut ne peut pas être 9999 car il s'agit d'un champ d'horodatage spécial, donc NA signifie que l'heure était inconnue."]
["Heure de fin (UTC)","End time in UTC","endUTC","time","no",null,"HH:MM:SS (UTC)","NA",null,"Time the survey ended (UTC); default cannot be 9999 because special timestamp field, so NA indicates unknown","Heure à laquelle l'inventaire a fini (UTC); la valeur par défaut ne peut pas être 9999 car il s'agit d'un champ d'horodatage spécial, donc NA signifie que l'heure était inconnue."]
["Durée de l'inventaire dans le secteur d'inventaire","Duration of time on survey area","dur","smallint","no",null,"Value ≥ 0",9999,null,"Survey duration in minutes, 9999 indicates unknown","Durée de l'inventaire en minutes, 9999 signifie que la durée est inconnue."]
["Le temps non dédié à inventorier a-t-il été soustrait de la durée de l'inventaire","Was downtime subtracted from survey duration?","durDown","varchar (20)","no",null,null,9999,"YesNo","Indicates if dur has down time (from refueling, weather, etc) subtracted ","Pour le champ \"dur,\" indique si le temps non dédié à inventorier (p. ex. pour le ravitaillement, en raison des conditions météorologiques, etc.) a été soustrait."]
["Couverture du secteur d'inventaire","Coverage of survey area","cov","smallint","no",null,"Value between 0 and 100",9999,null,"Percentage of habitable area in survey area flown (regardless of whether frozen)","Pourcentage des habitats dans le secteur d'inventaire qui ont été couverts (outre s'ils étaient gelés)"]
["Température","Temperature","temp","smallint","no",null,"Value between -100 and 100",9999,null,"Temperature during the survey in degrees Celsius","Température durant l'inventaire en degrés Celsius"]
["Pourcentage du secteur d'inventaire qui était gelé","Percent of survey area frozen","pctFroz","smallint","no",null,"Value between 0 and 100",9999,null,"Percentage of habitable area frozen on the survey area","Pourcentage des habitats qui étaient gelés dans le secteur d'inventaire"]
["Direction du vent","Wind direction","windDir","smallint","no",null,"Value between 0 and 359",9999,null,"Direction of wind in degrees (0 = N, 45=NE, 90=E, 135=SE, 180=S, 225=SW, 270=W, 315=NW)","Direction du vent en degrés (0 = N, 45=NE, 90=E, 135=SE, 180=S, 225=SO, 270=O, 315=NO)"]
["Vitesse du vent","Wind speed","windSpd","smallint","no",null,"Value ≥ 0",9999,null,"Wind speed in knots","Vitesse du vent en noeuds (kt)"]
["Couvert nuageux","Cloud cover","cloud","varchar (20)","no",null,null,9999,"CloudCoverCodes","Numeric cloud cover code","Code numérique du couvert nuageux"]
["Précipitation","Precipitation","precip","varchar (20)","no",null,null,9999,"PrecipitationCodes","Numeric precipitation code","Code numérique des précipitations"]
["Durée de la précipitation","Precipitation duration","precipDur","smallint","no",null,"Value between 0 and 100",9999,null,"Percentage of time with active precipitation during survey","Pourcentage du temps où les précipitations se sont produites durant l'inventaire"]
["Protocole de détection primaire","Primary detection protocol","primeDetect","varchar (20)","no",null,null,"NA","PrimaryDetectionCodes","When double-dependent detection protocols were implemented on the survey area, depicts whether the front or rear observer was the primary observer. See Roy et al. 2021 for methodology details. Must match entry in PrimaryDetectionCodes","Lorsqu'un protocole de détection double-dépendant a été mis en place dans le secteur d'inventaire, indique si c'est l'observateur assis à l'avant ou celui assis à l'arrière qui agissait comme observateur primaire. Consulter Roy et al. 2021 pour les détails méthodologiques. Doit correspondre aux valeurs de PrimaryDetectionCodes."]
["Initiales de l'observateur-navigateur","Navigator observer initials","navInit","varchar (4)","no",null,null,9999,"Observers","Unique anonymous identifier for each observer, must match entry in obsInit in Observers (lookup - table); can be 9999 if there was one but name unknown or NA if there wasn't one; linked to and replaced with unique anonymous identifier for each observer in Observers (lookup - table) for export","Identificateur anonyme unique pour chaque observateur, doit correspondre aux valeurs dans obsInit dans la table Observers (lookup - table); peut être 9999 s'il y avait un observateur dont le nom était inconnu ou NA s'il n'y avait pas d'observateur; lié et remplacé avec un identificateur anonyme unique pour chaque observateur dans la table Observers (lookup - table) pour exporter."]
["Initiales du deuxième observateur","Second observer initials","secObsInit","varchar (4)","no",null,null,9999,"Observers","Unique anonymous identifier for each observer, must match entry in Observers (lookup - table); can be 9999 if there was one but name unknown or NA if there wasn't one","Identificateur anonyme unique pour chaque observateur, doit correspondre aux valeurs dans obsInit dans la table Observers (lookup - table); peut être 9999 s'il y avait un observateur dont le nom était inconnu ou NA s'il n'y avait pas d'observateur"]
["Initiales du troisième observateur","Third observer initials","thirdObsInit","varchar (4)","no",null,null,9999,"Observers","Unique anonymous identifier for each observer, must match entry in Observers (lookup - table); can be 9999 if there was one but name unknown or NA if there wasn't one","Identificateur anonyme unique pour chaque observateur, doit correspondre aux valeurs dans obsInit dans la table Observers (lookup - table); peut être 9999 s'il y avait un observateur dont le nom était inconnu ou NA s'il n'y avait pas d'observateur"]
["Initiales du pilote","Pilot observor initials","pilInit","varchar (4)","no",null,null,9999,"Observers","Unique anonymous identifier for each observer, must match entry in Observers (lookup - table); can be 9999 if there was a pilot but name unknown or NA if there was no pilot (i.e., not aerial)","Identificateur anonyme unique pour chaque observateur, doit correspondre aux valeurs dans obsInit dans la table Observers (lookup - table); peut être 9999 s'il y avait un pilote dont le nom était inconnu ou NA s'il n'y avait pas de pilote (p. ex. l'inventaire n'est pas éarien)"]
["Nombre d'observateurs","Number of observers","numObs","smallint","no",null,null,9999,null,"Total number of observers on survey, should include pilot if actively participating in detection","Nombre d'observateurs participant à l'inventaire, devrait inclure le pilote s'il participe activement à la détection des observations"]
["Opérateur aérien","Helicopter operator","heliOp","varchar (20)","no",null,null,9999,null,"Name of the helicopter operator","Opérateur aérien (nom de la compagnie propriétaire de l'hélicoptère)"]
["Modèle de l'hélicoptère","Helicopter model","heliMod","varchar (20)","no",null,null,9999,"HeliModels","Model of the helicopter","Modèle de l'hélicoptère"]
["Immatriculation de l'hélicoptère","Helicopter call letters","heliCall","varchar (20)","no",null,null,9999,null,"Transport Canada call letters","Immatriculation de l'hélicoptère selon Transports Canada"]
["Type de fenêtres arrières de l'hélicoptère","Rear window of helicopter","rearWin","varchar (20)","no",null,null,9999,"RearWindowCodes","Code describing helicopter rear window","Code décrivant le type de fenêtres arrières de l'hélicoptère"]
["Type de train d'atterrissage de l'hélicoptère","Undercarriage of helicopter","under","varchar (20)","no",null,null,9999,"UndercarriageCodes","Code describing helicopter undercarriage","Code décrivant le type de train d'atterrissage de l'hélicoptère"]
["Commentaires relatifs aux conditions","Comments on conditions","commCon","text","no"," ",null,"NA",null,"Additional comments regarding the survey","Commentaires supplémentaires relatifs aux conditions de l'inventaire"]

{"sheet":"Observations (input - point FC)","index":4,"n_rows":20,"n_cols":11,"rows_kept":20}
["Alias French","Alias English","Field name","Data type","Mandatory at entry","Automated","Rule","Default","Domain","Description English","Description French"]
["Identificateur (ID) du secteur d'inventaire","Survey area ID","survArID","varchar (20)","yes",{"$nulls":4},"Standardized identifier describing the locale of the survey, concatenating ProjectCode with unique identifier for survey area within the project (e.g., for EWS25, a plot-based survey project, EWS25_76002)","Identificateur unique normalisé décrivant le lieu de l'inventaire, concaténant le ProjectCode avec l'identificateur unique du secteur d'inventaire à l'intérieur du projet (p. ex. pour le EWS25, qui est un projet d'inventaire par quadrats, EWS25_76002)"]
["Année","Year","yr","smallint","yes",null,"YYYY",null,null,"Year of the survey","Année de l'inventaire"]
["Identificateur (ID) de l'inventaire","Survey ID","survID","varchar (20)","no",{"$nulls":4},"Unique identifier for each survey that shows survey area identifier, year and project  as \"SurveyAreaID_Year\"","Identificateur unique pour chaque inventaire qui a un identificateur du secteur d'inventaire, année et projet en tant que \"SurveyAreaID_Year\" "]
["Identificateur (ID) de l'observation","Observation ID","obsID","GUID","no","yes","Generates a UUID for ObservationID when a new observation record is inserted.",null,null,"Unique identifier for each observation.","Identificateur (ID) unique pour chaque observation"]
["Latitude","Latitude","lat","decimal (9,6)","yes",null,"Value between -90 and 90 or 9999 if unknown",9999,null,"Latitude of the observation, WGS1984 (9999 if unknown)","Latitude de l'observation, WGS1984 (9999 si inconnue)"]
["Longitude","Longitude","lon","decimal (9,6)","yes",null,"Value between -180 and 180 or 9999 if unknown",9999,null,"Longitude of the observation, WGS1984 (9999 if unknown)","Longitude de l'observation, WGS1984 (9999 si inconnue)"]
["Code de l'espèce en anglais","Species code English","spEN","varchar (8)","yes",null,"Must have at least one of spEN or spFR",null,"Species","Four to eight letter english species code, must match entry in Species_ID in Species (lookup - table)","Code de quatre à huit lettres de l'espèce en anglais, doit correspondre aux valeurs de Species_ID dans la table Species (lookup - table)"]
["Code de l'espèce en français","Species code French","spFR","varchar (8)","yes",null,"Must have at least one of spEN or spFR",null,"Species","Four letter french species code, must match entry in  Alpha_Code_FR in Species (lookup - table)","Code de quatre lettres de l'espèce en français, doit correspondre aux valeurs de Alpha_Code_FR dans la table Species (lookup - table)"]
["Mâle","Male","male","smallint","yes",null,"Value ≥ 0",0,null,"Number of male(s) observed, within the same species group/flock","Nombre de mâle(s) observé(s), soit seul, soit à l'intérieur d'un groupe composé d'une seule espèce"]
["Femelle","Female","fem","smallint","yes",null,"Value ≥ 0",0,null,"Number of female(s) observed within the same species group/flock","Nombre de femelle(s) observée(s), soit seule, soit à l'intérieur d'un groupe composé d'une seule espèce"]
["Sexe inconnu","Unknown sex","unkSex","smallint","yes",null,"Value ≥ 0",0,null,"Number of individual(s) of unknown sex observed within the same species group/flock. All monomorphic species/sexes should be assigned as unknown","Nombre d'individu(s) de sexe inconnu, soit seul, soit à l'intérieur d'un groupe composé d'une seule espèce. Toutes les espèces/sexes monomorphiques devraient être classés en tant qu'inconnus."]
["Nombre total d'adultes observés","Total adults observed","total","smallint","no",null,"Value >0",null,null,"Total number of individuals observed, calculated from male + fem + unkSex","Nombre total d'individus dans l'observation, calculé à partir de male + fem + uknSex"]
["Type de preuve de nidification","Breeding evidence type","brType","varchar (20)","no",null,null,"NA","BreedTypeCodes","Breeding evidence code for colonies, nests, eggs, or young observed. NA if no breeding evidence associated with observation","Code du type de preuve de nidification, soit colonie, nid, oeufs, ou jeunes observés. NA s'il n'y a pas de preuve de nidification associée avec l'observation"]
["Nombre d'éléments du type de preuve de nidification","Breeding evidence count","brCnt","smallint","no",null,"Value > 0",0,null,"Count of colonies/nests/eggs/young for the given brType code","Nombre de colonie/nids/oeufs/jeunes pour un code brType donné"]
["Indice pour les groupes d'oiseaux comportant plus d'une espèce","Mixed species flock index","mxSpFInd","smallint","no",null,null,"NA",null,"Indicates whether an observation is part of a mixed flock, where observations from the same flock have the same index number (ascending from 1) within a given SurveyID","Indique que l'observation d'une espèce fait partie de l'observation d'un groupe mixte d'espèces; les observations d'espèces faisant partie d'un même groupe mixte porte le même chiffre indice (à partir de 1) pour un SurveyID donné."]
["Code de détection","Detection code","det","varchar (20)","no",null,null,"NA","DetectionCodes","Indicates which observer(s) made the detection: 1 = detection by primary observer(s); 2 = detection by secondary observer(s); 0 = detection that was missed by both (on occasions where helicopter circles around over the same water body and observation is made on second pass that should have been detected on first pass)","Indique quel observateur a détecté l'observation : 1 = détection par le ou les observateur(s) primaire(s); 2 = détection par le ou les observateur(s) secondaire(s); 0 = l'observation n'a pas été détectée par aucun des observateurs primaires et secondaire (p. ex., lorsqu'un hélicoptère tourne une seconde fois sur un plan d'eau et qu'une observation est alors faite lors de ce 2e passage, or cette observation aurait due être détectée au premier passage)."]
["Type d'habitat","Habitat type","hab","varchar (20)","no",null,null,"NA","HabitatTypes","Describes the habitat type in which the observation falls","Type d'habitat dans lequel l'observation a été faite."]
["Distance hors de secteur d'inventaire","Distance outside survey area","distOut","smallint","no",null,null,9999,null,"Distance (in m) calculated based on matching SurveyAreaID in SurveyAreaTable as indicated in Projects and calculating distance between observation and survey area boundary","Distance (en mètres) calculée selon le SurveyAreaID correspondant dans SurveyAreaTable tel qu'indiqué dans Projects, la distance calculée est celle entre l'observation et la limite du secteur d'inventaire"]
["Commentaires","Comments","comm","text","no",null,null,"NA",null,"Additional comments regarding the observation","Commentaire supplémentaire relatif à l'observation"]

{"sheet":"Observers (lookup - table)","index":5,"n_rows":4,"n_cols":10,"rows_kept":4}
["Alias French","Alias English","Field name","Data type","Mandatory at entry","Automated","Rule","Domain","Description English","Description French"]
["Nom complet de l'observateur","Observer full name","obsName","varchar (50)","yes",{"$nulls":3},"Name of the observer/pilot, must match entry in Observers (lookup - table)","Nom de l'observateur ou du pilote, doit correspondre aux valeurs dans la table Observers (lookup - table)"]
["Initiales de l'observateur","Observer intitials","obsInit","char (4)","yes",{"$nulls":3},"Initials of the observer/pilot, must match entry in Observers (lookup - table); can be 9999 if unknown","Initiales de l'observateur ou du pilote, valeur doit correspondre à celles dans la table Observers (lookup - table)"]
["Identificateur (ID) de l'observateur","Observer ID","obsUID","GUID","no","yes","Generates a UUID for ObserverID when a new observer record is inserted",null,"Unique anonymous identifier for each observer/pilot","Identificateur (ID) anonyme unique pour chaque observateur et pilote"]

{"sheet":"Species (lookup - table)","index":6,"n_rows":1,"n_cols":1,"rows_kept":1}
["* the species code fields in Observations (spEN and spFR) are linked directly to the Avian Taxonomic Core table (Species_ID and Alpha_Code_FR, respectively)"]

{"sheet":"Coded Value Domains","index":7,"n_rows":80,"n_cols":5,"rows_kept":80}
["Reference Table or Domain?","Domain","Code","Description English","Description French"]
["Domain","CWSRegionCodes","ATL","Atlantic Region","Région de l'Atlantique"]
[null,"CWSRegionCodes","ONT","Ontario Region","Région de l'Ontario"]
[null,"CWSRegionCodes","QBC","Québec Region","Région  du Québec"]
[null,"CWSRegionCodes","NOR","Northern Region","Région du Nord"]
[null,"CWSRegionCodes","PRA","Prairie Region","Région des Prairies"]
[null,"CWSRegionCodes","PAC","Pacific Region","Région du Pacifique"]
["Domain","YesNo",0,"No","Non"]
[null,"YesNo",1,"Yes","Oui"]
[null,"YesNo","NA","not applicable","Ne s'applique pas"]
[null,"YesNo",9999,"Unknown","Inconnu"]
["Reference Table","ProtocolTypes","Area Search","any area search survey protocol","Tout protocole d'inventaire par secteur"]
[null,"ProtocolTypes","Point Count","any point count survey protocol","Tout protocole d'inventaire par point d'écoute"]
["Reference Table","SurveyTypes","plot aerial area search","plot-based area search from the air (helicopter or fixed wing)","Inventaire par secteur dans des quadrats, à partir des airs (hélicoptère ou avion) "]
[null,"SurveyTypes","transect aerial area search","transect-based area search from the air (helicopter or fixed wing)","Inventaire par secteur dans des transects, à partir des airs (hélicoptère ou avion) "]
[null,"SurveyTypes","general aerial area search","general area search from the air (helicopter or fixed wing, not within plots or along transects, will need survey tracklines)","Inventaire général par secteur, à partir des airs (hélicoptère ou avion, mais pas dans des quadrats nio des transects; les tracés de l'inventaire doivent être fournis) "]
[null,"SurveyTypes","plot ground area search","plot-based area search from the ground (boat, vehicle or on foot)","Inventaire par secteur dans des quadrats, terrestre (véhicule ou à pied) ou aquatique (bateau)"]
[null,"SurveyTypes","point count roadside","point counts performed at roadside stops","Dénombrement par point d'écoute réalisé à des arrêts le long de routes"]
["Reference Table","SurveyAreaTables","Plots","survey area information for the Project is stored in the Plots table","L'information du secteur d'inventaire pour le projet se trouve dans la table Plots"]
[null,"SurveyAreaTables","Transects","survey area information for the Project is stored in the Transects table","L'information du secteur d'inventaire pour le projet se trouve dans la table Transects"]
[null,"SurveyAreaTables","Tracks","survey area information for the Project is stored in the Tracks table","L'information du secteur d'inventaire pour le projet se trouve dans la table Tracks"]
[null,"SurveyAreaTables","Points","survey area information for the Project is stored in the Points table","L'information du secteur d'inventaire pour le projet se trouve dans la table Points"]
["Reference Table","SurveyAreaShapes","square",null,"Carré"]
[null,"SurveyAreaShapes","circle",null,"Cercle"]
[null,"SurveyAreaShapes","hexagon",null,"Hexagone"]
[null,"SurveyAreaShapes","rectangle",null,"Rectangle"]
[null,"SurveyAreaShapes","irregular",null,"Forme irrégulière"]
["Domain","CloudCoverCodes",1,"Clear (<=4%)","Dégagé (<=4 %)"]
[null,"CloudCoverCodes",2,"Scattered (5-49%)","Partiellement nuageux (5-49 %)"]
[null,"CloudCoverCodes",3,"Broken (>50%)","Éclaircies (>50 %)"]
[null,"CloudCoverCodes",4,"Overcast (>95%)","Couvert (>95 %)"]
[null,"CloudCoverCodes",5,"Smoke","Fumée"]
[null,"CloudCoverCodes",9999,"Unknown","Inconnu"]
["Domain","PrecipitationCodes",0,"None","Aucune"]
[null,"PrecipitationCodes",1,"Snow","Neige"]
[null,"PrecipitationCodes",2,"Drizzle","Bruine"]
[null,"PrecipitationCodes",3,"Rain","Pluie"]
[null,"PrecipitationCodes",4,"Mist","Brouillard (terrestre) ou brume (mer)"]
[null,"PrecipitationCodes",9999,"Unknown","Inconnu"]
["Domain","PrimaryDetectionCodes",1,"Front","À l'avant"]
[null,"PrimaryDetectionCodes",2,"Rear","Àl'arrière"]
[null,"PrimaryDetectionCodes","NA","Double-observer protocol not implemented","Aucun protocole de double-observateur mis en place"]
["Reference Table","HeliModels",206,"Bell 206 (variant unspecified)","Bell 206"]
[null,"HeliModels","206JR","Bell 206 Jet Ranger","Bell 206 Jet Ranger"]
[null,"HeliModels","206B","shorter and lighter variant of Bell 206 Jet Ranger","Variante plus courte et plus légère d'un Bell 206 Jet Ranger"]
[null,"HeliModels","206LR","Bell 206 Long Ranger","Bell 206 Long Ranger"]
[null,"HeliModels","206L4","upgraded variant of Bell 206 Long Ranger","Variante plus performante d'un Bell 206 Long Ranger"]
[null,"HeliModels","205B","variant of Bell 205 Huey ","Variante d'un Bell 205 Huey "]
[null,"HeliModels","AS350","original model Airbus AS350","Modèle original d'un Airbus AS350"]
[null,"HeliModels","AS350BA","upgraded variant of Airbus AS350","Modèle amélioré d'un Airbus AS350"]
[null,"HeliModels","AS350B2","upgraded variant of Airbus AS350BA","Modèle amélioré d'un Airbus AS350BA"]
[null,"HeliModels","AS350D2","upgraded variant of Airbus AS350B2","Modèle amélioré d'un Airbus AS350B2"]
[null,"HeliModels",9999,"Unknown","Inconnu"]
["Domain","RearWindowCodes",1,"Flat","plate"]
[null,"RearWindowCodes",2,"Bubble","à bulles"]
[null,"RearWindowCodes",3,"Wedge","en coin"]
[null,"RearWindowCodes",4,"High Visibility (narrow and long)","haute visibilité (étroit et long)"]
[null,"RearWindowCodes",9999,"Unknown","Inconnu"]
["Domain","UndercarriageCodes",1,"High Skids","patins hauts"]
[null,"UndercarriageCodes",2,"Low Skids","patins bas"]
[null,"UndercarriageCodes",3,"Floats","flotteurs"]
[null,"UndercarriageCodes",4,"Popout","popout"]
[null,"UndercarriageCodes",9999,"Unknown","Inconnu"]
["Reference Table","BreedTypeCodes","N ","Nests","Nid"]
[null,"BreedTypeCodes","E","Eggs","Oeuf"]
[null,"BreedTypeCodes","D ","Dependent young (incapable of flight and adult dependent)","Petit (incapable de vol et dépendant des adultes)"]
[null,"BreedTypeCodes","J ","Juvenile, young or immature (capable of flight)","Juvénile, jeune, immature (capable de vol)"]
[null,"BreedTypeCodes","1A","Duckling age class - first year","Classe d'âge canetons - première année"]
[null,"BreedTypeCodes","1B","Duckling age class - second year","Classe d'âge canetons - deuxième année"]
[null,"BreedTypeCodes","C ","Colony with unknown number of nests (brCnt = 1 or NA; if number of nests is known, then will be code N with the nest count under brCnt)","Colonie où le nombre de nids est inconnu (brCnt = 1; si le nombre de nids est connu, sera alors codé N (et non pas C) avec le compte de nids sous brCnt)"]
[null,"BreedTypeCodes","NA","No breeding evidence associated with observation","Aucune preuve de nidification associée à l'observation"]
["Domain","DetectionCodes",1,"Primary Observer","Observateur primaire"]
[null,"DetectionCodes",2,"Secondary Observer","Observateur secondaire"]
[null,"DetectionCodes",0,"No Observer (missed on first pass)","Aucun observateur n'a fait l'observation lors du premier passage"]
[null,"DetectionCodes","NA","Observer unknown (double-observer protocol not implemented)","Observateur inconnu (aucun protocole de double-observateur is en place)"]
["Reference Table","HabitatTypes","stream","temporary placeholder for likely habitat type variables recorded during some surveys, TBD"]
[null,"HabitatTypes","wetland"]
[null,"HabitatTypes","river"]
[null,"HabitatTypes","lake"]
[null,"HabitatTypes","agricultural field"]

{"sheet":"Relationship Classes","index":8,"n_rows":64,"n_cols":2,"rows_kept":64}
["Projects to Plots"]
["Property","DetailsEN"]
["Relationship Class Name","ProjectsToPlots"]
["Origin Table","Projects"]
["Destination Table","Plots"]
["Type","Composite"]
["Cardinality","One-to-Many"]
["Origin Primary Key","projID"]
["Destination Foreign Key","projID"]
["Forward Label","Has Plot"]
["Backward Label","Belongs To Project"]
["Description","Each project can have multiple plots associated with it. This relationship links plots to their respective project."]
[]
["Plots to Conditions"]
["Property","DetailsEN"]
["Relationship Class Name","PlotsToConditions"]
["Origin Table","Plots"]
["Destination Table","Conditions"]
["Type","Composite"]
["Cardinality","One-to-Many"]
["Origin Primary Key","survArID"]
["Destination Foreign Key","survArID"]
["Forward Label","Has Conditions"]
["Backward Label","Belongs To Plot"]
["Description","Each plot can have multiple sets of conditions recorded over different surveys over time. This relationship links plot conditions to their respective plots."]
[]
["Conditions to Observations"]
["Property","DetailsEN"]
["Relationship Class Name","ConditionsToObservations"]
["Origin Table","Conditions"]
["Destination Table","Observations"]
["Type","Composite"]
["Cardinality","One-to-Many"]
["Origin Primary Key","survID"]
["Destination Foreign Key","survID"]
["Forward Label","Has Observations"]
["Backward Label","Belongs To Condition"]
["Description","Each set of conditions (on a specific date as identified by concatenating PlotID with Year as SurveyID) can have multiple observations. This relationship connects observations to the conditions under which they were made."]
[]
["Observers to Conditions"]
["Property","DetailsEN"]
["Relationship Class Name","ObserversToConditions"]
["Origin Table","Observers"]
["Destination Table","Conditions"]
["Type","Simple"]
["Cardinality","One-to-Many"]
["Origin Primary Key","obsInit"]
["Destination Foreign Key","pilInit, navInit, secondObsInit, thirdObsInit"]
["Forward Label","Participated In Conditions"]
["Backward Label","Includes Observer"]
["Description","One observer can be associated with many survey conditions. This relationship connects observers to the specific roles they had on a given survey."]
[]
["Species to Observations"]
["Property","DetailsEN"]
["Relationship Class Name","SpeciesToObservations"]
["Origin Table","Species"]
["Destination Table","Observations"]
["Type","Simple"]
["Cardinality","One-to-Many"]
["Origin Primary Key","spEN"]
["Destination Foreign Key","Species_ID"]
["Forward Label","Species Observed in Observation"]
["Backward Label","Includes Species"]
["Description","One species can be associated with many observations. This relationship connects species to the observation on which they were observed."]

{"sheet":"Plots BMDE (output - table)","index":9,"n_rows":50,"n_cols":4,"rows_kept":50}
["Note: For plot-based surveys only (where SurveyAreaTable in Projects is Plots) - will develop separate cross-walk for transect-based or other project protocol types that do not store survey area spatial information in Plots table)"]
["BMDE Field Name","Table","Field name or \"value\"","BMDE DescriptionEN"]
["InstitutionCode","Projects","instCode","The code or acronym identifying the institution administering the collection."]
["CollectionCode","Projects","projID","The code or acronym identifying the collection within the institution."]
["SamplingEventIdentifier","Conditions","survID","A unique identifier identifying the sampling event during which the observation was made. A sampling event is defined as an attempt to observe birds during a specified amount of time at a location (identified by SurveyAreaIdentifier)."]
["SamplingEventStructure","Projects","survEvStr","Describes the structure of the SamplingEventIdentifier"]
["SurveyAreaIdentifier","Conditions","survArID","A unique identifier identifying the geographic site at which the observation was made."]
["CatalogNumber","Observations","obsID","The alphanumeric identifying the record within the collection"]
["GlobalUniqueIdentifier","NA","concatenate URN:catalog:[instCode]:[projID]:[survID]:[obsID]","A universal resource name (URN) for the observation record"]
["BasisOfRecord","NA","\"observation\"","A descriptive term indicating whether the record represents an object or observation (always observation for WSD data)"]
["ProtocolType","Projects","proType","Broad category of protocol employed to make this observation"]
["ProtocolSpeciesTargeted","Projects","spTarg","A short description of the species or taxonomic group(s) targeted by the survey protocol"]
["AllSpeciesReported","Projects","allSpRep","Whether the ObservationCount for a given taxon includes all \nindividuals that have been detected within a higher taxonomic \ngroup, such as the class (eg, all Birds, all Fishes, or all Butterflies), as defined in the field ProtocolSpeciesTargeted, or as defined by the protocol. \"No\" should be used to indicate that the sampling event should not be used to infer negative observations (the absence of the species not reported within the scope of the protocol)"]
["ProtocolReference","Projects","proRef","A published reference describing the protocol used to collect the observation data"]
["ProtocolURL","Projects","proURL","The URL of the ProtocolReference"]
["StateProvince","Plots","provTerrFull","The full, unabbreviated name of the state or province of the observation"]
["Country ","Plots","country","The full, unabbreviated name of the country of the observation"]
["SurveyAreaSize","Plots","areaHa","Size (ha) of the survey area"]
["SurveyAreaPercentageCovered","Conditions","cov","Percentage of the SurveyAreaSize actually covered during the sampling event"]
["SurveyAreaShape","Plots","plotShape","Shape of the survey area covered by the observation event"]
["SurveyAreaLongAxisLength","Plots","longAxLen","Length (m) of the long axis of the survey area"]
["SurveyAreaShortAxisLength","Plots","shortAxLen","Length (m) of the short axis of the survey area"]
["DecimalLatitude","Plots","cenLat","The latitude of the location from which the observation was collected in decimal degrees"]
["DecimalLongitude","Plots","cenLon","The longitude of the location from which the observation was collected in decimal degrees"]
["GeodeticDatum","Projects","geoDat","The geodetic datum to which the latitude and longitude refer"]
["CoordinatesScope","Projects","survArScope","Geographic scope of the coordinates, indicating whether they represent the location of the sampling event or the observation"]
["CoordinateUncertaintyInMeters","Plots","cen2Corn","The upper limit of the distance from the coordinates describing a circle within which the whole of the described locality must lie"]
["DurationsInHours","Conditions","dur","The total duration of the entire observation event expressed as decimal hours"]
["NumberOfObservers","Conditions","numObs","The total number of observers who participated in the observation event"]
["YearCollected","Conditions","yr","The four digit year in the Common Era calendar during which the observation was made"]
["ObservationDate","Conditions","date","Full date of the observation event in ISO 8601 format (YYYY-MM-DD, e.g., 2025-03-31 for March 31 or 2025-12-05 for December 5)"]
["SpecimenDecimalLatitude","Observations","lat","The latitude from which the individual record was collected, in cases where the main coordinates described in DecimalLatitude represent a centroid for the entire sampling event."]
["SpecimenDecimalLongitude","Observations","lon","The longitude from which the individual record was collected, in cases where the main coordinates described in DecimalLongitude represent a centroid for the entire sampling event."]
["SpecimenGeodeticDatum","Projects","geoDat","The geodetic datum to which the SpecimenDecimalLatitude and SpecimenDecimalLongitude refer"]
["ScientificName","Species","Scientific_Name","The full name of the lowest level taxon to which the organism can be identified"]
["Class","Species","Taxon","The name of the class to which the organism is classified"]
["Order","Species","Order","The name of the order to which the organism is classified"]
["Family","Species","Family_Sci","The name of the family to which the organism is classified"]
["SpecificEpithet","Species","English_Name","The specific epithet of the scientific name applied to the observation"]
["AllIndividualsReported","NA","\"yes\"","Whether the ObservationCount includes all individuals detected during the sampling event (always \"yes\" for QWAC data)"]
["ObservationCount","Observations","total","Number of individuals detected or observed during this observation event"]
["ObservationDescriptor","NA","\"Total Adults\"","Descriptor that provides information on the type of count "]
["ObservationCount2","Observations","fem","Number of female individuals detected or observed during this observation event"]
["ObservationDescriptor2","NA","\"Female Adults\"","Descriptor that provides information on the type of count "]
["ObservationCount3","Observations","male","Number of male individuals detected or observed during this observation event"]
["ObservationDescriptor3","NA","\"Male Adults\"","Descriptor that provides information on the type of count "]
["ObservationCount4","Observations","unkSex","Number of unknown sex individuals detected or observed during this observation event"]
["ObservationDescriptor4","NA","\"Unknown Sex Adults\"","Descriptor that provides information on the type of count "]
["ObservationCount5","Observations","brCnt","Number of nests, eggs or young observed"]
["ObservationDescriptor5","Observations","brType","Descriptor that provides information on the type of count (not included in Total)"]

{"sheet":"Relational Diagram","index":10,"n_rows":0,"n_cols":0,"rows_kept":0}