41 places near Sperlasberg, Landkreis Miesbach, Bayern, Deutschland
  1. Auerschmied
    Auerschmied, Landkreis Miesbach, Bayern, Deutschland (Town)
  2. Grassau
    Grassau, Landkreis Miesbach, Bayern, Deutschland (Town)
  3. Großhub
    Großhub, Landkreis Miesbach, Bayern, Deutschland (Town)
  4. Jedling
    Jedling, Landkreis Miesbach, Bayern, Deutschland (Town)
  5. Kirchsteig
    Kirchsteig, Landkreis Miesbach, Bayern, Deutschland (Town)
  6. Loideriding
    Loideriding, Landkreis Miesbach, Bayern, Deutschland (Town)
  7. Oberhasling
    Oberhasling, Landkreis Miesbach, Bayern, Deutschland (Town)
  8. Rieding
    Rieding, Landkreis Miesbach, Bayern, Deutschland (Town)
  9. Schwaig
    Schwaig, Landkreis Miesbach, Bayern, Deutschland (Town)
  10. Untermoos
    Untermoos, Landkreis Miesbach, Bayern, Deutschland (Town)

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

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

        
0.037 seconds ⌛

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