topic Re: Calculating AREA and LENGTH Fields in SDO in Data Management Questions

Calculating AREA and LENGTH Fields in SDO

CMcDonald — Fri, 25 Mar 2011 15:45:36 GMT

Hi folks,

I have my users setup with editable access using File GeoDatabases. When they are finished I pull the data into Oracle which is setup in SDO Geometry in order to be open for our third parties.

The problem is that these reserved fields with there auto calculations are lost :(. Is there a way I can get the values in? Perhaps by creating a couple of new fields in the FGDB which will auto calculate also and I can then pull into Oracle.

Thanks 😉

Chris

Re: Calculating AREA and LENGTH Fields in SDO

JakeSkinner — Wed, 30 Mar 2011 15:30:46 GMT

I would recommend using a different storage type, such as ST_GEOMETRY, if you are not querying the data outside of ArcGIS or if no other application is dependent on this data type. Or you can query the Area and Length through SQL*PLUS:

http://resources.arcgis.com/content/kbase?fa=articleShow&d=27329

Re: Calculating AREA and LENGTH Fields in SDO

CMcDonald — Thu, 31 Mar 2011 07:03:00 GMT

Unfortunately we have to store our data in SDO Geometry as we have a few third party apps that read our Oracle data directly.

Re: Calculating AREA and LENGTH Fields in SDO

OvidioRivero — Mon, 04 Apr 2011 19:54:49 GMT

I also prefer ST_GEOMETRY but if you must use SDO_Geometry you could write a trigger that fires on insert or update and populate the fields.

You may want to look at these Oracle functions in the documentation:
SDO_GEOM.SDO_AREA
SDO_GEOM.SDO_LENGTH

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28400/sdo_objgeom.htm#insertedID0

Also remember that if your data is versioned you have to write the trigger on the the ADDS table too or have some code that covers both the ADDS table and business table.

If you are loading data in Oracle and are not editing it you could just run an update statement once to populate the columns.

Ovidio