24 places near 6027 Stockstadt am Main, Landkreis Aschaffenburg, Bayern, Deutschland
  1. Kleinostheim
    Kleinostheim, Landkreis Aschaffenburg, Bayern, Deutschland (Town)
  2. Mainaschaff
    Mainaschaff, Landkreis Aschaffenburg, Bayern, Deutschland (Town)
  3. Stockstadt am Main
    Stockstadt am Main, Landkreis Aschaffenburg, Bayern, Deutschland (Town)
  4. Rhein
    Rhein, Deutschland (Drainage)
  5. Main River
    Main River, Deutschland (Drainage)
  6. Gemeinde Mainhausen
    Gemeinde Mainhausen, Offenbach, Hessen, Deutschland (LocalAdmin)
  7. Gemeinde Kleinostheim
    Gemeinde Kleinostheim, Landkreis Aschaffenburg, Bayern, Deutschland (LocalAdmin)
  8. Gemeinde Mainaschaff
    Gemeinde Mainaschaff, Landkreis Aschaffenburg, Bayern, Deutschland (LocalAdmin)
  9. Gemeinde Stockstadt am Main
    Gemeinde Stockstadt am Main, Landkreis Aschaffenburg, Bayern, Deutschland (LocalAdmin)
  10. Unterfranken
    Unterfranken, Bayern, Deutschland (Colloquial)

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

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

        
0.017 seconds ⌛

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