-
Notifications
You must be signed in to change notification settings - Fork 0
Description of tables
Christian Beier edited this page Mar 9, 2024
·
6 revisions
Here you have the descriptions of fields for each table from Xolmis.
Universities, laboratories, museums, organizations, businesses, etc.
| Field | Description |
|---|---|
| Name | Full name of the institution |
| Acronym | Acronym used for the institution |
| Postal code | CEP (Brazil) or ZIP Code (USA) |
| Address | Postal address of the institution |
| Address detail | Building and/or apartment number, etc. |
| Neighborhood | City subdivision |
| Municipality | County, city, village, etc. |
| State | State of the country |
| Country | Country where is the institution |
| Contact person | Name of the person that you contact in the institution |
| E-mail address used to contact the person or the institution | |
| Telephone | Phone number used to contact the institution |
| Notes | Other information about the institution |
People that participate in research, projects, collection, media authoring, etc.
| Field | Description |
|---|---|
| Profile picture | Optional profile picture of the person |
| Name | Full name of the person |
| Citation | Citation form of the name |
| Acronym | Unique acronym used to type faster and import data |
| Treatment | Title or treatment: |
| Gender | Gender of the person: |
| Date of birth | Date of birth of the person, it will be used to show birthdays |
| Date of death | Optional date of death |
| RG | RG document number (Brazil), it will soon be deprecated |
| CPF | CPF document number (Brazil), equivalent to National ID Card (USA) |
| Personal or professional e-mail address | |
| Telephone | Phone number |
| Mobile phone | Mobile phone number |
| Postal code | CEP (Brazil) or ZIP Code (USA) |
| Address | Postal address where the person lives |
| Address detail | Building and/or apartment number, etc. |
| Neighborhood | Part of the city where the person lives |
| Municipality | County, city, village where the person lives |
| State | State of the country where the person lives |
| Country | Country where the person lives |
| Institution | Institution where the person work |
| Department | Department where the person is allocated |
| Role | Role of the person in the institution/department |
| Lattes | Lattes profile string |
| Orcid | Orcid profile string |
| X/Twitter | X/Twitter profile name |
| Instagram profile name | |
| Website | Personal website address |
| Notes | Any other information about the person |
Research projects.
| Field | Description |
|---|---|
| Title | Full title of the project |
| Short title | Title shortened when it is too long |
| Start date | First day of the project |
| End date | Last day of the project |
| Website | Website address of the project |
| E-mail address of the project or contact person | |
| Contact person | Person responsible to answer any contact |
| Abstract | Project abstract |
| Notes | Any other information about the project |
People participating in the project.
| Field | Description |
|---|---|
| Member | Person that participate in the project, selected from Researchers table |
Research and collection permits.
| Field | Description |
|---|---|
| Name | Short name to identify the permit |
| Permit number | Number of the permit document |
| Type | Type of permit: |
| Dispatcher | Institution or organization that dispatched the permit |
| Dispatch date | Date when the permit was dispatched |
| Expire date | Date when the permit will expire |
| Notes | Any other information about the permit |
Hierarchical catalog of toponyms.
- Country
- State
- Region
- Municipality
- District
- Locality
- District
- Municipality
- Region
- State
| Field | Description |
|---|---|
| Name | Site name |
| Acronym | Site acronym, if it has one |
| Type | Type of toponym: country, state, region, municipality, district, locality |
| Longitude | X axis/longitude of the geographical coordinate |
| Latitude | Y axis/latitude of the geographical coordinate |
| Altitude | Altitude at sea level in meters |
| Parent toponym | Parent site in the hierarchy |
| Full name | Site name with hierarchy |
| Site name on eBird | Site name as it is on eBird, for import purposes |
Sampling plots, transects, points, mistnet stations, etc.
| Field | Description |
|---|---|
| Name | Short name to identify the sampling plot |
| Acronym | Acronym used to type quicker |
| Locality | Site where the sampling plot is |
| Longitude | X axis/longitude of the geographical coordinate |
| Latitude | Y axis/latitude of the geographical coordinate |
| Description | Brief description of the sampling plot |
| Notes | Any other information about the sampling plot |
Mistnets with fixed or permanent locations in the mistnet station.
| Field | Description |
|---|---|
| Mistnet number | Mistnet ID number or code |
| Longitude | X axis/longitude of the geographical coordinate |
| Latitude | Y axis/latitude of the geographical coordinate |
| Notes | Any additional info about the mistnet |
Note
Taxa is a read-only table.
Bird taxa and information about each one.
Taxa of plants mainly used as nest support.
| Field | Description |
|---|---|
| Scientific name | The scientific name of the taxon |
| Authorship | Citation of authorship of the scientific name |
| Taxonomic rank | The taxonomic rank for the taxon |
| Vernacular name | Any vernacular or popular names for the taxon |
| Parent taxon | Taxon of upper rank to which the taxon is linked to |
| Valid name | Valid taxon name selected if the taxon is a synonym |
Field expeditions, campaigns.
| Field | Description |
|---|---|
| Name | Short name that describes and identify the expedition |
| Locality | Site where the expedition was held |
| Start date | First day of expedition |
| End date | Last day of expedition |
| Project | Project that the expedition is linked |
| Description | A brief description of the expedition |
Surveys and sampling events.
| Field | Description |
|---|---|
| Survey date | Date of sampling |
| Duration | Duration of sampling in minutes |
| Starting time | Time when the sampling was started |
| Ending time | Time when the sampling has ended |
| Method | Which method was used for sampling |
| Locality | In which locality the sampling occurred |
| Mistnet station | Station used if the sampling method was banding |
| Project | Project to which the sampling is associated |
| Longitude (initial) | X axis/longitude of the (initial) geographical coordinate |
| Latitude (initial) | Y axis/latitude of the (initial) geographical coordinate |
| End longitude | X axis/longitude of the ending geographical coordinate |
| End latitude | Y axis/latitude of the ending geographical coordinate |
| Number of observers | How many observers or banders were sampling |
| Sample identifier | Identifier for point, transect, list, etc. |
| Area | Total area sampled in hectares |
| Distance | Total distance sampled in kilometers |
| Number of mistnets | Total number of mistnets used for banding |
| Mistnet effort | Total effort of capture using mistnets (automatic) |
| Environment description | Brief description of the surroundings |
| Mistnet checking times | Times of each event of mistnet checking |
| Notes | Any additional info about the sampling |
People participating in the sampling.
| Field | Description |
|---|---|
| Researcher | Person that participate in the sampling, selected from Researchers table |
Mistnets and their effort of capture.
| Field | Description |
|---|---|
| Permanent mistnet | Mistnet from which get the number and coordinates |
| Mistnet number | Identifier of the mistnet |
| Longitude | X axis/longitude of the geographical coordinate |
| Latitude | Y axis/latitude of the geographical coordinate |
| Mistnet length | Length of the opened mistnet in meters |
| Mistnet height | Height of the mistnet in meters |
| Mesh size | Size of the mesh in milimeters |
| Mistnet area | Total area of the opened mistnet (automatic) |
| Survey date | Date when the mistnet was open |
| Total open time | Total time in which the mistnet was open (automatic) |
| Opening time 1-3 | Time when the mistnet was opened |
| Closing time 1-3 | Time when the mistnet was closed |
| Notes | Any other info about the mistnet |
Log of weather conditions.
| Field | Description |
|---|---|
| Date | Date of the weather assessment |
| Time | Time of the weather assessment |
| Moment | Moment of the sampling when the weather was assessed: start, middle, end |
| Cloud cover | Percentage of sky covered by clouds |
| Temperature | Temperature in Celsius degrees |
| Precipitation | Type of precipitation: None, Fog, Mist, Drizzle, Rain |
| Accumulated rainfall | In millimeters |
| Wind speed | In Beaufort scale and in km/h |
| Relative humidity | Percentage of humidity in the air |
| Atmospheric pressure | In millipascal (mPa) |
| Notes | Any other info about the weather |
Sightings of bird species and/or individuals.
| Field | Description |
|---|---|
| Observer | The observer selected from the Researchers table |
| Method | The method used when sighted the bird |
| Locality | Site where the bird was sighted |
| Longitude | X axis/longitude of the geographical coordinate |
| Latitude | Y axis/latitude of the geographical coordinate |
| Date | The date of the sighting |
| Time | The time when the bird was sighted |
| Taxon | The taxon sighted |
| Individual | The individual sighted |
| Quantity | Number of individuals sighted |
| Distance | The distance from the transect or the observer, in meters |
| Detection type | How the bird was detected: |
| Breeding/behavior code | eBird breeding/behavior code |
| Mackinnon list number | In which Mackinnon list the sighting is |
| Captured | Check if the bird/taxon was captured |
| Seen | Check if the bird/taxon was seen |
| Heard | Check if the bird/taxon was heard |
| Photographed | Check if the bird/taxon was photographed |
| Audio recorded | Check if the bird/taxon was recorded in audio |
| Number of new captures | How many birds were captured for the first time |
| Number of recaptures | How many birds were captured again |
| Number of unbanded | How many birds captured were not banded |
| Number of males | How many birds were males |
| Number of females | How many birds were females |
| Number of birds not sexed | How many birds you were not able to sex |
| Number of adults | How many birds were adults |
| Number of immatures | How many birds were immatures or juveniles |
| Number of birds not aged | How many birds you were not able to age |
| Record is on eBird | Check if the sighting is also on eBird |
| Outside the sampling | Check if the sighting was done outside of the regular sampling |
| Notes | Any other info about the sighting |
Field methods.
| Field | Description |
|---|---|
| Name | Full name of the method |
| Acronym | Acronym used to type quicker |
| Method name on eBird | Equivalent name of the method on eBird, for import purposes |
| Description | A brief description of the method to help identify it |
Samples collected.
| Field | Description |
|---|---|
| Field number | Code used to identify the sample |
| Type | The type of sample collected |
| Collection date | Date of collection |
| Locality | Site where the sample was collected |
| Longitude | X axis/longitude of the geographical coordinate |
| Latitude | Y axis/latitude of the geographical coordinate |
| Taxon | The taxon to which the sample pertains |
| Individual | The individual bird to which the sample pertains |
| Nest | The nest to which the sample pertains |
| Egg | The egg to which the sample pertains |
| Notes | Any other info about the sample collected |
People which collected the sample.
| Field | Description |
|---|---|
| Collector | Person involved in the collection of the sample |
Each preparation made from the sample.
| Field | Description |
|---|---|
| Accession number | Accession number received after preparation |
| Type | The type of preparation, what was made of the sample |
| Duplicate number | Sequential duplicate number for the accession |
| Date | Date of preparation |
| Preparer | Person who prepared the sample |
| Notes | Any other info about the preparation |
Stock of bird bands or retrieved bands.
| Field | Description |
|---|---|
| Size | Size of the band in CEMAVE standard (Brazil) |
| Number | Unique number for the band in its size |
| Prefix | Additional prefix of the band |
| Suffix | Additional suffix of the band |
| Type | Type of band |
| Color | Color of the band |
| Status | Status of the band: |
| Reported | Check if the band fate was already reported |
| Source | How the band was obtained or retrieved |
| Supplier | The supplier of the band |
| Carrier | Person who is/was with the band |
| Project | If the band is linked to a specific project |
| Notes | Any other info about the band |
Each captured or monitored bird individuals.
| Field | Description |
|---|---|
| Taxon | The taxon of the individual |
| Band | The bird band of the individual |
| Banding date | Date when the bird was banded |
| Double band | Additional band |
| Removed band | The band that was removed and replaced by the above band |
| Band change date | Date when the band was replaced |
| Right tarsus | Bands and colored bands on the right tarsus (below the joint) |
| Left tarsus | Bands and colored bands on the left tarsus (below the joint) |
| Right leg | Bands and colored bands on the right tarsus (above the joint) |
| Left leg | Bands and colored bands on the left tarsus (above the joint) |
| Birth date | Date of birth of the individual, it could be approximated |
| Death date | Date of death of the individual, it could be approximated |
| Sex | Sex of the individual: male, female, unknown |
| Age | Age of the individual: |
| Nest | Which nest where the bird was born |
| Father | Bird which is the father of the individual |
| Mother | Bird which is the mother of the individual |
| Recognizable markings | Description of any visible and recognizable markings |
| Notes | Any other info about the individual |
Capture events, measurements, qualitative info.
| Field | Description |
|---|---|
| Survey | In which sampling event the capture happened |
| Locality | Site where the capture happened |
| Capture date | Date when the capture happened |
| Capture time | Time when the capture happened |
| Bander | Person who banded the bird |
| Annotator | Person who recorded the data of the bird |
| Type | Type of capture: new capture, recapture, same day, band change |
| Mistnet | In which mistnet the capture happened |
| Longitude | X axis/longitude of the geographical coordinate |
| Latitude | Y axis/latitude of the geographical coordinate |
| Taxon | The taxon of the bird captured |
| Band | The band of the bird captured |
| Removed band | The replaced band |
| Right tarsus | Bands and colored bands combination in the right tarsus (below the joint) |
| Left tarsus | Bands and colored bands combination in the left tarsus (below the joint) |
| Age | Age of the bird captured: |
| Escaped | Check if the bird escaped before the complete measurement process |
| Status | Status of the bird when released: |
| Cloacal protuberance | Code for cloacal protuberance: |
| Brood patch | Code for brood patch: |
| Subcutaneous fat | Code for subcutaneous fat: |
| Body molt | Code for body molt: |
| Flight feathers molt | Code for flight feathers molt: |
| Flight feathers wear | Code for flight feathers wear: |
| Right wing chord | Right wing chord measurement in millimeters |
| First secondary chord | First secondary chord measurement in millimeters |
| Tail length | Tail length measurement in millimeters |
| Tarsus length | Tarsus length measurement in millimeters |
| Tarsus diameter | Tarsus diameter measurement in millimeters |
| Weight | Bird weight in grams |
| Skull length | Skull length measurement in millimeters |
| Exposed culmen | Exposed culmen length measurement in millimeters |
| Nostril to bill tip | Nostril to bill tip distance measurement in millimeters |
| Bill width | Bill width measurement in millimeters |
| Bill height | Bill height measurement in millimeters |
| Total length | Total length measurement in millimeters |
| Total culmen | Total culmen length measurement in millimeters |
| Philornis larvae quantity | Number of larvae of Philornis found parasitizing the individual |
| Kipp's index | Right wing chord - first secondary chord = Kipp's index (automatic) |
| Molt limits | Codes of molt limits: |
| Skull ossification | Code of skull ossification: |
| Molt cycle | Code of the molt cycle: |
| How was aged | Codes of how the bird was aged: |
| Sex | Sex of the bird captured: male, female, unknown |
| How was sexed | Codes of how the bird was sexed: |
| Notes | Any other info about the bird captured |
| Blood | Check if blood samples were collected |
| Feather(s) | Check if feathers were collected |
| Feces | Check if feces were collected |
| Parasite(s) | Check if parasites were collected |
| Audio(s) | Check if audio was recorded |
| Photos | Check if the bird was photographed |
| Claw | Check if claw sample was collected |
| Specimen (whole) | Check if the bird was collected whole |
| Photographer 1-2 | People who photographed the bird captured |
| Camera | Camera used to photograph the bird |
| First photo number | Sequential number of the first photo for a bird |
| Last photo number | Sequential number of the last photo for a bird |
| Field number | Identifier for the capture |
| Hemoglobin | Hemoglobin measurement in g/dL |
| Hematocrit | Hematocrit measurement in mm³ |
| Glucose | Blood glucose measurement in mg/dL |
Molt assessments.
| Field | Description |
|---|---|
| Date | Date of the molt assessment |
| Time | Time of the molt assessment |
| Bander | Person who did the molt assessment |
| Survey | In which sampling event the molt assessment occurred |
| P1-10 | Assessment of primary flight feathers |
| S1-9 | Assessment of secondary flight feathers |
| R1-6 | Assessment of rectrices (tail feathers) |
| PC1-9 | Assessment of primary coverts |
| Al1-3 | Assessment of alulae |
| GC1-10 | Assessment of great coverts |
| MC | Assessment of median coverts as a cluster |
| LC | Assessment of lesser coverts as a cluster |
| CC | Assessment of carpal covert |
| Growth bar width | Measurement of growth bar in millimeters |
| Notes | Any other info about the molt of the bird captured |
Nesting events, nest measurements, descriptions.
| Field | Description |
|---|---|
| Taxon | Taxon of the nest owner |
| Field number | Identifier of the nest |
| Fate | Fate of the nest: unknown, lost, success |
| Nest encounter date | Date when the nest was found |
| Last date | Last date when the nest was seen active |
| Project | Project to which the nest is linked |
| Observer | Person who found and monitored the nest |
| Locality | Site where the nest is |
| Longitude | X axis/longitude of the geographical coordinate |
| Latitude | Y axis/latitude of the geographical coordinate |
| Nest description | Brief description of the nest |
| Productivity | Nest productivity as the number of fledglings that left the nest |
| Support type | Type of structure/substrate where the nest was built |
| Height at ground level | In centimeters |
| Support plant 1-2 | Plant species used as support for the nest |
| Plant height | In centimeters |
| Stem thickness | In centimeters |
| Greater plant diameter | In centimeters |
| Lesser plant diameter | In centimeters |
| Days building | In how many days the nest was built |
| Days incubating | In how many days the eggs were incubated |
| Nestling-days | In how many days the nestlings left the nest |
| Total active-days | The total number of days in which the nest was active |
| Internal diameter | Diameter of the nest measured in the internal part |
| External diameter | Diameter of the nest measured in the external part |
| Internal height | Height of the nest measured in the internal part |
| External height | Height of the nest measured in the external part |
| Distance from plant edge | Position of the nest relative to the edge of the support plant |
| Distance from plant center | Position of the nest relative to the center of the support plant |
| Cover | Percentage of cover above the nest by stems, branches, and leaves |
| Notes | Any other info about the nest |
Revisions of the nest, with egg and nestling quantities.
| Field | Description |
|---|---|
| Nest revision date | Date when the nest was revised |
| Nest revision time | Time when the nest was revised |
| Observer 1-2 | The observers who did the revision |
| Stage | In which stage the nest was: building, laying, incubating, hatching, nestling, unknown |
| Status | Status of the nest: inactive, active, unknown |
| Number of eggs (host) | Number of eggs from the taxon that owns the nest |
| Number of nestlings (host) | Number of nestlings from the taxon that owns the nest |
| Nidoparasite taxon | Taxon of the nidoparasite |
| Number of nidoparasite eggs | Number of eggs from the nidoparasite |
| Number of nidoparasite nestlings | Number of nestlings from the nidoparasite |
| Parasitized by Philornis sp. larvae | Check if the nestling were parasitized by Philornis' larvae |
| Notes | Any other info about the nest |
Eggs measurements and monitoring.
| Field | Description |
|---|---|
| Field number | Identifier of the egg or nest |
| Egg number | Sequential number of the egg in the nest |
| Measurement date | Date when the egg was measured |
| Taxon | Taxon of the egg |
| Observer | Person who measured the egg |
| Individual hatched | Which individual bird hatched from the egg |
| Format | Shape of the egg: |
| Phase | Phase in which the egg is: |
| Eggshell color | Color of the eggshell field |
| Eggshell pattern | Pattern of coloring of the eggshell: |
| Eggshell texture | Texture of the eggshell: |
| Width | Largest width of the egg in millimeters |
| Length | Length of the egg in millimeters |
| Mass | Mass of the egg in grams |
| Volume | Estimated volume of the egg in mm³ (automatic) |
| Hatched | Check if the nestling hatched |
| Notes | Any other info about the egg |
Image information and related data linkage.
Audio information and related data linkage.
File or URL attachment information and related data linkage.