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...
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(); ...
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...
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? ...
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...
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...