Script to find Longitude and Latitude
- or -
Post a project like this2870
$80
- Posted:
- Proposals: 1
- Remote
- #1159457
- PRE-FUNDED
- Awarded
Description
Experience Level: Intermediate
General information for the business: Furniture Directory
Description of requirements/functionality: I am creating a local furniture retailer directory. A directory is a book that lists organizations categorized by themes with addresses and phone numbers. For example, https://nursinghomedirectory.com/michigan/grand-rapids is a directory of retirement homes in Grand Rapids, MI.
A sample of my directory can be viewed here http://bestliftchair.net/louisville-ky-lift-chair-recliners-buy-used-and-new/
We currently have pages written but do not have maps. We need someone to: 1.) find the longitude and latitude of addresses 2.) find the longitude and latitude of city centers 3.) calculate the distance between an address and city centers 4.) if the address is within 25 miles of a city center, note the city(s) in the spreadsheet.
Your job is to create a script that does that and return to me the edited .CSV. I will then upload the .CSV to the backend so that maps can be added to the directory.
Here are the files for this job:
https://www.dropbox.com/sh/nsjqw2slp4fa3u8/AABOOt4Hk_GcMt8nqReefmTma?dl=0 - A folder containing 7 spreadsheets. These are the business names, addresses, and phone numbers.
https://www.dropbox.com/s/ud8z7suczc1ngsf/cities.txt?dl=0 - This is a list of 704 cities
The CSV you are to hand to me needs these columns as they are what the map plugin requires:
A. BusinessName - the name of the business.
B. Address - the address the plugin should display on the front-end.
C. Latitude - the latitude of the address.
D. Longitude - the longitude of the address.
E. PhoneNumber - the phone number of the business.
F. Section - which cities the address is within 25 miles of. For this section, separate each city with a comma (ie "New York NY, Hoboken NJ, West Point NY").
The 7 spreadsheets have not been merged and duplicates have not been removed. You will need to do that. When removing duplicates, remove listings by address and not name or phone number -- some businesses have multiple address but the same phone number and name.
Extra notes: http://www.digital-geography.com/geocoding-addresses-directly-in-libreoffice-calc/ is how to get the longitude or latitude with Google Maps API or OpenStreetMaps. OSM has a limit of 1 request per second and Google Maps has a limit of 4,000 address per call.
http://stackoverflow.com/questions/10053358/measuring-the-distance-between-two-coordinates-in-php is how to triangulate the distance between two points on the globe.
Description of requirements/functionality: I am creating a local furniture retailer directory. A directory is a book that lists organizations categorized by themes with addresses and phone numbers. For example, https://nursinghomedirectory.com/michigan/grand-rapids is a directory of retirement homes in Grand Rapids, MI.
A sample of my directory can be viewed here http://bestliftchair.net/louisville-ky-lift-chair-recliners-buy-used-and-new/
We currently have pages written but do not have maps. We need someone to: 1.) find the longitude and latitude of addresses 2.) find the longitude and latitude of city centers 3.) calculate the distance between an address and city centers 4.) if the address is within 25 miles of a city center, note the city(s) in the spreadsheet.
Your job is to create a script that does that and return to me the edited .CSV. I will then upload the .CSV to the backend so that maps can be added to the directory.
Here are the files for this job:
https://www.dropbox.com/sh/nsjqw2slp4fa3u8/AABOOt4Hk_GcMt8nqReefmTma?dl=0 - A folder containing 7 spreadsheets. These are the business names, addresses, and phone numbers.
https://www.dropbox.com/s/ud8z7suczc1ngsf/cities.txt?dl=0 - This is a list of 704 cities
The CSV you are to hand to me needs these columns as they are what the map plugin requires:
A. BusinessName - the name of the business.
B. Address - the address the plugin should display on the front-end.
C. Latitude - the latitude of the address.
D. Longitude - the longitude of the address.
E. PhoneNumber - the phone number of the business.
F. Section - which cities the address is within 25 miles of. For this section, separate each city with a comma (ie "New York NY, Hoboken NJ, West Point NY").
The 7 spreadsheets have not been merged and duplicates have not been removed. You will need to do that. When removing duplicates, remove listings by address and not name or phone number -- some businesses have multiple address but the same phone number and name.
Extra notes: http://www.digital-geography.com/geocoding-addresses-directly-in-libreoffice-calc/ is how to get the longitude or latitude with Google Maps API or OpenStreetMaps. OSM has a limit of 1 request per second and Google Maps has a limit of 4,000 address per call.
http://stackoverflow.com/questions/10053358/measuring-the-distance-between-two-coordinates-in-php is how to triangulate the distance between two points on the globe.
HUY H.
100% (3)Projects Completed
4
Freelancers worked with
3
Projects awarded
20%
Last project
1 May 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies