[postgis-users] Using PosGIS in one dimension

2012-04-25 Thread Alvaro Tejero Cantero
Hello, I am interested in using some of the spatial operators to implement the interval algebra operations [1] 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, an

Re: [postgis-users] Using PosGIS in one dimension

2012-04-25 Thread David William Bitner
If you follow PostgreSQL development, you can see that 9.2 is bringing a whole suite of range data types for dealing with one dimensional intervals with the same expressivity as PostGIS. Not there yet, but coming soon On Wed, Apr 25, 2012 at 9:52 AM, Alvaro Tejero Cantero wrote: > Hello, > >

Re: [postgis-users] Using PosGIS in one dimension

2012-04-25 Thread Mike Toews
On 26 April 2012 07:41, David William Bitner wrote: > If you follow PostgreSQL development, you can see that 9.2 is bringing a > whole suite of range data types for dealing with one dimensional intervals > with the same expressivity as PostGIS. Not there yet, but coming soon Yup, I'll certain

Re: [postgis-users] Using PosGIS in one dimension

2012-04-25 Thread Alvaro Tejero Cantero
David, Mike, thank you very much for this spot-on information! I have two follow-up questions: 1/ is there an estimated release date for pg 9.2? (in its stead: are Postgres pre-release versions usually 'stable enough' - I am in an explorative setting, rock-solid stability is not yet needed). 2/

Re: [postgis-users] Using PosGIS in one dimension

2012-04-25 Thread Mike Toews
On 26 April 2012 09:54, Alvaro Tejero Cantero wrote: > David, Mike, > > thank you very much for this spot-on information! > > I have two follow-up questions: > > 1/ is there an estimated release date for pg 9.2? (in its stead: are > Postgres pre-release versions usually 'stable enough' - I am in a

Re: [postgis-users] Using PosGIS in one dimension

2012-04-26 Thread Alvaro Tejero Cantero
Hi Mike! Thank you. Your tip about loading numpy data into PostgreSQL will be key for my application ( http://stackoverflow.com/questions/8144002/use-binary-copy-table-from-with-psycopg2 ) In fact, do you know about the reverse process (loading to numpy arrays)? It seems that Psycopg2 cannot do i

Re: [postgis-users] Using PosGIS in one dimension

2012-04-26 Thread Mike Toews
On 27 April 2012 00:05, Alvaro Tejero Cantero wrote: > Hi Mike! > > Thank you. Your tip about loading numpy data into PostgreSQL will be key for > my application > (http://stackoverflow.com/questions/8144002/use-binary-copy-table-from-with-psycopg2) Great it's helpful! It probably deserves a bett

Re: [postgis-users] Using PosGIS in one dimension

2012-04-27 Thread Alvaro Tejero Cantero
Hi Mike! -รก. (snip) >> In fact, do you know about the reverse process (loading to numpy arrays)? It >> seems that Psycopg2 cannot do it but there is a project tackling that >> problem --- I don't know if this could eventually be incorporated into the >> mainstream driver (http://code.google.com