19 places near Podere Colombaie, Pisa, Toscana, Italia
filter by placetype:
  1. Montecatini
    Montecatini, Pisa, Toscana, Italia (Town)
  2. Podere Colombaie
    Podere Colombaie, Pisa, Toscana, Italia (Town)
  3. Ponteginori
    Ponteginori, Pisa, Toscana, Italia (Town)
  4. Riparbella
    Riparbella, Pisa, Toscana, Italia (Town)
  5. Montescudaio
    Montescudaio, Pisa, Toscana, Italia (Town)
  6. Montecatini Val di Cecina
    Montecatini Val di Cecina, 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.017 seconds ⌛; show me the details?

        
0.017 seconds ⌛

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