latitude

transform longitude latitude into meters

I need a function that maps gps positions to x/y values like this: getXYpos(GeoPoint relativeNullPoint, GeoPoint p){ deltaLatitude=p.latitude-relativeNullPoint.latitude; deltaLongitude=p.longitude-relativeNullPoint.longitude; ... resultX=latitude (or west to east) distance in meters from p to relativeNullPoint resultY=lon...

Get PHP Timezone Name from Latitude and Longitude?

Is there a way get the timezone of a user by their latitude and longitude? And not just the offset, but the actual timezone they're in. Essentially, I'm searching for the polar opposite of DateTimeZone::getLocation which returns the latitude and longitude for a certain timezone. ...

How Do I Calculate the Area of a Polygon in a MySQL Database When the Polygon's Points are Lat Longs?

Hi, How do I calculate the area of a polygon stored in a MySql database? The polygons' points are lat longs. So, degrees and minutes seem to be causing a problem. I've tried: SELECT AREA( my_polygon ) FROM `my_table` WHERE name = 'Newport' Because, the points are lat longs, I get weird results. (I'm not able to switch to Post...

Calculating the Area of a Polygon When the Polygon's Points are Lat Longs: Which Function is More Accurate?

Hi, I'm trying to find a way to calculate the area of a polygon using lat long coordinates in a Flex 3 site. Hong007 on Google Maps for Flash group was cool enough to post the following function: private function GetPolygonArea (polygon : Polygon):Number { var nVer : int = polygon.getOuterVertexCount(); ...

get postcode from latitude,longitude

I have downloaded the UK postcode list from http://www.ordnancesurvey.co.uk/oswebsite/opendata/index.html and installed it in a MSSQL 2005 database. The table consists of postcode, latitude and longitude. I need an efficient method to get the nearest postcode to a given lat/long. Calculating the distance between two points and choosing t...

How can I convert a geocell to lat/long?

I use GeoModel on app engine--super awesome, I love it for doing location based searches. However, I'd like to actualy also graph a geocell on to a map. Does anyone know how I can convert a geocell back to long/lat, such that I have 4 long/lat coordinates that define the vertices of the geocell? ...

Zipcodes & Distance

Hi, I have a list of zipcoded in a MySQL Database together with their Latitude & Longitude data (Column names: ZipCode, Lat, Lon). Now I have to make a search requests (search for the zipcode) to extract information from a website. When I make this search requests the results include all information within a radius of 50km of the zipco...

Problem in getting latitude and longitude

Here is the program i used to code it in my android application to find the GPS location of the device. enter code here package com.gps.TestingApps; import android.app.Activity; import android.content.Context; import android.location.Location; import android.location.LocationListener; import android.location.LocationManager; import a...

Determine longitudes and latitudes within a range

I have locations in my database. A location has the attributes latitude and longitude (taken from google maps, example: 48.809591). Is there any query that could help me retrieve the locations within a range of another location? Example: I have the location A with latitude = 48.809591, and longitude = 2.124009 and want to retrieve all l...