Skip to main content
Solved

write multicurve/multisurface into GPKG error

  • June 16, 2022
  • 14 replies
  • 213 views

viviancfhung
Contributor
Forum|alt.badge.img+1

There are GML/FGDB dataset with "round conner polygon" or multilines geometry which is mixed "curve and lines". It can't be written into GPKG file.

src dataset geometry

image.pngThe output geometry is IFMENull

How can fix it?

Best answer by david_r

Did you try using a generic geometry column in the GeoPackage table? That should work.

Try this:

image

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

14 replies

david_r
Celebrity
  • June 16, 2022

It depends on a few factors, but it should be possible. First make sure to use a generic geometry field on the writer. If you're writing to an existing geopackage with a specific geometry type that excludes arcs, you can insert an ArcStroker just before the writer.

You might also want to try using a GeometryRefiner and possibly also a GeometryValidator (OGC checks) to make sure all geometries are valid.


viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • June 23, 2022

Thanks, I will try


viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • June 24, 2022

After GeometryRefiner, we have point, line , polygon, arc, ellipse, surface ...

I use MULTICURVE to map arc, but

What's Geometry type in GPKG can map ellipse?

What's Geometry type in GPKG for surface?


viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • June 24, 2022

I try to use GeometryValidator (OGC checks), It classify all my MULTICURVE geometries or mixture of MULTILINESTRING and MULTICURVE geometries as failed.

Then how can I fix it


david_r
Celebrity
  • June 27, 2022

After GeometryRefiner, we have point, line , polygon, arc, ellipse, surface ...

I use MULTICURVE to map arc, but

What's Geometry type in GPKG can map ellipse?

What's Geometry type in GPKG for surface?

Ellipses and surfaces aren't supported in a GeoPackage, see https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/ogcgeopackage/quick_facts_ogcgeopackage.htm


david_r
Celebrity
  • June 27, 2022

I try to use GeometryValidator (OGC checks), It classify all my MULTICURVE geometries or mixture of MULTILINESTRING and MULTICURVE geometries as failed.

Then how can I fix it

Did you try using a generic geometry column in the GeoPackage table? That should work.


viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • June 28, 2022

viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • June 29, 2022

Did you try using a generic geometry column in the GeoPackage table? That should work.

I will try, thanks


viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • June 30, 2022

Did you try using a generic geometry column in the GeoPackage table? That should work.

I'm so new for FME. How can I set generic geometry column? Thanks


david_r
Celebrity
  • Best Answer
  • June 30, 2022

Did you try using a generic geometry column in the GeoPackage table? That should work.

Try this:

image


viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • July 4, 2022

Did you try using a generic geometry column in the GeoPackage table? That should work.

Thanks, I will try


viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • July 5, 2022

Did you try using a generic geometry column in the GeoPackage table? That should work.

  1. Is any way can we convert curve into line. convert round polygon into polygon
  2. our FGDB dataset use MULTISURFACE to define round polygon. Can it be translated to GPKG accurately

david_r
Celebrity
  • July 5, 2022

Did you try using a generic geometry column in the GeoPackage table? That should work.

  1. You can use an ArcStroker to convert all the arcs to polyline segments. Sometimes you may also want to add a GeometryRefiner after.
  2. I'm not sure I understand what you mean by "round polygon"... Do you mean an ellipse?

viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • August 2, 2022

Did you try using a generic geometry column in the GeoPackage table? That should work.

Thanks for your help, this setting solve some of my problems. But Now I got this error when use the setting to convert dataset

image...

imageOur geometry Data is this

imagewhat's Non-Cirular Arc.

Is this

image