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 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: 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, google xls, www escrow account, i want google earth, i need google earth, radius, polar, municipality, milano, longitude, latitude, italy like, execution, earth day, City Maps, database import filter

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

ID do Projeto: #161311