AnsweredAssumed Answered

SQL View to sanitize geometrycollections

Question asked by amarsden on May 16, 2017
Latest reply on May 17, 2017 by amarsden

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

Outcomes