Re: Spatial data and mysql

2008-06-24 Thread Rob Wultsch
On Thu, Apr 24, 2008 at 4:06 PM, Rob Wultsch [EMAIL PROTECTED] wrote: I have been storing points in mysql without use of the spatial extension. I do not forsee the need to ever store more than points, and am wondering if the spatial extensions would offer any significant advantages. I have

Re: Spatial data and mysql

2008-04-25 Thread Chris W
I just did a quick look at the documentation on the mysql spatial extension and it seems like over kill for what you are looking for. An easy way to approximate the search for all points a given distance from another is to simply use a bounding box. An index on the X and Y coordinates of the

Re: Spatial data and mysql

2008-04-25 Thread Rob Wultsch
On Fri, Apr 25, 2008 at 12:27 AM, Chris W [EMAIL PROTECTED] wrote: I just did a quick look at the documentation on the mysql spatial extension and it seems like over kill for what you are looking for. An easy way to approximate the search for all points a given distance from another is to

Spatial data and mysql

2008-04-24 Thread Rob Wultsch
I have been storing points in mysql without use of the spatial extension. I do not forsee the need to ever store more than points, and am wondering if the spatial extensions would offer any significant advantages. I have looked a bit for tutorials, etc... and have not found much. One feature that

Re: store spatial data in mysql

2007-01-09 Thread ViSolve DB Team
ViSolve DB Team - Original Message - From: CrazyWind [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, January 08, 2007 7:10 PM Subject: Re: store spatial data in mysql Thanks . I have read these doucments, but if i want store a .shp file, How should I do? Convert it ? Wating

store spatial data in mysql

2007-01-08 Thread CrazyWind
Hi everyone, I'm beginner in Gis,I want to establish a spatial database using MySQL. But I don't kown hoe to. Could someone give me the detail steps, or give me a databse that had spatial data? thanks. -- View this message in context: http://www.nabble.com/store-spatial-data-in-mysql-tf2938527

Re: store spatial data in mysql

2007-01-08 Thread ViSolve DB Team
: CrazyWind [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, January 08, 2007 4:02 PM Subject: store spatial data in mysql Hi everyone, I'm beginner in Gis,I want to establish a spatial database using MySQL. But I don't kown hoe to. Could someone give me the detail steps, or give me

Re: store spatial data in mysql

2007-01-08 Thread CrazyWind
://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html http://dev.mysql.com/doc/refman/5.0/en/creating-spatial-columns.html http://dev.mysql.com/doc/refman/5.0/en/populating-spatial-columns.html Thanks ViSolve DB Team -- View this message in context: http://www.nabble.com/store-spatial-data

spatial data in MySQL

2004-07-23 Thread Lawrence Strydom
Hi List, I have been looking for solutions to my problem for a while and this morning someone told me that MySQL 5.1 might be the answer. In short what I need is an interactive map displayed in a web browser. Users should be able to click on any point in the map and add text. The map and the

RE: spatial data in MySQL

2004-07-23 Thread Wilder Castelo
to MySQL. Now I am trying To visualize it by browser. -Mensaje original- De: Lawrence Strydom [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 23 de Julio de 2004 09:09 a.m. Para: [EMAIL PROTECTED] Asunto: spatial data in MySQL Hi List, I have been looking for solutions to my problem

RE: spatial data in MySQL

2004-07-23 Thread Wilder Castelo
Hi all! Estaba trabajando con el ArcView by ESRI, con una extension MySQL Connection http://arcscripts.esri.com/details.asp?dbid=12896 l) permitiendo poder exportar un Shapefile (Archivo Vectorial) a MySQL generandome el siguiente Peru.sql(que con gusto enviaria al correo que me preste su

spatial data in mysql

2004-02-27 Thread Saurabh Data
Dear newsgroup readers, I am doing research on spatial data and how it can be used in open source systems like mySQL. Can someone give me some outline of problems in handling spatial data in mySQL. Many THanks Saurabh

Re: spatial data in mysql

2004-02-27 Thread Paul DuBois
At 15:25 + 2/27/04, Saurabh Data wrote: Dear newsgroup readers, I am doing research on spatial data and how it can be used in open source systems like mySQL. Can someone give me some outline of problems in handling spatial data in mySQL. Many THanks Saurabh Probably the best place