Skip to main content
  • EN

Hello everyone,

This question has been asked before, but for some reason using the following transformers mentioned in the following post  (Geometrypartextractor > GeometryFilter > Chopper) didn't help me to split certain shapes into lines and arcs respectively. 

The situation is as follows for me: I read a dgn file (thus a CAD format) in FME in which I have exploded cells. Then I do some transforming on the data in fme before writing to a table in a database. The final step is that I use GeoServer to look on the table i which I have created in order to create a WMS. However in Geoserver, I get the following error: “ORA-13346: the coordinates defining an arc are collinear.".

In my dgn, I have the following kind of shapes and I think these shapes are the causes of this error. So, I am now trying to split  specifically those shapes with arcs and lines into separate lines and arcs. Unfortunately, that didn't work for me yet. I hope someone can nudge me in the right direction. As you can also see in the image below, I have shapes in shapes as well, since the cells in the dgn file consist of several shapes. So maybe that might also be the cause of this error, but I am not sure about that. 

 

 

Have you checked that the geometry is valid? Given the error you are getting that is what I would check first.

@ebygomm I haven't used the geometryvalidator, but I used the following function in the database for a sample size that consists of several shapes and I discovered that problems lie with the inner circle.

SELECT Q__ULID
FROM  TABLENAME
WHERE SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(GEOMETRIE, 0.1) = '13346';


When I delete this innercircel in the dgn, then I don't have this error anymore, Do you know by any chance a transformer that deletes the inner circle

 



 

Hi @joy, you can try using either the DonutBuilder or DonutHoleExtractor to remove your innermost circle. I’d suggest trying the DonutBuilder first as that would clip your larger circle by the smaller circle. I hope this helps!

Reply


Community Stats

30,351
Posts
115,341
Replies
38,082
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.