17 places near Pingrala, Ratlam, Madhya Pradesh, India
filter by placetype:
  1. Pingrala
    Pingrala, Ratlam, Madhya Pradesh, India (Town)
  2. Mandsaur
    Mandsaur, Madhya Pradesh, India (County)
  3. Ratlam
    Ratlam, Madhya Pradesh, India (County)
  4. Chittaurgarh
    Chittaurgarh, Rajasthan, India (County)
  5. Asia/Kolkata
    Asia/Kolkata (Timezone)
  6. Asia/Karachi
    Asia/Karachi (Timezone)
  7. Madhya Pradesh
    Madhya Pradesh, Madhya Pradesh, India (State)
  8. India
    India, India (Country)
  9. Indian Ocean
    Indian Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.046 seconds ⌛

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