[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