25 places near 03139, Spree-Neiße, Bundesland Brandenburg, Deutschland
  1. Sabrodt
    Sabrodt, Landkreis Bautzen, Sachsen, Deutschland (Town)
  2. Schwarze Pumpe
    Schwarze Pumpe, Spree-Neiße, Bundesland Brandenburg, Deutschland (Town)
  3. Spremberg
    Spremberg, Spree-Neiße, Bundesland Brandenburg, Deutschland (Town)
  4. Terpe
    Terpe, Spree-Neiße, Bundesland Brandenburg, Deutschland (Town)
  5. Odra River
    Odra River, Szczecin, Zachodniopomorskie, Polska (Drainage)
  6. Gemeinde Elsterheide
    Gemeinde Elsterheide, Landkreis Bautzen, Sachsen, Deutschland (LocalAdmin)
  7. Gemeinde Spreetal
    Gemeinde Spreetal, Landkreis Bautzen, Sachsen, Deutschland (LocalAdmin)
  8. Gemeinde Spremberg
    Gemeinde Spremberg, Spree-Neiße, Bundesland Brandenburg, Deutschland (LocalAdmin)
  9. Silesia
    Silesia (Colloquial)
  10. Direktionsbezirk Dresden
    Direktionsbezirk Dresden, Sachsen, Deutschland (Colloquial)

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

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

        
0.044 seconds ⌛

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