GIS | Forum profile

>phpinfo says that I use the MySql 5.0.41 client API. This is the version of php interface to mysql you are using. >A select version() sql command says 4.1.15-standard-log. This is the version of MySQL server you have. The two don't have to match. Good luck. Barry.

Have you checked the examples on http://dev.mysql.com/doc/refman/5.1/en/geometry-pr operty-functions.html#polygon-property-functions ? It all comes down to GeomFromText('Polygon((...))'); with ... being one or more closed loop LINESTRING definitions. The examples on the page above use a MULTIPOLYGON consisting of two triangles: 'Polygon((0 0,0 3,3 0,0 0...

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 ...

Contains() is currently just an alias to MBRContains(), see the first note on http://dev.mysql.com/doc/refman/5.1/en/functions-t hat-test-spatial-relationships-between-geometries. html and the section on MBRContains(), which has a usage example, on http://dev.mysql.com/doc/refman/5.1/en/relations-o n-geometry-mbr.html If you are looking for an equivalent to the MS SQL ...