[postgis-devel] [PostGIS] #1329: Change BOX3D to be SRID and dimension aware

PostGIS trac at osgeo.org
Fri Dec 16 06:09:01 PST 2011


#1329: Change BOX3D to be SRID and dimension aware
-------------------------+--------------------------------------------------
 Reporter:  robe         |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  blocker      |   Milestone:  PostGIS 2.0.0
Component:  postgis      |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by strk):

 If it's just for me that we have to make this change I'll need to double
 check my priorities :)

 Seriously my whole idea here was to simplify BOXes for use with BOX
 oriented operations, since we have a few. Mostly extent and operators and
 indices.

 The idea is to make it transparent for client code that goes:

 {{{
   CREATE INDEX mytable_spatial_index on mytable (<somecolumn>);
   SELECT * FROM mytable WHERE <somecolumn> && ST_MakeEnvelope(...);
   SELECT * FROM mytable WHERE <somecolumn> && ST_SetSRID'BOX(...)'; --
 legacy
 }}}

 The above with <somecolumn> possibly being of type GEOMETRY or GEOGRAPHY
 or RASTER or TOPOGEOMETRY.

 Did anyone already research on this topic and has conclusions about it ?
 Or I'd spend some time on it.

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