[postgis-tickets] [PostGIS] #3013: Dimension-based geometry column constraints

PostGIS trac at osgeo.org
Tue Jan 13 02:31:22 PST 2015


#3013: Dimension-based geometry column constraints
-------------------------+--------------------------------------------------
 Reporter:  mpd          |       Owner:  pramsey
     Type:  enhancement  |      Status:  new    
 Priority:  low          |   Milestone:         
Component:  postgis      |     Version:  trunk  
 Keywords:               |  
-------------------------+--------------------------------------------------
 Geometry column constraints are type-based, eg POINT, LINESTRING, POLYGON.

 In the case of an awful lot of polygonal (dimension==2) data this makes it
 necessary to use GEOMETRY (because so much data contains MULTIPOLYGONS as
 well as POLYGONS, eg any dataset of the countries of the world).

 If the type constraints could also, optionally, be dimension==0 (ie POINT
 or MULTIPOINT), dimension==1 (ie LINESTRING or MULTILINESTRING) or
 dimension==2 (ie POLYGON or MULTIPOLYGON), then GEOMETRY would not have to
 be used so frequently.

 Newer geometry types could also be added to the relevant constraint, eg
 CURVEPOLYGON to dimension==2, TIN to dimension==3, etc.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3013>
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-tickets mailing list