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