{"id":910,"date":"2015-01-20T17:48:25","date_gmt":"2015-01-20T17:48:25","guid":{"rendered":"https:\/\/www.hort.net\/techblog\/?p=184"},"modified":"2015-01-20T17:48:25","modified_gmt":"2015-01-20T17:48:25","slug":"which-plants-are-most-represented-by-patents","status":"publish","type":"post","link":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/","title":{"rendered":"Which plants are most represented by patents?"},"content":{"rendered":"<p>As we looked at the different plant patents that have been granted, we started to wonder which genera are most represented.<\/p>\n<p>This was pretty easy to do with a simple database query; we get a total for the first word (genus) of all plant names that start with the letters &#8216;A&#8217; through &#8216;Z&#8217; (which eliminates <a href=\"http:\/\/en.wikipedia.org\/wiki\/Grex_%28horticulture%29\" title=\"grex\">greges<\/a> and the like).<\/p>\n<div class=\"horttech-code\">\n<pre class=\"preserve-code-formatting\">\nmysql&gt; SELECT COUNT(sci_name) AS total, SUBSTRING_INDEX(sci_name, &#039; &#039;, 1) AS name FROM patent WHERE sci_name REGEXP &#039;^[A-Z]&#039; GROUP BY name ORDER BY total DESC LIMIT 50;\n+-------+---------------+\n| total | name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n+-------+---------------+\n|&nbsp;&nbsp; 742 | Rosa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp; 613 | Chrysanthemum |\n|&nbsp;&nbsp; 433 | Prunus&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp; 420 | Pelargonium&nbsp;&nbsp; |\n|&nbsp;&nbsp; 323 | Impatiens&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 317 | Petunia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 265 | Calibrachoa&nbsp;&nbsp; |\n|&nbsp;&nbsp; 226 | Osteospermum&nbsp;&nbsp;|\n|&nbsp;&nbsp; 200 | Verbena&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 173 | Euphorbia&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 165 | Hydrangea&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 140 | Hibiscus&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp; 134 | Fragaria&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp; 131 | Begonia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 130 | Echinacea&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 125 | Malus&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 121 | Dianthus&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp; 118 | Dahlia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp; 115 | Phlox&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 109 | Alstroemeria&nbsp;&nbsp;|\n|&nbsp;&nbsp; 108 | Heuchera&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp; 108 | Vitis&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp; 100 | Kalanchoe&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;97 | Vaccinium&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;95 | Mandevilla&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;92 | Nemesia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;81 | Clematis&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;78 | Rhododendron&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;70 | Argyranthemum |\n|&nbsp;&nbsp;&nbsp;&nbsp;69 | Sedum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;68 | Lobelia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;68 | Coreopsis&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;66 | Hosta&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;65 | Rubus&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;63 | Lantana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;62 | Lavandula&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;61 | Salvia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;60 | Diascia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;57 | Helleborus&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;55 | Phalaenopsis&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;55 | Campanula&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;53 | Angelonia&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;52 | Aster&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;49 | Lilium&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;49 | Sutera&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;47 | Veronica&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;41 | Torenia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;40 | Gerbera&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |\n|&nbsp;&nbsp;&nbsp;&nbsp;38 | Citrus&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n|&nbsp;&nbsp;&nbsp;&nbsp;38 | Caladium&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|\n+-------+---------------+\n50 rows in set (0.02 sec)\n<\/pre>\n<\/div>\n<p>So, there you have it.  Those are the 50 most popular genera to receive patents in the last decade.<\/p>\n<p>What do <em>you<\/em> want to know about plant patents?  Let us know in the comments and we&#8217;ll look it up.  Or maybe we can make a tool that you can use regularly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As we looked at the different plant patents that have been granted, we started to wonder which genera are most represented. This was pretty easy to do with a simple database query; we get a total for the first word (genus) of all plant names that start with the letters &#8216;A&#8217; through &#8216;Z&#8217; (which eliminates [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,56],"tags":[64,70,12],"class_list":["post-910","post","type-post","status-publish","format-standard","hentry","category-databases","category-patents","tag-genus","tag-patent","tag-plant"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Which plants are most represented by patents? - hort.net blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Which plants are most represented by patents? - hort.net blog\" \/>\n<meta property=\"og:description\" content=\"As we looked at the different plant patents that have been granted, we started to wonder which genera are most represented. This was pretty easy to do with a simple database query; we get a total for the first word (genus) of all plant names that start with the letters &#8216;A&#8217; through &#8216;Z&#8217; (which eliminates [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/\" \/>\n<meta property=\"og:site_name\" content=\"hort.net blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-20T17:48:25+00:00\" \/>\n<meta name=\"author\" content=\"Christopher Lindsey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Lindsey\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/2015\\\/01\\\/20\\\/which-plants-are-most-represented-by-patents\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/2015\\\/01\\\/20\\\/which-plants-are-most-represented-by-patents\\\/\"},\"author\":{\"name\":\"Christopher Lindsey\",\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/#\\\/schema\\\/person\\\/c5048c118466b10e17155d29454e63de\"},\"headline\":\"Which plants are most represented by patents?\",\"datePublished\":\"2015-01-20T17:48:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/2015\\\/01\\\/20\\\/which-plants-are-most-represented-by-patents\\\/\"},\"wordCount\":116,\"commentCount\":0,\"keywords\":[\"genus\",\"patent\",\"plant\"],\"articleSection\":[\"Databases\",\"patents\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.hort.net\\\/blog\\\/2015\\\/01\\\/20\\\/which-plants-are-most-represented-by-patents\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/2015\\\/01\\\/20\\\/which-plants-are-most-represented-by-patents\\\/\",\"url\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/2015\\\/01\\\/20\\\/which-plants-are-most-represented-by-patents\\\/\",\"name\":\"Which plants are most represented by patents? - hort.net blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/#website\"},\"datePublished\":\"2015-01-20T17:48:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/#\\\/schema\\\/person\\\/c5048c118466b10e17155d29454e63de\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/2015\\\/01\\\/20\\\/which-plants-are-most-represented-by-patents\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hort.net\\\/blog\\\/2015\\\/01\\\/20\\\/which-plants-are-most-represented-by-patents\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/2015\\\/01\\\/20\\\/which-plants-are-most-represented-by-patents\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Which plants are most represented by patents?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/\",\"name\":\"hort.net blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/#\\\/schema\\\/person\\\/c5048c118466b10e17155d29454e63de\",\"name\":\"Christopher Lindsey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Christopher-Lindsey_avatar_1437067426-96x96.jpg\",\"url\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Christopher-Lindsey_avatar_1437067426-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Christopher-Lindsey_avatar_1437067426-96x96.jpg\",\"caption\":\"Christopher Lindsey\"},\"url\":\"https:\\\/\\\/www.hort.net\\\/blog\\\/author\\\/chris\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Which plants are most represented by patents? - hort.net blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/","og_locale":"en_US","og_type":"article","og_title":"Which plants are most represented by patents? - hort.net blog","og_description":"As we looked at the different plant patents that have been granted, we started to wonder which genera are most represented. This was pretty easy to do with a simple database query; we get a total for the first word (genus) of all plant names that start with the letters &#8216;A&#8217; through &#8216;Z&#8217; (which eliminates [&hellip;]","og_url":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/","og_site_name":"hort.net blog","article_published_time":"2015-01-20T17:48:25+00:00","author":"Christopher Lindsey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Lindsey","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/#article","isPartOf":{"@id":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/"},"author":{"name":"Christopher Lindsey","@id":"https:\/\/www.hort.net\/blog\/#\/schema\/person\/c5048c118466b10e17155d29454e63de"},"headline":"Which plants are most represented by patents?","datePublished":"2015-01-20T17:48:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/"},"wordCount":116,"commentCount":0,"keywords":["genus","patent","plant"],"articleSection":["Databases","patents"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/","url":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/","name":"Which plants are most represented by patents? - hort.net blog","isPartOf":{"@id":"https:\/\/www.hort.net\/blog\/#website"},"datePublished":"2015-01-20T17:48:25+00:00","author":{"@id":"https:\/\/www.hort.net\/blog\/#\/schema\/person\/c5048c118466b10e17155d29454e63de"},"breadcrumb":{"@id":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.hort.net\/blog\/2015\/01\/20\/which-plants-are-most-represented-by-patents\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hort.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Which plants are most represented by patents?"}]},{"@type":"WebSite","@id":"https:\/\/www.hort.net\/blog\/#website","url":"https:\/\/www.hort.net\/blog\/","name":"hort.net blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hort.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.hort.net\/blog\/#\/schema\/person\/c5048c118466b10e17155d29454e63de","name":"Christopher Lindsey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hort.net\/blog\/wp-content\/uploads\/2015\/07\/Christopher-Lindsey_avatar_1437067426-96x96.jpg","url":"https:\/\/www.hort.net\/blog\/wp-content\/uploads\/2015\/07\/Christopher-Lindsey_avatar_1437067426-96x96.jpg","contentUrl":"https:\/\/www.hort.net\/blog\/wp-content\/uploads\/2015\/07\/Christopher-Lindsey_avatar_1437067426-96x96.jpg","caption":"Christopher Lindsey"},"url":"https:\/\/www.hort.net\/blog\/author\/chris\/"}]}},"_links":{"self":[{"href":"https:\/\/www.hort.net\/blog\/wp-json\/wp\/v2\/posts\/910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hort.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hort.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hort.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hort.net\/blog\/wp-json\/wp\/v2\/comments?post=910"}],"version-history":[{"count":0,"href":"https:\/\/www.hort.net\/blog\/wp-json\/wp\/v2\/posts\/910\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hort.net\/blog\/wp-json\/wp\/v2\/media?parent=910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hort.net\/blog\/wp-json\/wp\/v2\/categories?post=910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hort.net\/blog\/wp-json\/wp\/v2\/tags?post=910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}