4 places near Oberstetten, Landkreis Rosenheim, Bayern, Deutschland
filter by placetype:
  1. Landkreis Rosenheim
    Landkreis Rosenheim, Bayern, Deutschland (County)
  2. Landkreis Ebersberg
    Landkreis Ebersberg, Bayern, Deutschland (County)
  3. Landkreis Miesbach
    Landkreis Miesbach, Bayern, Deutschland (County)
  4. Landkreis München
    Landkreis München, Bayern, Deutschland (County)

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

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

        
0.079 seconds ⌛

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