[postgis-devel] [PostGIS] #1039: ST_Distance_Spheroid gives gbox_overlaps: geometries have mismatched dimensionality

PostGIS trac at osgeo.org
Mon Jun 20 02:02:04 PDT 2011


#1039: ST_Distance_Spheroid gives gbox_overlaps: geometries have mismatched
dimensionality
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 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.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1039>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list