Skip to content

ubikuity/List-of-neighboring-states-for-each-US-state

Repository files navigation

List-of-neighboring-states-for-each-US-state

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

I asked on StackOverflow but I had no luck: http://stackoverflow.com/questions/12402673/get-the-neighboring-states-of-a-given-usa-state

I wasn't able to find any open data.

So, I finally decided to create my own list using the following sources:

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

Notes:

  • 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:

Bitdeli Badge

About

List of neighboring/bordering/adjacent states for each USA state

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published