Re: [HACKERS] Indexing for geographic objects? - Mailing list pgsql-general

From selkovjr@mcs.anl.gov
Subject Re: [HACKERS] Indexing for geographic objects?
Date
Msg-id 200011280003.SAA16737@selkovjr.xnet.com
Whole thread Raw
In response to RE: [HACKERS] Indexing for geographic objects?  (Franck Martin <Franck@sopac.org>)
Responses RE: [HACKERS] Indexing for geographic objects?  ("Edmar Wiggers" <edmar@brasmap.com>)
List pgsql-general
Franck Martin wrote:
> I have already created geographical objects which contains MBR(Minimum
> Bounding Rectangle) in their structure, so it is a question of rewriting
> your code to change the access to the cube structure to the MBR structure
> inside my geoobject. (cf http://fmaps.sourceforge.net/) Look in the CVS for
> latest. I have been slack lately on the project, but I'm not forgetting it.

I see where you are aiming. I definitely want to be around when it
starts working.

> Quickly I ran through the code, and I think your cube is strictly speaking a
> box, which also a MBR.

Yes, cube is definitely a misnomer -- it suggests things are
equihedral, which they aren't. I am still looking for a short name or
an acronym that would indicate it is a box with an arbitrary number of
dimensions. With your application, you will surely benefit from a
smaller and faster code geared specifically for 3D.

> However I didn't see the case of intersection, which is the main question
> when you want to display object that are visible inside a box.

The procedure is there, it is called cube_inter, but there is no
operator for it.

> I suppose your code is under GPL, and you have no problem for me to use it,
> providing I put your name and credits somewhere.

No problem at all -- I will be honored if you use it. Was I careless
enough not to include a license? It's not exactly a GPL -- it's
completely unrestricted. I should have said that somewhere.

Good luck,

--Gene

pgsql-general by date:

Previous
From: Christian Ullrich
Date:
Subject: Failed regression tests with 7.0.3 on Windows NT 4.0
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] is it a bug?