18 places near 9395 Triefenstein, Bayern, Deutschland
  1. Holzkirchen
    Holzkirchen, Landkreis Würzburg, Bayern, Deutschland (Town)
  2. Remlingen
    Remlingen, Landkreis Würzburg, Bayern, Deutschland (Town)
  3. Holzmühle
    Holzmühle, Landkreis Würzburg, Bayern, Deutschland (Town)
  4. Main River
    Main River, Deutschland (Drainage)
  5. Gemeinde Remlingen
    Gemeinde Remlingen, Landkreis Würzburg, Bayern, Deutschland (LocalAdmin)
  6. Gemeinde Uettingen
    Gemeinde Uettingen, Landkreis Würzburg, Bayern, Deutschland (LocalAdmin)
  7. Unterfranken
    Unterfranken, Bayern, Deutschland (Colloquial)
  8. Landkreis Würzburg
    Landkreis Würzburg, Bayern, Deutschland (County)
  9. Main-Spessart
    Main-Spessart, Bayern, Deutschland (County)
  10. Europe/Berlin
    Europe/Berlin (Timezone)

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

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

        
0.027 seconds ⌛

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