Re: To GIS or Not to GIS... That is the Question
Hi,
craig thompson Wrote:
-------------------------------------------------------
> Okay folks I would call myself a newbie with the
> exception that I am old as dirt.
Welcome :)
> I have some young gun developers that are giving
> me differing opinions about a GIS problem we
> have.
>
> We are currently running MySQL 5.0.89-community on
> a centos server.
>
> My guys have an older version of Mysql running
> local on the machines. When they try to insert
> records with GIS data locally no prob. When they
> do the exact same on the server, they get
> garbage.
Can you elaborate on what you mean by "garbage"?
How is the data inserted?
> I have one guy who says that he thinks we are
> missing and extension in our MySQL, another who
> says we have what we need but there is a config
> issue, and I have a hosting company that says "Hey
> happy to help, just give us exact instructions for
> what you want us to do"
There is no special extension needed to store GIS data.
To my knowledge, it's not possible to build a server without
the support for this.
> Are there any functions I can call that can tell
> me if I indeed have what I need in the build? Any
> other config calls I need to run to have what I
> need to explain it better here?
>
> Any other input would be Great... Thanks Team.
It would be good to know how exactly the data is inserted on
the local systems and if there is any difference to how it's done
on the server. What exactly happens? Please try to describe the
steps that would allow us to reproduce the problem.
Thanks!
Lenz Grimmer - MySQL Community Relations Manager -
http://de.sun.com/
Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten, DE
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels
Vorsitz d. Aufsichtsrates: Martin Haering AG Muenchen: HRB161028