Closed

php script to convert csv of suburb data to maps plots

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: Google Maps API, JavaScript, MySQL, PHP

See more: plot addresses on google map from excel, map data google, can i plot multiple addresses on google maps, google maps import csv, google map data visualization, create map from excel data free, map data free, how to create a google map with excel data, 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:
( 92 reviews ) Yagoona, Australia

Project ID: #25594040

20 freelancers are bidding on average $168 for this job

mantislin

isolation Hi sir, I just checked and did example google map html page, please check here [login to view URL] Let me know if you have any questions. Thanks, Lin

$220 AUD in 3 days
(324 Reviews)
7.6
BaNgan

Hi isolation I see you are in need of a cron job php script to generate and override a html file on daily basis, pls send the csv file to check Thanks Ngan Le

$180 AUD in 2 days
(409 Reviews)
7.6
zeke

Dear Customer! I am an expert PHP developer with over 14 years of experience. Very interested to work on your project. My bid is for top quality work. Available to start immediately and finish as soon as possible. Plea More

$100 AUD in 5 days
(198 Reviews)
7.5
BZain

Expert in Google Maps API and can handle this PHP Script very well with all what required Inbox and let's talk further to get started - thank you!

$250 AUD in 5 days
(52 Reviews)
6.4
wpmonsters

Hello, We are a team of 30+ PHP developers. Having the required skills & experience we feel highly enthusiastic about the opportunity to work on your project. We can do all the things you've described. We have a pr More

$250 AUD in 2 days
(24 Reviews)
5.5
webdesignexpert1

Hi,I will fix bug in your php site.I have extensive experience in photoshop,illustrator,psd to html,HTML, HTML5, XHTML, CSS3, JQuery, JavaScript, Angular Javascript, Bootstrap, AJAX and PHP. Can you discuss on freel More

$200 AUD in 7 days
(22 Reviews)
5.7
Raf3Ddev

isolation. Dear, client. I 'm very skilled and experience in JavaScript, PHP, Google Maps API. I can complete your script perfectly. I want to meet you and go to contract. Thanks.

$250 AUD in 7 days
(12 Reviews)
5.1
lxitservices1

“I CAN DO” Hi there, Greetings!! We have read your project requirements and we have understood that you want to Some customization work on a running php script site I have extensive experience in photoshop,illustrato More

$80 AUD in 3 days
(30 Reviews)
5.5
nizamfarhas

Hi Your requirements: "php script to convert csv of suburb data to maps plots" I'm a senior PHP developer with 9 years of experience and I'm very familiar with API integration. As you will see in my profile all of my More

$130 AUD in 2 days
(8 Reviews)
4.3
aleoreina

Hello, I would like to you confirm me your points. Then, I can investigate what 's more easy way with perfomace for you. Just ping me .. i want know what is about your poll. My offer is that i did really submit . Than More

$250 AUD in 15 days
(10 Reviews)
4.0
d1master

Dear, I am well versed in Web DEV. And I am familiar with PHP/Javascript/Google Maps API/MYSQL I understand your main goal correctly and I can start work right now. I hope to discuss more details via chat before gettin More

$140 AUD in 2 days
(8 Reviews)
4.0
zzack

Hi there. I am James, an expert in website development using PHP. Just checked the scope of your work. Please let us discuss more detail through chat. Thanks. James.

$100 AUD in 1 day
(3 Reviews)
3.1
nguyentamcit

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [login to view URL] More

$200 AUD in 7 days
(2 Reviews)
2.6
elmasterlow

isolation hi. I am interested in. I understand that one part of your needs is to reverse lookup for latitutes and longitudes, right? Do you have sql db to save results or do you want to do it another way? greetings

$180 AUD in 7 days
(2 Reviews)
2.0
alifiharafi

isolation Hi, I understand your requirements. I just want to make sure about replacing "lga_name19" column with "latitude and longitude" values. Do you need to create random points inside polygon area or around the poi More

$70 AUD in 3 days
(1 Review)
0.8
Byrdin97

⭐⭐Hello⭐⭐⭐. I am a professional ---“ PHP& Google maps expert”--- with rich experience with CI,Laravel,CSS,HTML,JavaScript framework for 8+years. I have full-time now . I am sure that Site I made will satisfy your req More

$140 AUD in 7 days
(3 Reviews)
0.6
michalm010

Hi Dear, I am glad to bid on your project. Here is a PHP and javascript frameworks developer. I have read your description and I can help you in developing website as responsive, modern and simplistic design style as More

$140 AUD in 3 days
(0 Reviews)
0.0
davidebrioz

Hello, I am web mapping developer and have rich experience with Google Maps API. Please let me know when you are available. Best Regards, Davide

$250 AUD in 7 days
(0 Reviews)
0.0
vinodkmr5220

hello sir/ma'am As a highly skilled full stack developer i have rich experience in java,c,c++,c#python, arduino ,[login to view URL],word press,and android i m very confident with my skill and i'd like to help your busin More

$30 AUD in 7 days
(0 Reviews)
0.0
jaspune

isolation - Hello There, Having over 20 years of experience in Geo Spatial Technology, and purely working in GIS development. I can be a good help for your requirement. It seems easy and quick task but believe me there More

$200 AUD in 15 days
(0 Reviews)
0.0