Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder mic2100's Avatar
    Join Date
    Feb 2006
    Location
    Scunthorpe
    Posts
    562
    Thanks
    15
    Thanked 28 Times in 27 Posts

    Question everything south of a point in the UK

    What i have is a program that loads all of the insulation leads that are produces in a day onto a web based application for our surveyors to see. Now my manager as asked if it would be possible to produce a piece of code that will seperate any leads that are south of northamptonshire to do somthing else with them.

    Wot i am looking for is ideas on how i can approach this porblem since i am completly stuck with it. I thought about an arry that stored all the counties that fall in this area, once it comes accress one of them it does the new process.

    Help Please!!!

  • #2
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,495
    Thanks
    8
    Thanked 1,089 Times in 1,080 Posts
    In the U.S. we have zipcodes.

    Does the U.K. have any type of city codes? and possible
    an existing database you can tap into?

    Otherwise, a county database would be the option (as you mentioned).

    I'm thinking also of some GPS type thing (latitude entries) to determine
    what is south or north.

  • #3
    Senior Coder
    Join Date
    Sep 2005
    Posts
    1,791
    Thanks
    5
    Thanked 36 Times in 35 Posts
    if you need absolute accuracy, then you'll need to store latitude and longitude, there are a number of services that will provide these for postcodes.
    If county-level is specific enough, then that will be far easier- there are about 110 countires in England and wales, so it would probably only take a couple of hours to do the data-entry required for that, while you'd probably spend at least that on getting the code for lat/long comparisons working.


  •  

    Posting Permissions

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