23 places near Pettstadt, Landkreis Bamberg, Bayern, Deutschland
  1. Eichenhof
    Eichenhof, Landkreis Bamberg, Bayern, Deutschland (Town)
  2. Erlach
    Erlach, Landkreis Bamberg, Bayern, Deutschland (Town)
  3. Neuhaus
    Neuhaus, Landkreis Bamberg, Bayern, Deutschland (Town)
  4. Pettstadt
    Pettstadt, Landkreis Bamberg, Bayern, Deutschland (Town)
  5. Schadlos
    Schadlos, Landkreis Bamberg, Bayern, Deutschland (Town)
  6. Main River
    Main River, Deutschland (Drainage)
  7. Gemeinde Frensdorf
    Gemeinde Frensdorf, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  8. Gemeinde Hirschaid
    Gemeinde Hirschaid, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  9. Gemeinde Pettstadt
    Gemeinde Pettstadt, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  10. Gemeinde Strullendorf
    Gemeinde Strullendorf, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)

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

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

        
0.028 seconds ⌛

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