[mapguide-users] Experiences with Oracle Spatial

[jas]

Joel, Juan,

We are getting the same issue. It will display the table names, fields etc
but the data will not display. Is there anything specific that needs to be
setup e.g. config files, PHP etc. Any help would be appreciated.

Regards
Jas 

I found the following information:
have noticed that we get the following when using the GETSPATIALCONTEXTS
option (http://localhost/mapguide/mapagent/index.html):

The items we noticed were:
1) The SC is repeated 3 times
2) SpatialContext IsActive="false" 
3) The coord system range is 
<LowerLeftCoordinate>
<X>-180</X> 
<Y>-90</Y> 
</LowerLeftCoordinate>
- <UpperRightCoordinate>
<X>180</X> 
<Y>90</Y> 
</UpperRightCoordinate>

Where as our range in Oracle Spatial is:
DIMINFO
((X, 144.435155, 145.396467, 0.001), (Y, -38.231428, -37.17879, 0.001), , )

What do we need to talk to Oracle correctly?


?xml version="1.0" encoding="UTF-8" ?> 
- <FdoSpatialContextList>
<ProviderName>Autodesk.Oracle.3.1</ProviderName> 
- <SpatialContext IsActive="false">
<Name>SC_1</Name> 
<Description>Spatial context from Oracle metadata</Description> 
<CoordinateSystemName>Longitude / Latitude (GDA 94)</CoordinateSystemName> 
<CoordinateSystemWkt>GEOGCS [ "Longitude / Latitude (GDA 94)", DATUM ["GDA
94", SPHEROID ["GRS 80", 6378137, 298.257222101]], PRIMEM [ "Greenwich",
0.000000 ], UNIT ["Decimal Degree",
0.01745329251994330]]</CoordinateSystemWkt> 
<ExtentType>Static</ExtentType> 
- <Extent>
- <LowerLeftCoordinate>
<X>-180</X> 
<Y>-90</Y> 
</LowerLeftCoordinate>
- <UpperRightCoordinate>
<X>180</X> 
<Y>90</Y> 
</UpperRightCoordinate>
</Extent>
<XYTolerance>0.000000</XYTolerance> 
<ZTolerance>0.000000</ZTolerance> 
</SpatialContext>
- <SpatialContext IsActive="false">
<Name>SC_2</Name> 
<Description>Spatial context from Oracle metadata</Description> 
<CoordinateSystemName>Longitude / Latitude (GDA 94)</CoordinateSystemName> 
<CoordinateSystemWkt>GEOGCS [ "Longitude / Latitude (GDA 94)", DATUM ["GDA
94", SPHEROID ["GRS 80", 6378137, 298.257222101]], PRIMEM [ "Greenwich",
0.000000 ], UNIT ["Decimal Degree",
0.01745329251994330]]</CoordinateSystemWkt> 
<ExtentType>Static</ExtentType> 
- <Extent>
- <LowerLeftCoordinate>
<X>-180</X> 
<Y>-90</Y> 
</LowerLeftCoordinate>
- <UpperRightCoordinate>
<X>180</X> 
<Y>90</Y> 
</UpperRightCoordinate>
</Extent>
<XYTolerance>0.000000</XYTolerance> 
<ZTolerance>0.000000</ZTolerance> 
</SpatialContext>
</FdoSpatialContextList>
-- 
View this message in context: http://www.nabble.com/Experiences-with-Oracle-Spatial-tf2047988.html#a5644524
Sent from the OSGeo MapGuide forum at Nabble.com.