25 places near Mannheim-Neckarau Bahnhof, Stadtkreis Mannheim, Baden-Württemberg, Deutschland
filter by placetype:
  1. Stadtteil Rheinau
    Stadtteil Rheinau, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (LocalAdmin)
  2. Rhein-Neckar-Kreis
    Rhein-Neckar-Kreis, Baden-Württemberg, Deutschland (County)
  3. Bergstraße
    Bergstraße, Hessen, Deutschland (County)
  4. Ludwigshafen
    Ludwigshafen, Rheinland-Pfalz, Deutschland (County)
  5. Stadtkreis Mannheim
    Stadtkreis Mannheim, Baden-Württemberg, Deutschland (County)
  6. Europe/Berlin
    Europe/Berlin (Timezone)
  7. Europe/Paris
    Europe/Paris (Timezone)
  8. Baden-Württemberg
    Baden-Württemberg, Baden-Württemberg, Deutschland (State)
  9. Deutschland
    Deutschland, Deutschland (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.018 seconds ⌛

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