SRID = null; how to to convert coordinates from millimeters to meters?

[Fernando S.]

Hi Erwin,
   I don't know if I understood you doubt, but I will try to explain.
   I believe that you can use two ways. The first is using projection in
your mapfile and layer definition.
   The second way is using the two functions: SDO_CS.TRANSFORM and
SDO_CS.VIEWPORT_TRANSFORM. Perhaps you need to use the two functions of
conjugated form. The first function don't accept data with NULL SRID
values, but you can use the second function to transform your data for a
defined SRID and use it how a input of first function. Can be, you need
to test your data with the srid that you want.
   The way how I suggested to use the functions can be the wrong way but
can help you.
   I don't know if I helped you.
   Thank's.

----------------------------------------------------------------
Fernando Simon - simon at inf.univali.br
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada
http://g10.cttmar.univali.br
----------------------------------------------------------------

Erwin v.d. Bij wrote:

>Hello all,
>
>I have an Oracle Spatial database with a table A which have an SDO_GEOMETRY
>column, called geomm, which contains polygons. There is a spatial index on
>it.
>However we are forced to use SRID is NULL (!) but the coordinates are in
>millimeters.
>Are there easy ways to show the polygons with mapserver, knowing that
>mapserver
>accepts no millimeters? Is there a config parameter with mapserver to handle
>this or is there a query in oracle spatial to handle tihs?
>
>Erwin
>
>
>