Forum van Waarneming.nl

Informatie => Observation.org => Topic gestart door: Hans Verdaat op juni 07, 2019, 09:00:35 AM

Titel: How to import eBird data to Observation.org
Bericht door: Hans Verdaat op juni 07, 2019, 09:00:35 AM
This is a topic for all your questions on how to import your eBird data to Observation.org

To import eBird data to Observation.org, see https://old.observation.org/import/ebird_import.php
or to Waarneming.nl https://old.waarneming.nl/import/ebird_import.php

Manual export your eBird data, see instruction on http://support.birdjournal.com/knowledgebase/articles/476160-export-from-ebird-how-to
Try not to upload more then 5000 observations per upload
Do not open the original eBird file in excell and save it. The date and time formats will be corrupt




Titel: Re: eBird data import to Observation.org
Bericht door: Hans Verdaat op juni 07, 2019, 09:03:12 AM
more info:
Posted by Hisko on juli 25, 2018, 14:46:17 pm

The function for importing eBird data can also be used to upload your data from any other system.

Creating a csv file is always tricky due to format problems with numbers, data and time fields.
Make sure your file complies to the standards listed.

The eBird import file has 23 columns :
if you want to create a similar file to upload your data filed in another system.
Make sure you have the same number of colums. The column devider is ','
Columns in red must be filled
Submission ID     , can be any number,text. is used to make a record unigue together with species, date and your user id. You can use your own codes
Common Name   , not used
Scientific Name   , used to select the species in observation.org
Taxonomic Order , not used   
Count                 , number of individuals
State/Province    , not used
County               , not used
Location_id    , not used
Location             , not used
Latitude             , lat in decimal for example 52.0181171
Longitude          , lon in decimal for example 4.3786526
Date                 , used in format mm-dd-yyyy
Time                 , used in format hh:mm AM or PM for example 01:00 PM
Protocol             , only used for ebird to create checklists for protocol 'eBird - Stationary Count'
Duration (Min)    , only used for ebird to create end time for checklists
All Obs Reported   , only used for ebird imports
Distance Traveled (km)  , not used   
Area Covered (ha)         , not used   
Number of Observers     , not used
Breeding Code              , used see other table for possible codes
Observation Details       , not used

Species Comments        , used in observation remarks
Checklist Comments      , used in checklist comments if protocol =   'eBird - Stationary Count'   
ML catalog number        , not used   


Possible eBird breeding codes:
NY Nest with Young
NE Nest with Eggs
ON  Occupied Nest
FL   Recently Fledged young
FY   Feeding Young
FS   Carrying Fecal Sac
CF   Carrying Food
UN  Used Nest
DD  Distraction Display
PE   Brood Patch and Physiological Evidence
NB  Nest Building
CN  Carrying Nesting Material
B    Wren/Woodpecker Nest Building
T    Territory held for 7+ days
C   Courtship Display or Copulation
N   Visiting probable Nest site
A   Agitated behavior
P   Pair in Suitable Habitat
M  Multiple (7+) singing males
S7 Singing Male Present 7+ Days
S   Singing male
H   In appropriate habitat
F   Flyover
Titel: Re: How to import eBird data to Observation.org
Bericht door: Julian op oktober 09, 2019, 00:59:39 AM
Hi Hans and Hisko,

Is this form also being used for importing csv files to waarneming.nl or does its range limit to observation.org?
I'd like to be able to import my Batexplorer export files (csv) to the observation/waarneming systems as discussed here (https://forum.waarneming.nl/smf/index.php?topic=443812.msg2323961#msg2323961) and this would help me out for now.
Having gathered over 4000 sightings (and counting!) of Pipistrellus pipistrellus (https://waarneming.nl/species/387/) alone already this would be really beneficial.

That said, there would be the need for setting certain fields to get the sightings stored to the database as correct as possible.

Default values for those imported Batexplorer sightings should include:

activity: flying over
number:   1
counting method: seen not counted
method:   with batdetector

How to add them?
Titel: Re: How to import eBird data to Observation.org
Bericht door: hiskodevries op oktober 09, 2019, 08:32:35 AM
Julian, that`s not going to work for your particular case, but i can upload your data manually
Titel: Re: How to import eBird data to Observation.org
Bericht door: Julian op oktober 10, 2019, 11:57:26 AM
Many thanks to Hisko for adding an import system for Batexplorer exports! It's similar to the portal used for uploading eBird data.

https://waarneming.nl/import/batlogger_import.php
https://observation.org/import/batlogger_import.php
Titel: Re: How to import eBird data to Observation.org
Bericht door: marcel234 op oktober 10, 2019, 16:44:37 PM
Citaat van: Julian op oktober 10, 2019, 11:57:26 AM
Many thanks to Hisko for adding an import system for Batexplorer exports! It's similar to the portal used for uploading eBird data.

https://waarneming.nl/import/batlogger_import.php
https://observation.org/import/batlogger_import.php
Vleermuizen lijken gebonden aan asfalt, hoe meer wegen, hoe meer dwergvleermuizen..
https://old.waarneming.nl/monitoring.php?id_gebied=22769&id_soort=387&u%5B%5D=1&j%5B%5D=3000&a%5B%5D=0&k%5B%5D=0
Titel: Re: How to import eBird data to Observation.org
Bericht door: Thijs Fijen op juli 16, 2020, 22:46:23 PM
Is er ook een import-pagina voor ornitho-data?
Titel: Re: How to import eBird data to Observation.org
Bericht door: hiskodevries op juli 17, 2020, 07:31:45 AM
nee, die aandraag heb ik nooit eerder voorbij zien komen
Ja die hebben we https://forum.waarneming.nl/index.php/topic,470795.msg2407646.html#msg2407646
Titel: Re: How to import eBird data to Observation.org
Bericht door: klaasdebus op september 06, 2020, 12:36:09 PM
Citaat van: Hans Verdaat op juni 07, 2019, 09:00:35 AM
This is a topic for all your questions on how to import your eBird data to Observation.org

To import eBird data to Observation.org, see https://old.observation.org/import/ebird_import.php
or to Waarneming.nl https://old.waarneming.nl/import/ebird_import.php

Manual export your eBird data, see instruction on http://support.birdjournal.com/knowledgebase/articles/476160-export-from-ebird-how-to
Try not to upload more then 5000 observations per upload
Do not open the original eBird file in excell and save it. The date and time formats will be corrupt

Is there any possibility to make this work for waarnemingen.be?

kind regards,

Klaas
Titel: Re: How to import eBird data to Observation.org
Bericht door: hiskodevries op september 06, 2020, 15:24:23 PM
If you use old.waarnemingen.be/import/ebird_import.php that does not work?
Titel: Re: How to import eBird data to Observation.org
Bericht door: klaasdebus op september 06, 2020, 19:45:57 PM
hey,

It get this error: "Error in file /home/waarneming/www/_pie/objects/class.db.php on line 247"

Klaas
Titel: importtools and UTC en lokale tijd
Bericht door: marcel234 op mei 02, 2022, 18:48:19 PM
Citaat van: Hans Verdaat op februari 13, 2022, 12:31:05 PM
Ook zal de tijd registratie verbeterd worden. Daar liep iets mis met UTC en lokale tijd. Zal aangepast worden.
Het importeren van de tijdsregistratie lijkt niet goed te gaan, wordt daar nog aan gewerkt?
Titel: Re: How to import eBird data to Observation.org
Bericht door: hiskodevries op mei 03, 2022, 08:52:07 AM
daar is niets aan gewijzigd. je hebt het over de ebird import?
Titel: Re: How to import eBird data to Observation.org
Bericht door: marcel234 op mei 03, 2022, 09:00:11 AM
Ik merk het bij iNaturalist maar de opmerking heeft geen duidelijke context, mogelijk alle importtools..
https://forum.waarneming.nl/index.php/topic,490566.msg2505293.html#msg2505293
Titel: Re: How to import eBird data to Observation.org
Bericht door: hiskodevries op mei 03, 2022, 09:16:21 AM
klopt bij de inat import is dat een issue.
bij de andere imports niet
Titel: Re: How to import eBird data to Observation.org
Bericht door: Rutger Koperdraad op maart 16, 2023, 22:37:22 PM
Wordt de functionaliteit voor het importeren van eBird data nog onderhouden? Er zijn in ieder geval twee dingen die consequent niet goed gaan:


groet,
Rutger.
Titel: Re: How to import eBird data to Observation.org
Bericht door: hiskodevries op maart 21, 2023, 10:48:13 AM
Citaat van: Rutger Koperdraad op maart 16, 2023, 22:37:22 PMvolgens een logica die ik niet doorzie.
Rutger, dan wordt het moeilijk uitzoeken
ik ga er vanuit dat je niet zelf het bestand hebt geopend voordat je het upload naar obs.org
Citaat van: Rutger Koperdraad op maart 16, 2023, 22:37:22 PMDe eerste regel met gegevens, direkt onder de regel met veldnamen, wort stelselmatig overgeslagen
die heb ik niet eerder gehoord.