17 places near El Hatillo, Barbosa, Antioquia, Colombia
filter by placetype:
  1. El Hatillo
    El Hatillo, Barbosa, Antioquia, Colombia (Town)
  2. Hatillo
    Hatillo, Barbosa, Antioquia, Colombia (Town)
  3. Magdalena River
    Magdalena River, Colombia (Drainage)
  4. Barbosa
    Barbosa, Antioquia, Colombia (County)
  5. Don Matias
    Don Matias, Antioquia, Colombia (County)
  6. Girardota
    Girardota, Antioquia, Colombia (County)
  7. America/Bogota
    America/Bogota (Timezone)
  8. Antioquia
    Antioquia, Antioquia, Colombia (State)
  9. Colombia
    Colombia, Colombia (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.034 seconds ⌛

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