[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