12-08-2017 06:42 AM
I started using GeoMedia Desktop 2016 with PostGIS data server.
My initial data was in shape files. I have used two mechanisms to import data into PostGIS database
After import data in PostGIS database I have realised following things
“Could not commit changes to layer drp
Errors: ERROR: 1 feature(s) not added.
Provider errors: PostGIS error while adding features: ERROR: Column has Z dimension but geometry does not”
I am wondering if there is any way to use PostGIS database with both GeoMedia and QGIS for inserting and editing features in existing feature classes.
Thank you all in advance.
12-08-2017 07:47 AM
I would suggest you to create GeoMedia metadata using Database Utilities after you import the data using DBF loader. This might work.
12-08-2017 02:30 PM
The feature tables loaded using DBFloader will need to be configured for GeoMedia use by adding another Geometry column such as Geometry_GM of type Bytea; then proceed to database utilities and use the Geometry tab to define the Geometry Type, the Native Geometry field. The Primary Geometry Field should be auto populated by the GeoMedia binary geometry field.
It may be that spatial geometry written by the postgis shapefile import extension/tool is written as 2D. You might try the following SQL to force 2D geometry to 3D, populating the Z values with a zero. In this case we have an area feature class called "structures" with a spatial geometry column named "geom".
ALTER TABLE structures
ALTER COLUMN geom TYPE geometry(MultiPolygonZ)