topic Re: SQL View to sanitize geometrycollections in Data Management Questions

SQL View to sanitize geometrycollections

AdrianMarsden — Tue, 16 May 2017 15:09:22 GMT

We've a third party spatial application that writes into native T-SQL tables. It is happy with records like this;

GEOMETRYCOLLECTION (LINESTRING (315271.762 90124.145, 315271.812 90124.195), POLYGON ((315276.18 90120.38, 315275.05 90111.07, 315280.15 90110.42, 315279.36 90103.58, 315271.65 90104.25, 315267.35 90104.62, 315267.319 90104.625, 315267.681 90107.209, 315268.95 90117.12, 315272.94 90116.62, 315273.32 90118.96, 315270.73 90119.4, 315270.91 90120.92, 315271.36 90124.08, 315276.432 90123.633, 315276.18 90120.38)))

Anyone who has only ever used Esri products will, like me, be twitching at this mixing up stuff in a single record.

Anyone have any SQL views or procedures to sanitize these records into a format that sane GIS products can cope with?

Cheers

ACM

Re: SQL View to sanitize geometrycollections

JoshuaBixby — Tue, 16 May 2017 16:37:01 GMT

Splitting Multi Geometries into single geometries | Alastair Aitchison

Re: SQL View to sanitize geometrycollections

JoshuaBixby — Tue, 16 May 2017 16:37:39 GMT

This may have gotten more visibility in the https://community.esri.com/groups/geodatabase?sr=search&searchId=ef4987b4-fd9f-4abd-8337-9a1bd9a26383&searchIndex=0‌ space.

Re: SQL View to sanitize geometrycollections

AdrianMarsden — Wed, 17 May 2017 11:37:55 GMT

Odd - i tried that yesterday, but gave up when the results looked like "0x346......." rather than "POLYGON(1234,.....)

But I saved the view and flung it at ArcMap and it worked.

Thanks