Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Address Data Cleanup and Validation Using Google Maps
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.


Bidding period ended early.

Jan 28, 2012

Job awarded.

Jan 20, 2012

Job Description

  |  Change History >>


  • Posted: Thu, Jan 19, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

This is an address cleanup and validation project. We have 132000 records in an excel file. We want to

Phase 1: Clean up this data by moving some information stored with address column to a different column.

Phase 2: Validate the address by comparing against Google Map.

Phase 1:

Data Cleanup:

In many cases there is some data appended to the street name field. This data will have to be appended to the "GridNotes". In almost all of the cases, these records with have parenthesis e.g. "( "and " )". In some cases there may be an asterisk.
For every record where this "cleanup" is performed e.g. some data is appended to "GridNotes" field, set the "DC" column flag to 1, otherwise set it to 0.
NOTE: IT is very important that data is "Appended" and any existing notes are not effected

For every record for which there exist a word "prohibited" or "blocked" or "banned", mark the "Prohibited" column with 1, otherwise set it to 0. Also change the "DC" flag to 1.
Save a copy of this final...

Sign in or Register to see more

Job ID: 28186246
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Croatia (Hrvatska)  |  
- mapping experience for 5 years
 0.0   |  Private   |  0 Jobs
Bid ID: 28305550  |  Submitted: Jan 26, 2012 09:00 ET 
Proposal SEALED

 India  |  
Helping entrepreneurs, small to enterprise level of industries with a web solution. Our knowledge and expertise let us provide cutting edge web...
 4.1   |  $39,954 Earnings   |  19 Jobs
Bid ID: 28195592  |  Submitted: Jan 20, 2012 07:10 ET 
Proposal SEALED

 Russia  |  
Wordpress / Woocommerce / API expert. Bespoke complex backends / integrations.
 4.9   |  Private   |  70 Jobs
Bid ID: 28191142  |  Submitted: Jan 20, 2012 01:48 ET 
Within 3 days

 Pakistan  |  
I am an IT Professional having more than 8 years of working experience in Data Operations Management & Systems Implementations by using...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 28189782  |  Submitted: Jan 20, 2012 00:22 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »