span8
span4
span8
span4
Whenever I write features into a GeoPackage Table,this table is registered in the GPKG_GEOMETRY_COLUMNS table.FME registers all the tables I create with geometry_type_name: GEOMETRY.I expected that FME would register my table with point features as geometry type POINT,tables with polygon features as POLYGON,etc.,as prescribed in theGeoPackage-specification.Tables registered as GEOMETRY are recognized by QGIS as a feature class with unknown feature type.Which makes sense.
How do I enforce FME to register the correct geometry type for my tables,preferably in a workbench with a dynamic reader (PostGIS) and writer (GeoPackage)?
Wim
It's not a perfect solution,but I made a little workaround that accomplishes what you want to dogeomtypes.zip
Basically,I dynamically write some feature types with various geometry types.Simultaneously I check if only one kind of geometry type was written to each feature type.If so,then I use a SQLExecutor to update the `gpkg_geometry_columns` table for that feature type.
As far as the actual OGC Geopackage Writer supporting this behaviour (writing tables with specific geometry types): we haven't implemented that at this time.However,it's certainly something we could look into.Would you like to create a Knowledge CenterIdeafor writing GeoPackage tables with particular geometry types?
Maybe the example from Dale in this question helps you?writing-geometries-with-geopackage-writer-is-not-possible
Fanout based on attribute in a dynamic feature writer2 Answers
Postgis to geopackage dynamic schema.But how to rename the attributes?1 Answer
Cannot copy tables in PostGIS using dyamic reader and writer3 Answers
PostGIS writer used dynamically: How to reduce schemata?How to set correct geometry types?2 Answers
© 2019 亚搏在线Safe Software Inc |Legal