{"id":267,"date":"2014-06-01T22:41:12","date_gmt":"2014-06-01T20:41:12","guid":{"rendered":"http:\/\/ubikuity.net\/blog\/?p=267"},"modified":"2023-01-16T18:26:26","modified_gmt":"2023-01-16T17:26:26","slug":"list-of-neighboring-states-for-each-us-state","status":"publish","type":"post","link":"https:\/\/ubikuity.net\/blog\/2014\/06\/01\/list-of-neighboring-states-for-each-us-state\/","title":{"rendered":"List of neighboring states for each US state"},"content":{"rendered":"<p>I was searching for a list of neighboring\/bordering\/adjacent states for each USA state.<\/p>\n<p>I wasn&#8217;t able to find any <a href=\"http:\/\/en.wikipedia.org\/wiki\/Open_data\">open data<\/a>, so I decided to create my own list using the following sources:<\/p>\n<ul class=\"task-list\">\n<li><a href=\"http:\/\/theincidentaleconomist.com\/wordpress\/list-of-neighboring-states-with-stata-code\/\">http:\/\/theincidentaleconomist.com\/wordpress\/list-of-neighboring-states-with-stata-code\/<\/a><\/li>\n<li><a href=\"http:\/\/www.john.geek.nz\/2009\/01\/sql-tips-list-of-us-states\/\">http:\/\/www.john.geek.nz\/2009\/01\/sql-tips-list-of-us-states\/<\/a><\/li>\n<li><a href=\"http:\/\/theincidentaleconomist.com\/wordpress\/list-of-neighboring-states-with-stata-code\/\">http:\/\/askville.amazon.com\/Trivia-state-bordered-states\/AnswerViewer.do?requestId=3941039<\/a><\/li>\n<li><a href=\"http:\/\/en.wikipedia.org\/wiki\/List_of_U.S._states_by_date_of_statehood\">http:\/\/en.wikipedia.org\/wiki\/List_of_U.S._states_by_date_of_statehood<\/a><\/li>\n<li><a href=\"http:\/\/en.wikipedia.org\/wiki\/History_of_Washington,_D.C.\">http:\/\/en.wikipedia.org\/wiki\/History_of_Washington,_D.C.<\/a><\/li>\n<\/ul>\n<p>=&gt; Feel free to verify, contribute and reuse my file: <a href=\"https:\/\/github.com\/ubikuity\/List-of-neighboring-states-for-each-US-state\/blob\/master\/neighbors-states.csv\">neighbors-states.csv<\/a><\/p>\n<p><strong>Notes<\/strong>:<\/p>\n<ul class=\"task-list\">\n<li>The SQL script was created for SQL Server 2008.<\/li>\n<\/ul>\n<p><strong>Possible improvements:<\/strong><\/p>\n<ul class=\"task-list\">\n<li>Add a column called &#8220;IsApproximativeNeighbor&#8221; in the table &#8220;NeighborStates&#8221; to define properly the relation between Alaska and Washington state even if there is no common border.<\/li>\n<\/ul>\n<p><strong>Off topic:<\/strong><\/p>\n<ul class=\"task-list\">\n<li>At first, I wanted to use MySQL but I discovered that MySQL constraint implementation still is incomplete: &#8220;the CHECK clause is parsed but ignored by all storage engines&#8221;. See <a href=\"http:\/\/bugs.mysql.com\/bug.php?id=3464\">http:\/\/bugs.mysql.com\/bug.php?id=3464<\/a> and <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/create-table.html\">http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/create-table.html<\/a>.<\/li>\n<li>Maybe some of you remember the song from this cartoon: <a href=\"http:\/\/www.youtube.com\/watch?v=sNUDDaEOvuY\">Animaniacs video of Wakko&#8217;s famous 50 State Capitols song<\/a>.<\/li>\n<li>By the way, I never been to the USA and this list give some motivation to visit USA!<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I was searching for a list of neighboring\/bordering\/adjacent states for each USA state. I wasn&#8217;t able to find any open data, so I decided to create my own list using the following sources: http:\/\/theincidentaleconomist.com\/wordpress\/list-of-neighboring-states-with-stata-code\/ http:\/\/www.john.geek.nz\/2009\/01\/sql-tips-list-of-us-states\/ http:\/\/askville.amazon.com\/Trivia-state-bordered-states\/AnswerViewer.do?requestId=3941039 http:\/\/en.wikipedia.org\/wiki\/List_of_U.S._states_by_date_of_statehood http:\/\/en.wikipedia.org\/wiki\/History_of_Washington,_D.C. =&gt; Feel free to verify, contribute and reuse my file: neighbors-states.csv Notes: The SQL script was created [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[5],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6emaU-4j","_links":{"self":[{"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/posts\/267"}],"collection":[{"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/comments?post=267"}],"version-history":[{"count":4,"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/posts\/267\/revisions"}],"predecessor-version":[{"id":559,"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/posts\/267\/revisions\/559"}],"wp:attachment":[{"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/media?parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/categories?post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubikuity.net\/blog\/wp-json\/wp\/v2\/tags?post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}