9 places near 井栗, 新潟県, 日本
filter by placetype:
  1. 井栗
    井栗, 新潟県, 日本 (LocalAdmin)
  2. 上保内
    上保内, 新潟県, 日本 (LocalAdmin)
  3. 北野新田
    北野新田, 新潟県, 日本 (LocalAdmin)
  4. 下保内
    下保内, 新潟県, 日本 (LocalAdmin)
  5. 白山新田
    白山新田, 新潟県, 日本 (LocalAdmin)
  6. 大字加茂
    大字加茂, 新潟県, 日本 (LocalAdmin)
  7. 大字下条
    大字下条, 新潟県, 日本 (LocalAdmin)
  8. 大字天神林
    大字天神林, 新潟県, 日本 (LocalAdmin)
  9. 大字矢立新田
    大字矢立新田, 新潟県, 日本 (LocalAdmin)

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

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

        
0.035 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  139.014877,
                  37.652039
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 10
          }
        }
      ],
      "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"
      }
    }
  ]
}