18 places near Barrio de Crespo, Cartagena, Bolivar, Colombia
filter by placetype:
  1. Rafael Nunez Airport
    Rafael Nunez Airport, Cartagena, Bolivar, Colombia (Airport)
  2. Barrio de Crespo
    Barrio de Crespo, Cartagena, Bolivar, Colombia (Suburb)
  3. Cartagena
    Cartagena, Cartagena, Bolivar, Colombia (Town)
  4. Magdalena River
    Magdalena River, Colombia (Drainage)
  5. Cartagena
    Cartagena, Bolivar, Colombia (County)
  6. America/Bogota
    America/Bogota (Timezone)
  7. Bolivar
    Bolivar, Bolivar, Colombia (State)
  8. Caribbean Sea
    Caribbean Sea (Sea)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. North America
    North America (Continent)

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

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

        
0.045 seconds ⌛

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