GeodesiX is an addin for Microsoft Excel which allows you to display maps, perform forward and reverse geocoding, compute distances (Great Circle, driving, bicycling and walking) and verify your results in Google Maps, all within Excel. Features Multi-place display dynamically creates maps with any number of items, each with its own custom icon and popup menu Show on Map context menu displays the place or route with GoogleMaps in an Excel Task Pane Office-finder shows the nearest items to a location on the map. Relative distances are highlighted by line thickness Heatmap uses KML files to colour areas according to cell values. KML for all the world’s countries are builtin.
Overlays Overview Overlays are objects on the map that are tied to latitude/longitude coordinates, so they move when you drag or zoom the map. Overlays reflect objects that you "add" to the map to designate points, lines, areas, or collections of objects.
Our download server Our download server at http://download.geofabrik.de has excerpts and derived data from the OpenStreetMap dataset available for free download. Most of these files are updated every day – any change you upload to OpenStreetMap should be on our download server the next day. Geographic Regions Data on the download server is organised by region.
Country level Download country level data for any country in the world: administrative boundaries, roads, railroads, altitude, land cover, population density. Global level A new file with the (2011) global country boundaries Global climate data
Welcome to the CloudMade downloads site. This is where you can find extracts of maps from different places around the world. From here you can download:
Données de départ: - table1 (id,nom,geometry) - table2 (id,nom,geometry) + Index Spatial R*Tree Objectif: Pour chaque objet de la table1 , determiner la distance de l'objet le plus proche dans la table2 (dans la limite de 1Km, soit 1000m) Contrainte: De manière intuitive, la solution serait toute simple: SELECT table1.nom as nom1, table2.nom as nom2, min(st_distance(table1.geometry,table2.geometry)) as distance FROM table 1 JOIN table2 ON ( ....dist...) GROUP BY 1