Skip to content

Instantly share code, notes, and snippets.

View jbest's full-sized avatar

Jason Best jbest

16 followers · 35 following
View GitHub Profile
@jbest
jbest / gist:8040225
Last active December 31, 2015 20:29
Attempts of retrieving and parsing JSON from SOLR
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- Bootstrap -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet">
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js">
</script>
@jbest
jbest / synonyms_export.sql
Last active March 17, 2017 21:10
SQL for generating taxonomic units, synonyms, and vernaculars from ITIS database
# Generate synonyms from specified kingdom in ITIS file format:
# [SY] || tsn | tsn_accepted |
# Contact: Jason Best - jbest@brit.org
SELECT '[SY]', '',synonym_links.tsn, synonym_links.tsn_accepted
FROM synonym_links
INNER JOIN taxonomic_units on synonym_links.tsn=taxonomic_units.tsn
WHERE taxonomic_units.kingdom_id = 3 #3=plantae
# Delete lines below if export is performed separately in GUI etc
INTO OUTFILE '/var/lib/mysql-files/itis_synonyms.csv'
# saving to file may require modification of MySQL --secure-file-priv parameter
@jbest
jbest / test.py
Created April 25, 2018 21:32
"""
I'm trying to save the results of a session (stored
in the session dictionary) after the user has exited
the Gooey interface. This worked in a previous version
where I was using the click CLI module but when I added
Gooey, only the initial values stored in the session
dictionary are available upon script termination.
Requires:
Gooey
@jbest
jbest / keybase.md
Created December 6, 2019 21:30

Keybase proof

I hereby claim:

  • I am jbest on github.
  • I am jbest (https://keybase.io/jbest) on keybase.
  • I have a public key ASB2pXvv721LIkd6aCXP-J2t_-awhEVkiLPaIPhGVUKB0Ao

To claim this, I am signing this object:

@jbest
jbest / gist:002dd7d1e639cac9cbb2324cc2779e02
Created May 7, 2020 21:45
BEGIN MESSAGE.
pbSoFcvHh8PMPpI Zgn4aGgHhySnzwD Ldm0xrMKvJE4RxH OwAjEYEf0HyMtQq
dNoFNtTR89WMEAh eY60Famb6zGTCKq 6Xr2MZHgg4h4UIx oAdoQWwHN0mg8ez
6OFV7gELOBQkwxt RQVQbdhpVwWze0P mU7wg2q85o9njhM D9lAIM9R8b9h74W
b3mHtUbPzdvJXlJ inya9wpgehsUgnr mumOD.
END MESSAGE.