26 places near Main River, Deutschland
  1. Würzburg gemeindefreies Gebiet
    Würzburg gemeindefreies Gebiet, Landkreis Würzburg, Bayern, Deutschland (LocalAdmin)
  2. Unterfranken
    Unterfranken, Bayern, Deutschland (Colloquial)
  3. Landkreis Würzburg
    Landkreis Würzburg, Bayern, Deutschland (County)
  4. Main-Spessart
    Main-Spessart, Bayern, Deutschland (County)
  5. Main-Tauber-Kreis
    Main-Tauber-Kreis, Baden-Württemberg, Deutschland (County)
  6. Stadtkreis Würzburg
    Stadtkreis Würzburg, Bayern, Deutschland (County)
  7. Europe/Berlin
    Europe/Berlin (Timezone)
  8. Baden-Württemberg
    Baden-Württemberg, Baden-Württemberg, Deutschland (State)
  9. Bayern
    Bayern, Bayern, Deutschland (State)
  10. Deutschland
    Deutschland, Deutschland (Country)

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

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

        
0.03 seconds ⌛

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