Re: spatial queries
: thanks for the answer, I am also interested in the jdbc connectivity. Sorry, i thought that was and "if not" clause on your question. I've heard of some attempts at extending Lucene's "Directory" with a RDBMS backed implimentation -- from what i'm told they tend to focus on modeling lucene files as rows, which isn't really what people tend to be looking for when they ask about keeping a lucene index in a database -- people typically want to be able to do lucene queries and do relational queries at the same time; or as i like to call it: "eat their cake and eat and eat an upside down cake that was made from the same two eggs". By which i mean that since Lucene is an inverted index it approaches data from an "upside down" perspective compared to the way an RDBMS application would -- so sharing a single view of the data doesn't seem like it would work very well. : I think my concern wit the rangeset query is that there wouldn't be an : index for the rangeset, and as such wouldn't scale. That sounds like a RDBMS way of thinking -- not a an inverted index way of thinking :) ... in Lucene, every indexed field has a DB like "index" on it that makes traversing the values in a range. Trust me: I have applications that do a *lot* of "range queries" in Solr (which FYI: Solr cleverly deals with using RangeFilter's) and the performance is fine -- especially if you use a lot of ranges frequently (ie: if you are commonly doing bounding boxes arround the coordinates of major cities) -Hoss
Re: spatial queries
On 8/21/06, Norman Barker <[EMAIL PROTECTED]> wrote: ...3) Can you use a JDBC datastore which is shared amonst a cluster... FWIW, the Compass project [1] apparently has got a module to store Lucene indexes in a JDBC database. If this can work with Solr (I have no idea, you'll have to look at it), JDBC clustering should work as well, as it is transparent to the application. -Bertrand [1] http://www.opensymphony.com/compass/
Re: spatial queries
On 8/21/06, Chris Hostetter <[EMAIL PROTECTED]> wrote: : I am interested in solr for the RESTful interface, it fits into work I : am doing as part of an open source GIS project. I have a couple of : questions that I would be grateful for advice on; : : 1) Do spatial queries (such as documents within a bounding box) exist If your bounding boxes are square in a two dimensioal plane then they are easy to do using Range Queries -- if you need more ecentric bounding boxes (ie: circles) or you are dealing with polar coordiantes or something like that, then you'd want to take look at FUnctionQueries... http://www.nabble.com/forum/Search.jtp?forum=44&local=y&query=Distance+FunctionQuery -Hoss Chris, thanks for the answer, I am also interested in the jdbc connectivity. I think my concern wit the rangeset query is that there wouldn't be an index for the rangeset, and as such wouldn't scale. Now if I can store lucene indexes in PostgreSQL, and use the geometry type of PostGIS then I am fixed, I would be interested in putting this in Solr if I can get a few pointers to stop me floundering first!! thanks, Norman
Re: spatial queries
: I am interested in solr for the RESTful interface, it fits into work I : am doing as part of an open source GIS project. I have a couple of : questions that I would be grateful for advice on; : : 1) Do spatial queries (such as documents within a bounding box) exist If your bounding boxes are square in a two dimensioal plane then they are easy to do using Range Queries -- if you need more ecentric bounding boxes (ie: circles) or you are dealing with polar coordiantes or something like that, then you'd want to take look at FUnctionQueries... http://www.nabble.com/forum/Search.jtp?forum=44&local=y&query=Distance+FunctionQuery -Hoss
spatial queries
Hi, I am interested in solr for the RESTful interface, it fits into work I am doing as part of an open source GIS project. I have a couple of questions that I would be grateful for advice on; 1) Do spatial queries (such as documents within a bounding box) exist if not ... :-) 2) Is it possible to change the back end to utilise hibernate as in http://www.hibernate.org/hib_docs/annotations/reference/en/html/lucene.html ? I have implemented a geometry usertype for hibernate based on postgis. I think my concern here is speed, spatial databases are heavily optimised for within, intersect etc type queries 3) Can you use a JDBC datastore which is shared amonst a cluster 4) finally is there a concept of access controls for search queries so I only receive informations according to my user role. Many thanks, Norman Barker
