We have a restaurant table that has lat-long data for each row.
We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc.
We have the following query for this purpose:
***Parameters***
Longitude: -74.008680
Latitude: 40.711676
Radius: 1 mile
***Query***
SELECT *
FR...
After reading about Firefox's Geolocation functionality, which doesn't use GPS, I'm wondering what it would take for a browser (IE and/or Firefox) to be able to access a GPS device connected to a normal laptop/desktop computer?
So far the only technology I've found that seems to be able to do this is Google Gears' Geolocation API or dev...
I have a database table of all zipcodes in the US that includes city,state,latitude & longitude for each zipcode. I also have a database table of points that each have a latitude & longitude associated with them. I'd like to be able to use 1 MySQL query to provide me with a list of all unique city/state combinations from the zipcodes tab...
I want to get the longitude and latitude of device. I used location api to get the longtitude and latitude the problem now i am facing is i could not able to call the getLocation() method inside button click event.It is throwing error as getLocation() method cannot called from event thread.Can any one tell me how to solve this problem.
...
Hi,
I would like to show information on my website based on user's geography. In my current design would not want the user to enter their location/zip code.
Using IP I can find user's location but how do i leverage this information to show relevant events/information from surrounding cities/town.
Thanks
...
Let's say I'm just wondering around with my cellphone and I want to know exactly which place of business I'm in. This would seem to be easy, but I don't see away to do it. It's possible to reverse geocode but this gives an address range. Google doesn't seem to have http base local search using local information, because you could kind of...
I'd like to use WIPmania's API to map IP address. http://www.wipmania.com/en/api/
Does anyone know how to grab the value returned in PHP?
For example the url (http://api.wipmania.com/123.45.67.89?google.com) returns the country code KR.
If it was returning an XML file I'd be alright, but this has confused me.
Thanks in advance.
...
I want to make sure FireFox is using my local GPS on my machine (Dell Mini-10) for Location Aware browsing, not Google wi-fi triangulation services.
How would one make sure FireFox is using the GPS? To use GPS a driver or browser plugin (Loki?) I assume is needed to talk locally with Firefox and local hardware. Firefox config would ...
hi.
i noticed that some websites and some iPhone apps can detect my current geographic location.. i mean the exact latitude and longitude.
how can i integrate these feature in my web application. are there any free open source library that can be used to accomplish this task?
thank you.
...
Are there any easy ways to override the default behaviors of the geolocation api and just hard code your current location?
I think this would be useful for testing and for privacy reasons (providing fake location data)
I thought there was an add on for this but I can't seem to find one. Only option right now seems to be changing the a...
In order to calculate the nearest locations that are represented by latitude/longitude, I was considering dividing the map into small grids, approximately 100x100 meter grids. Essentially each point would be assigned to a grid.
I understand that I could instead also use spatial indexes with MySQL etc, but am planning to use a non-relati...
Does anyone know of a free web service to determine the zip code of an IP address?
...
Hi, I'm trying to plot markers with GXml onto my map, it works perfectly fine in firefox (which also has geolocation) but on the iPhone no plotting accures. Here is my code:
iPhone 3.0 geolocation demo
//
var iconBlue = new GIcon();
iconBlue.image = 'http://labs.google.com/ridefinder/images/mm_20_blue.png';
...
Hi all
I have a scenario, where I have x million longitude latitude points.
When a new long/lat point is added I want to know efficiently which other points are within a user configured distance parameter, so I can add them to a list.
got anything better than bounding boxes?
I would love to see algorithms, references and a few implem...
Hi there,
Since there are 3 generations of iPhone, what's the mechanism of their geo locating(WiFi, GPS, any other ways?)? I am doing iPhone development recently so I want to make a deep understanding of this.
(I want a list of all methods of locating and a specific introduction)
Thank you
...
Lately geo-targeting has been pretty popular in technology. By IP, cell tower, GPS, using browser plugins, HTML5?, mobile devices ...
Since I'm about to add some geo-targeted features on our site, I wanted to know what's the best approach. Is there some API that uses a mix of all those technologies? Or at least, what API/service would y...
I'm creating a small app in Sinatra, and I'd like to determine my users' cities from their zip code (which they would input), the distance between them and other users' (by zip code), and possibly a heat map of the zips.
How would I do this? I've tried the geoip gem, but it doesn't seem to do what I want. Would I use an external servi...
What is the maximum length (in kilometers or miles - but please specify) that one degree of latitude and longitude can have in the Earth surface?
I'm not sure if I'm being clear enough, let me rephrase that. The Earth is not a perfect circle, as we all know, and a change of 1.0 in the latitude / longitude on the equator (or in Ecuador) ...
i want to redirect all traffics coming from thailand to another domain
how can i do this in php ?
...
I'm working on a GeoTargeting application. I'm curious if longitude and latitude of a point on the earth can change?
If you know the exact position of the statue of liberty how sure is it that longitude and latitude will stay the same.
Does it change according to the season, time in the year, or slowly over time
...