11 places near Oberstetten, Landkreis Rosenheim, Bayern, Deutschland
filter by placetype:
  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.095 seconds ⌛; show me the details?

        
0.095 seconds ⌛

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