31 places near Oberstetten, Landkreis Rosenheim, Bayern, Deutschland
  1. Elendskirchen
    Elendskirchen, Landkreis Rosenheim, Bayern, Deutschland (Town)
  2. Eutenhausen
    Eutenhausen, Landkreis Rosenheim, Bayern, Deutschland (Town)
  3. Hofberg
    Hofberg, Landkreis Rosenheim, Bayern, Deutschland (Town)
  4. Krügling
    Krügling, Landkreis Rosenheim, Bayern, Deutschland (Town)
  5. Oberlaus
    Oberlaus, Landkreis Rosenheim, Bayern, Deutschland (Town)
  6. Unterlaus
    Unterlaus, Landkreis Rosenheim, Bayern, Deutschland (Town)
  7. Walpersdorf
    Walpersdorf, Landkreis Rosenheim, Bayern, Deutschland (Town)
  8. Oberstetten
    Oberstetten, Landkreis Rosenheim, Bayern, Deutschland (Town)
  9. Unterlans
    Unterlans, Landkreis Rosenheim, Bayern, Deutschland (Town)
  10. Pups
    Pups, Landkreis Rosenheim, Bayern, Deutschland (Town)

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

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

        
0.021 seconds ⌛

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