SDELayer VRS ArcCatalog for controling tolerance and resolution

GlennBald — Tue, 06 Dec 2011 19:25:23 GMT

Ok here is a my problem is:

I need to have a featureclass that has an objectId column called ID(not object ID) and for it to be user controlled(not SDE). I also need it to have a tolerance of 0.002 and xyresolution of 0.001 or 0.0001 (can't remember). Oh and its oracle spatials SDO_GEOMETRY.

I can use Sql to create the table then use sdelayer -o regester then alter to give the correct SRID. However I seem to have no control over the tolerance and resolution. If use ArcCatalog I have no option but to set ObjectId as ObjectID, it seems to automatically register with geodatabase tables.

The table itself is used to store captured data, but will not be editable.

So my questions are:
Whats my options?
Will a tolerance of 0 on a non editable table cause any issues?
Could I perhaps use Export and Import?

Thanks in advance any advice greatly appreciated:

Additional info:
ArcSDE 9.2, Oracle 10g with Oracle spatial on a redhat

Re: SDELayer VRS ArcCatalog for controling tolerance and resolution

VinceAngelo — Tue, 06 Dec 2011 22:48:48 GMT

If the table is effectively read-only, then the tolerance that is only managed by ArcSDE for
the use of ArcGIS is of no consequence. You can, of course, set the tolerance, either by
using the -R parameter to reference an SRID which has one, or by providing a fourth
parameter on the '-x' flag (you should *ALWAYS* specify an '-x' or '-R' when using
'sdelayer -o register'). [At least, I think that was supported as a fourth parameter on
the '-x' flag way back at 9.2; it certainly is supported in recent releases.]

- V

topic SDELayer VRS ArcCatalog for controling tolerance and resolution in Data Management Questions

SDELayer VRS ArcCatalog for controling tolerance and resolution

Re: SDELayer VRS ArcCatalog for controling tolerance and resolution