Results 1 to 9 of 9

 

Thread: CSV of uk towns

  1. #1
    getvisible's Avatar
    Moderator

    Status
    Offline
    Join Date
    Aug 2003
    Location
    My Neighbour is Elvis
    Posts
    4,562
    Thanks
    140
    Thanked 51 Times in 34 Posts


    Hi does anyone have a csv of uk towns ,ideally:

    county, town?

    the data will be used on a recruitment site if you're worried about competitive use.

    Cheers,

    Lee

  2. #2
    futureweb's Avatar
    Registered User

    Status
    Offline
    Join Date
    Jul 2005
    Location
    North Devon
    Posts
    919
    Thanks
    13
    Thanked 22 Times in 22 Posts
    I have a string of counties if thats any good i then split the string into an array then loop through and insert into a database you could change this no problem to insert into a csv file.

  3. #3
    buy.at

    Status
    Offline
    Join Date
    Aug 2003
    Location
    Whitley Bay
    Posts
    2,274
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Lee

    Ill have a quick look on Monday as I think we may have something which we got for someone else ages ago .

    Ill drop you a mail if I can dig it out on Monday

    Mal

  4. #4
    lowndsy's Avatar
    Dark Prince

    Status
    Offline
    Join Date
    Aug 2003
    Location
    Behind you
    Posts
    1,824
    Thanks
    7
    Thanked 44 Times in 33 Posts
    Slightly different approach, but I have counties by abbreviation and their postcodes, with coordinates. Got a nice script to go with it that works out the distance between two postcode areas (like W12 and ST3)

  5. #5
    Keith's Avatar
    Moderator

    Status
    Offline
    Join Date
    Aug 2003
    Location
    Richmond North Yorkshire
    Posts
    2,540
    Thanks
    172
    Thanked 119 Times in 83 Posts
    Hi Lee

    Came across this which might be what you need http://ukgaz.oxhut.co.uk/ havn't download it so dont know how good (or bad) it may be
    Keith ~ My Blog general ramblings. Internet Marketing Blogs UK all the blogs together in one place (pm for inclusion)

  6. #6
    Registered User

    Status
    Offline
    Join Date
    Mar 2004
    Location
    Stafford, UK
    Posts
    323
    Thanks
    1
    Thanked 4 Times in 2 Posts
    Unfortunately there is no county mapping, and it is a LOT of data but you might be able to do something with the USGS (United States Geological Survey). Scroll down for the UK datafile....

    http://earth-info.nga.mil/gns/html/cntry_files.html

    Note that the country files are tab, not comma separated. You probably then want to filter the data down first by "Feature Classification" = "P" (Populated Place), and then by "Populated Place Classification", which is numeric value from 1 to 5 representing the "significance" of the populated place.

    May be of no use but might help a bit!

    Added: Just noticed that the source in Keith's post is based on this data set with the added benefit of county mapping....
    Last edited by dmorison; 30-07-05 at 08:51 AM.
    Developer of the Price Tapestry Price Comparison Script now with full WordPress Plugin!

  7. #7
    ian
    Registered User

    Status
    Online
    Join Date
    Nov 2004
    Posts
    1,045
    Thanks
    30
    Thanked 106 Times in 80 Posts
    You'll have to do a bit of work in excel - http://www.ukvillages.co.uk/ukvillag...20of%20England



    Ian

  8. #8
    Registered User

    Status
    Offline
    Join Date
    Sep 2004
    Location
    Knaresborough
    Posts
    475
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i have a list of town & village names here:

    http://www.atomic78.com/townnames.xls

    You may need to do some work as there are some duplicates to filter (sorry no counties assigned)

  9. #9
    Registered User

    Status
    Offline
    Join Date
    Jan 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts



Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. a csv upload problem can you help?
    By sellfones in forum Programming
    Replies: 0
    Last Post: 26-07-05, 10:02 AM
  2. xml > csv into mysql with a sprinkle of php
    By morleymouse in forum Programming
    Replies: 4
    Last Post: 08-12-04, 02:13 PM
  3. Calling all Merchants and ASPs re CSV and links
    By jess1 in forum Affiliate Marketing Lounge
    Replies: 4
    Last Post: 09-04-04, 03:16 PM
  4. CSV datafeeds
    By drivetowin in forum Affiliate Window & buy.at
    Replies: 17
    Last Post: 20-09-03, 06:15 AM
  5. DataFeeds in XML & CSV
    By Marc Gear in forum Affiliate Window & buy.at
    Replies: 5
    Last Post: 10-09-03, 11:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
To Top

Content Relevant URLs by vBSEO 3.5.0 RC2