SGCN State Lists.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This notebook shows the essential query for individual SGCN state lists from the structure created in the sgcn schema of the experimental GC2 instance. The whole system has been completely rebuilt from the source repository out. The \"Process SGCN repository source files.ipynb\" (and its corresponding py script) in this repo is what executes that process starting with all the source files in the ScienceBase Repository.\n",
    "\n",
    "We are also making some tweaks to the design of the SWAP application where we want to stick with the overall philosophy that we always show exactly what the states submitted on the state pages of the apps. The National List shows what we add to the process by aligning with taxonomic authorities and making judgments on how we group the information. To aid in this process and show full transparency, we added a few additional properties to the sgcn.sgcn table so that each record traces back to its original source. These include sourcid (ScienceBase item URI/URL) along with sourcefileurl and sourcefilename (the actual file processed by the code to produce the data for a given state and year).\n",
    "\n",
    "Data for the states can be pulled from a database view or its corresponding ElasticSearch index. The view uses the following SQL:\n",
    "```sql\n",
    " SELECT scientificname_accepted AS scientificname, sgcn_state,\n",
    "    (array_agg(commonname_submitted ORDER BY sgcn_year DESC))[1] AS commonname,\n",
    "    (array_agg(taxonomicgroup_submitted ORDER BY sgcn_year DESC))[1] AS taxonomicgroup,\n",
    "    sum(((sgcn_year = 2005))::integer) AS sgcn2005,\n",
    "    sum(((sgcn_year = 2015))::integer) AS sgcn2015\n",
    "   FROM sgcn.sgcn\n",
    "  GROUP BY sgcn_state,scientificname_accepted\n",
    "```  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests\n",
    "from IPython.display import display"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'_execution_time': 0.095,\n",
       " 'auth_check': {'auth_level': 'Write',\n",
       "  'checked_relations': ['sgcn.sgcn'],\n",
       "  'session': None,\n",
       "  'success': True},\n",
       " 'features': [{'properties': {'sgcn_state': 'Alabama'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Indiana'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Minnesota'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'South Carolina'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Louisiana'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'California'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'New Mexico'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'New Hampshire'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'American Samoa'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Connecticut'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Alaska'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Nevada'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Oklahoma'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Maryland'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Idaho'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Ohio'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Delaware'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Florida'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Maine'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Montana'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Illinois'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Texas'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Oregon'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Rhode Island'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Mississippi'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Kansas'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'New Jersey'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Puerto Rico'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Wisconsin'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Pennsylvania'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Tennessee'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'New York'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Georgia'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Vermont'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Colorado'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Virgin Islands'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Arkansas'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Hawaii'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'North Dakota'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Washington'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Virginia'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Wyoming'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'West Virginia'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Missouri'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Iowa'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Guam'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Northern Mariana Islands'},\n",
       "   'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'South Dakota'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'District of Columbia'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Arizona'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Utah'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'North Carolina'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Nebraska'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Kentucky'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Massachusetts'}, 'type': 'Feature'},\n",
       "  {'properties': {'sgcn_state': 'Michigan'}, 'type': 'Feature'}],\n",
       " 'forGrid': [{'dataIndex': 'sgcn_state',\n",
       "   'header': 'sgcn_state',\n",
       "   'type': 'character varying',\n",
       "   'typeObj': None}],\n",
       " 'forStore': [{'name': 'sgcn_state', 'type': 'character varying'}],\n",
       " 'success': True,\n",
       " 'type': 'FeatureCollection'}"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Available States\n",
    "q = \"SELECT DISTINCT sgcn_state FROM sgcn.sgcn GROUP BY sgcn_state\"\n",
    "\n",
    "r = requests.get(\"https://gc2.mapcentia.com/api/v1/sql/bcb?q=\"+q).json()\n",
    "\n",
    "display (r)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'_shards': {'failed': 0, 'successful': 5, 'total': 5},\n",
       " 'hits': {'hits': [{'_id': 'AVvn7QDvUuPNezaKB8VR',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Hoary-aster',\n",
       "      'scientificname': 'Dieteria canescens var. glabra',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8VW',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Flat-top Aster',\n",
       "      'scientificname': 'Doellingeria umbellata var. pubens',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Vk',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Bog Spikerush',\n",
       "      'scientificname': 'Eleocharis elliptica',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 0,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Vascular Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Vt',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Awned Slender Wheatgrass',\n",
       "      'scientificname': 'Elymus trachycaulus var. andinus',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8V3',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Lace Grass',\n",
       "      'scientificname': 'Eragrostis capillaris',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8WG',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Early Blue-top Fleabane',\n",
       "      'scientificname': 'Erigeron vetensis',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8WQ',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Afranius Duskywing',\n",
       "      'scientificname': 'Erynnis afranius',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Insects'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8WS',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Sleepy Duskywing',\n",
       "      'scientificname': 'Erynnis brizo',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Insects'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8WW',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Hairy Duskywing',\n",
       "      'scientificname': 'Erynnis persius fredericki',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Insects'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Wa',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Johnny Darter',\n",
       "      'scientificname': 'Etheostoma nigrum',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 0,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Fish'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Wb',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Orangethroat Darter',\n",
       "      'scientificname': 'Etheostoma spectabile',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 0,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Fish'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Wd',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Five-lined Skink',\n",
       "      'scientificname': 'Eumeces fasciatus',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Reptiles'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8We',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Great Plains Skink',\n",
       "      'scientificname': 'Eumeces obsoletus',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 0,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Reptiles'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Wu',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Western Tailed Blue',\n",
       "      'scientificname': 'Everes amyntula',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Insects'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8W6',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Plains Topminnow',\n",
       "      'scientificname': 'Fundulus sciadicus ',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Fish'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8XJ',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Spring Avens',\n",
       "      'scientificname': 'Geum vernum',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8XP',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Northern Manna Grass',\n",
       "      'scientificname': 'Glyceria borealis',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8XS',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Western Rattlesnake-Plantain',\n",
       "      'scientificname': 'Goodyera oblongifolia',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8XZ',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Pinyon Jay',\n",
       "      'scientificname': 'Gymnorhinus cyanocephalus',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Birds'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Xe',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Ashy Sunflower',\n",
       "      'scientificname': 'Helianthus mollis',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Xf',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Seaside Heliotrope',\n",
       "      'scientificname': 'Heliotropium curassavicum var. curassavicum',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Xm',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Uncas Skipper',\n",
       "      'scientificname': 'Hesperia uncas',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Insects'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Xp',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Eastern Hognose Snake',\n",
       "      'scientificname': 'Heterodon platirhinos',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Reptiles'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Xw',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': \"Mare's-tail\",\n",
       "      'scientificname': 'Hippuris vulgaris',\n",
       "      'sgcn2005': 0,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'},\n",
       "   {'_id': 'AVvn7QDvUuPNezaKB8Xy',\n",
       "    '_index': 'bcb_sgcn_sgcn_statelists',\n",
       "    '_score': 3.820511,\n",
       "    '_source': {'properties': {'commonname': 'Small Bluets',\n",
       "      'scientificname': 'Houstonia pusilla',\n",
       "      'sgcn2005': 1,\n",
       "      'sgcn2015': 1,\n",
       "      'sgcn_state': 'Nebraska',\n",
       "      'taxonomicgroup': 'Plants'},\n",
       "     'type': 'Feature'},\n",
       "    '_type': 'sgcn_statelists'}],\n",
       "  'max_score': 3.820511,\n",
       "  'total': 991},\n",
       " 'timed_out': False,\n",
       " 'took': 5}"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# ElasticSearch API query for a state showing pagination method\n",
    "stateName = 'Nebraska'\n",
    "\n",
    "stateListQuery = \"https://gc2.mapcentia.com/api/v1/elasticsearch/search/bcb/sgcn/sgcn_statelists?q={%22query%22:{%22match%22:{%22properties.sgcn_state%22:%22\"+stateName+\"%22}}}&size=25&from=50\"\n",
    "\n",
    "stateList = requests.get(stateListQuery).json()\n",
    "\n",
    "display (stateList)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}