Thread: example function Polygon

Thanks Barry. Sorry to prolong this thread but if we look at this page: http://dev.mysql.com/doc/refman/4.1/en/functions-that-test-spatial-relationships-between-geometries.html (which happens to be the same for all MySql versions) where do they mark the version number where the functions were introduced/changed ? At: http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-opsfuncs.html there is a list of functions. It...

Hi, I am interested in designing a Geocoded Location Cache. At present we perform a look up for every position from an external source which is proving to be extremely restrictive and costly. All the locations are stored in the database as gpsPosition >> lat lng geocodedLocationId. I was thinking of either using QuadTrees in java to build its own cache or indexing the latitude and longitudes in mysql. Note currently 40,000,000...

Could you show me the example of function Polygon()? I don't know how to use it.

Hello The distance calculation between two points in can be done using GLength function as mentioned in the documentation. Eg:- SET @lat1 =40.756054, @lon1 = -73.986951, /** NEW YORK */ @lat2 =51.5001524, @lon2 = 0.1262362; /** London */ SELECT GLength(LineStringFromWKB(LineString(ASBINARY(GeomFromText(CONCAT('POINT(',@lat1,' ', @lon1,')'))) as Distance But the distance here calculated is not based on geo model....

IPinfoDB: IP address geolocation SQL database http://ipinfodb.com/ip_database.php

When will the GIS improvements made in WL#1326 be released into the production code (5.4... 6.0...further out...)? We're using the 'test' code now, but are wondering if we should even use the new reliable functions in our product.

Dear friends, I have a bunch of polygons defined and I would like to find out which of them are under a StringLine. I tried with: 1# SELECT id, AsText(g) AS myPolygon FROM flst WHERE MBRIntersects(LineStringFromText('LINESTRING(4480611.9803 5551488.0621,4480804.8855 5551431.9080)'), g); -> The result isn’t good enough because there is being used the boundary(=Big rectangle) of the StringLine Even with the function...

Hi there: I ran a query on a table that has two columns of type POINT with spatial indexing being applied (using R+ tree). The total records in the table is 480,847,800. This is how the table is created. CREATE TABLE table1 ( column1 varchar(11) NOT NULL default '1-1-174-418', startPoint POINT NOT NULL, endPoint POINT NOT NULL, SPATIAL INDEX point1_index (point1) USING RTREE, SPATIAL INDEX point2_index (point2) USING RTREE )...