1

When I want to display the elements stored in a spatial oracle DB, the compound elements aren't display. There is no error message.

The type of these compound elements is "1005".

Are these elements managed by QGIS? Can you suggest me how to display this type of polygon?

I'm using Oracle database 11g (11.2.0.1.0) and QGIS 2.16.0

Improve this question

1 Answer 1

Reset to default
1

The Oracle doc's suggests these are constructed using straight lines and arcs

SDO_ETYPE values 4, 1005, and 2005 considered compound elements. They contain at least one header triplet with a series of triplet values that belong to the compound element. For SDO_ETYPE values 1005 and 2005, the first digit indicates exterior (1) or interior (2):

1005: exterior polygon ring (must be specified in counterclockwise order)

2005: interior polygon ring (must be specified in clockwise order)

Compound polygon with some vertices connected by straight line segments and some by circular arcs. The value, n, in the Interpretation column specifies the number of contiguous subelements that make up the polygon. The next n triplets in the SDO_ELEM_INFO array describe each of these subelements. The subelements can only be of SDO_ETYPE 2. The end point of a subelement is the start point of the next subelement, and it must not be repeated. The start and end points of the polygon must be the same.

See Section 2.3.4 and Figure 2-5 for an example of a geometry using this type.

From the OGR documentation it appears that support for these features is only available since version 2.0. If you go to the help menu and select about it will tell you which version of GDAL/OGR your version was compiled against. If it is less than 2.0 then you will need to upgrade.

Improve this answer
6
  • Thank you for your answer. I have checked the versions in the "about" menu of QGIS. GDAL/OGR version is 2.1.0.
    – LaNf
    Commented Aug 9, 2016 at 15:27
  • can you try ogrinfo from the command line?
    – Ian Turton
    Commented Aug 9, 2016 at 15:42
  • 1
    QGIS has a native oracle provider which is not looped through OGR.
    – Matthias Kuhn
    Commented Aug 9, 2016 at 15:43
  • @MatthiasKuhn - I didn't know that, does it support compound features?
    – Ian Turton
    Commented Aug 9, 2016 at 15:47
  • Probably not I guess it wouldn't be hard to add it if there was somebody interested.
    – Matthias Kuhn
    Commented Aug 9, 2016 at 15:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.