[mapguide-users] RE: King.Oracle 0.3.2

[Haris Kurtagic]

Hi Joel,  
you are completly right.  It is picking up just one's with spatial
index.
I will change it.

Haris

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


All my views are already inserted into USER_SDO_GEOM_METADATA. After a
little investigation, I really think this is linked to what does and
does not have a spatial index.

I have 116 rows in my USER_SDO_GEOM_METADATA table, but only 42
different feature classes are returned when I use the mapagent
GetClasses function. 

The query below lists me all the table in USER_SDO_GEOM_METADATA plus
table/view info, along with presence of a spatial index or primary key.

select count(index_name), count(*) from (SELECT sdo.table_name,
       DECODE ( t.table_name,
		NULL,
		'View',
		'Table' ),
		i.index_name,
		c.constraint_name
  FROM user_sdo_geom_metadata sdo
 LEFT JOIN user_tables t ON  sdo.table_name = t.table_name
  LEFT JOIN  user_constraints  c ON sdo.table_name = c.table_name AND
constraint_type = 'P'
  LEFT JOIN user_indexes i  ON sdo.table_name = i.table_name  AND
index_type='DOMAIN' 
 ORDER BY sdo.table_name)

42 of these have spatial indexes, the rest do not. I even have a table
in here somehow that does not have a spatial index for whatever reason.
If i restrict this query to table/views with spatial indexes, I get
exactly the list of feature classes.

Joel


haris kurtagic wrote:
> 
> 
> 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
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
> 
> 
> 

--
View this message in context:
http://www.nabble.com/King.Oracle-0.3.2-tf2498546.html#a6965711
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