Website Spidering/Harvesting
$100-400 USD
Pago na entrega
[url removed, login to view] is a network of local entertainment sites providing events & business listings for all top UK cities - currently approx 50 locations however expanding to cover all UK cities, towns and even villages within 4 months.
We are constantly looking to improve the quality of our data and require certain websites to be "compared" with ours. Their venue data should be compared to ours, and any necessary updates to our database recorded.
Excel spreadsheets resources will be provided to the winning bidder on request.
## Deliverables
3 txt files should be delivered:
1. **[url removed, login to view]** ??" File containing all the update statements for venues. This file will be run against the database to update myvillage data.
2. **[url removed, login to view]** ??" File containing all the insert statements from new venues. This file will be run against the database to insert new venues into our database.
3. **[url removed, login to view]** ??" File containing all the update statements to update the content_type and content_sub_type columns for newly inserted venues. This file will be run against the database.
## Platform
Standard PostgresSQL compatible SQL.
ID do Projeto: #3207609