5 places near Gemeinde Alfstedt, Rotenburg an der Wümme, Niedersachsen, Deutschland
filter by placetype:
  1. Rotenburg an der Wümme
    Rotenburg an der Wümme, Niedersachsen, Deutschland (County)
  2. Landkreis Stade
    Landkreis Stade, Niedersachsen, Deutschland (County)
  3. Landkreis Cuxhaven
    Landkreis Cuxhaven, Niedersachsen, Deutschland (County)
  4. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)
  5. Landkreis Pinneberg
    Landkreis Pinneberg, Schleswig-Holstein, Deutschland (County)

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

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

        
0.04 seconds ⌛

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