uc3_birds_fallen_at_danish_lighthouses

Registros

Los datos en este recurso de registros biológicos han sido publicados como Archivo Darwin Core(DwC-A), el cual es un formato estándar para compartir datos de biodiversidad como un conjunto de una o más tablas de datos. La tabla de datos del core contiene 1.212 registros.

también existen 2 tablas de datos de extensiones. Un registro en una extensión provee información adicional sobre un registro en el core. El número de registros en cada tabla de datos de la extensión se ilustra a continuación.

Este IPT archiva los datos y, por lo tanto, sirve como repositorio de datos. Los datos y los metadatos del recurso están disponibles para su descarga en la sección descargas. La tabla versiones enumera otras versiones del recurso que se han puesto a disposición del público y permite seguir los cambios realizados en el recurso a lo largo del tiempo.

Versiones

La siguiente tabla muestra sólo las versiones publicadas del recurso que son de acceso público.

¿Cómo referenciar?

Los usuarios deben citar este trabajo de la siguiente manera:

Danmallam B (2021): uc3_birds_fallen_at_danish_lighthouses. v1.4. Training Organization. Dataset/Occurrence. https://training-ipt-b.gbif.org/resource?r=uc3_birds_fallen_at_danish_lighthouses&v=1.4

Derechos

Los usuarios deben respetar los siguientes derechos de uso:

El publicador y propietario de los derechos de este trabajo es Training Organization. Esta obra está bajo una licencia Creative Commons de Atribución/Reconocimiento (CC-BY 4.0).

Registro GBIF

Este recurso ha sido registrado en GBIF con el siguiente UUID: 72cedfec-7360-4cd8-b79b-6a65e3f4dd78.  Training Organization publica este recurso y está registrado en GBIF como un publicador de datos avalado por GBIF Secretariat.

Palabras clave

Occurrence; Observation

Contactos

Cobertura geográfica

Denmark

Cobertura temporal

Datos del proyecto

This dataset is an occurrence data with associated metadata for birds obtained from the Literature, “Birds fallen at Danish Lighthouses, 1883–1939” (In Danish, ‘Fuglene ved de danske Fyr, 1883–1939’). The data was collected in Denmark during the night of bird migration (1883–1939) and documented in the book "Fuglene ved de danske Fyr, 1895-1939" (UK: Birds at the Danish Lighthouses, 1895-1939). To digitize the data, a copy of the book was scanned using OCR (Optical Character Recognition) into PDF files. This was followed by the transfer of the PDF files into spreadsheets as individual records. The data published here is from two of the 45 Light Houses found in Denmark (Lodbjerg Fyr and Hanstholm Fyr) with a total of 1212 records (with 742 records belonging to Lodbjerg Fyr and 470 records belonging to Hanstholm Fyr).

Personas asociadas al proyecto:

Métodos de muestreo

Birds seen and their activities were recorded within Light Houses in Denmark by the keepers of the lighthouses. Fallen birds were also collected and sent to museum in Copenhagen. These birds were carefully preserved and catalogued by collection managers at the museum. Observations of weather conditions during the nights when birds were observed by the keepers were also documented.

Descripción de la metodología paso a paso:

1. The dataset was digitized from a copy of the book "Fuglene ved de danske Fyr." This was done by scanning the book using OCR (Optical Character Recognition) into PDF files. This was followed by transferring the PDF files into spreadsheets as individual records. To assess the quality of the data Excel and OpenRefine were used. Additionally, web tools like Canadensys coordinate conversion: http://data.canadensys.net/tools/coordinates, InfoXY: http://splink.cria.org.br/infoxy?criaLANG=en, and Global Names Resolver: http://resolver.globalnames.org were used together with the Excel and OpenRefine to clean/standardize the data. For date format, some records were not consistent with the conventional YYYY-MM-DD format and this was corrected in excel. To do this, the given cells were selected (click Format cell and Category Date) and I selected YYYY-MM-DD format. Years 2038 and 2093 were found to be outside the bounds (1883-1939). The records were carefully checked and it was observed that it could be an oversight since the ‘year’ column have it as 1938 and 1893. This was manually edited. To check for spelling errors, OpenRefine was used. Having launched the software and it opened in my machine browser, I Choose Files > Next and I checked and Create Project. The project was created with 1212 rows loaded and 10 rows showing by default. By clicking the triangular column menu (go to Facet, then make a Text facet) I realized a spelling error (Sylvia borin misspelt as Slyvia borin). I corrected the error manually by clicking edit in the cell and pasted the right spelling. Also, one of the taxonomies in German ‘Rindrossel’ was not translated and captured in a scientific name. Thus, with the aid of google search and translate, it was edited and captured as 'Turdus torquatus'. Many empty cells were found in columns like individualCount, sex, and lifeStage. These were left untouched because they could represent missing data or no observation at all. Similarly, Not Available (NA) values were noted and left untouched. And in the column disposition, two records appear to be outliers or could be an error in the record (e.g 240 and 887), as all other records fall under 50. Want to explore more about missing values and outliers? Please visit the following link https://www.coursera.org/lecture/ibm-exploratory-data-analysis-for-machine-learning/handling-missing-values-and-outliers-9O50z For geographic errors, five records were captured with negative signs in their latitude. These were manually corrected by removing the negative sign and validating the record using the tool InfoXY: http://splink.cria.org.br/infoxy?criaLANG=en This tool was used to validate all other geographic records to their identified locality. Also, not all the coordinates were consistent in their format, as some of the records were presented in the conventional decimal degrees while others in DDMMSS (e.g 56° 49' 24.3408'' N, 8° 15' 46.0404'' E). The degrees part of the latitude and longitude have a capital letter ‘A’ with circumflex, and ‘E’ was used in the longitude instead of ‘W’. The ‘A’ with circumflex was removed and ‘E’ was replaced with ‘W’ in the longitude before conversion using https://data.canadensys.net/tools/coordinates. The conversion was possible by copying and pasting the wrongly formatted coordinates in the tool before submitting. To validate names and populate the sheet with higher taxonomy from GBIF API, I used openRefine. To do this, I clicked on the column menu under speciesName and then Edit column followed by Add column by fetching URLs, where a new window popped Add column by fetching URLs based on column scientificName. I named the new column as Api_name, changed the Throthle Delay to 250 milliseconds, pasted the following expression "http://api.gbif.org/v1/species/match?verbose=true&name="+escape(value,'url'), and clicked OK. This took some time to process and finally generated an Api_name for the records. Next is to create a column for higher taxonomy by making reference to the created Api_name column. I followed the column menu under Api_name and clicked Edit Column followed by Add column based on this column... and a new column also popped up Add column based on column Api_name. I named the new column higherTaxonomy and pasted the following expression: value.parseJson().get("kingdom")+ ", "+value.parseJson().get("phylum")+ ", "+value.parseJson().get("class")+ ", "+value.parseJson().get("order")+ ", "+value.parseJson().get("family") Under the preview section of the new window, the Kingdom, Phylum, Class, Order, and family of the 10-demo taxon appeared and I entered OK which created a single column for all the categories of higher taxonomy being separated by a comma. Next, is to split the higherTaxonomy column into several columns containing the aforementioned taxonomic categories of each taxon. To do this, I followed the higherClassification menu column clicked Edit column followed Split into several columns…, by separator ‘,’ and OK. Having created the higherTaxonomy columns captured with the same header, I then had to rename the columns by following Edit Column then Rename this column and I manually renamed it as kingdom, phylum, class, order, and family columns. But these columns have leading and trailing spaces. To remove the leading and trailing spaces from the newly added higher taxonomy columns, I performed Edit Cells followed by Common transforms then Trim leading and trailing whitespace on each of the columns. This removed all the leading and trailing spaces and I then Export the cleaned file as Comma Separated Value (CSV) file.

Metadatos adicionales