<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hi Andre,</p>
    <p>did you try the key:value: shop:supermarket instead</p>
    <pre class="moz-signature" cols="72">Mit freundlichen Grüßen
Stefan Giese
Projektleiter/Consultant
------------------------------------------------------
Aufwind durch Wissen!
Jetzt neu: Webinare und Online-Schulungen
bei der <a class="moz-txt-link-abbreviated" href="http://www.foss-academy.com">www.foss-academy.com</a>
------------------------------------------------------

WhereGroup GmbH
Schwimmbadstr. 2
79100 Freiburg
Germany

Fon: +49 (0)761 / 519 102 - 61
Fax: +49 (0)761 / 519 102 - 11

<a class="moz-txt-link-abbreviated" href="mailto:stefan.giese@wheregroup.com">stefan.giese@wheregroup.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.wheregroup.com">www.wheregroup.com</a>
Geschäftsführer:
Olaf Knopp, Peter Stamm 
Amtsgericht Bonn, HRB 9885</pre>
    <div class="moz-cite-prefix">Am 29.06.2020 um 20:44 schrieb Andre
      Ulrich:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAA92fVjXNxhqe=EHNZi3g12mDZ0_rRvQTO18k8fpQ0Y+Xy+ojQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">
          <div dir="ltr">
            <div dir="ltr">
              <div>Dear community,</div>
              <div><br>
              </div>
              <div>I have to create a shape file containing all
                supermarkets in cologne. Therefore I want to use data
                from open street maps. I have already installed the
                (experimental) plugin "QuickOSM" for enabling queries on
                osm data directly in QGIS.</div>
              <div>For the query I have to pass a key and a value.
                According to<br>
              </div>
              <div><a
                  href="https://wiki.openstreetmap.org/wiki/Key:building"
                  moz-do-not-send="true">https://wiki.openstreetmap.org/wiki/Key:building</a></div>
              <div>there should be a value "supermarket" belonging to
                the key "building".</div>
              <div>In the QuickOSM-window I can choose the key
                "building" - fine. But when it comes to the value, I
                can't choose "supermarket" - it's not even listed (and I
                can't type it too). There are other values like
                "commercial", "industrial" or "retail", which might also
                fit. But a query using these values yields way too many
                results. I really only want to have supermarkets like
                rewe or penny or lidl or aldi or something like those.</div>
              <div><br>
              </div>
              <div>I also have downloaded a shape containing all
                buildings in "Regierungsbezirk Köln" from</div>
              <div><a
href="http://download.geofabrik.de/europe/germany/nordrhein-westfalen.html"
                  moz-do-not-send="true">http://download.geofabrik.de/europe/germany/nordrhein-westfalen.html</a></div>
              <div>as shp.zip.</div>
              <div>There are 2.5M objects in this shape. I have tried to
                filter them, using the attribute tabel -> select by
                expression. Everytime I try to filter these data my
                computer ends up crashing.</div>
              <div>I only see this loading symbol where my cursor is
                supposed to be. When I stop the programme manually I
                only get to see this error message (also in picture
                attached).</div>
              <div><br>
              </div>
              <div>Does anyone have a clue, where to get good data for
                my purposes (supermarkets in cologne)?</div>
              <div>Or should I simply wait longer for QGIS to filter
                these 2.5M objects (although I have waited for 30
                minutes or so)?</div>
              <div><br>
              </div>
              <div>Thanks for your efforts in advance!</div>
              <div>many greetings!</div>
              <div>André</div>
              <div><br>
              </div>
              <div>*************************************</div>
              <div>QGIS 3.12.3-Bucuresti</div>
              <div>installed with OSGeo4W</div>
              <div>Windows 10 Pro</div>
              <div>*************************************</div>
              <div><br>
              </div>
              <div><br>
                <br>
              </div>
              <br>
              -- <br>
              <div class="gmail_signature" dir="ltr">
                <div dir="ltr">
                  <div>
                    <div dir="ltr">
                      <div>
                        <div dir="ltr">
                          <div>Andre Ulrich<br>
                          </div>
                          <div>Email: <a
                              href="mailto:andre.ulrich@gmail.com"
                              target="_blank" moz-do-not-send="true">andre.ulrich63920@gmail.com</a></div>
                          <div><br>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
    </blockquote>
    <pre class="moz-signature" cols="72">-- 
</pre>
  </body>
</html>