[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