Re: issues doing a spatial query
Where is the doc that's "somewhere online"? One of the issues I face constantly is knowing what _current_ information is. Lots of posts out there are perfectly correct at the time they were written, but haven't been updated. Best, Erick On Fri, Apr 29, 2016 at 6:16 AM, GW wrote: > I realise the world wrap thing. but it is correct ~ they are coordinates > taken from Google maps. I'd does not really matter though. I switched the > query to use geofilt and everything is fine. > > Here's the kicker. > > There is a post somewhere online that says you cannot use geofilt with > multivalued location_RPT. I lost months because I did not try it. > > If i use geofilt with the coordinates in question (last in the multvalue) > with a distance of 1km I get a perfect result. In fact I can get a perfect > single direct hit on any of the values with geofilt + distance + > multivalued. > > > People that don't know what they are talking about should not post. > > Many thanks for your response. > > GW > > > On 29 April 2016 at 00:40, David Smiley wrote: > >> Hi. >> This makes sense to me. The point 49.8,-97.1 is in your query box. The >> box is lower-left to upper-right, so your box is actually an almost >> world-wrapping one grabbing all longitudes except -93 to -92. Maybe you >> mean to switch your left & right. >> >> On Sun, Apr 24, 2016 at 8:03 PM GW wrote: >> >> > I was not getting the results I expected so I started testing with the >> solr >> > webclient >> > >> > Maybe I don;t understand things. >> > >> > simple test query >> > >> > q=*:*&fq=locations:[49,-92 TO 50,-93] >> > >> > I don't understand why I get a result set for longitude range -92 to -93 >> > but should be zero results as far as I understand. >> > >> > >> > >> >> > >> > { >> > "responseHeader": { >> > "status": 0, >> > "QTime": 2, >> > "params": { >> > "q": "*:*", >> > "indent": "true", >> > "fq": "locations:[49,-92 TO 50,-93]", >> > "wt": "json", >> > "_": "1461541195102" >> > } >> > }, >> > "response": { >> > "numFound": 85, >> > "start": 0, >> > "docs": [ >> > { >> > "id": "data.spidersilk.co!337", >> > "entity_id": "337", >> > "type_id": "simple", >> > "gender": "Male", >> > "name": "Aviator Sunglasses", >> > "short_description": "A timeless accessory staple, the >> > unmistakable teardrop lenses of our Aviator sunglasses appeal to >> > everyone from suits to rock stars to citizens of the world.", >> > "description": "Gunmetal frame with crystal gradient >> > polycarbonate lenses in grey. ", >> > "size": "", >> > "color": "", >> > "zdomain": "magento.spidersilk.co", >> > "zurl": >> > " >> > >> http://magento.spidersilk.co/index.php/catalog/product/view/id/337/s/aviator-sunglasses/ >> > ", >> > "main_image_url": >> > " >> > >> http://magento.spidersilk.co/media/catalog/product/cache/0/image/9df78eab33525d08d6e5fb8d27136e95/a/c/ace000a_1.jpg >> > ", >> > "keywords": "Eyewear ", >> > "data_size": "851,564", >> > "category": "Eyewear", >> > "final_price_without_tax": "295,USD", >> > "image_url": [ >> > " >> > http://magento.spidersilk.co/media/catalog/product/a/c/ace000a_1.jpg";, >> > " >> > http://magento.spidersilk.co/media/catalog/product/a/c/ace000b_1.jpg"; >> > ], >> > "locations": [ >> > "37.4463603,-122.1591775", >> > "42.5857514,-82.8873787", >> > "41.6942622,-86.2697108", >> > "49.8522263,-97.1390697" >> > ], >> > "_version_": 1532418847465799700 >> > }, >> > >> > >> > >> > Thanks, >> > >> > GW >> > >> -- >> Lucene/Solr Search Committer, Consultant, Developer, Author, Speaker >> LinkedIn: http://linkedin.com/in/davidwsmiley | Book: >> http://www.solrenterprisesearchserver.com >>
Re: issues doing a spatial query
I realise the world wrap thing. but it is correct ~ they are coordinates taken from Google maps. I'd does not really matter though. I switched the query to use geofilt and everything is fine. Here's the kicker. There is a post somewhere online that says you cannot use geofilt with multivalued location_RPT. I lost months because I did not try it. If i use geofilt with the coordinates in question (last in the multvalue) with a distance of 1km I get a perfect result. In fact I can get a perfect single direct hit on any of the values with geofilt + distance + multivalued. People that don't know what they are talking about should not post. Many thanks for your response. GW On 29 April 2016 at 00:40, David Smiley wrote: > Hi. > This makes sense to me. The point 49.8,-97.1 is in your query box. The > box is lower-left to upper-right, so your box is actually an almost > world-wrapping one grabbing all longitudes except -93 to -92. Maybe you > mean to switch your left & right. > > On Sun, Apr 24, 2016 at 8:03 PM GW wrote: > > > I was not getting the results I expected so I started testing with the > solr > > webclient > > > > Maybe I don;t understand things. > > > > simple test query > > > > q=*:*&fq=locations:[49,-92 TO 50,-93] > > > > I don't understand why I get a result set for longitude range -92 to -93 > > but should be zero results as far as I understand. > > > > > > > > > > > { > > "responseHeader": { > > "status": 0, > > "QTime": 2, > > "params": { > > "q": "*:*", > > "indent": "true", > > "fq": "locations:[49,-92 TO 50,-93]", > > "wt": "json", > > "_": "1461541195102" > > } > > }, > > "response": { > > "numFound": 85, > > "start": 0, > > "docs": [ > > { > > "id": "data.spidersilk.co!337", > > "entity_id": "337", > > "type_id": "simple", > > "gender": "Male", > > "name": "Aviator Sunglasses", > > "short_description": "A timeless accessory staple, the > > unmistakable teardrop lenses of our Aviator sunglasses appeal to > > everyone from suits to rock stars to citizens of the world.", > > "description": "Gunmetal frame with crystal gradient > > polycarbonate lenses in grey. ", > > "size": "", > > "color": "", > > "zdomain": "magento.spidersilk.co", > > "zurl": > > " > > > http://magento.spidersilk.co/index.php/catalog/product/view/id/337/s/aviator-sunglasses/ > > ", > > "main_image_url": > > " > > > http://magento.spidersilk.co/media/catalog/product/cache/0/image/9df78eab33525d08d6e5fb8d27136e95/a/c/ace000a_1.jpg > > ", > > "keywords": "Eyewear ", > > "data_size": "851,564", > > "category": "Eyewear", > > "final_price_without_tax": "295,USD", > > "image_url": [ > > " > > http://magento.spidersilk.co/media/catalog/product/a/c/ace000a_1.jpg";, > > " > > http://magento.spidersilk.co/media/catalog/product/a/c/ace000b_1.jpg"; > > ], > > "locations": [ > > "37.4463603,-122.1591775", > > "42.5857514,-82.8873787", > > "41.6942622,-86.2697108", > > "49.8522263,-97.1390697" > > ], > > "_version_": 1532418847465799700 > > }, > > > > > > > > Thanks, > > > > GW > > > -- > Lucene/Solr Search Committer, Consultant, Developer, Author, Speaker > LinkedIn: http://linkedin.com/in/davidwsmiley | Book: > http://www.solrenterprisesearchserver.com >
Re: issues doing a spatial query
Hi. This makes sense to me. The point 49.8,-97.1 is in your query box. The box is lower-left to upper-right, so your box is actually an almost world-wrapping one grabbing all longitudes except -93 to -92. Maybe you mean to switch your left & right. On Sun, Apr 24, 2016 at 8:03 PM GW wrote: > I was not getting the results I expected so I started testing with the solr > webclient > > Maybe I don;t understand things. > > simple test query > > q=*:*&fq=locations:[49,-92 TO 50,-93] > > I don't understand why I get a result set for longitude range -92 to -93 > but should be zero results as far as I understand. > > > > > { > "responseHeader": { > "status": 0, > "QTime": 2, > "params": { > "q": "*:*", > "indent": "true", > "fq": "locations:[49,-92 TO 50,-93]", > "wt": "json", > "_": "1461541195102" > } > }, > "response": { > "numFound": 85, > "start": 0, > "docs": [ > { > "id": "data.spidersilk.co!337", > "entity_id": "337", > "type_id": "simple", > "gender": "Male", > "name": "Aviator Sunglasses", > "short_description": "A timeless accessory staple, the > unmistakable teardrop lenses of our Aviator sunglasses appeal to > everyone from suits to rock stars to citizens of the world.", > "description": "Gunmetal frame with crystal gradient > polycarbonate lenses in grey. ", > "size": "", > "color": "", > "zdomain": "magento.spidersilk.co", > "zurl": > " > http://magento.spidersilk.co/index.php/catalog/product/view/id/337/s/aviator-sunglasses/ > ", > "main_image_url": > " > http://magento.spidersilk.co/media/catalog/product/cache/0/image/9df78eab33525d08d6e5fb8d27136e95/a/c/ace000a_1.jpg > ", > "keywords": "Eyewear ", > "data_size": "851,564", > "category": "Eyewear", > "final_price_without_tax": "295,USD", > "image_url": [ > " > http://magento.spidersilk.co/media/catalog/product/a/c/ace000a_1.jpg";, > " > http://magento.spidersilk.co/media/catalog/product/a/c/ace000b_1.jpg"; > ], > "locations": [ > "37.4463603,-122.1591775", > "42.5857514,-82.8873787", > "41.6942622,-86.2697108", > "49.8522263,-97.1390697" > ], > "_version_": 1532418847465799700 > }, > > > > Thanks, > > GW > -- Lucene/Solr Search Committer, Consultant, Developer, Author, Speaker LinkedIn: http://linkedin.com/in/davidwsmiley | Book: http://www.solrenterprisesearchserver.com
issues doing a spatial query
I was not getting the results I expected so I started testing with the solr webclient Maybe I don;t understand things. simple test query q=*:*&fq=locations:[49,-92 TO 50,-93] I don't understand why I get a result set for longitude range -92 to -93 but should be zero results as far as I understand. { "responseHeader": { "status": 0, "QTime": 2, "params": { "q": "*:*", "indent": "true", "fq": "locations:[49,-92 TO 50,-93]", "wt": "json", "_": "1461541195102" } }, "response": { "numFound": 85, "start": 0, "docs": [ { "id": "data.spidersilk.co!337", "entity_id": "337", "type_id": "simple", "gender": "Male", "name": "Aviator Sunglasses", "short_description": "A timeless accessory staple, the unmistakable teardrop lenses of our Aviator sunglasses appeal to everyone from suits to rock stars to citizens of the world.", "description": "Gunmetal frame with crystal gradient polycarbonate lenses in grey. ", "size": "", "color": "", "zdomain": "magento.spidersilk.co", "zurl": "http://magento.spidersilk.co/index.php/catalog/product/view/id/337/s/aviator-sunglasses/";, "main_image_url": "http://magento.spidersilk.co/media/catalog/product/cache/0/image/9df78eab33525d08d6e5fb8d27136e95/a/c/ace000a_1.jpg";, "keywords": "Eyewear ", "data_size": "851,564", "category": "Eyewear", "final_price_without_tax": "295,USD", "image_url": [ "http://magento.spidersilk.co/media/catalog/product/a/c/ace000a_1.jpg";, "http://magento.spidersilk.co/media/catalog/product/a/c/ace000b_1.jpg"; ], "locations": [ "37.4463603,-122.1591775", "42.5857514,-82.8873787", "41.6942622,-86.2697108", "49.8522263,-97.1390697" ], "_version_": 1532418847465799700 }, Thanks, GW