19 places near Malandrone, Pisa, Toscana, Italia
filter by placetype:
  1. Castellina Marittima
    Castellina Marittima, Pisa, Toscana, Italia (Town)
  2. Rosignano Marittimo
    Rosignano Marittimo, Livorno, Toscana, Italia (Town)
  3. San Pietro in Palazzi
    San Pietro in Palazzi, Livorno, Toscana, Italia (Town)
  4. Malandrone
    Malandrone, Pisa, Toscana, Italia (Town)
  5. Rosignano Marittimo
    Rosignano Marittimo, Livorno, Toscana, Italia (LocalAdmin)
  6. Castellina Marittima
    Castellina Marittima, Pisa, Toscana, Italia (LocalAdmin)
  7. Toscano Arcipelago
    Toscano Arcipelago, Italia (Island)
  8. Pisa
    Pisa, Toscana, Italia (County)
  9. Livorno
    Livorno, Toscana, Italia (County)
  10. Europe/Rome
    Europe/Rome (Timezone)

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

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

        
0.027 seconds ⌛

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