<div dir="ltr">Thanks Alex.<div><br></div><div>I will explore the EOL API as well.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 28, 2015 at 7:10 PM, Alex Thompson <span dir="ltr"><<a href="mailto:godfoder@acis.ufl.edu" target="_blank">godfoder@acis.ufl.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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 href="http://eol.org/api" target="_blank">http://eol.org/api</a><br>
You can use the search api ( <a href="http://eol.org/api/docs/search" target="_blank">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 href="http://eol.org/api/docs/pages" target="_blank">http://eol.org/api/docs/pages</a> ) to pull the list of
vernacular names and some media<span class="HOEnZb"><font color="#888888"><br>
<br>
Alex Thompson<br>
iDigBio Infrastructure Team</font></span><div><div class="h5"><br>
<br>
<div>On 04/28/2015 08:56 AM, Priyank Tiwari
wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<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 href="http://api.gbif.org/v1/species/%7Bint%7D/vernacularNames" target="_blank">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 href="http://api.gbif.org/v1/species/%7Bint%7D/media" target="_blank">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></fieldset>
<br>
</div></div><span class=""><pre>_______________________________________________
API-users mailing list
<a href="mailto:API-users@lists.gbif.org" target="_blank">API-users@lists.gbif.org</a>
<a href="http://lists.gbif.org/mailman/listinfo/api-users" target="_blank">http://lists.gbif.org/mailman/listinfo/api-users</a>
</pre>
</span></blockquote>
<br>
</div>
<br>_______________________________________________<br>
API-users mailing list<br>
<a href="mailto:API-users@lists.gbif.org">API-users@lists.gbif.org</a><br>
<a href="http://lists.gbif.org/mailman/listinfo/api-users" target="_blank">http://lists.gbif.org/mailman/listinfo/api-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">~ Priyank</div>
</div>