8 places near Trebiano, La Spezia, Liguria, Italia
filter by placetype:
  1. Arcola
    Arcola, La Spezia, Liguria, Italia (Town)
  2. Il Romito
    Il Romito, La Spezia, Liguria, Italia (Town)
  3. Sarzana
    Sarzana, La Spezia, Liguria, Italia (Town)
  4. Trebiano
    Trebiano, La Spezia, Liguria, Italia (Town)
  5. Cerri
    Cerri, La Spezia, Liguria, Italia (Town)
  6. Ressora
    Ressora, La Spezia, Liguria, Italia (Town)
  7. San Lorenzo
    San Lorenzo, La Spezia, Liguria, Italia (Town)
  8. Ponte di Arcola
    Ponte di Arcola, La Spezia, Liguria, Italia (Town)

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

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

        
0.031 seconds ⌛

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