I have a latitude, and longitude : `&quot;-27.0000,133.0000&quot;`. I want produce a map base on that. 

I&#39;ve tried go to this link 

`https://maps.googleapis.com/maps/api/geocode/json?latlng=-27.0000,133.0000&amp;key=******`

I keep getting this error on the browser 

    {
       &quot;error_message&quot; : &quot;This API project is not authorized to use this API. Please ensure that this API is activated in the APIs Console: Learn more: https://code.google.com/apis/console&quot;,
       &quot;results&quot; : [],
       &quot;status&quot; : &quot;REQUEST_DENIED&quot;
    }

But I think I already enable that API. I log-in to my Google Console, and double check.

When I go to : `https://console.developers.google.com/project/75423435770063/apiui/apis/enabled`

I see :

**Geocoding + Geolocating is enable.**


[![enter image description here][1]][1]
 

I&#39;m a little stuck now. Is there anything that I missed here? 

  [1]: http://i.stack.imgur.com/Ytgql.png

This API project is not authorized to use this API. Please ensure that this API is activated in the APIs Console

I&#39;m trying to program geocoding. I created API key, but when I add it into my website code I don&#39;t get anything, however when I don&#39;t use API everything works well.  When I&#39;m sending:

    https://maps.googleapis.com/maps/api/geocode/json?address=&quot;.$adres.&quot;&amp;key=KLUCZ_XXX
    
I get a response:

    Browser API keys cannot have referer restrictions when used with this API.
    
If I use:

    https://maps.googleapis.com/maps/api/geocode/json?address=&quot;.$adres&quot; 
    
The result is correct but the number of queries is limited per day.

Key constraint: referrals HTTP (Web) - set to the domain from which conjure inquiry. Interface Google Maps Geocoding API is turned on.

Does the API key has to be activated also somewhere else to work?


API key Browser API keys cannot have referer restrictions when used with this API

I lost track of this effort years ago but have need to geocode thousands of addresses nightly. I must use the very accurate database sitting on the machine, installed when the Nuvi map update installed Mapsource.

When I contacted Garmin years ago, they expressed an interest in providing an API for this, but then I heard nothing and did not follow up. Their database is provided by navtec? I believe. Anyone have experience with that format?

I posted on the Garmin Developer forum a while ago, but its a little lethargic over there :)

Has anyone done this?
Does anyone know how it might be done without an API; meaning database structure and calls?

I&#39;ll take a solution in any language.

___
Added:

Garmin has expressed an interest in making this available to me. They just have not done it. 

I do not know the database format.

I am NOT looking for an online solution or any other &quot;alternative&quot;. This question is very specific.

Batch Geocoding with Garmin Mapsource

I tried implementing this formula: http://andrew.hedges.name/experiments/haversine/
The aplet does good for the two points I am testing:

![enter image description here][1]

Yet my code is not working.

    from math import sin, cos, sqrt, atan2

    R = 6373.0

    lat1 = 52.2296756
    lon1 = 21.0122287
    lat2 = 52.406374
    lon2 = 16.9251681

    dlon = lon2 - lon1
    dlat = lat2 - lat1
    a = (sin(dlat/2))**2 + cos(lat1) * cos(lat2) * (sin(dlon/2))**2
    c = 2 * atan2(sqrt(a), sqrt(1-a))
    distance = R * c

    print &quot;Result&quot;, distance
    print &quot;Should be&quot;, 278.546

The distance it returns is **5447.05546147**. Why?

  [1]: http://i.stack.imgur.com/FGED4.png

Getting distance between two points based on latitude/longitude

Hi I have the need to calculate the distance between two points having the lat and long.

I would like to avoid any call to external API.

I tried to implement the Haversine Formula in PHP:

Here is the code:

    class CoordDistance
     {
        public $lat_a = 0;
        public $lon_a = 0;
        public $lat_b = 0;
        public $lon_b = 0;
        
        public $measure_unit = &#39;kilometers&#39;;
        
        public $measure_state = false;
        
        public $measure = 0;
        
        public $error = &#39;&#39;;
        
        
        
        public function DistAB()
        
          {
              $delta_lat = $this-&gt;lat_b - $this-&gt;lat_a ;
              $delta_lon = $this-&gt;lon_b - $this-&gt;lon_a ;
              
              $earth_radius = 6372.795477598;
              
              $alpha    = $delta_lat/2;
              $beta     = $delta_lon/2;
              $a        = sin(deg2rad($alpha)) * sin(deg2rad($alpha)) + cos(deg2rad($this-&gt;lat_a)) * cos(deg2rad($this-&gt;lat_b)) * sin(deg2rad($beta)) * sin(deg2rad($beta)) ;
              $c        = asin(min(1, sqrt($a)));
              $distance = 2*$earth_radius * $c;
              $distance = round($distance, 4);
              
              $this-&gt;measure = $distance;
              
          }
        }

Testing it with some given points which have public distances I don&#39;t get a reliable result.

I don&#39;t understand if there is an error in the original formula or in my implementation 

Measuring the distance between two coordinates in PHP

I&#39;m calculating the distance between two GeoCoordinates. I&#39;m testing my app against 3-4 other apps. When I&#39;m calculating distance, I tend to get an average of 3.3 miles for my calculation whereas other apps are getting 3.5 miles. It&#39;s a big difference for the calculation I&#39;m trying to perform. Are there any good class libraries out there for calculating distance? I&#39;m calculating it like this in C#:

    public static double Calculate(double sLatitude,double sLongitude, double eLatitude, 
                                   double eLongitude)
    {
        var radiansOverDegrees = (Math.PI / 180.0);

        var sLatitudeRadians = sLatitude * radiansOverDegrees;
        var sLongitudeRadians = sLongitude * radiansOverDegrees;
        var eLatitudeRadians = eLatitude * radiansOverDegrees;
        var eLongitudeRadians = eLongitude * radiansOverDegrees;

        var dLongitude = eLongitudeRadians - sLongitudeRadians;
        var dLatitude = eLatitudeRadians - sLatitudeRadians;

        var result1 = Math.Pow(Math.Sin(dLatitude / 2.0), 2.0) + 
                      Math.Cos(sLatitudeRadians) * Math.Cos(eLatitudeRadians) * 
                      Math.Pow(Math.Sin(dLongitude / 2.0), 2.0);

        // Using 3956 as the number of miles around the earth
        var result2 = 3956.0 * 2.0 * 
                      Math.Atan2(Math.Sqrt(result1), Math.Sqrt(1.0 - result1));

        return result2;
    }

What could I be doing wrong? Should I calculate it in km first and then convert to miles?

Calculating Distance between two Latitude and Longitude GeoCoordinates

For example if we have these set of coordinates

    &quot;latitude&quot;: 48.858844300000001,
    &quot;longitude&quot;: 2.2943506,

How can we find out the city/country?

Given the lat/long coordinates, how can we find out the city/country?

I need a list of countries, states &amp; cities based on a collection of lat/long values I have. I need to store this information in a manner that hierarchy is preserve and without duplicates (e.g. &quot;USA&quot; and &quot;United States&quot; and &quot;United States of America&quot; are the same country; I only want one instance of this country in my database).

Is this possible to do with Google Map API?

Google Maps: how to get country, state/province/region, city given a lat/long value?

I have given a location defined by latitude and longitude.
Now i want to calculate a bounding box within e.g. 10 kilometers of that point.

The bounding box should be defined as latmin, lngmin and latmax, lngmax.

I need this stuff in order to use the [panoramio API][1].

Does someone know the formula of how to get thos points?

**Edit:** Guys i am looking for a formula/function which takes lat &amp; lng as input and returns a bounding box as latmin &amp; lngmin and latmax &amp; latmin.
Mysql, php, c#, javascript is fine but also pseudocode should be okay.

**Edit:** I am not looking for a solution which shows me the distance of 2 points


  [1]: http://www.panoramio.com/api/

How to calculate the bounding box for a given lat/lng location?

Is there a way to get a city name from a latitude and longitude point using the google maps api for javascript?

If so could I please see an example?

How can I get city name from a latitude and longitude point?

I am redesigning a customer database and one of the new pieces of information I would like to store along with the standard address fields (Street, City, etc.) is the geographic location of the address.  The only use case I have in mind is to allow users to map the coordinates on Google maps when the address cannot otherwise be found, which often happens when the area is newly developed, or is in a remote/rural location.

My first inclination was to store latitude and longitude as decimal values, but then I remembered that SQL Server 2008 R2 has a `geography` data type.  I have absolutely no experience using `geography`, and from my initial research, it looks to be overkill for my scenario.

For example, to work with latitude and longitude stored as `decimal(7,4)`, I can do this:

    insert into Geotest(Latitude, Longitude) values (47.6475, -122.1393)
    select Latitude, Longitude from Geotest

but with `geography`, I would do this:


    insert into Geotest(Geolocation) values (geography::Point(47.6475, -122.1393, 4326))
    select Geolocation.Lat, Geolocation.Long from Geotest

Although it&#39;s not *that* much more complicated, why add complexity if I don&#39;t have to?

Before I abandon the idea of using `geography`, is there anything I should consider?  Would it be faster to search for a location using a spatial index vs. indexing the Latitude and Longitude fields?  Are there advantages to using `geography` that I am not aware of?  Or, on the flip side, are there caveats that I should know about which would discourage me from using `geography`?

---

Update
----------

@Erik Philips brought up the ability to do proximity searches with `geography`, which is very cool.  

On the other hand, a quick test is showing that a simple `select` to get the latitude and longitude is significantly slower when using `geography` (details below).  , and a comment on the [accepted answer][1] to another SO question on `geography` has me leery:

&gt; @SaphuA You&#39;re welcome. As a sidenote be VERY carefull of using a
&gt; spatial index on a nullable GEOGRAPHY datatype column. There are some
&gt; serious performance issue, so make that GEOGRAPHY column non-nullable
&gt; even if you have to remodel your schema. – Tomas Jun 18 at 11:18

All in all, weighing the likelihood of doing proximity searches vs. the trade-off in performance and complexity, I&#39;ve decided to forgo the use of `geography` in this case.

---

Details of the test I ran:

I created two tables, one using `geography` and another using `decimal(9,6)` for latitude and longitude:

    CREATE TABLE [dbo].[GeographyTest]
    (
    	[RowId] [int] IDENTITY(1,1) NOT NULL,
    	[Location] [geography] NOT NULL,
    	CONSTRAINT [PK_GeographyTest] PRIMARY KEY CLUSTERED ( [RowId] ASC )
    ) 
    
    CREATE TABLE [dbo].[LatLongTest]
    (
    	[RowId] [int] IDENTITY(1,1) NOT NULL,
    	[Latitude] [decimal](9, 6) NULL,
    	[Longitude] [decimal](9, 6) NULL,
    	CONSTRAINT [PK_LatLongTest] PRIMARY KEY CLUSTERED ([RowId] ASC)
    ) 

and inserted a single row using the same latitude and longitude values into each table:

    insert into GeographyTest(Location) values (geography::Point(47.6475, -122.1393, 4326))
    insert into LatLongTest(Latitude, Longitude) values (47.6475, -122.1393)

Finally, running the following code shows that, on my machine, selecting the latitude and longitude is approximately 5 times slower when using `geography`.

    declare @lat float, @long float,
    		@d datetime2, @repCount int, @trialCount int, 
    		@geographyDuration int, @latlongDuration int,
    		@trials int = 3, @reps int = 100000
    
    create table #results 
    (
    	GeographyDuration int,
    	LatLongDuration int
    )
    
    set @trialCount = 0
    
    while @trialCount &lt; @trials
    begin
    
    	set @repCount = 0
    	set @d = sysdatetime()
    
    	while @repCount &lt; @reps
    	begin
    		select @lat = Location.Lat,  @long = Location.Long from GeographyTest where RowId = 1
    		set @repCount = @repCount + 1
    	end
    
    	set @geographyDuration = datediff(ms, @d, sysdatetime())
    
    	set @repCount = 0
    	set @d = sysdatetime()
    
    	while @repCount &lt; @reps
    	begin
    		select @lat = Latitude,  @long = Longitude from LatLongTest where RowId = 1
    		set @repCount = @repCount + 1
    	end
    
    	set @latlongDuration = datediff(ms, @d, sysdatetime())
    
    	insert into #results values(@geographyDuration, @latlongDuration)
    
    	set @trialCount = @trialCount + 1
    
    end
    
    select * 
    from #results
    
    select avg(GeographyDuration) as AvgGeographyDuration, avg(LatLongDuration) as AvgLatLongDuration
    from #results
    
    drop table #results

Results:

    GeographyDuration LatLongDuration
    ----------------- ---------------
    5146              1020
    5143              1016
    5169              1030
    
    AvgGeographyDuration AvgLatLongDuration
    -------------------- ------------------
    5152                 1022

What was more surprising is that even when no rows are selected, for example selecting where `RowId = 2`, which doesn&#39;t exist, `geography` was still slower:

    GeographyDuration LatLongDuration
    ----------------- ---------------
    1607              948
    1610              946
    1607              947
    
    AvgGeographyDuration AvgLatLongDuration
    -------------------- ------------------
    1608                 947

  [1]: https://stackoverflow.com/questions/6386577/sql-server-2008-r2-geography-distance/6387558#6387558





Why use the SQL Server 2008 geography data type?

Using the Google Geocoder v3, if I try to geocode 20 addresses, I get an OVER_QUERY_LIMIT unless I time them to be ~1 second apart, but then it takes 20 seconds before my markers are all placed.

Is there any other way to do it, other than storing the coordinates in advance?

How do I Geocode 20 addresses without receiving an OVER_QUERY_LIMIT response?

Is there any library (or even better, web service) available which can convert from a latitude/longitude into a time zone?

Timezone lookup from latitude longitude

I know the browser shares my IP address and details of nearby wireless networks to determine my location, but what sort of info does it know about nearby wifi networks?

For example, where I live are no public wireless networks, and from my home I can see about 5 private networks, yet my location is determined within 20 meters. With there being no open networks nearby, how does Google determine my location? The only way I can think of is that Google mapped the locations of all wireless networks when they mapped streets for Street View.

I&#39;ve searched about online, but all I can&#39;t find any specific details.

How, exactly does HTML5&#39;s GeoLocation work?

I am wanting to find the distance between two different points. This I know can be accomplished with the great circle distance.
&lt;http://www.meridianworlddata.com/Distance-calculation.asp&gt;

Once done, with a point and distance I would like to find the point that distance north, and that distance east in order to create a box around the point.


How can I measure distance and create a bounding box based on two latitude+longitude points in Java?

Supposedly, it is possible to get this from Google Maps or some such service. (US addresses only is not good enough.)

How to obtain longitude and latitude for a street address programmatically (and legally)

How would I go about converting an address or city to a latitude/longitude? Are there commercial outfits I can &quot;rent&quot; this service from? This would be used in a commercial desktop application on a Windows PC with fulltime internet access.


How to convert an address to a latitude/longitude?

**EDIT: I have been using Postgres with PostGIS for a few months now, and I am satisfied.**

I need to analyze a few million geocoded records, each of which will have latitude and longitude. These records include data of at least three different types, and I will be trying to see if each set influences the other.

What database is best for the underlying data store for all this data? Here&#39;s my desires:

 - **I&#39;m familiar with the DBMS.** I&#39;m weakest with PostgreSQL, but I am willing to learn if everything else checks out.
 - **It does well with GIS queries.** Google searches suggest that PostgreSQL + PostGIS may be the strongest? At least a lot of products seem to use it. MySql&#39;s Spatial Extensions seem comparatively minimal?
 - **Low cost.** Despite the 10GB DB limit in SQL Server Express 2008 R2, I&#39;m not sure I want to live with this and other limitations of the free version.
 - **Not antagonistic with Microsoft .NET Framework.** Thanks to Connector/Net 6.3.4, MySql works well C# and .NET Framework 4 programs. It fully supports .NET 4&#39;s Entity Framework. I cannot find any noncommercial PostgreSQL equivalent, although I&#39;m not opposed to paying $180 for Devart&#39;s dotConnect for PostgreSQL Professional Edition.
 - **Compatible with R.** It appears all 3 of these can talk with R using ODBC, so may not be an issue.

I&#39;ve already done some development using MySql, but I can change if necessary.

GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server?

When storing latitude or longitude data in an ANSI SQL compliant database, what datatype would be most appropriate? Should `float` be used, or `decimal`, or ...?

I&#39;m aware that Oracle, MySql, and SQL Server have added some special datatypes specifically for handling geo data, but I&#39;m interested in how you would store the information in a &quot;plain vanilla&quot; SQL database.

What datatype to use when storing latitude and longitude data in SQL databases?

I am new to Elasticsearch and am currently working on implementing a `geo_distance` filter for searching. As of now my index has the following mapping (I&#39;ve removed some fields):

    {
    advert_index: {
       mappings: {
          advert_type: {
             properties: {
                __v: {
                   type: &quot;long&quot;
                },
                caption: {
                   type: &quot;string&quot;
                },
                category: {
                   type: &quot;string&quot;
                },
                **location: {
                type: &quot;long&quot;
                },**
  
             }
          }
       }
    }

The geo_distance field is going to be implemented on the location field, where an example instance looks like this: 

    &quot;location&quot;: [
                   71,
                   60
                ],
I.e. is on geoJSON format `[lon, lat]`. 

I understand that I will have to update my index so that the location field is of type `geo_point`, as described in the documentation (&lt;a href=&quot;http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-geo-point-type.html&quot;&gt;mapping-geo-point&lt;/a&gt;). It seems like I have to drop the index and create a new one, but I am not able to do this. 

Am I on the right track? I would greatly appreciate it if anyone could help me with how I could create a new index or update my existing one with the correct data type. 

Many thanks!

All Geocoding Solutions on Gang of Coders

Total of 20 Geocoding Solutions