Design mysql database that can be ported to a website. Database will contain data extracted from an API at [url removed, login to view] Under Electricity dataset, require all Power Plant Level data to be downloaded into database. In addition, will download all US zip codes with lat/long (easy to find online or I can send excel file). Then, will create table that calculates distance between every power plant in database and every zip code. Then will create query to determine key power plant statistics based on user entry of zip code- list of all units within defined radius, % of different coal plant types, etc. This must then be ported to a demonstration website. This must be completed in the next 5-7 days.
6 freelancers are bidding on average $465 for this job
see some of the websites i have prepared : [url removed, login to view] [url removed, login to view] [url removed, login to view] and many more. I am html5 and php expert. i can start right now