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 favorite, and on top
of that, the applications I am using only work with MySql.
My problem is this. From the manual, all Geometry contains:
Its SRID, or Spatial Reference Identifier. This value identifies the
geometry's associated Spatial Reference System that describes the
coordinate space in which the geometry object is defined.
In MySQL, the SRID value is just an integer associated with the
geometry value. All calculations are done assuming Euclidean
(planar) geometry.
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, where is the list of acceptable values?
As far as I know, it's the same in MySQL 5.
Also, to developers on the list: perhaps it would be better if these
were text values like 'NAD83'??
I think that is unlikely to happen. The OpenGIS spec defines the
SRID to be an integer, and the SRID() function to be an integer-valued
function.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]