Find Jobs
Hire Freelancers

Database Merge

$30-250 USD

処理中
投稿日: 約12年前

$30-250 USD

完了時にお支払い
I have three databases. 1. Properietary: List of cities.(around 40,000) [Cityid1, Country Name, RegionName1, City Name, Citycustomname, countrycode] 2. Maxmind Location: List of Cities with additional fields. (300,000) [cityid2, Countrycode, RegionID, CityName, L1, L2] 3. Maxmind Regions (List of Region Codes, Region Label) [Regionid, RegionName2] I want one database for 40,000 records as mentioned in database #1. The records from 2 and 3 needs to be merged to appropriate rows in database#1. So in the end, the final database with 40,000 rows will have the following structure. [Cityid1, Cityid2, CountryName, RegionName1, RegionName2, City Name, CityCustomName, RegionID, L1, L2, Countrycode] This will require both the SQL skills and Manual data verification. This can be done all manually if required but bulk can be done using the database. Steps required: a. Merge #2 and #3 to create a database #4. So that you get the regionname+cityname+countrycode combination. b. Find through the database, all the records that match countrycode, Regionname, Cityname. Merge this data as specified above. Store this data in table #5. c. Find through the database, all the records in #1 table that do not exist in table #5. Store these in table #6. d. Manually update records in table #6. e. Merge table #5 and table #6 to come up with finalized table. We have a quick method to check for accuracy for each row and we will NOT pay unless the data is accurate for every row in the database. These are all cities so Countrycode, Region etc should all match up fairly easily for the MOST part. Again, we are OK if you wish to update the records in an excel sheet manually. We just want the final data and as we said, we can check for the accuracy of all 40K records in one click of a button if done right so do bid only if you are going to do this properly. Payment will be done upon data verification and project completion.
プロジェクト ID: 1596912

プロジェクトについて

16個の提案
リモートプロジェクト
アクティブ 12年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に16人のフリーランサーが、平均$177 USDで入札しています
ユーザーアバター
Expert here, please see the Pm for more details
$30 USD 0日以内
4.7 (229 レビュー)
7.1
7.1
ユーザーアバター
Hi, I have experience in this job, please contact me
$250 USD 3日以内
4.9 (95 レビュー)
5.7
5.7
ユーザーアバター
Hi, I can merge database 2 and 3 into 40,000 records mentioned in database 1. Please check inbox for more. Thank you.
$75 USD 3日以内
5.0 (62 レビュー)
5.6
5.6
ユーザーアバター
Hello Sir, I am interested to work on your project, if you do consider. Regards
$180 USD 5日以内
5.0 (24 レビュー)
5.0
5.0
ユーザーアバター
Hi i can do it, please send the sample of 3 database and clarify more about step "d. Manually update records in table #6." What do you mean by manually? you need also to lookup information from Internet for they are not in the 2,3 databases? How many of the 40K approximately would require this step? Looking forward to hearing you, Cuong NH
$250 USD 5日以内
4.7 (23 レビュー)
4.9
4.9
ユーザーアバター
Hi There, We can have your master table prepared for you and ensure that the work is accurate before presenting the results to you. For 95% of the task, we endeavor that automation techniques will be used. We will be using custom SQL code to manipulate, merge, de-dupe and verify your results and we can ensure that it will be done well. Please contact us if you would like to discuss any details further. Thanks MAV-IT
$250 USD 4日以内
4.9 (7 レビュー)
4.1
4.1
ユーザーアバター
Available to start immediately and finish as soon as possible.
$200 USD 2日以内
4.9 (11 レビュー)
4.3
4.3
ユーザーアバター
I can do it !
$125 USD 7日以内
5.0 (11 レビュー)
3.6
3.6
ユーザーアバター
Hi, I have gone through the csv's and the fips file. Please see PM.
$75 USD 2日以内
5.0 (1 レビュー)
2.2
2.2
ユーザーアバター
I can do the task as you want, we are expert in handling database.
$60 USD 3日以内
4.6 (1 レビュー)
1.4
1.4
ユーザーアバター
Basically, its a simple DATABASE FILE PROCESSING--analysis, extraction, manipulation, & storage of which I'm good at. Backed by 20+ professional IT years you can count on the accuracy and timely delivery of the project.
$250 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Good Morning, I have excellent skills in excel. I will not manually merge the data but rather use excel formula and macro to do the job. All 40,000 data can be done in 1 day.
$250 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan. With Regards Sri Technocrat.
$300 USD 10日以内
0.0 (0 レビュー)
3.7
3.7
ユーザーアバター
Hey, will do as per your need.
$240 USD 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I have analyzed your files and can do a good job!!!
$150 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I'd like to do this project
$150 USD 3日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Valencia, United States
0.0
0
メンバー登録日:4月 30, 2012

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。