topic Re: How to interpret sde.ST_Geometry.POINTS property in Oracle in Geodatabase Questions

How to interpret sde.ST_Geometry.POINTS property in Oracle

AndreaV — Tue, 12 May 2015 10:04:25 GMT

Hi,

I use ArcSDE 10.2 with Oracle 11g and I use ST_Geometry as the default GEOMETRY_STORAGE.

I work in .NET Framework and I use the Oracle Developer Tools (ODT) to create a wrapper for the User Defined-Type (UDT) ST_Geometry. I can read the whole object structure but I don't know how to interpret the binary stream stored in the POINTS property of the ST_GEOMETRY object.

With refer to: ArcGIS Help 10.1, ESRI says that:

"Points: Contains the byte stream of the point coordinates that define the geometry" but no further detail is given.

Is there any documentation about that or anyone knows how to interpret the POINTS property?

Thanks in advance

Andrea

Re: How to interpret sde.ST_Geometry.POINTS property in Oracle

ToddBlanchette — Tue, 12 May 2015 11:29:45 GMT

Is this what you require?

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Re: How to interpret sde.ST_Geometry.POINTS property in Oracle

AndreaV — Tue, 12 May 2015 12:05:02 GMT

Thank you for the answer but ST_GEOMETRY.POINTS is not stored as OGC WKB. POINTS property stores a binary stream of coordinates. The problem is to know how the coordinates are encoded.

Re: How to interpret sde.ST_Geometry.POINTS property in Oracle

VinceAngelo — Tue, 12 May 2015 12:21:13 GMT

The POINTS stream layout is unchanged from 9.2 (when HIGH precision was added), and virtually unchanged since 3.0. There's plenty of older documentation which details the format Using it, however, is not best practice. Instead use the SDE.ST_AsBinary or SDE.ST_AsText accessors, and then you won't be impacted if it does change.

- V

Re: How to interpret sde.ST_Geometry.POINTS property in Oracle

AndreaV — Tue, 12 May 2015 12:42:24 GMT

Thank you, but using SDE.ST_AsBinary or SDE.ST_AsText is not an option because of performance issues,

Can you send me some links to old documentation that describe that format, please?

Thanks

Andrea

Re: How to interpret sde.ST_Geometry.POINTS property in Oracle

MuratKarahan — Mon, 22 May 2017 21:26:42 GMT

Hi Andrea,

If you got the POINTS blob format resource, can you share it ?

Re: How to interpret sde.ST_Geometry.POINTS property in Oracle

SIT_AGSM_VERONA_SPAAGSM_VERONA — Fri, 06 Apr 2018 06:45:50 GMT

Hi all...

I also have a similar problem... please could you post your code for the wrapper?

I tried to develop myself but nothing works fine.

Thanks a lot!

Matteo