[web2py] Re: ST_Transform in GIS support

2019-03-19 Thread David Orme
So, in addition to st_transform, I would add st_aswkb. This isn't an official Postgis command - it provides a method to bypass the automatic conversion to WKT found in here: https://github.com/web2py/pydal/blob/master/pydal/adapters/base.py#L550 With a suitably modified PostgreRepresenter, that

[web2py] Re: ST_Transform in GIS support

2019-03-19 Thread David Orme
I guess more generally there is an issue with having to do a round trip through WKT to update a record - it loses precision and is there is an explicit warning about using it for passing data: http://postgis.org/docs/ST_AsText.html I don't see any point in altering how the select represents the

[web2py] Re: ST_Transform in GIS support

2019-03-19 Thread Leonel Câmara
That looks great to me! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py