28 places near Stadtteil Philippinenhof, Stadtkreis Kassel, Hessen, Deutschland
  1. Nord
    Nord, Stadtkreis Kassel, Hessen, Deutschland (Suburb)
  2. Philippinenhof/warteberg
    Philippinenhof/warteberg, Stadtkreis Kassel, Hessen, Deutschland (Suburb)
  3. Frommershausen
    Frommershausen, Landkreis Kassel, Hessen, Deutschland (Town)
  4. Fuldatal
    Fuldatal, Landkreis Kassel, Hessen, Deutschland (Town)
  5. Ihringshausen
    Ihringshausen, Landkreis Kassel, Hessen, Deutschland (Town)
  6. Kassel
    Kassel, Stadtkreis Kassel, Hessen, Deutschland (Town)
  7. Niedervellmar
    Niedervellmar, Landkreis Kassel, Hessen, Deutschland (Town)
  8. Vellmar
    Vellmar, Landkreis Kassel, Hessen, Deutschland (Town)
  9. Rhein
    Rhein, Deutschland (Drainage)
  10. Weser River
    Weser River, Deutschland (Drainage)

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

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

        
0.348 seconds ⌛

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