[postgis-devel] [PostGIS] #555: Ability to define a geometry column as Polyhedral surface

[PostGIS]

#555: Ability to define a geometry column as Polyhedral surface
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 Olivier,

 I'm sure you are aware of these, but though I would itemize them as I come
 across so we don't forget.


 {{{
 CREATE TABLE pgis_garden (gid serial);
 SELECT
 AddGeometryColumn('pgis_garden','the_geom',ST_SRID(the_geom),GeometryType(the_geom),ST_CoordDim(the_geom))
                         FROM ((SELECT ST_GeomFromEWKT(
 'SRID=0;PolyhedralSurface(
 ((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),
 ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0
 0)),  ((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),
 ((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)),  ((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0
 1))
 )') As the_geom) ) As foo limit 1;

 }}}

 gives error:


 {{{
 ERROR:  Invalid type name - valid ones are:
 }}}


 {{{
 SELECT GeometryType(the_geom), ST_GeometryType(the_geom)
                         FROM ((SELECT ST_GeomFromEWKT(
 'SRID=0;PolyhedralSurface(
 ((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),
 ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0
 0)),  ((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),
 ((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)),  ((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0
 1))
 )') As the_geom) ) As foo limit 1;
 }}}


 Gives 'Unknown' for GeometryType and ST_PolyhedralSurface for
 ST_GeometryType.  You think we should allow GeometryType to return
 POLYHEDRALSURFACE ?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/555>
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.