[Geoserver-users] Projection issues with SDE layers

[mallelaprasanth]

Hi I am a user of Geoserver. I have configured Geo Server with SDE plugin. I
am able to access all my SDE layers. I have successfully published my SDE
layers as well.

[Jody Garnett]

50 m sounds very specific. I would check the data at each stage and look
for a difference in spatial reference system, or the definition of the
spatial reference system between ArcSDE and GeoServer and Google Earth.

You may find http://spatialreference.org useful for checking?

I know in Postgis you can look at table with all the reference system
definitions, is their a similar facility in ArcSDE you could check?

Jody Garnett


On Thu, Mar 6, 2014 at 1:42 AM, mallelaprasanth

Post by mallelaprasanth
Hi I am a user of Geoserver. I have configured Geo Server with SDE plugin. I
am able to access all my SDE layers. I have successfully published my SDE

[Stefano Iacovella]

Post by Jody Garnett
50 m sounds very specific. I would check the data at each stage and look
for a difference in spatial reference system, or the definition of the
spatial reference system between ArcSDE and GeoServer and Google Earth.
You may find http://spatialreference.org useful for checking?
I know in Postgis you can look at table with all the reference system
definitions, is their a similar facility in ArcSDE you could check?

As Jody already pointed out the amount of displacement may be related to
datum shift.

Could you post the output of

sdelayer -o describe_long -l <table_name>,<geom_column_nam>

Cheers

Stefano

---------------------------------------------------
41.95581N 12.52854E


http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas

[mallelaprasanth]

Hi Jody and Stefan,

I got information regarding table from SDE and the table output is

ArcSDE 10.0 for Oracle11g Build 685 Fri May 14 12:05:43 2010
Layer Administration Utility
-----------------------------------------------------
Layer Description ....: <None>
Table Owner ..........: dummy
Table Name ...........: testTable
Spatial Column .......: SHAPE
Layer Id .............: 91
SRID .................: 3
Auth SRID.............: 2
Minimum Shape Id .....: 1
Offset ...............:
falsex: -5423300.000000
falsey: -12407500.000000
System Units .........: 10000.000000
Z Offset..............: 0.000000
Z Units ..............: 1.000000
Measure Offset .......: <None>
Measure Units ........: <None>
XY Cluster Tolerance .: 0.001
Spatial Index ........:
parameter: SPIDX_GRID,GRID0=27000,FULL
exist: Yes
array form: 27000,0,0
Layer Envelope .......:
minx: 209510.67760, miny: 359613.82300
maxx: 240343.70690, maxy: 440212.44500
Entities .............: nslc+
Layer Type ...........: Extended SQL Type/ST_GEOMETRY
Creation Date ........: Thu Dec 19 08:54:33 2013
I/O Mode .............: NORMAL
Autolocking ..........: Enabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....:
PROJCS["QND_1995_Qatar_National_Grid",GEOGCS["GCS_QND_1995",DATUM["D_QND_1995",SPHEROID["International_1924",6378388.0,297.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",200000.0],PARAMETER["False_Northing",300000.0],PARAMETER["Central_Meridian",51.21666666666667],PARAMETER["Scale_Factor",0.99999],PARAMETER["Latitude_Of_Origin",24.45],UNIT["Meter",1.0]]

Layer Configuration ..: DEFAULTS

How to overcome with this datum shift problem. Is datum shift is because of
ESRI or with the GEOSERVER.
Please let me know.

Thanks,
Prasanth.






--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Projection-issues-with-SDE-layers-tp5107681p5107842.html
Sent from the GeoServer - User mailing list archive at Nabble.com.