3 places near Freden, Landkreis Hildesheim, Niedersachsen, Deutschland
filter by placetype:
  1. Landkreis Northeim
    Landkreis Northeim, Niedersachsen, Deutschland (County)
  2. Landkreis Hildesheim
    Landkreis Hildesheim, Niedersachsen, Deutschland (County)
  3. Landkreis Holzminden
    Landkreis Holzminden, Niedersachsen, Deutschland (County)

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

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

        
0.015 seconds ⌛

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