I have a new website that will offer a new shopping experience target towards local search. I am trying to create a directory/database of local business' in Canada and the US. I need a professional scraper who has experience capturing this information.
I need the following information and organized in this order:
Country | State/Province | City | Category | Sub Category | Business Name | Business Address | Phone Number | Street/Unit/Block | Postal Code (zip code) | Map coordinates (longitude and latitude) | Website URL | Email address | Business Description | Up to six descriptive keywords | Up to three alternate location descriptions.
The target websites to capture this information is Yellowpages.ca (Canada) and Yellowpages.com (USA). Autotrader.ca (Canada), Autotrader.com (USA), Cars.com (USA). Realtor.ca (Canada) and Realtor.com (USA).
The Categories (as laid out by these sites) I need are:
Accessories, New and Used Dealers, Motorcycles, Motorized Vehicles, Parts and Supply, Repairs - Bodywork, Repairs - Mechanical, Trailers, Related Services, Detailing and Aesthetics
Business and Professional Services:
Administrative and Specialty Services, Consultants, Furniture and Office/Industrial Machines, Import and Export Services, Marketing and Sales, Printing/Publishing/Copying, Engineers Consulting
Computers, Communications, Electronics:
Communication Services and Equipment, Computer Equipment, Computer Services, Electronics Services and Equipment, Internet
Family and Community:
Children and Child Care, Pet Services
Finance and Legal:
Accounting Services, Banks and Financial Services, Investment Services, Loans and Credit Services, Retirement and Financial Planning, Taxes, and Legal
Barbers Beauty Salons and Spas, Skin and Scalp Services and Products
Real Estate and Insurance:
Building Management, Real Estate, Insurance
Travel and Lodging:
Construction and Renovation:
Concrete Cement and Paving, Contractor Equipment and Services, Electrical Products and Services, Floors Ceilings and Roofs, Hardware Supplies and Services, Inspectors and Surveyors, Plumbing and Piping, Chimneys, Painting and Plastering, Foundations and Piling, Heavy Construction and Equipment
Home and Garden:
Appliances, Cabinets Racks and Organizers, Cleaning Supplies and Services, Cooling and Ventilating, Doors, Furniture, Garden and Lawn, General Supplies and Services, Heating, Interior Decorating, Kitchen and Bath Supplies and Services, Lighting, Moving and Storage, Outdoor Accessories and Equipment, Outdoor Services, Painting Floor and Wall Coverings, Safety and Security, Windows, Pest Control, Bedrooms and Linens
I expect there to be several 1,000,000+ records. If possible I would like them in mysql, if not in csv, or both. The data must be accurate and run through a deduplication software to weed out duplicate records. This Job is large and could be ongoing with the right person. Must speak english and must be an expert in this field. The job doesn't have to start immediately and can be set up to be convenient for both parties.
When submitting a bid please indicate whether its for Canada, USA, or Both.