<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Not a GBIF staffer, just chiming in with my 2c:<br>
<br>
1) There should be a taxonKey value in occurence results, which
should map to the key value in the species API (which should,
probably, always be non-null). If the taxonRank in the occurence is
equal to SPECIES, this should be a species record as well (it might
be identified only to genus, or it might be identifier below
species).<br>
<br>
2 & 3) EOL is a good source for both vernacular names, and high
quality images of specimens. They also have a pretty decent API:
<a class="moz-txt-link-freetext" href="http://eol.org/api">http://eol.org/api</a><br>
You can use the search api ( <a class="moz-txt-link-freetext" href="http://eol.org/api/docs/search">http://eol.org/api/docs/search</a> ) to
query for the pageID of the taxon you're interested in, then use the
pages api ( <a class="moz-txt-link-freetext" href="http://eol.org/api/docs/pages">http://eol.org/api/docs/pages</a> ) to pull the list of
vernacular names and some media<br>
<br>
Alex Thompson<br>
iDigBio Infrastructure Team<br>
<br>
<div class="moz-cite-prefix">On 04/28/2015 08:56 AM, Priyank Tiwari
wrote:<br>
</div>
<blockquote
cite="mid:CADbPz3Ew8BocTB9vY2Se9ZYCj9p=UvmHQJmya7i3jFfDEH5+zg@mail.gmail.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<div dir="ltr">
<div><br>
</div>
<div>Hi All,</div>
<div><br>
</div>
<div>I am currently trying to display the GBIF data in a format
which is currently not supported by the GBIF API. For exmaple,
displaying the list of species within few KM radius from a
specific location ordered by species occurrence count.</div>
<div><br>
</div>
<div>To accomplish this, I decided to use the occurrence
download API to fetch the data for all the required regions,
store it in a database and query as per my requirement. I
decided to go with following 2 simple tables in the database, </div>
<div>
<ol>
<li><b>Species</b> - stores species related data like
scientific name, vernacular names, representative image
url, etc<br>
</li>
<li><b>Occurences</b> - stores occurence related data like
eventDate, gbifid, decimalLatitude, decimalLongitude, etc</li>
</ol>
</div>
<div>After having a quick look at the downloaded occurrences.txt
file, following queries came to my mind,</div>
<div><br>
</div>
<div>1. What should be my primary key for species table? I see
'speciesKey' column as a candidate, but it is set as null for
some species. The occurrence record has a scientific name but
no speciesKey. Any suggestions on this? What field I can use
as unique identifier for species?</div>
<div><br>
</div>
<div>2. Vernacular names are missing for almost all the
occurrences. Is there any API by which I can also obtain
vernacular names for a species? <a moz-do-not-send="true"
href="http://api.gbif.org/v1/species/%7Bint%7D/vernacularNames">http://api.gbif.org/v1/species/{int}/vernacularNames</a>
seems to do the job, but what is {int} (speciesKey?) and how
do I get it from occurrence data?</div>
<div><br>
</div>
<div>3. I also need few representative images of the species. <a
moz-do-not-send="true"
href="http://api.gbif.org/v1/species/%7Bint%7D/media">http://api.gbif.org/v1/species/{int}/media</a>
seems to do the job, but it returns a large image and I am
looking for a small thumbnail image. Any way to accomplish
this? Also, any API that can provide me both the vernacular
names and imge url in single API call?</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Priyank</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
API-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:API-users@lists.gbif.org">API-users@lists.gbif.org</a>
<a class="moz-txt-link-freetext" href="http://lists.gbif.org/mailman/listinfo/api-users">http://lists.gbif.org/mailman/listinfo/api-users</a>
</pre>
</blockquote>
<br>
</body>
</html>