20 places near Sbrullini, Macerata, Marche, Italia
filter by placetype:
  1. Porto Potenza Picena
    Porto Potenza Picena, Macerata, Marche, Italia (Town)
  2. Casette Antonelli
    Casette Antonelli, Macerata, Marche, Italia (Town)
  3. Sbrullini
    Sbrullini, Macerata, Marche, Italia (Town)
  4. Potenza Picena
    Potenza Picena, Macerata, Marche, Italia (LocalAdmin)
  5. Macerata
    Macerata, Marche, Italia (County)
  6. Europe/Belgrade
    Europe/Belgrade (Timezone)
  7. Europe/Rome
    Europe/Rome (Timezone)
  8. Marche
    Marche, Italia (State)
  9. Italia
    Italia, Italia (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.04 seconds ⌛

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