9 places near Gemeinde Püttlingen, Landkreis Saarbrücken, Saarland, Deutschland
filter by placetype:
  1. Engelfangen
    Engelfangen, Landkreis Saarbrücken, Saarland, Deutschland (Town)
  2. Etzenhofen
    Etzenhofen, Landkreis Saarbrücken, Saarland, Deutschland (Town)
  3. Köllerbach
    Köllerbach, Landkreis Saarbrücken, Saarland, Deutschland (Town)
  4. Kölln
    Kölln, Landkreis Saarbrücken, Saarland, Deutschland (Town)
  5. Püttlingen
    Püttlingen, Landkreis Saarbrücken, Saarland, Deutschland (Town)
  6. Riegelsberg
    Riegelsberg, Landkreis Saarbrücken, Saarland, Deutschland (Town)
  7. Rittenhofen
    Rittenhofen, Landkreis Saarbrücken, Saarland, Deutschland (Town)
  8. Saarbrücken
    Saarbrücken, Landkreis Saarbrücken, Saarland, Deutschland (Town)
  9. Sellerbach
    Sellerbach, Landkreis Saarbrücken, Saarland, Deutschland (Town)

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

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

        
0.025 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  6.89228,
                  49.29451
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}