Loading GIS data - how?

2003-09-19 Thread W. Thomas Wall 
I’m a newbie to MySQL and am trying to evaluate it for our use.  I’ve been
studying the 4.1 GIS features and can’t figure out some relatively simple
things:

 

- How do I load data (e.g., POINTs) into a GEOMETRY column, either from a
file or from other (NUMERIC) database columns?

  It appears that I have to reformat my data into either WKT or WKB, and
then issue a series of INSERTS, since the POINTS(x,y) function is listed as
not being implemented.  

 

Is this correct?  If so, when will POINTS() and other MySQL GIS functions be
implemented in a released binary?  Does anyone have some simple scripts or
source code available that will do this (on a Windows box) in the mean time?

 

An additional stupid question:

- Do you have a simple way of loading data from a tab-delimited file where
the first row DOES contain the column names?  I would like to ensure that
the file’s columns correspond to correct columns in the database, rather
than loading them “blind”.

 

Thanks,

– Thomas

Loading GIS data - how?

2003-09-19 Thread W. Thomas Wall 
I’m a newbie to MySQL and am trying to evaluate it for our use.  I’ve been
studying the 4.1 GIS features and can’t figure out some relatively simple
things:

 

- How do I load data (e.g., POINTs) into a GEOMETRY column, either from a
file or from other (NUMERIC) database columns?

  It appears that I have to reformat my data into either WKT or WKB, and
then issue a series of INSERTS, since the POINTS(x,y) function is listed as
not being implemented.  

 

Is this correct?  If so, when will POINTS() and other MySQL GIS functions be
implemented in a released binary?  Does anyone have some simple scripts or
source code available that will do this (on a Windows box) in the mean time?

 

An additional stupid question:

- Do you have a simple way of loading data from a tab-delimited file where
the first row DOES contain the column names?  I would like to ensure that
the file’s columns correspond to correct columns in the database, rather
than loading them “blind”.

 

Thanks,

– Thomas