Is there any way I can pass this polygon value to attribute/element in correct format so it is saved in SQL database column with geography data type? I know there is an undocumented function AS:PointFromJtsk, which creates a point. Is there similar function for polygons?
On the other hand it should be enough to take the string and store it in the geography column. It is supposed to work out of box. The format looks valid to me.
The input polygon coordinates are in JTSK format. So as a first step it is necessary to convert it to WGS-84 format. So it would be better to create XSL function PolygonFromJtsk - you can reuse Origam.Geo functions. There is a web, where you can test the conversion - https://martin.hinner.info/geo/.
When you insert this coordinates
@washi Our customer agrees with the estimated effort to implement this feature. Please provide me with an estimated implementation date - we are actually in a time pressure from a customer.
This function would be available with 25.5 release, that should be available in the week starting from 5th of May. If this would be an issue, there is still possibility to create separate library that is not dependent on Origam release cycle. It would mean some extra overhead (1-4 hrs) and it wouldn’t be part of the main Origam relaease. It would also have more complicated deployment. You would need to deploy the extra dll and also the extra model package with the definition of the namespace.
I’m confused by the output from S-JTSK->WGS84. After I input the coordinate pairs I get a table with six columns… How exactly should I map that to the polygon coordinates for the given example?
