[Mapserver-users] Projection conversion

[nicolas.fortin at ec.gc.ca]

Thanks for your answer!

The EXTENT in comment is an extent on the shoreline layer and if I switch to
it, I'll see the shoreline correctly.

If I remove all the PROJECTION, all work fine too but only one layer at a
time depending of the bounding box uses.

I'll see if epsg:2145 and epsg:102002 are 'really' the same as the SDO
projection...

Nick

-----Message d'origine-----
De : Tyler Mitchell [mailto:TMitchell at lignum.com] 
Envoyé : Friday, October 31, 2003 11:46 AM
À : nicolas.fortin at ec.gc.ca
Cc : mapserver-users at lists.gis.umn.edu
Objet : RE : [Mapserver-users] Projection conversion







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