Find ArcSDE resolution

[OlivierOlivier]

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]

All ArcSDE releases have always stored SDEBINARY, SDELOB, and ST_GEOMETRY geometries
with compressed integers. The coordinate reference has always described the parameters
which form the origin and scale factors in the four dimensions available to geometries (plus
the coordinate system, and since 9.2, cluster tolerance). There are many ways to access the
coordref, but the easiest is to use 'sdelayer -o describe_long' and search for "offset", "units",
and "precision" (among others) --

C:\>sdelayer -o describe_long -i ora100 -u staff -p ***** -l census_bg1a,shape
 
ArcSDE 10.0  for Oracle11g Build 775 Fri Sep 17 11:45:27  2010
Layer    Administration Utility
-----------------------------------------------------
Layer Description ....: <None>
Table Owner ..........: STAFF
Table Name ...........: CENSUS_BG1A
Spatial Column .......: SHAPE
Layer Id .............: 14
SRID .................: 5
Auth SRID.............: 4
Minimum Shape Id .....: 1
Offset ...............:
falsex:       -400.000000
falsey:       -400.000000
System Units .........: 1000000000.000000
Z Offset..............:          0.000000
Z Units ..............:          1.000000
Measure Offset .......: <None>
Measure Units ........: <None>
XY Cluster Tolerance .:          0.000000002
Spatial Index ........:
  parameter:    SPIDX_GRID,GRID0=0.21,FULL
  exist:        Yes
  array form:   0.21,0,0
Layer Envelope .......:
  minx:      -179.14734,        miny:       -14.60526
  maxx:       179.77847,        maxy:        71.35256
Entities .............: na+
Layer Type ...........: SDE-LOB
Creation Date ........: 05/24/11 16:11:57
I/O Mode .............: NORMAL
Autolocking ..........: Disabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....: GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
Layer Configuration ..: sdelob

- Vince

[OlivierOlivier]

Thanks very much for your help, Vince!

[RamuNallamalli]

How can i modify the precision from Basic to HIGH?

[VinceAngelo]

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 <table,column> [-e <entity_mask>] [-M <minimum_id>]
                  [-S <layer_description_str>]
                  [-k <config_keyword>] [-i <service>] [-s <server_name>]
                  [-D <database>] [Spatial_Index] [-L <ON | OFF>]
                  [-E {empty | calc | xmin,ymin,xmax,ymax}]
                  [-P HIGH [{-R <SRID> | [Spatial_Ref_Opts2]}]]
                  [-u <DB_User_name>] [-p <DB_User_password>] [-N] [-q]
Where
      [Spatial_Ref_Opts2]:= [-x <xoffset,yoffset,xyscale>]
                            [-z <zoffset,zscale>]  [-m <moffset,mscale>]
                            [-G {<projection_ID> | file=<proj_file_name>}]
      [Spatial_Index]    := [-g {<Grid_Options> |
                                  GRID,<Grid_Options> |
                                  AUTOMATIC |
                                  NONE |
                                  RTREE}]
      [Grid_Options]     := [<grid_sz0>[,<grid_sz1>[,<grid_sz2>]]
                                                   [,{FULL | SPARSE}]]
sdelayer -h
sdelayer -?

Please note that changing precision has no impact on the accuracy, just the
storage size of future geometries.

- V

[RamuNallamalli]

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]

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