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

[Erwin v.d. Bij]

Hello Fernando,

Thanks for your response. See my reaction below.

>   I believe that you can use two ways. The first is using projection in
>your mapfile and layer definition.

I've looked in in it, but still don't how to do this.

>   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.

As far a I understand is the SDO_CS.VIEWPORT_TRANSFORM function a one time action that converts geometry columns to SRID defined gemoetries. However, I have a database which is updated each minute with new records and each record contains a gemoetry column with coordinates in millimeters. If for each database update we have to run SDO_CS.VIEWPORT_TRANSFORM, it will be very timeconsuming. Maybe, I don't understand it correctly. I'm still a newbie on Mapserver and Oracle Spatial as well.

Kind regards,

Erwin
>   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
>>
>>
>>
>