title: Get the neighboring states of a given USA state
body: <p>I created the SQL table with the US states using this page: <a href="http://www.john.geek.nz/2009/01/sql-tips-list-of-us-states/" rel="nofollow">http://www.john.geek.nz/2009/01/sql-tips-list-of-us-states/</a></p>
  
  <pre><code>CREATE TABLE [dbo].[UsaStates] (
      [Code] CHAR (2)     NOT NULL,
      [Name] VARCHAR (50) NOT NULL,
      CONSTRAINT [PK_UsaStates] PRIMARY KEY CLUSTERED ([Code] ASC)
  );
  </code></pre>
  
  <p>I created another SQL table called "NeighborStates" with 2 columns: State and NeighborState.</p>
  
  <pre><code>CREATE TABLE [dbo].[NeighborStates](
      [StateCode] [char](2) NOT NULL,
      [NeighborStateCode] [char](2) NOT NULL,
   CONSTRAINT [PK_NeighborStates] PRIMARY KEY CLUSTERED 
  (
      [StateCode] ASC,
      [NeighborStateCode] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  
  ALTER TABLE [dbo].[NeighborStates]  WITH CHECK ADD  CONSTRAINT [FK_NeighborStates_NeighborStates_Neighbors] FOREIGN KEY([NeighborStateCode])
  REFERENCES [dbo].[UsaStates] ([Code])
  GO
  
  ALTER TABLE [dbo].[NeighborStates]  WITH CHECK ADD  CONSTRAINT [FK_NeighborStates_UsaStates] FOREIGN KEY([StateCode])
  REFERENCES [dbo].[UsaStates] ([Code])
  GO
  </code></pre>
  
  <p>But now, I'm looking for some geospatial data or even a hard-coded list (list of neighbors states for each state) to fill my table "NeighborStates".</p>
  
  <p>Do you know where to find a datasource with the neighboring states of a given USA state?</p>
  
  <pre><code>INSERT INTO [NeighborStates](StateCode,NeighborStateCode) ???
  </code></pre>