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
Rene:
We've easily integrated GIS with MySQL into our
sites:
http://tenant.com/map-search.php
http://yearlyrentals.com
http://acnj.com/map.php
...
Thanks!
Jim Ginn
Visit My Work
(888)
546-4466 office
(609) 226-5709 cell
> Awesome, this is what I was trying to find, as you
succinctly wro
Awesome, this is what I was trying to find, as you succinctly wrote it. I
*really* appreciate getting pointed in the right direction, since I haven't
found a lot of MySQL's GIS tutorials directed at what I'm trying to do.
Still, a couple questions, the Distance() function you included, that must
Yes, spatial indexes are very fast:
Query would be something like:
SET @center = GeomFromText('POINT(37.372241 -122.021671)');
SET @radius = 0.005;
SET @bbox = GeomFromText(CONCAT('POLYGON((',
X(@center) - @radius, ' ', Y(@center) - @radius, ',',
X(@center) + @radius, ' ', Y(@center) - @rad
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
Brian
>I'm in the midst of the age-old problem of finding the right SQL to
>make a Dealer Locator by ZIP code. Like Steffan's posts from a
>couple weeks ago, I have the ZIP code data in one table with
>latitudes and longitudes, and the table of Dealers with ZIP codes
>in a separate table.
Fo
"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 f
In both cases you will have to write your own code. MySQL, so far, only
can store Spatial data and do very simple (still, r-tree optimized) GIS
queries (like: all objects inside rect).
mirza
Terry Pothecary wrote:
Hi.
This may be a daft question, so forgive me:
I am just starting out with the Sp
16 matches
Mail list logo
