28 places near Appel, Harburg, Niedersachsen, Deutschland
filter by placetype:
  1. Appel
    Appel, Harburg, Niedersachsen, Deutschland (Town)
  2. Eversen
    Eversen, Harburg, Niedersachsen, Deutschland (Town)
  3. Grauen
    Grauen, Harburg, Niedersachsen, Deutschland (Town)
  4. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  5. Oldendorf
    Oldendorf, Harburg, Niedersachsen, Deutschland (Town)
  6. Podendorf
    Podendorf, Harburg, Niedersachsen, Deutschland (Town)
  7. Appelbeck
    Appelbeck, Harburg, Niedersachsen, Deutschland (Town)
  8. Ruhmannshof
    Ruhmannshof, Harburg, Niedersachsen, Deutschland (Town)
  9. Eversenheide
    Eversenheide, Harburg, Niedersachsen, Deutschland (Town)
  10. Weser River
    Weser River, Deutschland (Drainage)

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

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

        
0.022 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.74449,
                  53.389969
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}