1. Welcome to UKBF! Check out our FAQ guide.

Plot post codes

Discussion in 'IT & Internet' started by einarp, Oct 16, 2007.

  1. einarp

    einarp UKBF Regular Free Member

    Posts: 54 Likes: 1
    I'm trying to make a plot map of our geographical spread of customers. I have all data in three different formats.

    Either full post code
    Or left half of post code
    Or Coordinates (latitude, longitude).

    Anyone can help me with one-off job with me having to pay for a software?
  2. Jeewhizz

    Jeewhizz UKBF Regular Free Member

    Posts: 691 Likes: 69
    Using the latitude & longitude, you could get these plotted on a google Map - quite easy really.
  3. einarp

    einarp UKBF Regular Free Member

    Posts: 54 Likes: 1
    I have 1400 customers... I need to be able to plot them all in one.
  4. Chris Ashdown

    Chris Ashdown UKBF Regular Free Member

    Posts: 4,612 Likes: 1,019
    Look for GIS software normally part of a cad package like autocad you can then either use lat long or utm grids, I think post codes are expensive to use
  5. chancebot

    chancebot UKBF Regular Free Member

    Posts: 26 Likes: 0
    This should be pretty easy. Use a site like

    http://mapmaker.donkeymagic.co.uk/

    to get core javascript for one of your records and then write a script to create the javascript for the remaining 1399. You'll need to get your own googlemaps API key.
  6. einarp

    einarp UKBF Regular Free Member

    Posts: 54 Likes: 1
    It would probably take me shorter time to manually plot 1400 post codes than to learn whatever you just said :)

    Anything for dummies?
  7. Jeewhizz

    Jeewhizz UKBF Regular Free Member

    Posts: 691 Likes: 69
    I sent you a PM yesterday with some solutions
  8. Spiderden

    Spiderden UKBF Regular Free Member

    Posts: 713 Likes: 77
  9. RobertSagoyan

    RobertSagoyan UKBF Regular Free Member

    Posts: 18 Likes: 0
    Google Maps is very good . It's also support UK postcodes now.
    You need to put your customer locations(lat/long) to XML file and read it using Google map api ,
    javascript and google map api , all what you need.
  10. einarp

    einarp UKBF Regular Free Member

    Posts: 54 Likes: 1
    Again, a little too advanced for a poor accountant :)

    I have an excel file with postcode, lat. and long. which I guess is fairly simple to make into xml.

    Any link to any places where I can just upload the file and the plotting is done?
  11. altyfc

    altyfc UKBF Regular Free Member

    Posts: 106 Likes: 1
    Is this an online map you're wanting?

    Our http://www.aardvarkmap.net tool might be just what you're looking for. You just enter your postcodes at step 1, and it will plot them on to a Google Map for you.

    At the end, you just copy and paste some code.
  12. Galloglaigh

    Galloglaigh UKBF Regular Free Member

    Posts: 30 Likes: 3
    MS Autoroute has a data import facility from excel. Import the postcodes and they are shown on a GB map. No limit as far as I am aware on the number and it's quick. Think it's 40 Euros.

    Another feature is that you can plot say 10 postcodes and get an optimised route ie, shortest / quickest etc. Good for planning delivery routes etc
  13. RobertSagoyan

    RobertSagoyan UKBF Regular Free Member

    Posts: 18 Likes: 0
    Einarp , there is a lot of documentation how to plot map with markers of locations array.
    Google is the perfect solution for this.
    This is a funciton which works with XML. Just :) use google to find the API , if you need more details,just let me know. perhaps you have already solved your request.
    GDownloadUrl("YOUR XML ", function(data, responseCode)
    {

    }