geocode 5592 records fails

[bookeyuk83]

It only codes around half of them, is there anyway to fix this?
I have postcode for the locations only I am afraid.

[Help]

we're looking at the issue you described.

whats the diff between postcode and mdfcode, and which did you use to gecode?

[Help]

We are looking at one of your records that was unable to be geocoded:

If we try to geocode mdfcode "ESASB", with google/yahoo/mapquest, none are able to determine where it is.

however, google maps gives us an answer:  (Not sure why)
http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=ESASB&sll=55.954774,-2.611313&sspn=0.244296,0.234489&ie=UTF8&ll=55.903421,-2.425232&spn=0.489241,0.468979&z=11&iwloc=A

And if we geocode the postalcode (TD113TX) associated with it, we get the following:
yahoo geocoded it as follows, mapquest and google didn't know what it was:
http://maps.google.com/maps?q=55.852249,-2.387230

We are digging deeper...

[Help]

We've built a geocoder comparison tool up to show results of the leading free international geocoders:

You can find it here:
http://compare.innovationgeo.com/

[bookeyuk83]

Hello

The mdf code is a code that has not geographical use at all, its a building ID code.
The postcode is a UK spec postcode and can be geocoded.
Looking at the tool you have provided only Yahoo get 3 sample postcodes correct, map quest fails every time. Google gets the locations very wrong.
Also in my spreadsheet the postcodes are in the format of S753JL this fails, but if I edit the postcode to S75 3JL the geocode from Yahoo is correct.

I now have to edit 2,500 rows of data. doh!

Thanks for your help

[Help]

can you use a substring function in the google spreadsheet to split the postal codes?

ie:
if postalcode length == 6 (or has no space) then concatenate 1-3 + " " + 4-6?

[bookeyuk83]

Thanks for that one minor problem though.

UK postcodes come in the following formats...

AB1 1CB
AB12 1CB
AB1T 1CB
AB12T 2SB