Re: Using Solr's spatial functionality for astronomical catalog

2016-02-16 Thread david.w.smi...@gmail.com
Ah; I saw that. I'm glad you figured it out. Yes, you needed the SQL alias. I'm kinda surprised you didn't get an error about a field by the name of your expression not existing... but maybe you have a catch-all dynamic field or maybe you're in data-driven mode. In either case, I'd expect a qui

Re: Using Solr's spatial functionality for astronomical catalog

2016-02-16 Thread Colin Freas
Looks like the only issue was that I did not have an alias for SourceRpt field in the SQL. With that in place, everything seems to work more or less as expected. SourceRpt shows up where it should. Queries like http://localhost:8983/solr/spatial/select?q=*:*&fq={!geofilt%20sfield=Sour c

Re: Using Solr's spatial functionality for astronomical catalog

2016-02-16 Thread Colin Freas
David, thanks for getting back to me. SpatialRecursivePrefixTreeFieldType seems to be what I need, and the default search seems appropriate. This is for entries in an astronomical catalog, so great circle distances on a perfect sphere is what I¹m after. I am having a bit of difficulty though.

Re: Using Solr's spatial functionality for astronomical catalog

2016-01-20 Thread david.w.smi...@gmail.com
Hello Colin, If the spatial field you use is the SpatialRecursivePrefixTreeFieldType one (RPT for short) with geo="true" then the circle shape (i.e. point-radius filter) implied by the geofilt Solr QParser is on a sphere. That is, it uses the "great circle" distance computed using the Haversine f

Using Solr's spatial functionality for astronomical catalog

2016-01-19 Thread Colin Freas
Greetings! I have recently stood up an instance of Solr, indexing a catalog of about 100M records representing points on the celestial sphere. All of the fields are strings, floats, and non-spatial types. I’d like to convert the positional data to an appropriate spatial point data type suppo