[postgis-users] Using PosGIS in one dimension
Alvaro Tejero Cantero
alvaro at minin.es
Wed Apr 25 07:52:52 PDT 2012
I am interested in using some of the spatial operators to implement
the interval algebra operations  in one dimension.
My application is tagging of intervals in neurophysiological
recordings, a little bit similar to what people do in genomics.
I would like to know if it is possible, and whether PostGIS is also
optimized for this scenario. A typical query is to retrieve all
intervals of type A that are enclosed in intervals of type B.
A few quick queries didn't return anything, and what I found about the
INTERVAL datatype in Postgres didn't fit our scenario so well,
because they are using DATETIMEs and we need to use integer timestamps
(4-byte integers are enough), as we are sampling time at 20000Hz.
Any comments are appreciated.
More information about the postgis-users