All ArcSDE releases have always stored SDEBINARY, SDELOB, and ST_GEOMETRY geometrieswith compressed integers. The coordinate reference has always described the parameterswhich form the origin and scale factors in the four dimensions available to geometries (plusthe 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