THREADS - ESRI Discussion Forums

You are here: Home > User Forums > arcgis server forums > Thread Replies

ArcGIS Server Forums

ArcGIS Server ArcSDE: Oracle forum

Storage of Points in ESRI ST_Geometry	omri fima	Nov 07, 2009
Re: Storage of Points in ESRI ST_Geometry	A.J. Romanelli	Nov 09, 2009
Re: Storage of Points in ESRI ST_Geometry	Vince Angelo	Nov 09, 2009

Report Inappropriate Content • Top • Print • Reply
Subject	Storage of Points in ESRI ST_Geometry
Author	omri fima
Date	Nov 07, 2009
Message	beacuse of limitations in my ORM , it is quite complicated to use the transfomation methods, so i thought probably the easiest solution is to read the geometry data directly from the POINTS BLOB. I'm finding it hard to find what is the storage format of the POINTS BLOB inside an ST_GEOMETRY Column. is it Compressed binary? just wkb? or anything else?

Report Inappropriate Content • Top • Print • Reply
Subject	Re: Storage of Points in ESRI ST_Geometry
Author	A.J. Romanelli
Date	Nov 09, 2009
Message	Reading data directly from the points blob isn't supported, you need to access this data from an ESRI interface (the sde api or the st_geometry functions) if you want to work in a supported environment. The st_geometry uses the same sdebinary storage as far as I know (but I wouldn't recommend trying to decode that unless you are willing to put in a large amount of time/effort to something that may change with the next software release).

Report Inappropriate Content • Top • Print • Reply
Subject	Re: Storage of Points in ESRI ST_Geometry
Author	Vince Angelo
Date	Nov 09, 2009
Message	If reading BLOBs is the easiest solution, you've got a pretty hairy environment going. I don't even know if you can access the raw LOB from an ST_GEOMETRY object. - V