8 places near Ohlenbüttel, Harburg, Niedersachsen, Deutschland
filter by placetype:
  1. Eversen
    Eversen, Harburg, Niedersachsen, Deutschland (Town)
  2. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  3. Mienenbüttel
    Mienenbüttel, Harburg, Niedersachsen, Deutschland (Town)
  4. Ohlenbüttel
    Ohlenbüttel, Harburg, Niedersachsen, Deutschland (Town)
  5. Oldendorf
    Oldendorf, Harburg, Niedersachsen, Deutschland (Town)
  6. Rade
    Rade, Harburg, Niedersachsen, Deutschland (Town)
  7. Bachheide
    Bachheide, Harburg, Niedersachsen, Deutschland (Town)
  8. Eversenheide
    Eversenheide, Harburg, Niedersachsen, Deutschland (Town)

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

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

        
0.175 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.77734,
                  53.397362
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}