How do you propose to code those functions if they are not available in the DB engine?. MS SQL Server does have functions to extract longitude and latitude data from geography points but PostGIS does not seem to have them.
I can send in a patch for MSSQL with the following extended methods: Lat Long M Z (last two being measure and elevation info) and more functions are available depending on the version of MSSQL. Denes On Wednesday, September 30, 2015 at 4:56:56 PM UTC-4, wish7...@gmail.com wrote: > > Done: https://github.com/web2py/pydal/issues/298 > > Cheers > Toby > > Am Dienstag, 29. September 2015 23:17:37 UTC+2 schrieb wish...@gmail.com: >> >> +1 from my side too :-) Was a pydal ticket ever opened? >> Otherwise I would do now... >> >> Cheers >> Toby >> >> Am Montag, 22. Juni 2015 08:51:59 UTC+2 schrieb Massimo Di Pierro: >>> >>> Please open a pydal ticket. I do not think we support this yet but we >>> can add it. >>> >>> On Wednesday, 23 April 2014 05:44:39 UTC-5, libe...@gmail.com wrote: >>>> >>>> Hi everyone, >>>> I am trying to extract latitude and longitude from a POSTGIS >>>> geography() field. Unfortunately the usual st_x() and st_y() functions >>>> normally used >>>> for geometry() fields won't work. >>>> How can I extract the required values or transform geography in >>>> geometry? >>>> >>>> Thanks >>>> >>> -- 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-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
