M.App Enterprise Discussions

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 33
Registered: ‎02-02-2018
Accepted Solution

Digitizing Error

Good Day Community,

 

I have encountered a digitizing error which states that i am not using right geometry type when digitizing. I have imported a single polygon and when i use the statement SC.digitize('Buffer', {commands: ['NEWPOLYGON'], startOnLoad: 'NEWPOLYGON'}). It gives me an error in which i have to check my log file.

 

22023: Geometry type (Polygon) does not match column type (MultiPolygon)

 

I will append the error message as well as my log file with an example of the error i am facing.

 

error.JPG

 

As you can see it is a single Polygon

buffererror.JPG

 

sqlerror.JPG

 

I have appended my log file at the bottom of this post.

 

Any help on this matter will be greatly appreciated.

 

Kind Regards,

Hannes

 

 

Highlighted
Staff
Posts: 1,118
Registered: ‎10-18-2015

Re: Digitizing Error

it seems the client is trying to send back a polygon type to the server, while the geometry type is MultiPolygon. Could it be you have changed the type after the import of the vector data into Studio content?

 

You may either convert the geometry type now:

Alter table  table1 alter column geom type geometry (polygon,srid)

or try to remove vector data from content and add it again.

 

HTH,

Stefano

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Highlighted
Contributor
Posts: 33
Registered: ‎02-02-2018

Re: Digitizing Error

Hey Stefano,

 

Thanks for your quick response.

 

I found the solution. I was trying to write a new shapefile to an existing shapefile that has multi polygons. Instead of creating a new table in postgres called 'buffer' and appending the shapefile to that table. 

 

 

Hannes