31 places near 海士ケ島新田, 新潟県, 日本
filter by placetype:
  1. 魚沼市
    魚沼市, 新潟県, 日本 (Town)
  2. 南魚沼市
    南魚沼市, 新潟県, 日本 (Town)
  3. 信濃川
    信濃川, 日本 (Drainage)
  4. 大崎
    大崎, 新潟県, 日本 (LocalAdmin)
  5. 穴地
    穴地, 新潟県, 日本 (LocalAdmin)
  6. 穴地新田
    穴地新田, 新潟県, 日本 (LocalAdmin)
  7. 海士ケ島新田
    海士ケ島新田, 新潟県, 日本 (LocalAdmin)
  8. 浦佐
    浦佐, 新潟県, 日本 (LocalAdmin)
  9. 鰕島
    鰕島, 新潟県, 日本 (LocalAdmin)
  10. 黒土新田
    黒土新田, 新潟県, 日本 (LocalAdmin)

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

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

        
0.022 seconds ⌛

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