query-472b6ea5e0183b5ad3b927d4cc91202c
Birds with different eBird & ABA IDs Maybe this is useful for further evaluation: Or for the 430 records you're after (probably): Notes from CornellThe eBird team at Cornell University tell me: = "y00475") are where there were originally two different species and now the species have been "lumped".(Q470016)American Coot The y00 codes (e.g. . Codes don't change, regardless of common and scientific name changes or changes in taxonomic level. osprey2 becomes a full species, the code remains unchanged and will be ridgwayi subspecies. We sometimes use numbers at the end for subspecies and splits. So if ridgwayi is the osprey2 subspecies, carolinensis is the code for the osprey1; ospreyIn the case of e.g. Osprey, the species level code is actually , as the two projects focus on breeding species within these geographic areas. eurkesBirds of North America or Neotropical Birds do not cover vagrants like Birds of North America, Neotropical Birds, eBird, Macaulay Library and All About Birds all utilize the eBird species codes. (which is restricted to the ABA region). As we manage over 10,000 species, there are inevitable conflicts in generating codes strictly following what ABA uses, we resolve those conflicts various ways but the result is the codes don't always align. (P4526)ABA bird ID Because eBird is a global database and follows the Clements Taxonomy, our codes sometimes diverge from ]reply[17:50, 19 December 2017 (UTC) Andy's edits; Talk to Andy); Pigsonthewing (Andy Mabbett-- A list of items with different values for P3444 and P4526 (430 of them, at the time of writing) is returned by this query:
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?ebird ?ababird WHERE {
?item wdt:P3444 ?ebird.
?item wdt:P4526 ?ababird .
BIND(IF(?ebird != ?ababird, 'different', 'same') AS ?match) .
FILTER(?match!='same').
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
}
}
Query found at
- https://www.wikidata.org/wiki/Property_talk:P3444
- https://www.wikidata.org/wiki/User:Pigsonthewing/Queries
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2017/12