[Mapserver-users] Projection conversion

[Tyler Mitchell]

I haven't used Oracle Spatiall, but if you are wondering about projections,
here is an idea to try.
It looks too me like you have everything setup properly in your map file -
the only problem may be your data.
Your map file project setting and your "PointTest" layer's projection
settings are the same, therefore, no reprojecting is required for that
layer.  Your "shoreline" layer has a different EPSG, so it has to project
it.

I'd guess that there could be at least 3 things going on:
- Your request for the data using SRID=82196 may not be giving you data
that is in EPSG:2145
- EPSG:2145 may be wrong altogether
- There is no data being returned from Oracle.

I suggest changig the EXTENT and map file PROJECTION settings to match your
Shoreline data.  If you can view the shoreline data, then you can at least
rule out my last point above.

Tyler

> I'm new to mapserver and I'm making some tests to make it work with
> Oracle spatial (very simple tests though).
>
> One of my test consist of two layers, one in Lambert Conformal Conic
> (LCC) and the other in NAD83 MTM Zone 8.
>
> I wonder if I have to do something special to make Mapserver convert
> between projection...
>
> For the mapfile below, only the LCC layer is visible in the bounding box.
>
> # BEGIN MAPFILE
> # Mapserver test 3 for Oracle
> # Nicolas Fortin, Env Can nicolas.fortin at ec.gc.ca
>
> NAME MS_ORA_TEST_3
> EXTENT 7613000 1218000 7620000 1227000
> #EXTENT 275000 5019000 280000 5027000
> SIZE 350 450
> PROJECTION
>   "init=epsg:102002"
> END
>
> LAYER # Test table
>   NAME "PointTest"
>   TYPE POINT
>   CONNECTIONTYPE oraclespatial
>   CONNECTION "martins/****@bayfield"
>   DATA "GEOLOC FROM MARTINS.CT_LCC_MI"
>   STATUS DEFAULT
>   DUMP TRUE
>
>   PROJECTION
>     "init=epsg:102002"
>   END
>
>   CLASS # PolyClass
>     NAME "Point"
>     COLOR 0 100 240
>     OUTLINECOLOR 0 0 0
>   END
>
> END # LAYER
>
> LAYER # Test table
>   NAME Shoreline
>   TYPE LINE
>   CONNECTIONTYPE oraclespatial
>   CONNECTION "usr_bathy/****@bayfield"
>   DATA "GEOLOC FROM USR_BATHY.SHORELINE USING SRID 82196"
>   STATUS DEFAULT
>   DUMP TRUE
>
>   PROJECTION
>     "init=epsg:2145"
>   END
>
>   CLASS # PolyClass
>     NAME "Shoreline"
>     COLOR 0 0 0
>     #LABEL
>     #  COLOR 0 0 0
>     #END # LABEL
>   END
>
> END # LAYER
>
> END
> # END MAPFILE
> Thx,
> Nicolas Fortin
> Mathématicien, Programmeur, Analyste de données
> SMC-Québec Hydrologie, Environnement Canada
> 1141, Rte de l'Église, Sainte-Foy(QC) G1V 4H5
> (418)648-2516
> nicolas.fortin at ec.gc.ca <mailto:nicolas.fortin at ec.gc.ca>
>