[postgis-users] ST_FromBinary not expected

[Bjornar Skinnes]

thank you :)  Basically means I'll stick with the WKT reading from the
oracle if I need something at least close to std ;)

man. 31. aug. 2020 kl. 18:44 skrev Paul Ramsey <pramsey at cleverelephant.ca>:

> Oracle uses non-standary WKB type numbers for curves.
>
> https://docs.oracle.com/cd/B19306_01/appdev.102/b14373/constant-values.html
>
> Instead of the preamble looking liks this (hex WKB)
>
> 00 - big endian
> 00000009 - compound curve
> 00000007 - 7 elements
> 00 - big endian
> 00000002 - linestring
> 00000002 - two vertices
> ...etc...
>
> it looks like this
>
> 00 - big endian
> 000f4242 - 1000002, the oracle number for compound curve
> 00000007 - 7 elements
> - wait, missing the endian flag, so not propertly recursive???
> 00000002 - linestring
> 00000002 - two vertices
> ...etc...
>
> So the Oracle thing is just radically non-standard.
> I'm concerned that PostGIS doesn't yell loudly when fed that content
> though, since the type number is so very wrong.
>
> P
>
> > On Aug 31, 2020, at 6:32 AM, Bjornar Skinnes <
> bjornar_skinnes at trimble.com> wrote:
> >
> > ORACLE:
> >
> > SELECT
> > SDO_UTIL.TO_WKTGEOMETRY(
> > SDO_UTIL.FROM_WKBGEOMETRY( utl_encode.base64_decode( utl_raw.cast_to_raw(
> > 'AAAPQkIAAAAHAAAAAgAAAAJAuSqxaGHpKUDWw+D1vl2eQLoaUGI9C/pA1u9vKwIM
> > SgAPQkEAAAADQLoaUGI9C/pA1u9vKwIMSkC6HrsUzOUkQNbwSP7Se+xAuiLzdKuj
> > h0DW8TI9bHIZAAAAAgAAAAJAuiLzdKujh0DW8TI9bHIZQLpXJeNDMNdA1v0dwo9c
> > KQAPQkEAAAAnQLpXJeNDMNdA1v0dwo9cKUC6WybbyQ4ZQNb+BKY8A89Aul8c7YCh
> > e0DW/u6HJtBOQLpk+rFrJEpA1wBUU5HjCEC6arpeJHiFQNcBwdsenydAunBb6JKT
> > JUDXAzhOLRnaQLp12RZ2ZApA1wS3S8an8EC6ezEgsDl7QNcGP+biTj1AuoBd86V+
> > qkDXB9Gp++dtQLqA3EPQVPFA1wf5K2Vt2UC6gVocm0E6QNcIIMSXdCVAuoYEjAQb
> > VEDXCY3zcGUYQLqKhmZVn29A1wsDMy8BdUC6kpqGPzW/QNcN3SxRP81AupoMCCBf
> > 8kDXENJN0vGqQLqeHJ9RoWBA1xKaMibdEUC6ofU/bCaaQNcUacq8UVVAuqWXUucS
> > MEDXFj+9C9L0QLqpBeNDMNdA1xgb1wo9cUC6rEJbEIK0QNcZ/MAJx1JAuq9QYj0L
> > +kDXG+J++dsjQLqxV0BKwU1A1x03hf6ZjEC6s0o9X9zfQNcejmZiNKhAurZqQ8g0
> > 40DXIRcKU1/9QLq5Tpd8iOhA1yOkGI9C/0C6u1/Fd+ZDQNclmlZmwjRAur1T974S
> > H0DXJ5Jul41QQLq/LNcIRnVA1ymKdTRLU0C6wO8ajvd/QNcrg8an755AusKcb6yn
> > OkDXLXyaShfnQLrEOZmI0qJA1y92RZ2ZA0C6xciwGLncQNcxbv7SdDFAusdOFGoa
> > UEDXM2gxJul5QLrIy9pTlG5A1zVgHa8r1EC6ykZmVZ9vQNc3WDEm6XlAusq1W5sG
> > g0DXN+yNARO0QLrLJJuVHFxA1ziA5VwPy0C6zcSQv+MyQNc6x73DdrJAutIQYj0L
> > +kDXPORqesgdAAAAAgAAAAJAutIQYj0L+kDXPORqesgdQLrfhqfe1rtA10IyXjU/
> > fQAPQkEAAAAFQLrfhqfe1rtA10IyXjU/fUC66RUfs2M1QNdHOKu8CEJAuuj4k2P1
> > c0DXTMj1vl2eQLrnxFDOkblA107FGgOkQ0C659N0q6OHQNdQxwo9cKQAAAACAAAA
> > A0C659N0q6OHQNdQxwo9cKRAuvscKOT7mEDXW+2yKNyYQLsk07Y02tNA12xBJuVH
> > Fw=='
> > )))) FROM DUAL;
> >
> > Give as expected:
> > COMPOUNDCURVE (LINESTRING (6442.692999 23311.514999, 6682.313999
> 23485.737), CIRCULARSTRING (6682.313999 23485.737, 6686.73078613848
> 23489.140553113, 6690.950999 23492.784999), LINESTRING (6690.950999
> 23492.784999, 6743.147999 23540.465), CIRCULARSTRING (6743.147999
> 23540.465, 6747.15179115862 23544.0726461446, 6751.112999 23547.726999,
> 6756.97926969181 23553.3176007001, 6762.727999 23559.028999,
> 6768.3590175256 23564.8797714951, 6773.847999 23570.864, 6779.19190503505
> 23576.9984670414, 6784.366999 23583.276, 6784.86040975641 23583.8932736943,
> 6785.351999 23584.511999, 6790.01776147525 23590.21798334, 6794.524999
> 23596.049999, 6802.60361094534 23607.4558299182, 6810.046999 23619.286,
> 6814.11180601301 23626.4093110236, 6817.957999 23633.652999,
> 6821.59110874361 23640.9959134636, 6825.022999 23648.435, 6828.25920203391
> 23655.9492210814, 6831.313999 23663.539, 6833.34082476825 23668.8675533771,
> 6835.289999 23674.224999, 6838.41509677211 23684.3600052297, 6841.306999
> 23694.563999, 6843.37410687801 23702.411523523, 6845.327999 23710.288,
> 6847.17515613289 23718.1634035812, 6848.933999 23726.059, 6850.61107901652
> 23733.9469170793, 6852.224999 23741.847999, 6853.78393702066
> 23749.7343031058, 6855.304999 23757.628, 6856.79630014776 23765.5018117836,
> 6858.274999 23773.378, 6858.70842904004 23775.6961062138, 6859.142999
> 23778.013999, 6861.76783370301 23787.1209572467, 6866.063999 23795.568999),
> LINESTRING (6866.063999 23795.568999, 6879.525999 23816.787),
> CIRCULARSTRING (6879.525999 23816.787, 6889.08251496479 23836.8854818421,
> 6888.970999 23859.139999, 6887.76685801561 23867.0797127823, 6887.825999
> 23875.11), LINESTRING (6887.825999 23875.11, 6907.109999 23919.713999,
> 6948.826999 23985.017999))
> >
> > In postgres / postgis however:
> > Select
> ST_AsText(ST_GeomFromEWKB(ST_AsBinary(ST_GeomFromEWKB(decode('AAAPQkIAAAAHAAAAAgAAAAJAuSqxaGHpKUDWw+D1vl2eQLoaUGI9C/pA1u9vKwIM
> > SgAPQkEAAAADQLoaUGI9C/pA1u9vKwIMSkC6HrsUzOUkQNbwSP7Se+xAuiLzdKuj
> > h0DW8TI9bHIZAAAAAgAAAAJAuiLzdKujh0DW8TI9bHIZQLpXJeNDMNdA1v0dwo9c
> > KQAPQkEAAAAnQLpXJeNDMNdA1v0dwo9cKUC6WybbyQ4ZQNb+BKY8A89Aul8c7YCh
> > e0DW/u6HJtBOQLpk+rFrJEpA1wBUU5HjCEC6arpeJHiFQNcBwdsenydAunBb6JKT
> > JUDXAzhOLRnaQLp12RZ2ZApA1wS3S8an8EC6ezEgsDl7QNcGP+biTj1AuoBd86V+
> > qkDXB9Gp++dtQLqA3EPQVPFA1wf5K2Vt2UC6gVocm0E6QNcIIMSXdCVAuoYEjAQb
> > VEDXCY3zcGUYQLqKhmZVn29A1wsDMy8BdUC6kpqGPzW/QNcN3SxRP81AupoMCCBf
> > 8kDXENJN0vGqQLqeHJ9RoWBA1xKaMibdEUC6ofU/bCaaQNcUacq8UVVAuqWXUucS
> > MEDXFj+9C9L0QLqpBeNDMNdA1xgb1wo9cUC6rEJbEIK0QNcZ/MAJx1JAuq9QYj0L
> > +kDXG+J++dsjQLqxV0BKwU1A1x03hf6ZjEC6s0o9X9zfQNcejmZiNKhAurZqQ8g0
> > 40DXIRcKU1/9QLq5Tpd8iOhA1yOkGI9C/0C6u1/Fd+ZDQNclmlZmwjRAur1T974S
> > H0DXJ5Jul41QQLq/LNcIRnVA1ymKdTRLU0C6wO8ajvd/QNcrg8an755AusKcb6yn
> > OkDXLXyaShfnQLrEOZmI0qJA1y92RZ2ZA0C6xciwGLncQNcxbv7SdDFAusdOFGoa
> > UEDXM2gxJul5QLrIy9pTlG5A1zVgHa8r1EC6ykZmVZ9vQNc3WDEm6XlAusq1W5sG
> > g0DXN+yNARO0QLrLJJuVHFxA1ziA5VwPy0C6zcSQv+MyQNc6x73DdrJAutIQYj0L
> > +kDXPORqesgdAAAAAgAAAAJAutIQYj0L+kDXPORqesgdQLrfhqfe1rtA10IyXjU/
> > fQAPQkEAAAAFQLrfhqfe1rtA10IyXjU/fUC66RUfs2M1QNdHOKu8CEJAuuj4k2P1
> > c0DXTMj1vl2eQLrnxFDOkblA107FGgOkQ0C659N0q6OHQNdQxwo9cKQAAAACAAAA
> > A0C659N0q6OHQNdQxwo9cKRAuvscKOT7mEDXW+2yKNyYQLsk07Y02tNA12xBJuVH
> > Fw==', 'base64')))));
> >
> > Gives something weird:
> > LINESTRING(0 6442.692999,23311.514999 6682.313999,23485.737
> 0,6682.313999 23485.737,6686.73078613848 23489.140553113,6690.950999
> 23492.784999,0 6690.950999)
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200831/1899465e/attachment.html>