We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10.
The features can be organized with a tree structure:
Geographic Data(shape,name,address) ImportantFeature(level,classcode....) ImportFeaturePoint ImportFeatureLine ImportFeaturePolygon River RiverLine RiverPolygon Hotel: HotelPoint School SchoolPoint ... ...
And the origin data are created by Esri FileGeotadabase(.gdb), one feature one table(in arcmap), and then these data are exported to Oracle 11g by SDE.
Now we have database tables:
BuildingPoint RiverLine RiverPolygon .....
And we need to query these data by different criteria, for example, we need to query all the geographic data, all the
ImportantFeature data or all the
River no matter the geometry type is point,polyline or polygon.
So I create view to make the features together like:
create view xxView as select shape,name,address from ImportFeaturePoint union all select shape,name,address from ImportFeatureLine .....
However I got a very low performance for this solution, check my last post, so I wonder if there is an alternative way to implement my requirement?