Create MySQL table of street names

$30-250 AUD

Concluído

Publicado

há mais de 9 anos

$30-250 AUD

Pago na entrega

I need a MySQL table of Australian street names scraped and integrated into an existing MySQL database. The two main tables in the database contain address data. These need to be amended to include a column containing the foreign key from the new table. The new columns must then be populated with the foreign key for existing data and code written to populate the new column with the correct foreign key for new data as it comes in. The new table must reference and use foreign keys for location and postcodes from another table. Where the external source does not contain street names currently in the two main tables, normalised versions of those street names are to be added to the new table.

MySQL

Ruby

Web Scraping

ID do Projeto: 6359927

Sobre o projeto

14 propostas

Projeto remoto

Ativo há 10 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@amovchan

Hello, As discussed before, I will parse source site and retrieve street names from it and populate database with street names linked to postcodes and localities. Also, street names already in database will be processed and linked with data. Regards, Oleksandr Movchan

$250 AUD em 7 dias

4,8

(8 avaliações)

5,5

14 freelancers estão ofertando em média $122 AUD for esse trabalho

@avinashjain09

Hello, I have a good command over mysql and also I am a Oracle certified associate also. I can complete your task, I have 3+ years of experience in php and mysql.

$90 AUD em 1 dia

4,7

(93 avaliações)

6,2

@Texnomic

Dear Sir, I'm a Certified Database & Application Developer. I've experience in build/rebuilding databases with 100+ Million records. The task in your description can be down within few hours but I gave it two days just in case.

$111 AUD em 2 dias

5,0

(6 avaliações)

5,2

@audelk

sir, i can scrap the data from mysql table without a problem. just let me know. thank you audel

$111 AUD em 7 dias

5,0

(13 avaliações)

4,9

@sameerali661

A proposal has not yet been provided

$30 AUD em 1 dia

4,6

(8 avaliações)

3,3

@strider196

Hi, your project sounds simple enough. Shouldn't be too much of an issue to get it done in less than 3 days! :)

$30 AUD em 3 dias

5,0

(2 avaliações)

2,8

@RohitMotwani

Hi sir, i have 5+ years of experience in building huge enterprise applications and i can also show you some samples of web scrapping code if you require... I can do your work within 1 day however please suggest from which site/page, the code should scrap data ?? Waiting for your positive response...

$55 AUD em 1 dia

5,0

(2 avaliações)

2,0

@webformobile

As I understood it, the data source is already provided, however it's my duty to parse the incoming format and into streets into database. I'm going to deliver you neat, maintainable solution well-covered with tests, preferably RSpec (however other test frameworks are fine, too). See my SQL matchers portfolio sample to learn how I test.

$110 AUD em 3 dias

5,0

(1 avaliação)

1,9

@karanammk

i worked on this kind of requirement many times ,i have experience in DB design and am waiting for opportunity to work

$222 AUD em 3 dias

0,0

(0 avaliações)

0,0

@mayankp0810

i have a good knowledge of mysql. i have very fast typing speed , so i can do the task very fast. i can do the project on time.

$155 AUD em 3 dias

0,0

(0 avaliações)

0,0

@davidg237

Hi, I have a Oracle Course Certification including that I used MySQL in previous projects I had. Also, I've been working with databases for 2 year, so I can help you with your request.

$111 AUD em 5 dias