How can I get a human-readable expression of an spoint-object instead of the blob-stuff?
mysql> SELECT spoint( '(10d,20d)' ); +---------------------------------------+ | spoint( '(10d,20d)' ) | +---------------------------------------+ | PHB0PodE50oYV8Y/h0TnShhX1j88dHA+AA== | +---------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT sstr( spoint( '(10d,20d)' )); +-------------------------------+ | sstr( spoint( '(10d,20d)' )) | +-------------------------------+ | (0.1745329252 , 0.3490658504) | +-------------------------------+ 1 row in set (0.01 sec) mysql> SELECT sstr( 'PHB0PodE50oYV8Y/h0TnShhX1j88dHA+AA==' ); +------------------------------------------------+ | sstr( 'PHB0PodE50oYV8Y/h0TnShhX1j88dHA+AA==' ) | +------------------------------------------------+ | (0.1745329252 , 0.3490658504) | +------------------------------------------------+ 1 row in set (0.00 sec)
How can I switch from radians to degree representation of mysql_sphere-objects?
mysql> SET sphere_outmode="DEG";before anything else. If one then prints e.g. a mysql_sphere point (with sstr), the values will be given in degree. Default unit is radians. You can switch back to radians using
mysql> SET sphere_outmode="RAD";One can also swith to degree, arc minute, arc second representation with
mysql> SET sphere_outmode="DMS";Please note that setting sphere_outmode does not affect the output of the distance operator sdist and length/circumference operators slength and scircum. Their results are always in radians (but you can convert this easily to degree using *180/pi() of course).
Is it possible to print a point-point representation of a spherical line-object?