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

 



 

Reply


Community Stats

29,979
Posts
113,899
Replies
37,610
Members
Terms & ConditionsCookie settings