17 places near 上児木, 新潟県, 日本
filter by placetype:
  1. 大島
    大島, 新潟県, 日本 (LocalAdmin)
  2. 荻島
    荻島, 新潟県, 日本 (LocalAdmin)
  3. 代官島
    代官島, 新潟県, 日本 (LocalAdmin)
  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.014 seconds ⌛; show me the details?

        
0.014 seconds ⌛

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