24 places near Roxheim, Landkreis Bad Kreuznach, Rheinland-Pfalz, Deutschland
filter by placetype:
  1. Gemeinde Roxheim
    Gemeinde Roxheim, 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.015 seconds ⌛; show me the details?

        
0.015 seconds ⌛

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