[mapguide-users] King.Oracle 0.3.2

Haris Kurtagic haris at sl-king.com
Mon Oct 23 21:16:49 EDT 2006


Thank you.

You need to add a row in user_sdo_geom_metadata for viwes also (indexes
are just fine, no need to change them).

You need to run sql like:
INSERT INTO user_SDO_GEOM_METADATA  VALUES ('CURVEPOLYGON',
'GEOM',SDO_DIM_ARRAY(  
    SDO_DIM_ELEMENT('X', -1000000, 1000000, 0.005),
    SDO_DIM_ELEMENT('Y', -1000000, 1000000, 0.005)
     )
,NULL)

Change curvepolygon to your view name and geom to your geometry column
name and cordinates and SRID and  ...  :)


Haris

-----Original Message-----
From: Joel Carranza [mailto:jec at gatekeeper.com] 
Sent: Tuesday, October 24, 2006 3:12 AM
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] King.Oracle 0.3.2


Your my hero Haris,

I got datasets displaying right out of the box with this version. This
includes my Oracle 9.2 instance.  I think that may be the first time
that has ever happened with this new MapGuide :) I will continue to test
and provide you with some more feedback tommorow. 

The biggest issue for me is that my views still aren't being displayed.
Could this be because the spatial index is declared on the underlying
table and not on the view itself? 

Joel


haris kurtagic wrote:
> 
> Hi,
> some new features for King.Oracle 0.3.2 provider: ( wishes coming from

> people testing this provider).
>  
> 1. Support for Oracle 9i
> I have tested querying data and schema creation on 9.2 and it works
ok. 
>  
> 2. Support for Geodetic Coordinate system Previous release didn't work

> well with geodetic data.
> I run some test and it seems it is working ok now. 
> Uses optimized rectangle for envelope queries, so it should work even 
> for whole earth queries.
>  
> 3. Spatial tables which have geometry column registered in 
> sdo_geom_metadata with "." in name will be skipped.
> Geometry can come from function so it is registered with "." in name.
> Dot is not allowed in FDO xml schema names.
> This is temporary workaround.
>  
> Get it here: www.sl-king.com/fdooracle
>  
>  
> I will soon release version with support for editing of geometries 
> trough fdo provider and that would conclude my first round of
features.
>  
> I would like to ask community for suggestions/whishes what would like 
> to see in this provider.
>  
> If someone can help me in putting some kind of web survey I would 
> appreciate very much.
> Is something like this possible on this ColabNet's or ..?
>  
> Thank you,
> Haris
> 
> 
> 

--
View this message in context:
http://www.nabble.com/King.Oracle-0.3.2-tf2498546.html#a6965381
Sent from the OSGeo MapGuide mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org





More information about the Mapguide_users mailing list