| id | sighting_date | species | number | latitude | longitude | flag_location | comments | school | grade | image_url | customerid | number_old | flag_number | species_old | flag_species |
---|
Column Name: | id
| sighting_date
| species
| number
| latitude
| longitude
| flag_location
| comments
| school
| grade
| image_url
| customerid
| number_old
| flag_number
| species_old
| flag_species
|
Definition: | A unique identifier for each sighting submitted. | Date when the sighting was submitted. | Designation for the type of sighting being reported. | Number of individuals observed per sighting category. Data review indicated errors in the number field: missing data/null values or "0" and/or numbers entered did not correspond with numbers reported in the comment field. The initial cleaning process for this field did not include filtering the comments for this data or extracting those reported numbers. It only replaced missing/null values or zeros with a "1". Because some observers reported actual numbers of species sighted, researchers are encouraged to read the comments. | Latitude in decimal degrees specified by the observer, determined using the "report sighting" user interface, in the submitted sighting. | Longitude in decimal degrees specified by the observer, determined using the "report sighting" user interface, in the submitted sighting. | A column designated to flag those locations (longitude and latitude) that their values were obtained based on different methods. | Any commentary or detail that the user wishes to include as part of their sighting. | The name of the school reporting the data. | The student or classroom grade where the data is reported by the school. | The journeynorth.org website URL to the image posted with the corresponding sighting | A unique identifier of the user who reported the sighting. | Original number of individuals observed per sighting previous data cleaning. | A column designated to flag those sightings that the values of their number column were changed from its original entry. Data review indicated errors in the number field: missing data/null values or "0" and/or numbers entered did not correspond with numbers reported in the comment field. The initial cleaning process for this field did not include filtering the comments for this data or extracting those reported numbers. It only replaced missing/null values or zeros with a "1". Because some observers reported actual numbers of species sighted, researchers are encouraged to read the comments. This column flags where the number has been modified by the data cleaning process. | Original designation for the reporting category prior data cleaning. | A column designated to flag those reporting categories that the value of their species column were changed. |
Storage Type: | string
| dateTime
| string
| integer
| float
| float
| string
| string
| string
| string
| string
| string
| float
| string
| string
| string
|
Measurement Type: | nominal | dateTime | nominal | ratio | ratio | ratio | nominal | nominal | nominal | nominal | nominal | nominal | ratio | nominal | nominal | nominal |
Measurement Values Domain: | Definition | A unique identifier for each sighting submitted. |
| Format | YYYY-MM-DD | Precision | |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | Ice-Out | Definition | A spring reporting category (January 1-July 31). Journey North specifically tracks the spring arrival of Common Loons. Observers report first arrival dates using this reporting category. Ice-Out A spring reporting category (January 1-July 31). Observers report when the ice cover melts from lakes, rivers, ponds and oceans. This event is known as "ice-out." Ice-out dates are a way to measure the advance of spring, and dates can be compared from year to year. Journey North defines "ice-out" as when the body of water is 90% free of ice. Researchers are encouraged to examine observer comments in this category for sightings where ice-out also coincides with a first Common Loon sighting. | Source | |
| Code Definition | Code | Loon (FIRST sighted) | Definition | A spring reporting category (January 1-July 31). Journey North specifically tracks the spring arrival of Common Loons. Observers report first arrival dates using this reporting category. | Source | |
|
|
| | Unit | decimalDegree | Type | real |
| Unit | decimalDegree | Type | real |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | The location (latitude and longitude) was recorded using the zip code of the community scientist when they first registered online with Journey North. | Source | |
| Code Definition | Code | 1 | Definition | The location (latitude and longitude) was recorded by the community scientists using the Google Maps location picker available on the Journey North web interface at the time of submission of the sighting. | Source | |
|
|
| Definition | Any commentary or detail that the user wishes to include as part of their sighting. |
| Definition | The name of the school reporting the data. |
| Definition | The student or classroom grade where the data is reported by the school. |
| Definition | The journeynorth.org website URL to the image posted with the corresponding sighting |
| Definition | A unique identifier of the user who reported the sighting. |
| | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | no change | Source | |
| Code Definition | Code | 1 | Definition | When the value was missing, a 1 was added as a new value. | Source | |
| Code Definition | Code | 2 | Definition | When the value was zero, a 1 was added as a new value. | Source | |
|
|
| Definition | Original designation for the reporting category prior data cleaning. |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | No change | Source | |
| Code Definition | Code | 1 | Definition | Reclassification based on current reporting categories and or typos. | Source | |
|
|
|
Missing Value Code: | | | | | | | | Code | -999999.999 | Expl | The user did not include any value as it is not required. |
| Code | -999999.999 | Expl | The user did not include any value as it is not required. |
| Code | -999999.999 | Expl | The user did not include any value as it is not required. |
| Code | -999999.999 | Expl | Not all sightings contain an image URL as a photo submission of the sighting is not required. |
| | Code | -999999.999 | Expl | The user forgot to include the number of sighted hummingbirds. |
| | Code | -999999.999 | Expl | Some sightings did not have any value as the reporting category. |
| |
Accuracy Report: | | | | | | | | | | | | | | | | |
Accuracy Assessment: | | | | | | | | | | | | | | | | |
Coverage: | | | | | | | | | | | | | | | | |
Methods: | | | | | | | | | | | | | | | | |