21 places near 81046, Caserta, Campania, Italia
filter by placetype:
  1. Cancello ed Arnone
    Cancello ed Arnone, Caserta, Campania, Italia (Town)
  2. Grazzanise
    Grazzanise, Caserta, Campania, Italia (Town)
  3. Brezza
    Brezza, Caserta, Campania, Italia (Town)
  4. Cancello ed Arnone
    Cancello ed Arnone, Caserta, Campania, Italia (LocalAdmin)
  5. Grazzanise
    Grazzanise, Caserta, Campania, Italia (LocalAdmin)
  6. Caserta
    Caserta, 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.011 seconds ⌛; show me the details?

        
0.011 seconds ⌛

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