{"id":3186,"date":"2018-05-11T10:24:31","date_gmt":"2018-05-11T18:24:31","guid":{"rendered":"http:\/\/bien.nceas.ucsb.edu\/bien\/?page_id=3186"},"modified":"2021-04-12T17:29:29","modified_gmt":"2021-04-13T01:29:29","slug":"gnrs-data-dictionary","status":"publish","type":"page","link":"https:\/\/bien.nceas.ucsb.edu\/bien\/tools\/gnrs\/gnrs-data-dictionary\/","title":{"rendered":"GNRS Data Dictionary"},"content":{"rendered":"

Below are the columns returned by the GNRS<\/a>, their definitions and constrained values, where applicable.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Column name<\/strong><\/td>\nMeaning<\/strong><\/td>\nValues<\/strong><\/td>\n<\/tr>\n
id<\/td>\nInteger identifier assigned by the GNRS. Not the same as user_id (see below)<\/td>\n<\/td>\n<\/tr>\n
poldiv_full<\/td>\nAll three verbatim political divisions, concatenated with '@' as a delimiter. Can be used as a single-column text identifier for joining back to source database.<\/td>\n<\/td>\n<\/tr>\n
\n

country_verbatim<\/span><\/p>\n<\/td>\n

Country name, as submitted<\/td>\n<\/td>\n<\/tr>\n
state_province_verbatim<\/span><\/td>\nSecond-level political division, as submitted<\/td>\n<\/td>\n<\/tr>\n
county_parish_verbatim<\/span><\/td>\nThird-level political division, as submitted<\/td>\n<\/td>\n<\/tr>\n
country*<\/td>\nMatched country name<\/td>\n<\/td>\n<\/tr>\n
state_province*<\/td>\nMatched state_province name<\/td>\n<\/td>\n<\/tr>\n
county_parish*<\/td>\nMatched county_parish name<\/td>\n<\/td>\n<\/tr>\n
\n

country_id<\/span><\/p>\n<\/td>\n

GeoNames integer ID for the matched country<\/td>\n<\/td>\n<\/tr>\n
\n

state_province_id<\/span><\/p>\n<\/td>\n

GeoNames integer ID for the matchedstate_province<\/span><\/td>\n<\/td>\n<\/tr>\n
\n

county_parish_id<\/span><\/p>\n<\/td>\n

GeoNames integer ID for the matched\u00a0county_parish<\/span><\/td>\n<\/td>\n<\/tr>\n
\n

match_method_country<\/span><\/p>\n<\/td>\n

Method used to match country<\/td>\nexact alternate name, exact ascii name, exact standard name, fuzzy alternate name, fuzzy standard name, iso_alpha3 code, iso code<\/td>\n<\/tr>\n
\n

match_method_state_province<\/span><\/p>\n<\/td>\n

Method used to match\u00a0state_province<\/span><\/td>\nexact alternate name, exact ascii name, exact ascii short name, exact name, fuzzy alternate name, fuzzy ascii name, fuzzy ascii short name, fuzzy standard name, iso code<\/td>\n<\/tr>\n
\n

match_method_county_parish<\/span><\/p>\n<\/td>\n

Method used to match\u00a0county_parish<\/span><\/td>\n<\/td>\n<\/tr>\n
\n

match_score_country<\/span><\/p>\n<\/td>\n

Match score for country\u00a0(if fuzzy matching used)<\/td>\n0 to 1<\/td>\n<\/tr>\n
\n

match_score_state_province<\/span><\/p>\n<\/td>\n

Match score for\u00a0state_province<\/span><\/span>\u00a0(if fuzzy matching used)<\/span><\/td>\n0 to 1<\/td>\n<\/tr>\n
\n

match_score_county_parish<\/span><\/p>\n<\/td>\n

Match score for\u00a0county_parish<\/span><\/span>\u00a0(if fuzzy matching used)<\/span><\/td>\n0 to 1<\/td>\n<\/tr>\n
\n

poldiv_submitted<\/span><\/p>\n<\/td>\n

Level of political division submitted<\/td>\ncountry, state_province, county_parish<\/td>\n<\/tr>\n
\n

poldiv_matched<\/span><\/p>\n<\/td>\n

\u00a0Level of political division matched<\/td>\n\u00a0country, state_province, county_parish<\/td>\n<\/tr>\n
\n

match_status<\/span><\/p>\n<\/td>\n

Overall match status<\/td>\n\u00a0full match,\u00a0no match,\u00a0<\/span>partial match<\/span><\/td>\n<\/tr>\n
\n

user_id<\/span><\/p>\n<\/td>\n

Verbatim user-submitted identifier, if supplied<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

* Matched names returned are the plain ASCII (non-accented) standard English version, as per GeoNames<\/a>.<\/p>\n

Return to main GNRS page.<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Below are the columns returned by the GNRS, their definitions and constrained values, where applicable. Column name Meaning Values id Integer identifier assigned by the GNRS. Not the same as user_id (see below) poldiv_full All three verbatim political divisions, concatenated with '@' as a delimiter. Can be used as a single-column text identifier for joining […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":3184,"menu_order":80,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-3186","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/3186"}],"collection":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/comments?post=3186"}],"version-history":[{"count":9,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/3186\/revisions"}],"predecessor-version":[{"id":3639,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/3186\/revisions\/3639"}],"up":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/3184"}],"wp:attachment":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/media?parent=3186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}