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
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
