Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Wednesday, June 4, 2014 4:11 PM
Points: 271, Visits: 84

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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:07 AM
Points: 2,901, Visits: 1,805
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:07 AM
Points: 2,901, Visits: 1,805
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: Wednesday, June 4, 2014 4:11 PM
Points: 271, Visits: 84
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: Thursday, May 23, 2013 10:23 AM
Points: 91, Visits: 123
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: Yesterday @ 5:47 PM
Points: 12,910, Visits: 32,020

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
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, June 20, 2014 10:09 AM
Points: 2, Visits: 19
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: Yesterday @ 5:47 PM
Points: 12,910, Visits: 32,020
note: 7 year old thread.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1472118
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse