24 places near Stadtteil Borgfeld, Stadtkreis Bremen, Freie Hansestadt Bremen, Deutschland
filter by placetype:
  1. Hodenberg
    Hodenberg, Stadtkreis Bremen, Freie Hansestadt Bremen, Deutschland (Suburb)
  2. Katrepel
    Katrepel, Stadtkreis Bremen, Freie Hansestadt Bremen, Deutschland (Suburb)
  3. Rockwinkel
    Rockwinkel, Stadtkreis Bremen, Freie Hansestadt Bremen, Deutschland (Suburb)
  4. Timmersloh
    Timmersloh, Landkreis Osterholz, Niedersachsen, Deutschland (Suburb)
  5. Verenmoor
    Verenmoor, Landkreis Osterholz, Niedersachsen, Deutschland (Suburb)
  6. Bremen
    Bremen, Stadtkreis Bremen, Freie Hansestadt Bremen, Deutschland (Town)
  7. Lilienthal
    Lilienthal, Landkreis Osterholz, Niedersachsen, Deutschland (Town)
  8. Weser River
    Weser River, Deutschland (Drainage)
  9. Gemeinde Lilienthal
    Gemeinde Lilienthal, Landkreis Osterholz, Niedersachsen, Deutschland (LocalAdmin)
  10. Stadtteil Borgfeld
    Stadtteil Borgfeld, Stadtkreis Bremen, Freie Hansestadt Bremen, Deutschland (LocalAdmin)

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

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

        
0.088 seconds ⌛

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