AnsweredAssumed Answered

Oracle SQL - Spatial View With Union of Polygon Feature Classes

Question asked by mhmiles on Jul 24, 2014
Latest reply on Nov 12, 2014 by modybsystematics-co-il-esridist

Hi!

 

So at my office I curate a lot of datasets maintained by other (ArcGIS-compatible, but not ArcGIS-using) departments, fed into an Oracle-based SDE, for consumption by all departments in an intranet web mapping system used by all departments and all divisions at my company.

 

One of the groups of data I have contains two feature classes of point data that are functionally very similar, and for an unrelated project it looked like I needed both FCs merged into one FC, so I tried to accomplish this using a union in a Spatial View:

 

(Table names have been changed and some fields removed for anonymity's sake)

 

CREATE OR REPLACE FORCE VIEW POINTS_COMBINED

(OBJECTID, SHAPE)

AS

  SELECT CAST (ROWNUM AS INTEGER) AS OBJECTID, SHAPE

  FROM

  (

  SELECT SHAPE FROM POINTS_1

  UNION ALL

  SELECT SHAPE FROM POINTS_2

  )

  ORDER BY OBJECTID;

This seems to work perfectly - the total number of features in the Spatial View is the same as the sum of the features in the individual FCs.

 

With this, I decided to try the same method with a couple of polygon FCs, but for whatever reason I get the error "Stream Not Found" when I use literally the same SQL statement with the FC names changed to reflect the polygon FCs.

 

Any idea what I'm missing? I've checked the Spatial Reference for both and they're the same, so it's not that, as far as I can tell. Is it possibly just that polygon shape data is more complex than point shape data?

Outcomes