Filter cities by distance +

Here is a list of all the 8102 municipalities (city, town and villages) of Italy: [url removed, login to view]

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 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. '[url removed, login to view];amp;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 [url removed, login to view] 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.

Habilidades: ASP, Processamento de dados, Perl, PHP, Administrador do Sistema

Veja mais: you proxy google, www escrow it, use escrow to import, http proxy code, gets source code, exceed database, escrow com need account, escrow block, algorithm of the day, algorithm com, cities distance, distance cities mysql, google maps distance filter, filter cities, google maps radius filter, asp distance cities script, romanian distance cities api, perl find lat lon within distance radius, perl radius, google xls, www escrow account, i want google earth, i need google earth, radius, polar

Acerca do Empregador:
( 69 comentários ) Milano, Italy

ID do Projeto: #161312

Concedido a:


Dear Project Manager, see PMB. Thanks.

$68 USD em 5 dias
(6 Comentários)

9 freelancers are bidding on average $87 for this job


I can do it for $250. If interested - let's discuss details in PM

$100 USD in 3 dias
(58 Comentários)

Can do with in a day

$100 USD em 1 dia
(34 Comentários)

Please see PM for details.

$100 USD in 7 dias
(55 Comentários)

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.

$100 USD in 7 dias
(11 Comentários)

Dear interservices! Please refer to PMB.

$70 USD in 3 dias
(8 Comentários)

Please have glance at PMB for more detail. Thanks, [url removed, login to view]

$75 USD in 3 dias
(7 Comentários)

Hi, We are eager to do your [url removed, login to view] 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 Mais

$70 USD in 5 dias
(0 Comentários)

I can complete this project on 100$.

$100 USD in 30 dias
(0 Comentários)