I don't want to alter the geometry, just change the geometry type from Polygon to Multipolygon, in order to comply with a constraint.
FME – Converting Geometry Type from Polygon to Multipolygon
fmegeometry
Related Solutions
Using FME 2013 beta here
read the CAD [DXF] control the geometry - GeometryCoercer (FMEline) control the geometry - Force 2D (2d line only)
Build the Polygons
Output port AREA
Write Shapefile
See Image - as proof of concept.
You are confusing the PostgreSQL polygon geometric type with the PostGIS geometry type. They are are different approaches, and don't normally mix together.
Try converting the bytea to geometry instead:
ALTER TABLE polygon
ALTER COLUMN geom
TYPE geometry
USING geom::geometry;
And if you want to restrict it to just Polygon geometry types with EPSG:4326, use typmods:
ALTER TABLE polygon
ALTER COLUMN geom
TYPE geometry(Polygon,4326)
USING geom::geometry(Polygon,4326);
Related Question
- [GIS] Split a polygon using SqlServer geometry type
- [GIS] OpenLayers 4.2 – Changing the interaction geometry type from polygon to multipolygon
- PostGIS MultiPolygon Conversion – How to Convert from MultiPolygon to Polygon in PostGIS
- Shapefile Geometry – Fix “no such field as `OGR_GEOMETRY'” When Changing Multipolygon to Polygon
- OpenLayers – How to Get the Bigger Polygon of a Multipolygon
Best Answer
You can use
Aggregatortransformer.Be careful what mode you choose. To illustrate, I have 5 polygons in entry. If I choose :
FID), I have 5 unique values so I will keep the 5 geometries.