- Home
- :
- All Communities
- :
- Products
- :
- ArcGIS Enterprise
- :
- ArcGIS Enterprise Ideas
- :
- Improve the docs: How to "Convert ST_POINT subtype...
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Follow this Idea
- Printer Friendly Page
- Report Inappropriate Content
Improve the docs: How to "Convert ST_POINT subtype to ST_GEOMETRY supertype"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Regarding technical article #000011333:
Workaround:
Convert the geometry attribute field from the subtype (for example, st_point) to the supertype st_geometry.
The docs say we should convert the ST_POINT subtype to ST_GEOMETRY supertype. But they don't say how to make the conversion.
The only way I've found so far is to convert to WKB or WKT and then back to ST_GEOMETRY:
--This works, but is clunky and slow:
sde.st_geomfromwkb(sde.st_asbinary(...)).
Is that how Esri recommends we make the conversion? It would help if Esri could explicitly tell us what is meant there. Thanks.
Note:
I've tried using the TREAT() function too. But that didn't seem to work properly:
Stack Overflow: Convert UDT subtype to supertype
Related: Convert MDSYS.ST_LINESTRING subtype value to MDSYS.ST_GEOMETRY supertype
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.