Find Jobs
Hire Freelancers

PHP distance calculations by postcode

$30-100 USD

Completed
Posted about 14 years ago

$30-100 USD

Paid on delivery
I need to create a page (in PHP and MySQL) that allows you to find the distance (in miles) between two UK postcodes, by entering either the postcodes or the names of the places. I have an existing database of postcodes with place names, which was obtained from the following link: [login to view URL] (click on the link titled "[login to view URL]") I have set this up with a function that calculates the distance, however the results are not accurate enough. The data appears to be OK, so it must be the calculation that is inaccurate. So, we need to either create a new function that provides accurate results, OR start from scratch with new data. The current database contains the first part of each postcode only, for example "DH1" instead of "DH1 2YZ", and each postcode has latitude/longitude values as well as the place name. Example record: "DH1", "54.781", "-1.566", "Durham" There is an official database of postcode geo-location data (called "Code-Point Open") that is available in CSV format from here: [login to view URL] However, this data does not contain place names. If we were to use this data, we would need to add a field for the place name and somehow populate it with a value for each postcode - possibly by scraping a site like Google Maps? Example record: "DH1 1AB",10,"X",-99,-99,-99,-99,-99,-99,-99,430317,543630,064,"Y51","Q30","00","EJ","MG","X" Another issue with this data is that it only contains *full* postcodes. So, if we were to search for a city by name, it would return many, many postcodes - we would need a mechanism for selecting which one of the postcodes to use (possibly the first alphabetically, as this is usually quite central). I am open to suggestions for the best possible method. I hope all the above makes sense! If you have any questions, please don't hesitate to ask me. Thanks for your time, Adam
Project ID: 3423261

About the project

19 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$33.15 USD in 3 days
4.9 (261 reviews)
6.6
6.6
19 freelancers are bidding on average $86 USD for this job
User Avatar
See private message.
$85 USD in 3 days
4.9 (935 reviews)
8.9
8.9
User Avatar
See private message.
$85 USD in 3 days
5.0 (307 reviews)
7.9
7.9
User Avatar
See private message.
$82.45 USD in 3 days
4.6 (122 reviews)
7.7
7.7
User Avatar
See private message.
$38.25 USD in 3 days
4.9 (305 reviews)
6.8
6.8
User Avatar
See private message.
$254.15 USD in 3 days
4.9 (48 reviews)
6.3
6.3
User Avatar
See private message.
$72.25 USD in 3 days
5.0 (59 reviews)
5.6
5.6
User Avatar
See private message.
$85 USD in 3 days
4.6 (14 reviews)
5.3
5.3
User Avatar
See private message.
$51 USD in 3 days
4.8 (64 reviews)
5.2
5.2
User Avatar
See private message.
$42.50 USD in 3 days
5.0 (46 reviews)
4.6
4.6
User Avatar
See private message.
$38.25 USD in 3 days
5.0 (14 reviews)
3.8
3.8
User Avatar
See private message.
$68 USD in 3 days
5.0 (9 reviews)
2.7
2.7
User Avatar
See private message.
$42.50 USD in 3 days
5.0 (3 reviews)
2.2
2.2
User Avatar
See private message.
$109.65 USD in 3 days
4.5 (7 reviews)
2.5
2.5
User Avatar
See private message.
$34 USD in 3 days
5.0 (9 reviews)
2.0
2.0
User Avatar
See private message.
$85 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$272 USD in 3 days
0.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$80.75 USD in 3 days
0.0 (3 reviews)
0.0
0.0
User Avatar
See private message.
$80.75 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
7-15 Pink Lane, United Kingdom
5.0
41
Payment method verified
Member since Sep 18, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.