17 places near Pijiño del Carmen, Magdalena, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. San Zenon
    San Zenon, Magdalena, Colombia (County)
  3. Santa Ana
    Santa Ana, Magdalena, Colombia (County)
  4. Pijiño del Carmen
    Pijiño del Carmen, Magdalena, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Bolivar
    Bolivar, Bolivar, Colombia (State)
  7. Magdalena
    Magdalena, Magdalena, Colombia (State)
  8. Colombia
    Colombia, Colombia (Country)
  9. Caribbean Sea
    Caribbean Sea (Sea)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.058 seconds ⌛

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