Find ArcSDE resolution

Question

Hi,

I have an existing SDE 9.2 database and I know that ArcSde 9.2 stores coordinates as a positive integer.

I can't find how could I know the resolution and the extent used to create original layer.

Can someone help me ?

Thanks very much,

Olivier

VinceAngelo · Answer

Incorrect coordinate contents is completely unrelated to coordinate reference precision.

Please post a new thread that provides complete details of the OS, database, and application
software versions in use (release, version and service pack level), the geometry storage type,
and how you're generating the coordinates.  I doubt ArcGIS generated that error message,
so specifing your client product is probably important as well.

- V

RamuNallamalli · Answer

Hi Vince,

Thanks alot for replying to my query. In my application, there is a problem in displaying the maps. When i was doing a Map search, for few locations i am getting

Methodname :QuerySDEDataSource : getMapExtent] Error Desc: LINESTRING OR POLY BOUNDARY IS SELF-INTERSECTING. SdeError: -155 SdeErrMsg:  SdeExtErrMssg:  SdeExtErrCode: 0

We assume that the tolerance level at SDE is giving exception. So, please throw some light on this.

Thanks & Regards,
Ramu Nallamalli

VinceAngelo · Answer

A Help search on "HIGH PRECISION" returned the Desktop documentation. If the layer is a simple feature class (and you have the command-line utilities installed), you can use 'sdelayer -o alter -P HIGH':C:\>sdelayer -o alter Error: Table name and spatial column must be specified. Must specify layer parameter for ALTER operation. ArcSDE 10.1 Layer Administration Utility ----------------------------------------------------- sdelayer -o alter -l [-e ] [-M ] [-S ] [-k ] [-i ] [-s ] [-D ] [Spatial_Index] [-L ] [-E {empty | calc | xmin,ymin,xmax,ymax}] [-P HIGH [{-R | [Spatial_Ref_Opts2]}]] [-u ] [-p ] [-N] [-q] Where [Spatial_Ref_Opts2]:= [-x ] [-z ] [-m ] [-G { | file=}] [Spatial_Index] := [-g { | GRID, | AUTOMATIC | NONE | RTREE}] [Grid_Options] := [[,[,]] [,{FULL | SPARSE}]] sdelayer -h sdelayer -? Please note that changing precision has no impact on the accuracy, just the storage size of future geometries. - V