Started 3 weeks, 3 days ago (2009-10-21 11:45:00)
by Hartmut Holzgraefe
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...
Started 3 weeks, 4 days ago (2009-10-20 03:13:00)
by Daniel Blackhurst
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 ...
Started 1 month, 1 week ago (2009-10-07 00:32:00)
by Hartmut Holzgraefe
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 ...
Started 2 months, 2 weeks ago (2009-08-26 04:31:00)
by Sergei Golubchik
if you think you have found a bug (and index corruption usually qualifies as a bug) please report it on bugs.mysql.com, our
bug tracker. Otherwise it has a good chance of go unnoticed and not fixed.
Started 2 months, 3 weeks ago (2009-08-20 02:52:00)
by Hartmut Holzgraefe
The current GIS implementation does not support more than 2 dimensions.
Future versions may include 3D support, the current development target
is full OpenGIS compliance though which only requires 2D though, so 3D
is not a high priority target yet ...
--
Hartmut Holzgraefe, MySQL Regional Support Manager EMEA
Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
...
Started 2 months, 3 weeks ago (2009-08-19 05:37:00)
by Lenz Grimmer
Hi,
James Allen Wrote:
------------------------------------------------- ------
> I am trying to add a
spatial index to a table
> column named Location of type BLOB. If I try
> this:
>
> ALTER TABLE route ADD SPATIAL
> INDEX(Location);
>
> I get:
>
> #Error: BLOB/TEXT column 'Location' used in key
> specification without a key length
>
> But in the ...
Size: 974 bytes
