Hi
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
Solved! Go to Solution.
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
This may have gotten more visibility in the https://community.esri.com/groups/geodatabase?sr=search&searchId=ef4987b4-fd9f-4abd-8337-9a1bd9a2638... space.