Plot post codes

E

einarp

• Oct 16, 2007

• Original Poster
• #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?

 

J

Jeewhizz

• Oct 16, 2007

• Original Poster
• #2

Using the latitude & longitude, you could get these plotted on a google Map - quite easy really.

 

Upvote 0

E

einarp

• Oct 16, 2007

• Original Poster
• #3

Jeewhizz said:

Using the latitude & longitude, you could get these plotted on a google Map - quite easy really.

Click to expand...

I have 1400 customers... I need to be able to plot them all in one.

 

Upvote 0

C

Chris Ashdown

Free Member

Dec 7, 2003

13,401

3,011

Norfolk

• Oct 16, 2007

• #4

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

 

Upvote 0

C

chancebot

Free Member

Oct 5, 2007

26

0

• Oct 16, 2007

• #5

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.

 

Upvote 0

E

einarp

• Oct 17, 2007

• Original Poster
• #6

It would probably take me shorter time to manually plot 1400 post codes than to learn whatever you just said

Anything for dummies?

 

Upvote 0

J

Jeewhizz

• Oct 17, 2007

• Original Poster
• #7

I sent you a PM yesterday with some solutions

 

Upvote 0

S

Spiderden

• Oct 18, 2007

• Original Poster
• #8

I have a file that I used for a nearest store script I was commissioned to write a couple of years ago. It has both Lat & Long as well as OS coordinates for the first half of all UK post codes. You may find this useful.

http://www.eshopforums.com/upload_files/postcodedata.txt

 

Upvote 0

R

RobertSagoyan

• Oct 25, 2007

• Original Poster
• #9

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.

 

Upvote 0

E

einarp

• Oct 25, 2007

• Original Poster
• #10

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?

 

Upvote 0

A

altyfc

Free Member

Apr 13, 2003

107

1

Aardvarkland

• Oct 26, 2007

• #11

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.

 

Upvote 0

G

Galloglaigh

• Oct 26, 2007

• Original Poster
• #12

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

 

Upvote 0

R

RobertSagoyan

• Oct 28, 2007

• Original Poster
• #13

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)
{

}

 

Upvote 0