topic Re: Help With Spatial Views in Oracle in Developers Questions

Help With Spatial Views in Oracle

DavidYamamoto — Wed, 17 Jun 2015 22:13:46 GMT

Hello Kind People. I'm trying to create a database view in Oracle, joining polygon feature class in the geodatabase to an attribute table. I'm using the ArcCatalog tool Data Management Tools --> General --> Create Database View. I specify all of the input parameters, including the SQL to define the view. I'm including the OBJECTID and SHAPE field from the feature class. The tool runs fine, but when I look at the view in Catalog, it's just a data table. The SHAPE column is of type LONG. I thought I should be able to load the view up in ArcMap and see the geometries. Am I misssing something here? Than you very much in advance for any and all assistance. David

Re: Help With Spatial Views in Oracle

SamuelTompsett — Wed, 17 Jun 2015 23:49:04 GMT

Hi David,

Can you provide more information about the polygon feature class? What is the geometry storage type of the feature class?

Can you right click on the database connection and create a new view?

-Sam

Re: Help With Spatial Views in Oracle

DavidYamamoto — Thu, 18 Jun 2015 00:03:17 GMT

Hell Samuel. Thank you for your help. Yes, I am able to right click on the database connection in ArcCatalog and create a view. However, when I look at the created view in ArcCatalog it appers as a simple data table, not a polygon feature. When I look at the field type of the polygon feature in ArcCatalog I see that it is of type "Geometry". But if I look at the table in Oracle SQL Developer, the SHAPE column is of data type NUMBER.

Thank you again. David

Re: Help With Spatial Views in Oracle

SamuelTompsett — Thu, 18 Jun 2015 14:04:19 GMT

Hi David,

Please go to the properties of the feature class in ArcCatalog, particularly the General tab.

You will see a section called Geometry Properties. What does the Storage part say?

The reason I ask is because views created with feature classes in Binary storage, will display strange behavior. We want to make sure the geometry storage for the feature class is either ST_Geometry or SDO_Geometry for Oracle when creating views in ArcCatalog or ArcMap.

-Sam

Re: Help With Spatial Views in Oracle

DavidYamamoto — Thu, 18 Jun 2015 16:32:34 GMT

Hello Samuel. I just went to ArcCatalog and checked the general tab of the properies on the feature class. Under Geometry Properties, it states "Storage: High Precision usning Esri Binary spatial type. Is that the problem? Thank you again for all of your help. David

Re: Help With Spatial Views in Oracle

SamuelTompsett — Thu, 18 Jun 2015 16:39:00 GMT

Hi David,

That is most likely the problem.

What version is the geodatabase?

-Sam

Re: Help With Spatial Views in Oracle

DavidYamamoto — Thu, 18 Jun 2015 16:52:08 GMT

We're running Oracle 11g. Okay, I found this:

Add the ST_Geometry type to an Oracle database—Help | ArcGIS for Desktop

I will follow the steps and see if this fixes the problem. I will let you know if it works. Thank you again.

David

Re: Help With Spatial Views in Oracle

SamuelTompsett — Thu, 18 Jun 2015 16:54:48 GMT

Hi David,

You shouldn't have to do that. You can use either the migrate storage tool, or change the configuration keyword with copy/paste of the feature class.

ArcGIS Desktop

-Sam

Re: Help With Spatial Views in Oracle

DavidYamamoto — Thu, 18 Jun 2015 16:59:44 GMT

Okay, great. I'm glad I don't have to do that. Let me give this a try. David

Re: Help With Spatial Views in Oracle

SamuelTompsett — Thu, 18 Jun 2015 17:03:00 GMT

Also, make sure you have a backup of the database or feature class. Once you move to ST_Geometry, you cannot use the migrate storage to migrate back to Binary.

-Sam

Re: Help With Spatial Views in Oracle

DavidYamamoto — Thu, 18 Jun 2015 17:08:40 GMT

Hi Sam. Okay, will do. By the way, is there a special license level for the Data Management-->Database toolset? I don't see it in Catalog.

Re: Help With Spatial Views in Oracle

DavidYamamoto — Thu, 18 Jun 2015 17:10:30 GMT

I found it! It's different in 10.3

Data Management-->Geodatabase Administrattion-->Mirgrate Storage

Sorry about that.

Re: Help With Spatial Views in Oracle

DavidYamamoto — Thu, 18 Jun 2015 17:29:39 GMT

Hi Sam. I used the Migrate Storage tool to change the geometry storage type, created the view, AND IT WORKED! You've been very helpful. I can't thank you enough. David

Re: Help With Spatial Views in Oracle

SamuelTompsett — Thu, 18 Jun 2015 17:32:25 GMT

You are very welcome. Please mark this thread as answered.

Have a good day!

-Sam