Skip to main content
Solved

write multicurve/multisurface into GPKG error


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

david_r wrote:

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

Try this:

image

View original
Did this help you find an answer to your question?

14 replies

david_r
Evangelist
  • 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
Evangelist
  • June 27, 2022
viviancfhung wrote:

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
Evangelist
  • June 27, 2022
viviancfhung wrote:

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
david_r wrote:

Thanks


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

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
david_r wrote:

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
Evangelist
  • Best Answer
  • June 30, 2022
david_r wrote:

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
david_r wrote:

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
david_r wrote:

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
Evangelist
  • July 5, 2022
david_r wrote:

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
david_r wrote:

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 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings