Find Jobs
Hire Freelancers

php script to convert csv of suburb data to maps plot

$10-30 AUD

Completed
Posted almost 4 years ago

$10-30 AUD

Paid on delivery
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!
Project ID: 25593567

About the project

2 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 parser, and loading all of the information into Google Maps, and I can certainly write it in a way that will be easy to run as an automated script.
$16 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
2 freelancers are bidding on average $18 AUD for this job
User Avatar
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 development with lots of CMS such as wordpress. I think I can do this job for you in a short time, perfectly. And i can start work now. Looking forward to connecting to discuss. Thanks.
$20 AUD in 7 days
5.0 (5 reviews)
4.3
4.3

About the client

Flag of AUSTRALIA
Yagoona, Australia
5.0
91
Payment method verified
Member since May 24, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.