[postgis-devel] [PostGIS] #395: Make check errors on Mac - spheroid area - srid 32702

[PostGIS]

#395: Make check errors on Mac - spheroid area - srid 32702
-----------------------+----------------------------------------------------
  Reporter:  colivier  |       Owner:  pramsey                         
      Type:  defect    |      Status:  new                             
  Priority:  medium    |   Milestone:  PostGIS 1.5.0                   
 Component:  postgis   |     Version:  trunk                           
Resolution:            |    Keywords:  Mac regress  spheroid_area 32702
-----------------------+----------------------------------------------------
Comment (by colivier):

 {{{
      the_pt      |       the_area       |              geog_utm_area
 -----------------+----------------------+------------------------------------------
  POINT(-170 -80) | 0.000115919886854499 | POINT(519384.803295972
 1118247.58518847)
  POINT(-170 -70) | 5.82107245751251e-05 | POINT(538169.782260327
 2233813.84855605)
  POINT(-170 -60) | 3.50390659657751e-05 | POINT(555776.26675161
 3348167.26456303)
  POINT(-170 -50) | 2.41302911850039e-05 | POINT(571666.447503441
 4460890.18469981)
  POINT(-170 -40) | 1.70080525747629e-05 | POINT(585360.461842782
 5571763.93536657)
  POINT(-170 -30) | 1.17068806768372e-05 | POINT(596450.152566998
 6680793.77724325)
  POINT(-170 -20) | 7.38417888529463e-06 | POINT(604609.323831738
 7788206.44383463)
  POINT(-170 -10) | 3.57911220325025e-06 | POINT(609600.772514415
 8894421.4108076)
  POINT(-170 10)  | 3.58120134247297e-06 | POINT(609600.772514415
 1105578.5891924)
  POINT(-170 20)  | 7.38386138654512e-06 | POINT(604609.323831738
 2211793.55616537)
 (10 rows)

 foo=# SELECT ST_AsText(the_geog) as the_pt,
 ST_Area(ST_Buffer(the_geog,10)) As the_area,
 ST_AsText(ST_Transform(geometry(the_geog),utm_srid)) As geog_utm_area
 FROM (SELECT geography(ST_SetSRID(ST_Point(i*10,j*10),4326)) As the_geog,
 utmzone(ST_SetSRID(ST_Point(i*10,j*10),4326)) As utm_srid
 FROM generate_series(-17,17) As i
 CROSS JOIN generate_series(-8,8) As j
 ) As foo
 WHERE ST_Area(ST_Buffer(the_geog,10)) NOT between 310 and 314
 LIMIT 10;

 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/395#comment:10>
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.