5 places near Kohlenhusen, Landkreis Stade, Niedersachsen, Deutschland
filter by placetype:
  1. Jork
    Jork, Landkreis Stade, Niedersachsen, Deutschland (Town)
  2. Kohlenhusen
    Kohlenhusen, Landkreis Stade, Niedersachsen, Deutschland (Town)
  3. Königreich
    Königreich, Landkreis Stade, Niedersachsen, Deutschland (Town)
  4. Wellenstraße
    Wellenstraße, Landkreis Stade, Niedersachsen, Deutschland (Town)
  5. Hahnöfersand
    Hahnöfersand, Landkreis Stade, Niedersachsen, Deutschland (Town)

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

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

        
0.035 seconds ⌛

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