35 places near Kastenfeld, Landkreis Rosenheim, Bayern, Deutschland
  1. Donau
    Donau, Magyarország (Drainage)
  2. Inn
    Inn, Österreich (Drainage)
  3. Salzach
    Salzach, Österreich (Drainage)
  4. Gemeinde Schechen
    Gemeinde Schechen, Landkreis Rosenheim, Bayern, Deutschland (LocalAdmin)
  5. Gemeinde Prutting
    Gemeinde Prutting, Landkreis Rosenheim, Bayern, Deutschland (LocalAdmin)
  6. Gemeinde Stephanskirchen
    Gemeinde Stephanskirchen, Landkreis Rosenheim, Bayern, Deutschland (LocalAdmin)
  7. Gemeinde Vogtareuth
    Gemeinde Vogtareuth, Landkreis Rosenheim, Bayern, Deutschland (LocalAdmin)
  8. Gemeinde Rosenheim
    Gemeinde Rosenheim, Stadtkreis Rosenheim, Bayern, Deutschland (LocalAdmin)
  9. Oberbayern
    Oberbayern, Bayern, Deutschland (Colloquial)
  10. Alps
    Alps (Colloquial)

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

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

        
0.034 seconds ⌛

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