Spatial Extension on Windows

------=_NextPart_000_0025_01C5D4B6.4E1FCB10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Does anyone have any experience running mysql Spatial Extension on =
Windows? I would like to store GIS data in mysql, but I cannot find a =
Windows binary that actually has the spatial extensions turned on. Does =
anyone know where to find one that is not a beta release? I posted =
earlier with no reply. If I am not posting properly or to the correct =
list, please let me know.

Garry Washburn
Seeker of Knowlege
--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: =
http://lists.mysql.com/win32?unsub=3Dgwashburn@goldimaging.c om

------=_NextPart_000_0025_01C5D4B6.4E1FCB10--

Re: Spatial Extension on Windows

From what I can work out, the spatial extensions are very immature -
sort of like Oracle Spatial 1 (8i) compared to Oracle Spatial 2 (9i).

Where I used to work had to make a choice between OS1 and going with
Oracle normal. In the end we went with Oracle normal and doing the
spatial calculations with stored procedures instead.

I've been out of the company now for over a year so I don't know if they
have switched across to the latest Spatial (was it updated for 10?) but
with 7.5TB of data I would doubt it very much.

Which leads me to something else - no one has mentioned that doing a
50km "circle" for searches won't produce an exact circle, more of an egg
shape, but since you are interested in precision (we used to work to
centimetre precision) a couple of hundred metres here and there won't
make much difference.

G.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Spatial Extension on Windows

Ah, Graham, that's too bad.

Yes, then the right thing to do is perform the calculations outboard,
perhaps not even using MySQL's stored procedures. However, even without
them, many spatial calculations can be preconditioned for speed by using
several auxiliary tables.

Thanks.

BTW, is this spatial extension a MySQL MyISAM innovation, an InnoDB
innovation, or something else?

- Jan


On Thu, 20 Oct 2005 12:49:07 +0100, "Graham Reeds"
said:
> From what I can work out, the spatial extensions are very immature -=20
> sort of like Oracle Spatial 1 (8i) compared to Oracle Spatial 2 (9i).
>=20
> Where I used to work had to make a choice between OS1 and going with=20
> Oracle normal. In the end we went with Oracle normal and doing the=20
> spatial calculations with stored procedures instead.
>=20
> I've been out of the company now for over a year so I don't know if they=
=20
> have switched across to the latest Spatial (was it updated for 10?) but=
=20
> with 7.5TB of data I would doubt it very much.
>=20
> Which leads me to something else - no one has mentioned that doing a=20
> 50km "circle" for searches won't produce an exact circle, more of an egg=
=20
> shape, but since you are interested in precision (we used to work to=20
> centimetre precision) a couple of hundred metres here and there won't=20
> make much difference.
>=20
> G.
>=20
>=20
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: =20
> http://lists.mysql.com/win32?unsub=3Djtgalkowski@alum.mit.ed u
>=20
--=20
Jan Theodore Galkowski (o°) =

jtgalkowski@alum.mit.edu
http://www.smalltalkidiom.net



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org