Overpass: Alte Objekte finden

Ich habe versucht eine Overpass-Turbo Abfrage zu bauen, welche mir Restaurants auswirft, die zuletzt vor 5 Jahren bearbeitet wurden:

[timeout:60];
(
  nw["amenity"="restaurant"](changed:"2000-01-01T04:00:00Z","2018-03-03T04:00:00Z")({{bbox}});
);
out meta;
>;
out meta;

Leider bekomme ich selbst bei kleinen bboxen einen out-of-memory Fehler.
Overpass-Bug oder ist die Abfrage falsch?

1 Like

Immerhin einen Workaround habe ich gefunden:
Obige Abfrage ohne den changed-Teil, dann die Daten in ein Textfile kopieren und per grep entsprechend nach timestamp filtern.

Resultat (Anfang der Datei):

  <node id="292136825" lat="52.0816275" lon="8.0840665" version="1" timestamp="2008-08-29T21:28:12Z" changeset="466245" uid="50914" user="jhin">
  <node id="299808501" lat="51.9359312" lon="7.1723879" version="3" timestamp="2009-11-01T01:04:07Z" changeset="3003066" uid="62614" user="Fam-Os">
  <node id="377960862" lat="51.8951190" lon="7.4724887" version="1" timestamp="2009-04-16T13:53:55Z" changeset="582241" uid="87807" user="hami-123">
  <node id="444021117" lat="52.2235645" lon="7.2054649" version="1" timestamp="2009-07-19T22:55:09Z" changeset="1879297" uid="118623" user="hknk1">
  <node id="469952037" lat="51.9609405" lon="8.0815880" version="1" timestamp="2009-08-17T19:51:54Z" changeset="2181217" uid="124982" user="Treckerfahrerin">
  <node id="498497927" lat="52.1398762" lon="8.1421529" version="2" timestamp="2009-12-05T18:18:24Z" changeset="3297438" uid="85991" user="Gaianer">
  <node id="506808142" lat="51.9162793" lon="8.1333935" version="2" timestamp="2009-11-02T23:58:21Z" changeset="3021255" uid="107703" user="herisusa">
  <node id="663781052" lat="51.9443703" lon="7.6228615" version="1" timestamp="2010-03-10T19:00:19Z" changeset="4092275" uid="170672" user="1248">
  <node id="665786889" lat="51.9993545" lon="8.0615812" version="2" timestamp="2010-03-14T11:21:40Z" changeset="4123072" uid="107703" user="herisusa">
  <node id="725633757" lat="51.8479772" lon="7.5088946" version="1" timestamp="2010-05-07T22:26:25Z" changeset="4634702" uid="87807" user="hami-123">
  <node id="766162386" lat="52.0313420" lon="8.1934191" version="1" timestamp="2010-06-07T00:21:30Z" changeset="4924135" uid="107703" user="herisusa">
  <node id="975737442" lat="52.2092865" lon="7.3194466" version="3" timestamp="2010-11-08T22:37:46Z" changeset="6324587" uid="118623" user="hknk1">
  <node id="289598001" lat="51.7534562" lon="7.2079281" version="3" timestamp="2011-10-06T17:46:04Z" changeset="9482892" uid="290680" user="wheelmap_visitor">
  <node id="419938350" lat="52.0542385" lon="7.1437523" version="2" timestamp="2011-10-19T15:55:46Z" changeset="9596105" uid="290680" user="wheelmap_visitor">
  <node id="698066430" lat="51.9604389" lon="7.6251462" version="8" timestamp="2011-10-05T15:11:27Z" changeset="9474855" uid="290680" user="wheelmap_visitor">
  <node id="874234453" lat="51.9341327" lon="7.5786980" version="2" timestamp="2011-07-22T23:15:14Z" changeset="8802417" uid="475155" user="skynetzx">
  <node id="975748434" lat="52.2221442" lon="7.3444425" version="2" timestamp="2011-06-21T17:52:08Z" changeset="8506783" uid="118623" user="hknk1">
  <node id="1326387758" lat="52.1737915" lon="7.0579418" version="1" timestamp="2011-06-15T13:14:48Z" changeset="8447200" uid="68619" user="spider-256">
  <node id="1412142065" lat="52.0532659" lon="7.2302982" version="2" timestamp="2011-10-19T15:54:40Z" changeset="9596105" uid="290680" user="wheelmap_visitor">
  <node id="1461125595" lat="52.2042807" lon="8.0416314" version="2" timestamp="2011-10-10T12:38:28Z" changeset="9521418" uid="531732" user="DetSp">
  <node id="1461133454" lat="52.2044040" lon="8.0420472" version="3" timestamp="2011-11-05T20:42:52Z" changeset="9744488" uid="290680" user="wheelmap_visitor">
  <node id="1465568155" lat="52.2044311" lon="8.0445603" version="1" timestamp="2011-10-13T18:12:49Z" changeset="9549519" uid="531732" user="DetSp">
  <node id="1525402552" lat="52.1520652" lon="7.3340925" version="1" timestamp="2011-11-30T22:28:18Z" changeset="10003973" uid="107660" user="Björn Tschorn">
  <node id="513800121" lat="52.1021078" lon="8.0882686" version="2" timestamp="2012-05-31T16:26:16Z" changeset="11759527" uid="290680" user="wheelmap_visitor">
  <node id="520653345" lat="52.0434236" lon="7.8763417" version="2" timestamp="2012-04-08T21:57:40Z" changeset="11231381" uid="107703" user="herisusa">
  <node id="639562644" lat="52.1866822" lon="8.0695572" version="2" timestamp="2012-12-11T20:03:55Z" changeset="14241980" uid="226816" user="Flappi">
  <node id="704059993" lat="52.0048509" lon="8.0942366" version="3" timestamp="2012-08-23T16:18:12Z" changeset="12829435" uid="290680" user="wheelmap_visitor">
  <node id="904378503" lat="52.1142413" lon="8.2061024" version="2" timestamp="2012-04-25T16:53:52Z" changeset="11412272" uid="290680" user="wheelmap_visitor">
  <node id="1109729567" lat="52.0885236" lon="7.4825472" version="2" timestamp="2012-03-09T09:34:35Z" changeset="10916363" uid="290680" user="wheelmap_visitor">
  <node id="1152546940" lat="52.2063970" lon="8.0414101" version="3" timestamp="2012-12-22T07:56:05Z" changeset="14363019" uid="184028" user="ratorst">
  <node id="1154615069" lat="52.2001454" lon="7.9808469" version="2" timestamp="2012-05-21T18:50:09Z" changeset="11659471" uid="290680" user="wheelmap_visitor">
  <node id="1339401430" lat="51.9545657" lon="7.6264390" version="5" timestamp="2012-01-07T15:44:08Z" changeset="10322121" uid="572691" user="gisgk2011">
  <node id="1542861427" lat="52.1498769" lon="7.7289045" version="2" timestamp="2012-12-30T17:50:51Z" changeset="14467469" uid="184028" user="ratorst">
  <node id="1692189217" lat="52.1725907" lon="7.5212208" version="2" timestamp="2012-07-27T16:19:33Z" changeset="12507293" uid="290680" user="wheelmap_visitor">
  <node id="1875101916" lat="52.1151106" lon="8.2025702" version="2" timestamp="2012-08-24T19:08:58Z" changeset="12848554" uid="47978" user="Christoph Lotz">
  <node id="1923881015" lat="52.1188413" lon="7.3846106" version="1" timestamp="2012-09-20T16:49:00Z" changeset="13185934" uid="118856" user="staehler">
  <way id="156998945" version="1" timestamp="2012-03-26T20:02:33Z" changeset="11110092" uid="221720" user="H4kor">
  <node id="60592511" lat="52.1244667" lon="7.1007475" version="5" timestamp="2013-01-14T19:24:30Z" changeset="14652374" uid="323464" user="LutzK">
  <node id="294107366" lat="52.1727038" lon="7.5241382" version="4" timestamp="2013-11-19T16:53:12Z" changeset="18997425" uid="545385" user="thom123">
  <node id="324231174" lat="52.0829908" lon="7.9993394" version="4" timestamp="2013-10-28T17:13:40Z" changeset="18587934" uid="184028" user="ratorst">

Vielleicht hat es mit dem hier beschriebenen Bug zu tun.


Ich würde das so machen: Overpass-Turbo-Abfrage

nw[amenity=restaurant]({{bbox}})->.all;
(.all; - nwr.all(newer:"{{date:5year}}"););
(._;>;);
out meta;
4 Likes

Danke, scheint zu funktionieren.

wirklich schick, wieder was gelernt!

@Shaun_das_Schaf (und der Rest):

Wie geht das mit Werten von Tags, z. B. check_date=“älter als x Jahre” (oder noch besser: älter als x Monate, aber jünger als y Monate)?

1 Like

Hier wird man fündig.

(Ping @aselnigu )