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

[Fernando S.]

Hi Erwin,
    You don't need to execute the SDO_CS.VIEWPORT_TRANSFORM function
every time that you update the database with the new records.
    You can define your data layer as:  data "geom from (select
SDO_CS.TRANSFORM(SDO_CS.VIEWPORT_TRANSFORM(<your geom column>, <SRID for
millimeters>), <SRID that you want as output>) as geom from <your table>)".
    Using this way you don't need to update your database, you use the
return of the function how as source of the geometry.
    Remember this way can be worst, but in your case can work very well.
    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 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
>>>
>>>
>>>
>>>
>>>
>
>
>