ST_X function on POSTGIS geography() fields

[libe...@gmail.com]

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

[Ruud Schroen]

I'd like to know this as well. Does anyone have some tips?

[Massimo Di Pierro]

Please open a pydal ticket. I do not think we support this yet but we can add it.

[wish...@gmail.com]

+1 from my side too :-) Was a pydal ticket ever opened?
Otherwise I would do now...

Cheers
Toby

[wish...@gmail.com]

Done: https://github.com/web2py/pydal/issues/298

Cheers
Toby

[DenesL]

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