24 places near Gemeinde Roxheim, Landkreis Bad Kreuznach, Rheinland-Pfalz, Deutschland
filter by placetype:
  1. Gemeinde St. Katharinen
    Gemeinde St. Katharinen, Landkreis Bad Kreuznach, Rheinland-Pfalz, Deutschland (LocalAdmin)
  2. Gemeinde Wallhausen
    Gemeinde Wallhausen, Landkreis Bad Kreuznach, Rheinland-Pfalz, Deutschland (LocalAdmin)
  3. Landkreis Bad Kreuznach
    Landkreis Bad Kreuznach, Rheinland-Pfalz, Deutschland (County)
  4. Mainz-Bingen
    Mainz-Bingen, Rheinland-Pfalz, Deutschland (County)
  5. Europe/Berlin
    Europe/Berlin (Timezone)
  6. Europe/Paris
    Europe/Paris (Timezone)
  7. Rheinland-Pfalz
    Rheinland-Pfalz, Rheinland-Pfalz, Deutschland (State)
  8. Deutschland
    Deutschland, Deutschland (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.014 seconds ⌛

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