Find Jobs
Hire Freelancers

Converting Longitude and Latitude to Postcodes

$30-250 USD

In Progress
Posted about 10 years ago

$30-250 USD

Paid on delivery
We have an excel spreadsheet of about 700,000 records. Each of these records has a UK longitude and latitude for it. We need a postcode for each field added to the spreadsheet, I believe this can be added either through a crawler or referencing the closest point by using a list of all postcodes with their longitude and latitude with a mathematical calculation.
Project ID: 5413826

About the project

28 proposals
Remote project
Active 10 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
28 freelancers are bidding on average $274 USD for this job
User Avatar
Please send me the list of coordinates, I will be glad to prepare a sample for you. This looks like an interesting project. I will be glad if you choose me, to work for you on this or any further project. I have big past experience on similar tasks, I'm sure you will be satisfied with the results.
$147 USD in 1 day
5.0 (62 reviews)
8.5
8.5
User Avatar
Hi, Ready to start work. We do this Manually. Highly Interested. Please provide your lists to me to make some sample work for your confirmation before we start. Please check our clients feedback and completion rate. We are eagerly awaiting for your positive reply. Thanks, Jennifer.
$1,000 USD in 25 days
5.0 (356 reviews)
7.7
7.7
User Avatar
Hi, could you send me the file (or a sample file) so I can see some of the coordinates values (and format). I might be able to give you the solution within an hour if the data has the correct format Thanks
$144 USD in 0 day
4.8 (263 reviews)
7.7
7.7
User Avatar
Hello, I am VB, VBA, C#, WPF, Java, PHP, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile and portfolio. I am ready to discuss and doing the project. I did similar project in the past and ready to doing your. The critical issue in your project is the time and I think I submitted the wrong time and I will fix that because if each record take 5 seconds to get it the total will be 5*700000/60/60 = 972 hours = 40 continues days of running the application. Regards, Eyad
$1,777 USD in 47 days
5.0 (44 reviews)
7.2
7.2
User Avatar
Hi frewen. As you correctly pointed out, the addresses need to be matched with a list of available postcodes. It can be done via VBA macro in Excel. Kindly discuss via message. Regards.
$160 USD in 3 days
5.0 (91 reviews)
7.1
7.1
User Avatar
Hi, I am Asanka and this task can be done very easily. I already have a program that can find postal codes from location coordinates. Therefore it is only a matter of time to write a small script to find all your postal codes. It won't take more than one day. let me know. Thanks. Asanka
$155 USD in 3 days
5.0 (31 reviews)
6.7
6.7
User Avatar
Hello, I have written a program in Javascript which locates the longitude and latitude using Google maps API and finds the corresponding postcode. It runs fast, however 700000 records need a lot of time, that's why my bid is for 1 day (24 hours), just to be sure. The results are accurate and verified. The program is not only tested but also used for many different applications. Looking forward to hear from you, Kind regards, chriskerpini
$100 USD in 1 day
4.9 (79 reviews)
6.8
6.8
User Avatar
hi kindly share the list of all longitude and latitude to provide you the sample output with their postal codes. cheers mate
$100 USD in 3 days
5.0 (30 reviews)
6.1
6.1
User Avatar
Hi Are you looking for the outcode only, like AB1 or for the full post code like AB1 0DN? I am placing this bid assuming you are looking for the outcode. This is what i am going to do. I have a database of complete UK Post codes, with lat and long (only the outcodes). I will add one more column DistanceFromX against each post code where X is any selected postcode (say a post code in the central region). I have the code to find distance between two lat & long. So now I have each post code with its lat and long and its distance to Post code X. Now for each lat in long in your file, I will calculate the distance to X post code. Then I will find the Postcode which is maximum close to this distance, that will be the post code for your input lat & long. I wll have your file in mysql db, loop the db for the above logic, fill post code for all the rows and send you back the data with post codes. The same logic theoritically can be applied for full postcodes also, however the list of ful postcodes comes to around 17M, making it difficult to load to database and calculate DistanceFromX value. I can start immediately and complete in 2-3 days time. I commit a proper and timely communication and high quality deliverables, if selected. Thank you Roni
$120 USD in 5 days
5.0 (32 reviews)
6.0
6.0
User Avatar
hi there I was in UK for 7 years, I came back from there last year, I have a bit idea about the postcode, I was working at Royal Mail for 2 years. is that ok if I want to do this manually? hope to get reply from you. thank you Ahmed
$222 USD in 15 days
4.9 (87 reviews)
5.5
5.5
User Avatar
Greetings,can you send me a sample of 1000 records to extract the nearest post code?The lat/long are in WGS84 or British Datum?Thanks in advance,Ilirjan
$221 USD in 7 days
4.9 (75 reviews)
5.6
5.6
User Avatar
I have checked your project, and I have everything set to start working. I have found all postal codes, with long. and lat. so finishing is no problem. With regards, Tom
$250 USD in 7 days
4.9 (34 reviews)
5.4
5.4
User Avatar
I can convert 700k of longitude and latitude using Google Maps API. This is simple task, but Google have a restrictions for amount of requests per day (usually this is only 2500 entries per day). Also i believe that some math algorithms can be used to speed up conversion (if some coordinates in the same location, can be be used same ZIP code) Can you send sample of data for initial test conversion? Why 20 days? I have done a conversion of 500k latitude/longitude into Address (ZIP, city, state, country). Those conversion was done in 2 weeks. Regards, Eugene
$600 USD in 20 days
4.9 (14 reviews)
5.0
5.0
User Avatar
* OM SAI RAM * Respected Sir/Mam, I have read the project completely and I have understood my responsibilities (If awarded) clearly. To tell more about myself, I am dedicated and sincere in working on the projects awarded to me here. I can understand the urgency of the employers and work to finish the project in time. Moreover, As you can see my profile, I am quite a new freelancer. I love to keep my reputation up to the mark. If you wish to award the project to me trusting my abilities, you are always welcome to contact me anytime of the day. Let us have a chat on the project details before I take the responsibilities, As this will help me understand the project clearly. So that We won't be in a situation where our time won't be wasted later. Lastly, I would like to tell that I stand by my words and I assure you that your expectations will be satisfied completely by my work. You will be happy with my work at the end. As a request, I ask you kindly to offer me this project's responsibilities and pave me a path to stand out of the crowd in Freelancer. Thanks in advance. With regards, SathyaNarayana Singh. J.
$250 USD in 45 days
4.9 (9 reviews)
3.5
3.5
User Avatar
Hi, I am very much interested about the project. I will use Java programming and use Google Geocoder to get the postcodes. I can complete the job within 1 week. I am ready to start. Thanks, Bishnu 3rd Eye Lab
$105 USD in 7 days
4.6 (6 reviews)
2.6
2.6
User Avatar
I have done this work a number of times and can provide your a database which you can use it convert your postcodes to lat/long combinations. I have implemented this in a lot of websites / application which we had developed. I have over 20 years of experience in It developing / maintaining applications
$222 USD in 7 days
5.0 (2 reviews)
1.3
1.3
User Avatar
Hello, This task is a simple one, i'd take a official csv-list of UK postcodes, your adress list exported to csv, haversine formula and quite simple tool of my own to calculate closest postcode for each of your adresses. Regards Martin.
$120 USD in 2 days
5.0 (1 review)
0.4
0.4
User Avatar
A proposal has not yet been provided
$144 USD in 3 days
0.0 (1 review)
0.0
0.0
User Avatar
A proposal has not yet been provided
$88 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi This is Sagar. I am having good exp on visual basic. I have already worked on lot of macros and this type of calculations work. Will complete your task in specified time. I am currently available and will start your work immediately.
$133 USD in 3 days
0.0 (0 reviews)
1.3
1.3

About the client

Flag of UNITED KINGDOM
Lichfield, United Kingdom
5.0
11
Payment method verified
Member since Jun 8, 2013

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.