Simple data harvest.
$30-100 USD
Betalt ved levering
Go to www.rentwave.com. For each state, gather each 'metro' area in all regions. Store each 'metro' and its state in a 'metro' table, described below. (exclude "& Vicinity" from the 'metro' name).
Next, for each 'metro', harvest each town listed in that 'metro'. Store the towns in a towns table, and link its cooresponding unique 'metro id' number from the 'metro' table.
Required table structures:
CREATE TABLE `metro`(`mid` int( 11 ) NOT NULL AUTO_INCREMENT,`metro` varchar(50) NOT NULL default '',`state` varchar(50) NOT NULL default '');
CREATE TABLE `towns`(
`mid` int( 11 ) NOT NULL default '',
`tid` int(11) NOT NULL AUTO_INCREMENT,
`town` varchar(100) NOT NULL default '');
## Deliverables
1) No program is required, just all of the data, fully validated.
## Platform
MySQL
Projekt ID: #2972948