25 places near Sarkadkeresztúr, Békés, Magyarország
filter by placetype:
  1. Sarkadkeresztúr
    Sarkadkeresztúr, Sarkadkeresztúr, Békés, Magyarország (Town)
  2. Donau
    Donau, Magyarország (Drainage)
  3. Tisa River
    Tisa River, Magyarország (Drainage)
  4. Southern Great Plain
    Southern Great Plain, Magyarország (Colloquial)
  5. Northern Great Plain
    Northern Great Plain, Magyarország (Colloquial)
  6. Transylvania
    Transylvania, România (Colloquial)
  7. Sarkad
    Sarkad, Békés, Magyarország (County)
  8. Sarkadkeresztúr
    Sarkadkeresztúr, Békés, Magyarország (County)
  9. Mezôgyán
    Mezôgyán, Békés, Magyarország (County)
  10. Europe/Belgrade
    Europe/Belgrade (Timezone)

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": [
                  21.38287,
                  46.828091
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}