GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Filter cities by distance +

   Click here to post similar project

Filter cities by distance + is project number 161312 posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed (Selected Service Provider)
Selected Providers: selected service provider entwood
Budget: $30-100
Created: 07/22/2007 at 13:20 EDT
Bidding Ends: 08/03/2007 at 13:20 EDT
Project Creator: interservices View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(19 reviews)
Description: Here is a list of all the 8102 municipalities (city, town and villages) of Italy: http://www.istat.it/strumenti/definizioni/comuni/elenco_comuni_italiani_1_gen_2007.xls

I need these three things:

1) I need a script or program, in whatever language you want, that gets their latitude/longitude from Google Maps

Note1: Google queries must be done in http://maps.google.it. You can grab latitude and longitude from the URL of the link named 'Collegamento a questa pagina' on the bottom-right of the page.
Note2: be aware that Google has a block after (I think but I'm not sure of the number) 5000 subsequent queries from the same IP. You will need to wait a day (?) or to use a proxy for the remaining queries.

2) then I need you to upload the 8102 municipalities names and their latitude/longitude in my MySQL database

Note: I can import your Utf-8 SQL file to do this.

3) then I need you to put on my webserver a PHP or Perl or ASP program that, given a municipality and a radius in KM as parameters (e.g. 'script.php?municipality=Milano&radius=15'), returns a list with all the municipalities that are within this radius including the given municipality.

Note1: to obtain the distances between the returned municipalities given the latitude/longitude you must use an algorithm like http://www.freevbcode.com/ShowCode.asp?ID=1793 or another that takes into account the actual polar flattening of the earth and the equatorial bulge...
Note2: the execution time, given a radius of 100 KM, must not exceed 0.2 seconds, therefore you will need to calculate the distances in two steps: the first step will use a very simple and fast but unprecise algorithm to exclude the most of the municipalities, that that are clearly more far that the given radius; the second step will use the slower but more precise algorithm described in Note1 to accurately decide if the remaining municipalities are within the given radius.

_____

Full source code and ownership required. Escrow offered.
Report violation
Job Type:
  • ASP
  • Data Processing
  • Perl/CGI
  • PHP
  • System Admin.
Database: MySQL
Operating system: (None)
Bid count: 9
Average bid: $ 87

 

Related project
 
Nonpublic project #315600 Featured Nonpublic
login to view
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 2

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
wasimsohail
View PM Post PM
$ 100 7 days 07-22-2007 14:56 EDT 9.83/109.83/109.83/109.83/109.83/109.83/109.83/109.83/109.83/109.83/10
(94 reviews)
Please see PM for details.
e3d
View PM Post PM
$ 100 3 days 07-22-2007 13:56 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(55 reviews)
I can do it for $250. If interested - let's discuss details in PM
hsoft
View PM Post PM
$ 100 1 day 07-23-2007 00:19 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(20 reviews)
Can do with in a day
ConquerInfoTech
View PM Post PM
$ 75 3 days 07-22-2007 14:14 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(17 reviews)
Please have glance at PMB for more detail. Thanks, ConquerInfoTech.Com
johnsinit
View PM Post PM
$ 70 3 days 07-22-2007 17:46 EDT 9.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/10
(9 reviews)
Dear interservices! Please refer to PMB.
entwood
View PM Post PM
$ 68 5 days 07-27-2007 15:53 EDT 9.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/10
(7 reviews)
Dear Project Manager, see PMB. Thanks.
frankouz
View PM Post PM
$ 100 7 days 07-26-2007 17:36 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(3 reviews)
Please see PM for details. I have good knowledge of PHP, MySql. I have no problem using Geocoder from Google Map API to do what you need.
sandiphgt
View PM Post PM
$ 70 5 days 07-22-2007 17:23 EDT (No Feedback Yet)
Hi, We are eager to do your project.We have team having more than 4 years of experience in php/mysql .They are expert in AJAX technique. We have experienced of binding google map with sites. We can do your task easily. Please contact me through PMB ,if you have any doubt or query . Thanks Sandy
prakashru
View PM Post PM
$ 100 30 days 07-22-2007 14:22 EDT (No Feedback Yet)
I can complete this project on 100$.
Bid on This Project

 

[ EU Freelance ] [ Join GAF Free ] [ Secure Forms ]

What is GetAFreelancer.com? ( Read about the company )

Web Development doesn't have to be expensive. Outsourcing will cut your expenses by more than 50%. We have thousands of satisfied clients around the world. Would you like to outsource your next project? Would you like to make money as a freelancer? Click Sign Up to start!

Buy services with help from our secure escrow system. Bookmark our homepage to make sure you don't forget about our website next time you need to develop an IT project for yourself or your company. Companies of any size have used our web services.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.