Completed

php script to convert csv of suburb data to maps plot

I'm looking for someone to do the followint things using php preferably so I can run this on my server automatically and daily.

Here is what's required:

- Pull this csv data from this URL : [login to view URL]

- For any row with an empty lga_name19, use the postcode column to perform a lookup of the suburb

- Delete the columns lhd_2010_code, lhd_2010_name, lga_code19

- Create a new column to replace lga_name19 with latitude and longitude

- Randomly offset the latitude + longitude for each line by a few meters (this is to help reduce the number of points exactly in the same spot on the map, feel free to do this in any way you like, this is just a suggested method) - Another method could be to simply count the total number of rows for a suburb and use that number on the plot)

- Plot onto a Google map and zoom into NSW, Australia

- Present this as a html page with a html dropdown that allows users to select the last 7,14,30,60 days or "all" days

I would like to be able to run this script via cron daily so please make it executable or , whatever, and make it output to a html file that overwrites, or... whatever :)

Now, I know there are lots of bots on here so to be sure you're actually human and paying attention, please make sure the very first word of your response to this project is the word 'isolation'.

I imagine this should be a fairly small project so please don't go crazy with your bids. I'm sure I'll have more work for you in the coming weeks.

Good luck!

Skills: PHP, Google Maps API, JavaScript, MySQL

See more: plot addresses on google map from excel, freelancer search, google map data visualization, freelance tech jobs, freelancer id, map data free, freelance tasks, freelancer jobs, php script convert pdf web page, php script convert octal ascii, php script convert csv tab delimited, php script upload csv file mysql, perl script insert csv file data mysql, php script convert html csv, php script convert csv rss, php script convert text file csv, kml script convert csv data, php script convert csv file, php script convert csv files xml, php script convert xml file csv

About the Employer:
( 91 reviews ) Yagoona, Australia

Project ID: #25593567

Awarded to:

SebastianK15

Isolation! I love working with PHP, and I have a lot of experience using Google Maps and Google Places API, this project looks like it should be a breeze as I know exactly how I would implement each part of the CSV par More

$16 AUD in 2 days
(0 Reviews)
0.0

2 freelancers are bidding on average $18 for this job

CloudAdvisory

isolation Hi, client. Your posting is very interesting for me. I'm a talent web developer with PHP, HTML5, MySQL, JQuery and several frameworks like Laravel,Node.js etc. And I have a enough experience in web design and More

$20 AUD in 7 days
(5 Reviews)
4.3