Brian,
st_distancesphere does not exists, indeed (neither one with double pp in
'spphere').
You could try distance_sphere(geom, geom) instead.
Seems like there is not ST_ version (yet).
gl
Brian Hamlin wrote:
Hi All-
I wanted to try the Spheroid distance function on some choice city
centroids..
but, the query is not working
geometry_columns says: t
f_table_name worldcities ; the_geom | 2 | 4326 | POINT
I can say for example
select the-geom from worldcties where city = 'fresno' and region =
'ca';
but, when I combine it as in
select st_distancespphere(
(select the-geom from worldcities where city = 'fresno' and region =
'ca'),
(select the-geom from worldcities where city = 'chico' and region =
'ca') );
error; function st_distancesphere(geometry, geometry) does not exist
adding a cast to type ::POINT says
cannot caste type geometry to point
what am I missing?
thanks
-Brian
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
----------------------------------------------------------------
Guido Lemoine
Joint Research Centre, European Commission
Institute for the Protection and Security of the Citizen (IPSC)
Support to External Security
Via E. Fermi, 2749 TP 267 Ispra 21027 (VA), Italy
Tel. +39 0332 786239 (direct line) Fax. +39 0332 785154
WWW: http://ses.jrc.it
----------------------------------------------------------------
Disclaimer:
Views expressed are those of the individual and do not represent
the views of the European Commission
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
