Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
diegobormann
Partner - Contributor II
Partner - Contributor II

Multiplygon in WKT string error Malformed POLYGON

Hi All,

I am trying to load a file with mixed polygon en multipolygon string, for example this:

MULTIPOLYGON (((118462.014262774 523525.500466823,118505.043155173 523523.74021227,118505.466187813 523526.17750229,118462.014262774 523525.500466823)),((118065.66470074 524913.991069003,118067.497318595 524867.153577111,118061.944957043 524947.575987283,118065.66470074 524913.991069003),(117502.84570334 524872.498581894,117493.297684833 524851.440027772,117583.150547387 524895.692966491,117502.84570334 524872.498581894)),((118822.800868181 525680.233662053,118836.006563487 525686.879251603,118805.274007681 525724.800658573,118822.800868181 525680.233662053)))

When I am trying to load this using the GEO connector I get the following error:

Connector reply error: QVX_SYNTAX_ERROR: *Failed to process query: Failed to create dataset Gebied_dim: Malformed POLYGON geometry: MULTIPOLYGON (((118462.014262774 523525.500466823,118505.043155173 523523.74021227,118505.466187813 523526.17750229,118462.014262774 523525.500466823)),((118065.66470074 524913.991069003,118067.497318595 524867.153577111,118061.944957043 524947.575987283,118065.66470074 524913.991069003),(117502.84570334 524872.498581894,117493.297684833 524851.440027772,117583.150547387 524895.692966491,117502.84570334 524872.498581894)),((118822.800868181 525680.233662053,118836.006563487 525686.879251603,118805.274007681 525724.800658573,118822.800868181 525680.233662053)))
 
I know it is possible with shape files but I would expect MULTIPOLYGON also to work using WKT, anyone?
PS: crs='EPSG:28992'
 
Kind Regards,
Diego
Labels (1)
1 Solution

Accepted Solutions
Patric_Nordstrom
Employee
Employee

Hi,

I had look at the data and I can confirm it's bug, will be fixed in the next release.

Meanwhile the workaround is to set the the CRS to EPSG:4326 when running the connector and afterwards replace EPSG:4326 EPSG:28992 in the generated code. After that the data can be loaded correctly.

 

Thanks,

Patric

View solution in original post

5 Replies
Patric_Nordstrom
Employee
Employee

Have you tried loading the shape in another tool like QGIS?

If the geometry is broken it can't be loaded in to QGA.

Thanks,

Patric

diegobormann
Partner - Contributor II
Partner - Contributor II
Author

Hi,

Yes QGIS works just fine. Thank you for the response! I think multipolygon in WKT is just supported.

Thanks again!
Patric_Nordstrom
Employee
Employee

Hi,

I had look at the data and I can confirm it's bug, will be fixed in the next release.

Meanwhile the workaround is to set the the CRS to EPSG:4326 when running the connector and afterwards replace EPSG:4326 EPSG:28992 in the generated code. After that the data can be loaded correctly.

 

Thanks,

Patric

IgorSh
Partner - Contributor
Partner - Contributor

Hi, similar problem, but this solution doesn't help.

Erorr code:

The following error occurred: Connector reply error: QVX_TABLE_NOT_FOUND: Failed to create dataset Enclosing: Malformed POLYGON geometry:

KallePersson
Employee
Employee

Hi @IgorSh ,

Would it be possible for you to share the file that fails (or if you know which specific polygon that fails, just that one) with me and I can take a look at what the issue is.