[postgis-users] 3d index in postgis

Kevin Neufeld kneufeld at refractions.net
Mon Aug 25 14:22:43 PDT 2008


Indexes in PostGIS are 2D only.  In other words, an gist index on a 3D 
geometry column will only use the first 2 dimensions of the geometries 
(equal geometries in 2D, but varying in the 3rd dimension, are treated 
the same).

Having said that, you probably can get 3D index support by way of the 
PostgreSQL module cube.
http://www.postgresql.org/docs/8.3/static/cube.html

searchelite wrote:
> Dear All, is there any 3d-index in postgis? how can i index a table that has
> 3d-coordinate values?
> 
> thanks



More information about the postgis-users mailing list