5 places near Derneburg, Landkreis Hildesheim, Niedersachsen, Deutschland
filter by placetype:
  1. Astenbeck
    Astenbeck, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  2. Derneburg
    Derneburg, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  3. Hackenstedt
    Hackenstedt, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  4. Heersum
    Heersum, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  5. Sottrum
    Sottrum, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)

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

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

        
0.013 seconds ⌛

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