Problem: a table of coordinate lat/lngs. Two rows can potentially have the same coordinate. We want a query that returns a set of rows with unique coordinates (within the returned set). Note that distinct is not usable because I need to return the id column which is, by definition, distinct. This sort of works (@maxcount is the number of...
When I use UIImagePickerController to select a photo, either from the Camera Roll or the Photo Library, the image that gets returned to me in the method 'didFinishPickingImage' does not contain the exif data for latitude and longitude. I know that the headers are there, because they show up when imported into iPhoto, also if I upload ...
Hi, I am facing a strange thing when i open some URL. The URL is (www.jobserve.com) When i open this URL from my home, it opens some web page. Same url if i open from my office network, i get a entirely differnt URL, which is what i want. Both, my home and office are in same city in India(3 Km. apart!) but somehow from my home networ...
I have a database of geocoded entries. I need to determine which two entries are the furthest apart from a subset of the total entries. For example, I select a list of 10 entries then, from that list, determine which two places represent the greatest distance within that list. I cannot wrap my head around how to approach this. I've cons...
Hey all, Is there a library out there that will get you your approximate location using the google service (https://www.google.com/loc/json)? Google Gears has support for it as described here http://code.google.com/p/gears/wiki/GeolocationAPI There is also good doco on the web service request/response schema. Firefox and iPhone Safari...
Hi Everybody! I have a large Oracle database ( 720,000 records aprox) where each record has its own geographic coordinates (lat & lng) and i need to select just the records that are in a specific distance from a point ( inside a specific radius). Currently i've implemented a distance function (based on haversine) that i've found in a...
Hi, I am trying to develop some simple location logic in the server-side portion of a java servlet-based webapp. There are really just two operations that I'm interested in: Given a start point (lat/long) s1, distance d, and search point (also lat/long) s2, determine if the s2 is within d distance from s1. Given two points (lat/long),...
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 need to implement a Geo proximity search in my application but I'm very confused regarding the correct formula to use. After some searches in the Web and in StackOverflow I found that the solutions are: Use the Haversine Formula Use the Great-Circle Distance Formula Use a Spatial Search Engine in the Database Option #3 is really no...
How do I calculate distance between 2 coordinates by sea? I also want to be able to draw a route between the two coordinates. Only solution I found so far is to split a map into pixels, identify each pixel as LAND or SEA and then try to find the path using A* algorithm. Then transform pixels to relative coordinates. There are some soft...
Hi I want to get all countries ip addresses range from IANA's whois server, Not from maxmind or ip2location site. IANA is authentic site hence I would like to get all ipaddress ranges for countries from that site. Is it possible to query the WHOIS server such a way?? ...
we have a company wide SharePoint portals planned for few thousand users. since the users are distributed among different countries and their applications (hosted in sharepoint) We would like to consider geo deployment Vs geo load balancing. Please share your inputs. We are aware of this, Geo SharePoint Cluster facilitates - Farms a...
I am trying to geolocate a user then present him a driving path to my location using django and javascript. The js i am using is over here: http://github.com/gvkalra/random/blob/master/templates/home/index.html If to the geolocation prompt I say "Share my location", the system is not working. I am unable to figure out why ..... Please h...
Hi, I'm just playing around with a dataset of my region generated by JOSM. I moved it into a mySQL DB with the 0.6 API scheme using Osmosis and now I'm desperately trying the following: I want to get all streets of a city. AFAIK there is no tag/relation in the OSM data to determine this so I tried it using a proximity search to get al...
Is there a way to convert Geo information to real place name? For example, I take a photo on "137-159 New Montgomery St San Francisco, CA 94105", the Geotagging information is : geo:37.786971,-122.399677 when I type the geo in google map, it can show the place name to me. Does google provide API to get it? Thanks in advance. ...
I'm attempting to stream Tweets from the UK as a whole, using Twitters stream API, however I'm having trouble with my bounding box. The LAT/LON pairs I'm using to define a bounding box of the whoe UK(Ire included) is as follows. -9.05, 48.77, 2.19, 58.88 However when I try to use this with the Twitter stream API, it states the follow...
this is the geo website that has geo-atom and geo-rss but the website don't has all geo Overlays ,like :Polylines ,Polygons,Icons, i has a geo-rss that has all about it, it is here but i can not find a geo-atom that has all Overlays demo, can you give me one , thanks ...
Hello Everyone, This is my scenario. I have the latitude and longitude of certain places in a CSV file.I now want to be able to show these points on a map. say for example on the US map.I tried converting this CSV file to shape file and tried to use the geo-tools to do this, but am missing some jar file which am unable to figure out.Wha...
I used this code but it doesnt work: Need the distance between two gps coordinates like 41.1212, 11.2323 in kilometers (Java) double d2r = (180 / Math.PI); double distance = 0; try{ double dlong = (endpoint.getLon() - startpoint.getLon()) * d2r; double dlat = (endpoint.getLat() - startpoint.getLat()) * d2r; double a = ...
I am using GEO API in a iPhone app, sometimes the app takes a long time to load the data, so I need a way to make the response fast, any ideas??? My App calls Geo API services in Asynchronous mode. ...