21 places near Totari, Caserta, Campania, Italia
filter by placetype:
  1. Totari
    Totari, Caserta, Campania, Italia (Town)
  2. Carattano
    Carattano, Caserta, Campania, Italia (Town)
  3. Alife
    Alife, Caserta, Campania, Italia (LocalAdmin)
  4. Gioia Sannitica
    Gioia Sannitica, Caserta, Campania, Italia (LocalAdmin)
  5. Caserta
    Caserta, Campania, Italia (County)
  6. Benevento
    Benevento, Campania, Italia (County)
  7. Europe/Belgrade
    Europe/Belgrade (Timezone)
  8. Europe/Rome
    Europe/Rome (Timezone)
  9. Campania
    Campania, 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.017 seconds ⌛; show me the details?

        
0.017 seconds ⌛

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