17 places near Castellina Marittima, Pisa, Toscana, Italia
filter by placetype:
  1. Castellina Marittima
    Castellina Marittima, Pisa, Toscana, Italia (Town)
  2. Riparbella
    Riparbella, Pisa, Toscana, Italia (Town)
  3. Castellina Marittima
    Castellina Marittima, Pisa, Toscana, Italia (LocalAdmin)
  4. Riparbella
    Riparbella, Pisa, Toscana, Italia (LocalAdmin)
  5. Toscano Arcipelago
    Toscano Arcipelago, Italia (Island)
  6. Pisa
    Pisa, Toscana, Italia (County)
  7. Livorno
    Livorno, Toscana, Italia (County)
  8. Europe/Rome
    Europe/Rome (Timezone)
  9. Toscana
    Toscana, Italia (State)
  10. Italia
    Italia, Italia (Country)

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.55058,
                  43.397652
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}