span8
span4
span8
span4
I want to transform a Personal Geodatabase to a PostGIS database.In my Personal Geodatabase are Polygons (which also have multi parts).I used an Aggregator Grouped by OBJECTID of the features to create Multipolygons.Unfortunately this resulted in a geometry collection,so I used a GeometryRefiner which was suggested to me,but this only converted the Geometry collection back to Polygons.I also applied a GeometryFilter to check that there are only Areas in the dataset - this is actually true.
So,how can I identify the error?And how can I create Multipolygons so that my transformation will be successful?
Also,when creating the writer,make sure to deselect "Create generic spatial columns",that way you can manually specify the geometry type in the output feature type properties:
An idea to add a parameter on the PostGIS Writer to better handle geometry situations like these has been posted on the Ideas Exchange:
PostGIS Writer: Add option to better manage geometry
Check it out and be sure to up vote it if you think it'll help your 亚搏在线workflows!
this is a bit of a trick in the system as you can only get to it when you first create the writer
once setup it is easy but if you leave it to generic you could end up with anything,我们甚至多面....
What happens if you try to set postgis_type to postgis_multipolyon:
Documentation here:https://docs.亚搏在线safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/postgis/Feature_Representation.htm
What exactly is the error that you're getting?Can you post log here please.
If you use the Aggregator and group by the OBJECTID,it is very probable that no aggregates are generated,as usually the OBJECTID is unique.
In most cases,FME should be able to automaticall convert your geometries to the format expected by PostGIS.Which geometry type is used in your destination table?
© 2019 亚搏在线Safe Software Inc |Legal