[postgis-users] Spheroid Question

Dan Phillips danp at americanclearinghouse.com
Thu Jun 23 13:55:42 PDT 2005


I'm a PostGIS newbie & would really appreciate some help. I'm taking my
first stab at some basic sql and have hit a wall. The code below generates
the error "SPHEROID parser - doesnt start with SPHEROID"


SELECT
  CRID,
  distance_spheroid(centroid(the_geom),
  makepoint(-72.607912, 42.058052),
  'spheroid["GRS_1980",6378137,298.257222101]') as distance
FROM crrts
WHERE
  the_geom && expand(makepoint(-72.607912, 42.058052),2000)
  AND distance_spheroid(centroid(the_geom),
  makepoint(-72.607912, 42.058052),
  'spheroid["GRS_1980",6378137,298.257222101]')<2000 ;

Any ideas?

Thanks!

Dan Phillips




More information about the postgis-users mailing list