NULL, add spatial index
> (coordinates);
>
> You can check the data with the ASTEXT() function:
>
> SELECT longitude, latitude, ASTEXT(coordinates) FROM places;
>
>
> Hope this helps
> -Gavin Towey
>
> From: René Fournier [mailto:m...@renefournier.com]
> Sent:
ordinates);
You can check the data with the ASTEXT() function:
SELECT longitude, latitude, ASTEXT(coordinates) FROM places;
Hope this helps
-Gavin Towey
From: René Fournier [mailto:m...@renefournier.com]
Sent: Saturday, December 19, 2009 12:42 AM
To: Gavin Towey
Cc: mysql
Subject: Re: Spatial e
tial index. Oops, I forgot to change a couple
> occurances of "line_segment" to "coordinates" line_segment was just the
> column name I was using in my original query.
>
> Regards,
> Gavin Towey
>
> -Original Message-----
> From: René Fournier [mai
couple occurances of
"line_segment" to "coordinates" line_segment was just the column name I was
using in my original query.
Regards,
Gavin Towey
-Original Message-
From: René Fournier [mailto:m...@renefournier.com]
Sent: Thursday, December 17, 2009 8:54 AM
To: Gavin Towey
C
adius, ',',
>> X(@center) - @radius, ' ',
Y(@center) - @radius, '))')
>> );
>>
>>
select id, astext(coordinates), Distance(@center,line_segment) as dist
>> FROM places where MBRContains(@bbox, line_segment) order by
dist limit
>> 10;
nter) - @radius, '))')
> );
>
> select id, astext(coordinates), Distance(@center,line_segment) as dist
> FROM places where MBRContains(@bbox, line_segment) order by dist limit 10;
>
> Regards,
> Gavin Towey
>
>
> -Original Message-
> From: Ren
')
);
select id, astext(coordinates), Distance(@center,line_segment) as dist
FROM places where MBRContains(@bbox, line_segment) order by dist limit 10;
Regards,
Gavin Towey
-Original Message-
From: René Fournier [mailto:m...@renefournier.com]
Sent: Wednesday, December 16, 2009 4:32 PM
To:
irly quick:
SELECT SQL_NO_CACHE * FROM places WHERE latitude BETWEEN 51.98228037384 AND
52.033153677 AND longitude BETWEEN -113.94770681881 AND -113.86685484296;
But I wonder a couple things:
1. Would MySQL's [seemingly anemic] spatial extensions would speed things up if
I added a colum
Use 3d pythagorean theorem.
the distance d between point1 (x1,y1,z1) and point2 (x2,y2,z2) is...
d = sqrt((x1-x2)^2 + (y1-y2)^2 + (z1-z2)^2)
as for building an index for this? i have no idea. but that is how you
find the distance between two 3D points.
b
Jose Antonio wrote:
MySQL offers Sp
Hello.
For a pity, I do not have an exact answer on how to do your task in a
best way with MySQL. Searching in the archives gave me these links:
http://lists.mysql.com/mysql/185851
http://lists.mysql.com/mysql/185846
Perhaps, you will need the help of stored routines or UDFs:
http://dev.mys
MySQL offers Spacial Extensions to operate with points in a 2 dimensional
space.
For a project I'm working on, I need to work with points in an N dimensional
space and measure the distance among them. Is there a clever do to solve the
following problem?:
Let's say I have 4 3D point (X,Y,Z):
(0,0
longitudes, and the table of Dealers with ZIP codes in a separate table.
While researching this I came across a reference to MySQL's Spatial
Extensions:
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions-in-mysql.html
This is WAY over my head. The reference I found said these e
e.
While researching this I came across a reference to MySQL's Spatial
Extensions:
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions-in-mysql.html
This is WAY over my head. The reference I found said these extensions
are "immature". I'm not even exactly sure what an ext
"Andras Kende" <[EMAIL PROTECTED]> wrote on 08/13/2005 10:32:07 PM:
> Hello,
>
> I have a html page with 70+ form fields some like 40 fields are only
used
> for entering quantity numbers…
>
> Don’t want to do Mysql table with 70 fields…
>
> Is it a good idea to put this 50 fields of the form f
Andras,
>Is it a good idea to put this 50 fields of the form fields into
a single
>text mysql field?
>Somehow process it with php before, put inside of some kind of xml
>structure?
Nothing wrong with 70 columns unless there are interdependencies
&/or groupings
amongst the 70 values that re
Hello,
I have a html page with 70+ form fields some like 40 fields are only used
for entering quantity numbers…
Don’t want to do Mysql table with 70 fields…
Is it a good idea to put this 50 fields of the form fields into a single
text mysql field?
Somehow process it with php before, put inside
Paul DuBois wrote:
At 16:27 -0400 8/12/05, [EMAIL PROTECTED] wrote:
This is a big issue. Will this be the same in version 5? Or will
the SRIDs actually be used? I would like to just represent
everything in lat/lon, not on a planar surface. Now, if the SRIDs
are used in MySql 5, whe
At 16:27 -0400 8/12/05, [EMAIL PROTECTED] wrote:
To the powers that be: Can we get a MySql GIS/spatial list?? This
is going to be a very popular area (actually it is already).
I am trying to use the Spatial extensions to MySql. To be honest
PostGIS has many more features, but MySql is my
To the powers that be: Can we get a MySql GIS/spatial list?? This is
going to be a very popular area (actually it is already).
I am trying to use the Spatial extensions to MySql. To be honest
PostGIS has many more features, but MySql is my favorite, and on top of
that, the applications
Spatial extensions and I am wondering
how I can use it to determine the distances between any 2 landmarks that
have been entered as POINTs in the database. The POINTs are entered with
longitude and lattitude coordinates.
I have 2 problems:
1) The Distance nor the Buffer functions have not been
Hi.
This may be a daft question, so forgive me:
I am just starting out with the Spatial extensions and I am wondering
how I can use it to determine the distances between any 2 landmarks that
have been entered as POINTs in the database. The POINTs are entered with
longitude and lattitude
Hi
is there an easy way (through e.g. VCL components) to
use the spatial features which will be offerd by
MySQL 4.1 from Delphi?
Rainer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
HI!
I'm trying to use spatial extensions.
I need to transfer a table like this,
++-+---+--+-+-+---+
| Field | Type| Collation | Null | Key | Default | Extra |
++-+---+--+-+-+---+
| x | i
I am new to the world of GIS and have an application where I would like
to use MySQL's (found in 4.1 alpha currently) Spatial Extensions. I
have a set of latitude and longitude for various locations and am trying
to figure out how to convert to the SRID units. I have started going
thr
At 22:05 +0400 9/29/03, G B U wrote:
> On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
>
> Hmm... am I missing something?! IIRC there is nothing manual about Innodb
> not supporting spatial extensions. And on windows it seems that
all is working
> fine. This is from
t;> abnormal behaviour.
>>
>
>Currently you can use spatial columns only in the MyISAM tables.
Also, the crash described above is fixed in MySQL 4.1.1. GIS features
still are available only in MyISAM (as Victoria notes), but attempting
to use them with InnoDB won't
> On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
> >
> > Hmm... am I missing something?! IIRC there is nothing manual about Innodb
> > not supporting spatial extensions. And on windows it seems that all is working
> > fine. This is from my Win2000 box
On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
>
> Hmm... am I missing something?! IIRC there is nothing manual about Innodb
> not supporting spatial extensions. And on windows it seems that all is working
> fine. This is from my Win2000 box with the same Mysql version
meone test this and confirm or disconfirm above-mentioned
> >> abnormal behaviour.
> >>
> >
> >Currently you can use spatial columns only in the MyISAM tables.
>
>
> Also, the crash described above is fixed in MySQL 4.1.1. GIS features
> still are available on
At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
"G B U" <[EMAIL PROTECTED]> wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying to
"G B U" <[EMAIL PROTECTED]> wrote:
>
> It seems to me that combination from the subject just doesn't work.
> Every time I try to incorporate spatial column into Innodb table
> Mysql dies. The simplest case, easy to repeat is bellow.
> When I'm trying to create table with just one spatial column
Hi
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying to create table with just one spatial column I'm
getting following error:
mysql> cre
Firstable thanks for all, now I have two more
questions:
The first, I would like to know if the JDBC driver
supports the spatial extensions, and the second
question is how much stable is version alpha 4.1 of
MySQL?
Thanks:
Enrique
___
Yahoo
> -Original Message-
> From: Enrique Andreu [mailto:[EMAIL PROTECTED]
> Sent: 05 August 2003 08:08
> To: [EMAIL PROTECTED]
> Subject: Problems with spatial extensions
>
>
> Hi, I would like to have a column of a table of the
> type GeometryCollection, but when I tr
Hi, I would like to have a column of a table of the
type GeometryCollection, but when I try to type a
simple example like the ones in the manual, I get
this:
mysql> CREATE TABLE geom (g GEOMETRY);
ERROR 1064: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL se
t; start with:
>
> 1) For now, is the [EMAIL PROTECTED] the place to discuss MySQL's
> Spatial Extensions?
Yes.
> 2) Are there any plans to create a separate list (e.g.
> [EMAIL PROTECTED]) in the future?
Nope.
--
For technical support contracts, goto https://order.mysql.c
MySQL's
Spatial Extensions?
2) Are there any plans to create a separate list (e.g.
[EMAIL PROTECTED]) in the future?
Kind regards,
Gijsbert Noordam
ISIS Benelux BV
The Netherlands
T +31 345-544 744
F +31 345-544 777
37 matches
Mail list logo
