id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc 1039,ST_Distance_Spheroid / ST_Distance_Sphere gives gbox_overlaps: geometries have mismatched dimensionality,robe,pramsey,"This works in PostGIS 1.5 and fails in PostGIS 2.0.0 now {{{ SELECT ST_Distance_Spheroid(foo1.the_geom, foo2.the_geom, 'SPHEROID[""GRS_1980"",6378137,298.257222101]') As result, ST_AsText(foo1.the_geom) As ref1_geom, ST_AsText(foo2.the_geom) As ref2_geom FROM ((SELECT ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j*0.05) As the_geom FROM (SELECT a*1.11111111 FROM generate_series(-10,50,10) As a) As i(i) CROSS JOIN generate_series(40,70, 20) As j ORDER BY i, i*j, j)) As foo1 CROSS JOIN ((SELECT geom As the_geom FROM (VALUES ( ST_GeomFromEWKT('SRID=4326;POLYGON((-71.0771 42.3866 1,-71.0767 42.3872 1,-71.0767 42.3863 1,-71.0771 42.3866 1))') ), ( ST_GeomFromEWKT('SRID=4326;POLYGON((-71.0775 42.386 2,-71.0773 42.3863 1.75,-71.0773 42.3859 1.75,-71.0775 42.386 2))') ) ) As g(geom))) As foo2 }}} This works in PostGIS 1.5.3 -- broken now in PostGIS 2.0.0 I haven't isolated it to see which one of the above records is the problem child. It's not all of them. Let me know if you want me to try to distill further. ",defect,closed,medium,PostGIS 2.0.0,postgis,master,fixed,,