Populate data from Google maps places api into database

I need to fetch list of all the sports, adventure, fitness venues within a city, along with the different sports activities done by them as well as their timings, contact details, images, etc. Here are the details:

1. Create the entire code in PHP

2. Create a loop which will fire google maps location api for list of activities in our db, one activity at a time with a gap of 5 minutes (i should be able to change this duration)

3. for each activity, create another loop to get list based on different lat long and radius combination so that entire city is covered (say a 100x100 km rectange). This loop should fetch list for a different lat long after 5 mins, i should be able to change this duration. And then it will fetch for next lat long after next 5 mins till the loop is over.

4. Store details of each location in the attached tables. The maps api fetches only 20 results at a time and another 40 or 60 are available from next pages. Get me ALL locations. For each location, you may have to fire google maps places details api for detailed information.

5. store google places id so that I know if google is sending me same location or venue. Store all details in the tables I have provided. You can add more columns if needed but please use the SAME tables.

6. You will also have to fetch the images of the location and store in a structured folder on local server. The path of image should be stored in tables, some examples are attached in sql.

7. You will have to use your own google maps api key for testing.

8. Once you give me the code, I will use my google maps api key and test on my server for 2-3 activities.

9. If anything is not working on my server, you will have to help me fix it. I use ubuntu server

10. Its a short assignment. Payment will be done ONLY in end, after all above steps are completed. Please do not ask for payment before handing over code. That is against freelancer rules.

If I am not available on chat, please still send me your questions. I need this work to be completed within 2 days. If you cannot complete in 2 days, I will not make any payment and my request is, please do not bid for this project.

If you have any questions, please make sure you clarify everything before you start work. I don't like delays.

Skills: Google Maps API, Javascript, MySQL, PHP

See more: feeding xml data google maps, google maps marker locations database, google maps flash api animations, google maps post api, embed google maps website locations database, google maps java api, google maps interface api, show custom mysql data google maps, google maps pins api, google maps generator api, update data google maps, google maps pins based database, google maps marker mysql database search, api google maps search nearby database, api google maps php applications database, aspnet load data google maps database, script gps data google maps api

About the Employer:
( 21 reviews ) Navi Mumbai, India

Project ID: #21856670

5 freelancers are bidding on average ₹8080 for this job


I can start your project immediately. I can provide full-time communication and work your time-zone. If you give me a chance to serve you, I will provide a high quality product within the deadline. Best Regards

₹7000 INR in 7 days
(3 Reviews)

Hello, I have 10 years of experience in PHP, Wordpress, Codeigniter, Laravel, Python, Django, JavaScript, Shopify, Magento, OpenCart, Angular.JS, HTML, CSS. Please have a glance here on my previous work. [login to view URL] More

₹7000 INR in 7 days
(3 Reviews)

Hi, When we can talk please schedule a time? I will work till satisfaction of you and do work more perfectly and clearly. Please have a check Website designing and development work work below [login to view URL] More

₹7000 INR in 7 days
(2 Reviews)

Dear Sir. I am interested in your project. I'm senior PHP, SQL, Javascript developer. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your customers. I will More

₹7000 INR in 7 days
(0 Reviews)

- previous experience in such topics; - eager to discuss a lot in this chat stream; - degree stats / maths ;

₹12400 INR in 4 days
(0 Reviews)