[mapguide-users] KingOra 8.7 - view w/geometry w/out underlingtable

[Haris Kurtagic]

Hm, perhaps spatial index.
If you could trace and see what sql statement are executed and try them
on your own.
If I remember correctly that could be also diff. between how data is
accessed in Map3d and MG.
Haris

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Haris
Kurtagic
Sent: Wednesday, April 01, 2009 9:35 PM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] KingOra 8.7 - view w/geometry w/out
underlingtable

First thing which comes to my mind are extents. Setting correct map
extents in MG.
Map3d will run Select Aggregates to get extents while MG will not.

Haris

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of djonio
Sent: Wednesday, April 01, 2009 9:28 PM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] KingOra 8.7 - view w/geometry w/out underling
table


Haris and/or others,

I have a view based upon the extents found within
"all_sdo_geom_metadata". It constructs the "GEOMETRY" column based upon
the upper and lower bounds found in DIMINFO. A nice rectangular polygon
surface. All is well with the world.
I have added this view to all_sdo_geom_metadata so that KingOra sees it.
All is well with the world. It does see it.

The issue is: none of the geometry gets rendered in MGOS. It does render
just fine w/in Map3d 2008/2009 using the KingOra 8.5 dll's(I have not
installed 8.7 for Map3d as of yet)
I am not sure if this is problem or "just the way it is"? 

CREATE OR REPLACE FORCE VIEW "GISMIA"."VIEW_FCLTY_EXTENTS" ("ID",
"OWNER", "TABLE_NAME", "COLUMN_NAME", "SRID", "XMIN", "YMIN", "XMAX",
"YMAX", "GEOMETRY") AS 
  (
SELECT ROWNUM, XVALS.OWNER OWNER, XVALS.TABLE_NAME TABLE_NAME,
XVALS.COLUMN_NAME, XVALS.SRID SRID,
  XVALS.XMIN XMIN, YVALS.YMIN YMIN, XVALS.XMAX XMAX,YVALS.YMAX YMAX,
MDSYS.SDO_GEOMETRY(2003,XVALS.SRID,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003
,1),MDSYS.SDO_ORDINATE_ARRAY(XVALS.XMIN,YVALS.YMIN,XVALS.XMAX,YVALS.YMIN
,XVALS.XMAX,YVALS.YMAX,XVALS.XMIN,YVALS.YMAX, XVALS.XMIN,YVALS.YMIN))
  FROM
  (SELECT e.sdo_lb as xmin, e.sdo_ub as xmax,
G.TABLE_NAME,G.COLUMN_NAME,G.SRID,G.OWNER from all_Sdo_geom_metadata G,
TABLE(G.diminfo)e WHERE e.sdo_dimname='X' AND g.table_name like
'FCLTY%') XVALS,
  (SELECT e.sdo_lb as ymin, e.sdo_ub as ymax,
G.TABLE_NAME,G.COLUMN_NAME,G.SRID,G.OWNER from all_Sdo_geom_metadata G,
TABLE(G.diminfo)e WHERE e.sdo_dimname='Y' AND g.table_name like
'FCLTY%') YVALS
  WHERE XVALS.TABLE_NAME = YVALS.TABLE_NAME 
    AND XVALS.COLUMN_NAME = YVALS.COLUMN_NAME 
    AND XVALS.OWNER = YVALS.OWNER) ORDER BY OWNER,TABLE_NAME;
 
r,
dennis
-- 
View this message in context:
http://n2.nabble.com/KingOra-8.7---view-w-geometry-w-out-underling-table
-tp2571093p2571093.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users