[indexing] 2d spatial + 1d value in one index?

From: "Martijn Meijers" <w3(at)zw9(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: [indexing] 2d spatial + 1d value in one index?
Date: 2005-11-29 12:03:39
Message-ID: 43195.130.161.233.101.1133265819.squirrel@ssl.zw9.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear list members,

Let me first introduce myself, I'm Martijn and currently doing my master's
thesis research at Delft University (The Netherlands). I am working in the
field of spatial databases and I am going to test, investigate and
implement a data structure which is suitable for on-the-fly generalization
of map data.

I am a proponent of open source software, therefore I'd like to use
PostgreSQL. Another candidate for my research is Oracle. However, I cannot
find any information on PostreSQL if it is capable of creating a spatial
index on 2 dimensional spatial data (on its native geometry types) plus an
extra value, so in the tables there will be something like:

geometry | importance value
-------------------------------------------
line(x1, y1,...,xn, yn) | 5.0
line(x2, y2,...,xn, yn) | 2.0

Is there an (R-tree-like, i.e. reactive) index structure available which
can handle such tuples, so the query optimizer can handle a. geometry
(location in 2D) and b. the other value in one go?

Thanks in advance,

Martijn Meijers
--
MSc student at Delft University of Technology
URL: http://www.gdmc.nl/martijn/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-11-29 12:10:17 Re: postgres log file
Previous Message surabhi.ahuja 2005-11-29 11:05:47 postgres log file