Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Neighboring counties Expand / Collapse
Author
Message
Posted Wednesday, August 2, 2006 9:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 19, 2016 3:21 PM
Points: 272, Visits: 101

I need some data that lists neighboring counties.

Does anyone know of any 3rd party software that does this type of thing?

 

Post #298992
Posted Wednesday, August 2, 2006 10:08 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:47 AM
Points: 3,243, Visits: 2,616
Are you talking about UK counties?

There are only 86 counties in the UK so it is probably quicker and cheaper to derive the data yourself. http://www.abcounties.co.uk/counties/map.htm


LinkedIn Profile

Newbie on www.simple-talk.com
Post #299032
Posted Wednesday, August 2, 2006 10:08 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:47 AM
Points: 3,243, Visits: 2,616
Are you talking about UK counties?

There are only 86 counties in the UK so it is probably quicker and cheaper to derive the data yourself. http://www.abcounties.co.uk/counties/map.htm


LinkedIn Profile

Newbie on www.simple-talk.com
Post #299033
Posted Wednesday, August 2, 2006 10:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 19, 2016 3:21 PM
Points: 272, Visits: 101
Although I'm from the UK, I'm talking about counties per state as in USA
Post #299046
Posted Thursday, August 3, 2006 1:02 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 18, 2016 1:50 PM
Points: 91, Visits: 132
You might look into a company called MapInfo. They have a lot of offerings for location-based info. I'm not sure they have what you need or not, but it could be worth a look.


Post #299454
Posted Thursday, August 3, 2006 1:28 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 14,408, Visits: 37,690

an interesting idea; i've got databases that have a lat/longitude for each county, so you could calculate where nearby counties are < 40 miles or something; but that's not what you were after, right?

what happens if the county in question borders on another state? do you want all counties contiguous with that county, regardless of state, or just contiguous AND in that state?

this would be a project i'd throw at an intern to gather the data; it's kind of neat, although i don't know how it would be of value yet.



Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #299466
Posted Wednesday, July 10, 2013 7:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 1, 2015 1:52 PM
Points: 2, Visits: 22
Go to www.census.gov, or americanfactfinder2 or visit esri.com for mapping resources. There are lots of data out there.
Post #1472107
Posted Wednesday, July 10, 2013 7:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 14,408, Visits: 37,690
note: 7 year old thread.

Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1472118
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse