{"id":221,"date":"2011-03-14T09:19:01","date_gmt":"2011-03-14T08:19:01","guid":{"rendered":"http:\/\/sematext.solr.pl\/?p=221"},"modified":"2020-11-11T09:19:47","modified_gmt":"2020-11-11T08:19:47","slug":"car-sale-application-spatial-search-adding-location-data-part-3","status":"publish","type":"post","link":"https:\/\/solr.pl\/en\/2011\/03\/14\/car-sale-application-spatial-search-adding-location-data-part-3\/","title":{"rendered":"“Car sale application” \u2013 Spatial Search, adding location data (part 3)"},"content":{"rendered":"

The amount of announcements in our database is so large, that our web site users started to look for another option to filter search results and another way of sorting them. We need to add the functionality, which allows us to operate with localization data related to the cars.<\/p>\n\n\n\n\n\n

Requirements specification<\/h2>\n

We would like to add two new functionalities:<\/p>\n

    \n
  1. Filtering the results in order to display only those announcements, that are located not farther than x kilometres from the given place, where x = 50,100,200,500,1000 km.<\/li>\n
  2. Sorting the results using the distance between the given place and the given car’s localization.<\/li>\n<\/ol>\n

    In order to face the requirements, we need to use solr’s functionality called \u201cSpatial Search\u201d, that is available in solr distribution from version 3.1. The changes we need to provide are related to schema.xml file modifications and the input data changes, where we have to add the information about the localization of every car. In the end we will create proper requests.<\/p>\n

    Schema.xml changes<\/h2>\n
      \n
    1. New field types definitions:\n
        \n
      • the first definition is nothing more than another numerical type:<\/li>\n
        <fieldType name=\"tdouble\" precisionStep=\"8\" omitNorms=\"true\" positionIncrementGap=\"0\"\/><\/pre>\n
      • the second definition uses the “solr.LatLonType” class, which allows us to index localization data using the dynamic field with suffix “_coordinate”:<\/li>\n
        <fieldType name=\"location\" subFieldSuffix=\"_coordinate\"\/><\/pre>\n<\/ul>\n<\/li>\n
      • New fields definitions:\n
          \n
        • field, that will be used to accumulate the city name data, that is related to every car:<\/li>\n
          <field name=\"city\" type=\"string\" indexed=\"true\" stored=\"true\" \/><\/pre>\n
        • “loc” field will be used to index localization data:<\/li>\n
          <field name=\"loc\" type=\"location\" indexed=\"true\" stored=\"false\"\/><\/pre>\n
        • the dynamic field used internally to accumulate the information provided by the “loc” field:<\/li>\n
          <dynamicField name=\"*_coordinate\" type=\"tdouble\" indexed=\"true\" stored=\"false\"\/><\/pre>\n<\/ul>\n<\/li>\n<\/ol>\n
          Input data analysis<\/h2>\n
          In order to present how to modify the input data, let’s take 5 announcements from the cities:<\/p>\n
            \n
          1. Koszalin\n
              \n
            • latitude<\/em>: 54.12<\/li>\n
            • longitude<\/em>: 16.11<\/li>\n<\/ul>\n<\/li>\n
            • Bia\u0142ystok\n
                \n
              • latitude<\/em>: 53.08<\/li>\n
              • longitude<\/em>: 23.09<\/li>\n<\/ul>\n<\/li>\n
              • Szczecin\n
                  \n
                • latitude<\/em>: 53.25<\/li>\n
                • longitude<\/em>: 14.35<\/li>\n<\/ul>\n<\/li>\n
                • Gda\u0144sk\n
                    \n
                  • latitude<\/em>: 54.21<\/li>\n
                  • longitude<\/em>: 18.40<\/li>\n<\/ul>\n<\/li>\n
                  • Warszawa\n
                      \n
                    • latitude<\/em>: 52.15<\/li>\n
                    • longitude<\/em>: 21.00<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
                      We provide the localization data by entering the latitude and longitude separated by the comma in the “loc” field. Our data might look like this:\n<\/p>\n
                      <add>\n   <doc>\n      <field name=\"id\">1<\/field>\n      <field name=\"make\">Audi<\/field>\n      <field name=\"model\">80<\/field>\n      <field name=\"year\">2008<\/field>\n      <field name=\"price\">9774<\/field>\n      <field name=\"engine_size\">2000<\/field>\n      <field name=\"mileage\">92467<\/field>\n      <field name=\"colour\">green<\/field>\n      <field name=\"damaged\">false<\/field>\n      <field name=\"city\">Koszalin<\/field>\n      <field name=\"loc\">54.12,16.11<\/field>\n   <\/doc>\n   <doc>\n      <field name=\"id\">2<\/field>\n      <field name=\"make\">Audi<\/field>\n      <field name=\"model\">A8<\/field>\n      <field name=\"year\">2009<\/field>\n      <field name=\"price\">9078<\/field>\n      <field name=\"engine_size\">1000<\/field>\n      <field name=\"mileage\">31369<\/field>\n      <field name=\"colour\">black<\/field>\n      <field name=\"damaged\">false<\/field>\n      <field name=\"city\">Bia\u0142ystok<\/field>\n      <field name=\"loc\">53.08,23.09<\/field>\n   <\/doc>\n   <doc>\n      <field name=\"id\">3<\/field>\n      <field name=\"make\">Audi<\/field>\n      <field name=\"model\">TT<\/field>\n      <field name=\"year\">1997<\/field>\n      <field name=\"price\">1109<\/field>\n      <field name=\"engine_size\">1299<\/field>\n      <field name=\"mileage\">116987<\/field>\n      <field name=\"colour\">silver<\/field>\n      <field name=\"damaged\">true<\/field>\n      <field name=\"city\">Szczecin<\/field>\n      <field name=\"loc\">53.25,14.35<\/field>\n   <\/doc>\n   <doc>\n      <field name=\"id\">4<\/field>\n      <field name=\"make\">BMW<\/field>\n      <field name=\"model\">Seria 7<\/field>\n      <field name=\"year\">2007<\/field>\n      <field name=\"price\">140000<\/field>\n      <field name=\"engine_size\">3000<\/field>\n      <field name=\"mileage\">418000<\/field>\n      <field name=\"colour\">green<\/field>\n      <field name=\"damaged\">false<\/field>\n      <field name=\"city\">Gda\u0144sk<\/field>\n      <field name=\"loc\">54.21,18.40<\/field>\n   <\/doc>\n   <doc>\n      <field name=\"id\">5<\/field>\n      <field name=\"make\">Chevrolet<\/field>\n      <field name=\"model\">TrailBlazer<\/field>\n      <field name=\"year\">2007<\/field>\n      <field name=\"price\">140000<\/field>\n      <field name=\"engine_size\">3000<\/field>\n      <field name=\"mileage\">418000<\/field>\n      <field name=\"colour\">green<\/field>\n      <field name=\"damaged\">false<\/field>\n      <field name=\"city\">Warszawa<\/field>\n      <field name=\"loc\">52.15,21.00<\/field>\n   <\/doc>\n<\/add><\/pre>\n
                      Let’s create queries<\/h2>\n
                      We have our localization data in the index, so all we need right now is to create queries that will satisfy our needs. Let’s imagine, that we are searching for announcements when being in Bia\u0142ystok city, which is located about 200 km away from the Warszawa city, about  400 km away from the Gda\u0144sk city, about  550 km away from the Koszalin city and about 650 km away from the Szczecin city.<\/p>\n
                      To execute the first point from the requirements specification, we add the special filter query to our request:\n<\/p>\n
                      ...&fq={!geofilt sfield=loc}&pt=53.08,23.09&d=50<\/pre>\n
                      where:<\/p>\n
                        \n
                      • sfield<\/em> – the name of the field, where we have our localization data indexed.<\/li>\n
                      • pt<\/em> – the localization of the starting point, it is the Bia\u0142ystok city in our case.<\/li>\n
                      • d<\/em> – the distance used to narrow the search results. By using the 50,100,200,500,1000 values we can satisfy all our needs.<\/li>\n<\/ul>\n
                        Example:<\/p>\n
                          \n
                        1. Query:\n
                          q=*:*&fq={!geofilt sfield=loc}&pt=53.08,23.09&d=200<\/pre>\n<\/li>\n
                        2. Search results:<\/li>\n
                          <result name=\"response\" numFound=\"2\" start=\"0\">\n   <doc>\n      <str name=\"city\">Bia\u0142ystok<\/str>\n      <str name=\"colour\">black<\/str>\n      <bool name=\"damaged\">false<\/bool>\n      <int name=\"engine_size\">1000<\/int>\n      <str name=\"id\">2<\/str>\n      <str name=\"make\">Audi<\/str>\n      <int name=\"mileage\">31369<\/int>\n      <str name=\"model\">A8<\/str>\n      <float name=\"price\">9078.0<\/float>\n      <int name=\"year\">2009<\/int>\n   <\/doc>\n   <doc>\n      <str name=\"city\">Warszawa<\/str>\n      <str name=\"colour\">green<\/str>\n      <bool name=\"damaged\">false<\/bool>\n      <int name=\"engine_size\">3000<\/int>\n      <str name=\"id\">5<\/str>\n      <str name=\"make\">Chevrolet <\/str>\n      <int name=\"mileage\">418000<\/int>\n      <str name=\"model\">TrailBlazer<\/str>\n      <float name=\"price\">140000.0<\/float>\n      <int name=\"year\">2007<\/int>\n   <\/doc>\n<\/result><\/pre>\n<\/ol>\n
                          That’s great, we don’t have any announcements from the Koszalin, Gda\u0144sk or Szczecin city, as these cities are located farther than 200 km from the Bia\u0142ystok city.<\/p>\n
                          To execute the second point from the requirements specification, we use the possibility to sort the search results by using the geodist function. The query would look like this:\n<\/p>\n
                          ...&sfield=loc&pt=53.08,23.09&sort=geodist()+desc<\/pre>\n
                          The example of sorting the search results using the distance, starting from the Bia\u0142ystok city:<\/p>\n
                            \n
                          1. Query:\n
                            q=*:*&sfield=loc&pt=53.08,23.09&sort=geodist()+asc<\/pre>\n<\/li>\n
                          2. Search results:<\/li>\n
                            <result name=\"response\" numFound=\"5\" start=\"0\">\n   <doc>\n      <str name=\"city\">Bialystok<\/str>\n      <str name=\"colour\">black<\/str>\n      <bool name=\"damaged\">false<\/bool>\n      <int name=\"engine_size\">1000<\/int>\n      <str name=\"id\">2<\/str>\n      <str name=\"make\">Audi<\/str>\n      <int name=\"mileage\">31369<\/int>\n      <str name=\"model\">A8<\/str>\n      <float name=\"price\">9078.0<\/float>\n      <int name=\"year\">2009<\/int>\n   <\/doc>\n   <doc>\n      <str name=\"city\">Warszawa<\/str>\n      <str name=\"colour\">green<\/str>\n      <bool name=\"damaged\">false<\/bool>\n      <int name=\"engine_size\">3000<\/int>\n      <str name=\"id\">5<\/str>\n      <str name=\"make\">Chevrolet <\/str>\n      <int name=\"mileage\">418000<\/int>\n      <str name=\"model\">TrailBlazer<\/str>\n      <float name=\"price\">140000.0<\/float>\n      <int name=\"year\">2007<\/int>\n   <\/doc>\n   <doc>\n      <str name=\"city\">Gda\u0144sk<\/str>\n      <str name=\"colour\">green<\/str>\n      <bool name=\"damaged\">false<\/bool>\n      <int name=\"engine_size\">3000<\/int>\n      <str name=\"id\">4<\/str>\n      <str name=\"make\">BMW<\/str>\n      <int name=\"mileage\">418000<\/int>\n      <str name=\"model\">Seria 7<\/str>\n      <float name=\"price\">140000.0<\/float>\n      <int name=\"year\">2007<\/int>\n   <\/doc>\n   <doc>\n      <str name=\"city\">Koszalin<\/str>\n      <str name=\"colour\">green<\/str>\n      <bool name=\"damaged\">false<\/bool>\n      <int name=\"engine_size\">2000<\/int>\n      <str name=\"id\">1<\/str>\n      <str name=\"make\">Audi<\/str>\n      <int name=\"mileage\">92467<\/int>\n      <str name=\"model\">80<\/str>\n      <float name=\"price\">9774.0<\/float>\n      <int name=\"year\">2008<\/int>\n   <\/doc>\n   <doc>\n      <str name=\"city\">Szczecin<\/str>\n      <str name=\"colour\">silver<\/str>\n      <bool name=\"damaged\">true<\/bool>\n      <int name=\"engine_size\">1299<\/int>\n      <str name=\"id\">3<\/str>\n      <str name=\"make\">Audi<\/str>\n      <int name=\"mileage\">116987<\/int>\n      <str name=\"model\">TT<\/str>\n      <float name=\"price\">1109.0<\/float>\n      <int name=\"year\">1997<\/int>\n   <\/doc>\n<\/result><\/pre>\n<\/ol>\n
                            That’s correct! Mission accomplished.<\/p>\n
                            The end<\/h2>\n
                            Once more we are up to our website users expectations. This time we have added the functionalities, which allow our users to filter and sort the search results using the localization and distance data. Full success!<\/p>","protected":false},"excerpt":{"rendered":"
                            The amount of announcements in our database is so large, that our web site users started to look for another option to filter search results and another way of sorting them. We need to add the functionality, which allows us<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[27],"tags":[288,182],"class_list":["post-221","post","type-post","status-publish","format-standard","hentry","category-solr-en","tag-howto-2","tag-schema-2"],"_links":{"self":[{"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/posts\/221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":1,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/posts\/221\/revisions"}],"predecessor-version":[{"id":222,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/posts\/221\/revisions\/222"}],"wp:attachment":[{"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/media?parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/categories?post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/tags?post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}