15 places near Apfelbach, Main-Tauber-Kreis, Baden-Württemberg, Deutschland
filter by placetype:
  1. Apfelbach
    Apfelbach, Main-Tauber-Kreis, Baden-Württemberg, Deutschland (Town)
  2. Dörtel
    Dörtel, Main-Tauber-Kreis, Baden-Württemberg, Deutschland (Town)
  3. Markelsheim
    Markelsheim, Main-Tauber-Kreis, Baden-Württemberg, Deutschland (Town)
  4. Gemeinde Bad Mergentheim
    Gemeinde Bad Mergentheim, Main-Tauber-Kreis, Baden-Württemberg, Deutschland (LocalAdmin)
  5. Gemeinde Niederstetten
    Gemeinde Niederstetten, Main-Tauber-Kreis, Baden-Württemberg, Deutschland (LocalAdmin)
  6. Main-Tauber-Kreis
    Main-Tauber-Kreis, Baden-Württemberg, Deutschland (County)
  7. Europe/Berlin
    Europe/Berlin (Timezone)
  8. Baden-Württemberg
    Baden-Württemberg, Baden-Württemberg, Deutschland (State)
  9. Deutschland
    Deutschland, Deutschland (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

Search again including deprecated places, unknown places, places that visit Null Island or everything?

This query took 0.015 seconds ⌛; show me the details?

        
0.015 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.82265,
                  49.44643
                ]
              }
            }
          }
        }
      ],
      "must_not": [
        {
          "terms": {
            "woe:placetype": [
              0,
              11,
              25
            ]
          }
        },
        {
          "term": {
            "geom:latitude": {
              "value": 0.0
            }
          }
        },
        {
          "term": {
            "geom:longitude": {
              "value": 0.0
            }
          }
        },
        {
          "exists": {
            "field": "woe:superseded_by"
          }
        }
      ]
    }
  },
  "aggs": {
    "placetypes": {
      "terms": {
        "field": "woe:placetype_name",
        "size": 10000
      }
    }
  },
  "sort": [
    {
      "woe:scale": {
        "order": "desc",
        "mode": "max"
      }
    },
    {
      "woe:id": {
        "order": "asc",
        "mode": "max"
      }
    }
  ]
}