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

djonio DJonio at miami-airport.com
Wed Apr 1 15:28:05 EDT 2009


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.



More information about the mapguide-users mailing list