27 places near Tora e Piccilli, Caserta, Campania, Italia
filter by placetype:
  1. Piccilli
    Piccilli, Caserta, Campania, Italia (Town)
  2. Presenzano
    Presenzano, Caserta, Campania, Italia (Town)
  3. Tora
    Tora, Caserta, Campania, Italia (Town)
  4. Foresta
    Foresta, Caserta, Campania, Italia (Town)
  5. Tuoro
    Tuoro, Caserta, Campania, Italia (Town)
  6. Marzano Appio
    Marzano Appio, Caserta, Campania, Italia (LocalAdmin)
  7. Conca della Campania
    Conca della Campania, Caserta, Campania, Italia (LocalAdmin)
  8. Tora e Piccilli
    Tora e Piccilli, Caserta, Campania, Italia (LocalAdmin)
  9. Presenzano
    Presenzano, Caserta, Campania, Italia (LocalAdmin)
  10. Frosinone
    Frosinone, Lazio, Italia (County)

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

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

        
0.052 seconds ⌛

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