Ubikuity.net Web application developer

1 June 2014

List of neighboring states for each US state

Filed under: Programming — John Ubikuity @ 22:41

I was searching for a list of neighboring/bordering/adjacent states for each USA state.

I wasn’t able to find any open data, so I decided to create my own list using the following sources:

=> Feel free to verify, contribute and reuse my file: neighbors-states.csv


  • The SQL script was created for SQL Server 2008.

Possible improvements:

  • Add a column called “IsApproximativeNeighbor” in the table “NeighborStates” to define properly the relation between Alaska and Washington state even if there is no common border.

Off topic:

No Comments »

No comments yet.

RSS feed for comments on this post.

Leave a comment

Powered by WordPress