Jan K. (job poster) hired Christopher M. (Tasker) to help with this task. Got a similar task you need done?
Open
Assigned
Completed

Simple but highly repetitive data entry task

Posted by Jan K.

Location

Remote

Due date
Friday, 29th Sep 2017
Details
Hi, I have exactly 1.3 million GPS coordinates (latitude longitude) in columns in a spreadsheet.

I need someone to copy and paste all of these coordinates in groups of 100 coordinates to this webpage ([Content Moderated]
(This webpage will find what address is near each GPS coordinate.)

You then need to copy and paste the addresses found in this website along-side the original GPS coordinate in the spreadsheet.

Note: the webpage undergoes "throttling", so it is initially very fast (0-100ms per line), but after 200th line the throttling makes it take longer than 21 seconds per line. The first 100 coordinates are fairly quick.

So: I recommend opening multiple windows, each with around 20-30 instances of this webpage, and running the request for exactly 100 lines at a time (in each open tab in your browser) - being *very* careful to correctly paste the correct address next to the correct GPS coordinate each time.

In total, this project should require you to open 13,706 instances of this webpage, and match the address to 100 GPS coordinates each time. On my system it takes 3min 30 sec for the webpage to find the first 100 addresses. If you open 100 webpages (tabs) simultaneously it will theoretically take 3:30 to find 10,000 addresses, with all 100 tabs running the site simultaneously (not factoring in the small amount of time to copying and paste the data back and forth each time.

I understand that this is a really boring, repetitive task. If you are clever enough to write a "macro" to get your computer to automate this task, be my guest.
At the end of the day, I just care that the GPS coordinates are correctly aligned to the street addresses in the spreadsheet you send to me. I don't mind what approach you take to complete the task.
Assignee
Christopher M.
(25)
96%Completion rate

The percentage of accepted tasks this Tasker has completed.

Writing a macro is exactly what I plan to do. Tonight, if you like.
1 year ago

1 more reply

Yes.
The computer will do most of the work with complete precision. No risk of copy-paste errors.
Jan K.poster
Awesome, would be great if you could get it done as soon as possible then
Task Activity
8 comments about this Task
Comments are now closed
Really curious what this is for!
Hi Jan, you might need to attach info as image. Since airtasker sensors all numbers
Jan K.poster
Latitude Longitude Address
Unnamed Road, Thermaikos 575 00, Greece"
Unnamed Road, Thermaikos 575 00, Greece"
Athanasiou Diakou, Thermaikos 575 00, Greece"
Unnamed Road, Thermaikos 575 00, Greece"
Unnamed Road, Thermaikos 575 00, Greece"
Unnamed Road, Nea Propontida 630 80, Greece"
Unnamed Road, Thermaikos 575 00, Greece"
is Oktovriou 26, Epanomi 575 00, Greece"
is Oktovriou 26, Epanomi 575 00, Greece"
Athanasiou Diakou, Thermaikos 575 00, Greece"
L. Ampatzoglou 67, Nea Kallikratia 630 80, Greece"
L. Ampatzoglou 67, Nea Kallikratia 630 80, Greece"
L. Ampatzoglou 67, Nea Kallikratia 630 80, Greece"
Unnamed Road, Thermaikos 575 00, Greece"
A/D Thessalonikis Neon Moudanion, Thermi 575 00, Greece"
Hi Jan.

Actually really excited to do a mundane task! I have an eye for detail and have done this type of project before as a media monitor. I could get started tonight with the aim of completion this time tomorrow.

Looking forward to getting this done for you!
Jan K.poster
Please be aware: 1.3 million codes, guys
Task Assigned
0 new tasks