corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Help me find a web site


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Help me find a web site
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
26th Oct 09 at 21:01   View Garage View User's Profile U2U Member Reply With Quote
Need web sites that if you type in a postcode it gives you a list of addresses in that postcode.

I'm programming one and I need to see how they work. Ta.
LukeS
Member
Registered: 25th Nov 07
Location: Ormskirk
User status: Offline
26th Oct 09 at 21:02   View User's Profile U2U Member Reply With Quote
Doesn't google maps do this?
C2RL R
Member
Registered: 28th Mar 02
Location: Redcliffe, QLD
User status: Offline
26th Oct 09 at 21:02   View User's Profile U2U Member Reply With Quote
post office site does that doesnt it?
James_DT
Member
Registered: 9th Apr 04
Location: Cambridgeshire
User status: Offline
26th Oct 09 at 21:03   View User's Profile U2U Member Reply With Quote
This is the one I look addresses up with, as it's quicker than Royal Mail's website.
http://www.postcodeanywhere.co.uk/demos/addresses_uk.aspx

edit:
Presents the results a little bit differently, provides a map.
http://www.allies-computing.co.uk/find-address-postcode-demo.html

[Edited on 26-10-2009 by James_DT]
C2RL R
Member
Registered: 28th Mar 02
Location: Redcliffe, QLD
User status: Offline
26th Oct 09 at 21:03   View User's Profile U2U Member Reply With Quote
http://postcode.postoffice.co.uk/portal/po/addressfinder?catId=20700386
Edd
Member
Registered: 8th Nov 04
Location: Glasgow
User status: Offline
26th Oct 09 at 21:04   View User's Profile U2U Member Reply With Quote
all insurance websites do this

ie admiral
elephant
Cosmo
Member
Registered: 29th Mar 01
Location: Im the real one!
User status: Offline
26th Oct 09 at 21:04   View User's Profile U2U Member Reply With Quote
parcel force website will do it too, just select to send a new parcel and will give you the chance to enter a postcode and see all the addresses/business names.
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
26th Oct 09 at 21:04   View Garage View User's Profile U2U Member Reply With Quote
Yeah need anything like shop checkouts, car insurance, stuff like that. Anywhere that looks them up.
M2RTY
Member
Registered: 25th May 01
User status: Offline
26th Oct 09 at 21:26   View User's Profile U2U Member Reply With Quote
confused.com
M2RTY
Member
Registered: 25th May 01
User status: Offline
26th Oct 09 at 21:27   View User's Profile U2U Member Reply With Quote
and payperparcel.co.uk as ive just done a few
Ste
Premium Member

Avatar

Registered: 5th Mar 03
Location: Taif, Saudi Arabia
User status: Offline
26th Oct 09 at 21:27   View Garage View User's Profile U2U Member Reply With Quote
http://www.alexnolan.net/onlinetools/ukpostcodefinder.htm

I would rather lose by a mile because i built my own car, than win by an inch because someone else built it for me.
Paul_J
Member
Registered: 6th Jun 02
Location: London
User status: Offline
26th Oct 09 at 22:47   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ian
Need web sites that if you type in a postcode it gives you a list of addresses in that postcode.

I'm programming one and I need to see how they work. Ta.


I programmed this when I was at Seiko.

Request the data from the royal mail, comes on a massive DVD of how it's all put together, database etc...

Basically, the database to store every address in the country would be huge, so what it stores is things that are different as seperate entities.

So you end up building it up - House Name / Building name / Number - Road Name - Street line 2 - Town - County etc.

but the data is seperated off into different tables containing different parts, each item split so its unique...

So you get rows that just contain things like '1', '2', '3', '4'... 'heath', 'hill', 'road', 'street', 'office', 'drive'... etc

Ahhhh... actually I can neither remember it fully or seem to be able to explain what I mean easily google it, but basically the royal mail have a sample data and guide for you to learn how to use it... then there's a big database you get that has all this data seperated out in this weird way (so nothing is ever replicated) and then using your code it builds the address up...

Hang on, I may have some sample code... Lemme check.

[Edited on 26-10-2009 by Paul_J]
Paul_J
Member
Registered: 6th Jun 02
Location: London
User status: Offline
26th Oct 09 at 22:50   View User's Profile U2U Member Reply With Quote
bugger can't find the code on this laptop, probably at home somewhere in a old back up... the code was all in PL SQL as it was a oracle database.
PaulW
Member
Registered: 26th Jan 03
Location: Atherton, Greater Manchester
User status: Offline
26th Oct 09 at 22:52   View User's Profile U2U Member Reply With Quote
Not had a proper look at that database I pm'd you about yet Ian, is it not listed in there?
Paul_J
Member
Registered: 6th Jun 02
Location: London
User status: Offline
26th Oct 09 at 22:55   View User's Profile U2U Member Reply With Quote
http://www.royalmail.com/portal/rm/jump2?mediaId=400085&catId=400084
Paul_J
Member
Registered: 6th Jun 02
Location: London
User status: Offline
26th Oct 09 at 22:57   View User's Profile U2U Member Reply With Quote
there you go ian - there's the guide

http://www.royalmail.com/portal/rm/jump2?mediaId=400085&catId=400084

it explains how it's split up and how you re form it from this.

 
New Topic
New Poll

Corsa Sport » Message Board » Off Day » Help me find a web site 23 database queries in 0.0167031 seconds