メトリクス集計 - デカルト境界（Cartesian-bounds） - 《Elasticsearchガイドv8.15》日本語

Cartesian-bounds aggregation
Cartesian Bounds Aggregation on shape fields

Cartesian-bounds aggregation

すべての値を含む空間境界ボックスを計算するメトリック集約で、PointまたはShapeフィールドに対して行われます。

例:

Python

resp = client.indices.create(
   index="museums",
   mappings={
   "properties": {
   "location": {
   "type": "point"
   }
   }
   },
)
print(resp)
resp1 = client.bulk(
   index="museums",
   refresh=True,
   operations=[
   {
   "index": {
   "_id": 1
   }
   },
   {
   "location": "POINT (491.2350 5237.4081)",
   "city": "Amsterdam",
   "name": "NEMO Science Museum"
   },
   {
   "index": {
   "_id": 2
   }
   },
   {
   "location": "POINT (490.1618 5236.9219)",
   "city": "Amsterdam",
   "name": "Museum Het Rembrandthuis"
   },
   {
   "index": {
   "_id": 3
   }
   },
   {
   "location": "POINT (491.4722 5237.1667)",
   "city": "Amsterdam",
   "name": "Nederlands Scheepvaartmuseum"
   },
   {
   "index": {
   "_id": 4
   }
   },
   {
   "location": "POINT (440.5200 5122.2900)",
   "city": "Antwerp",
   "name": "Letterenhuis"
   },
   {
   "index": {
   "_id": 5
   }
   },
   {
   "location": "POINT (233.6389 4886.1111)",
   "city": "Paris",
   "name": "Musée du Louvre"
   },
   {
   "index": {
   "_id": 6
   }
   },
   {
   "location": "POINT (232.7000 4886.0000)",
   "city": "Paris",
   "name": "Musée d'Orsay"
   }
   ],
)
print(resp1)
resp2 = client.search(
   index="museums",
   size="0",
   query={
   "match": {
   "name": "musée"
   }
   },
   aggs={
   "viewport": {
   "cartesian_bounds": {
   "field": "location"
   }
   }
   },
)
print(resp2)

Ruby

response = client.indices.create(
  index: 'museums',
  body: {
   mappings: {
   properties: {
   location: {
   type: 'point'
   }
   }
   }
  }
)
puts response
response = client.bulk(
  index: 'museums',
  refresh: true,
  body: [
   {
   index: {
   _id: 1
   }
   },
   {
   location: 'POINT (491.2350 5237.4081)',
   city: 'Amsterdam',
   name: 'NEMO Science Museum'
   },
   {
   index: {
   _id: 2
   }
   },
   {
   location: 'POINT (490.1618 5236.9219)',
   city: 'Amsterdam',
   name: 'Museum Het Rembrandthuis'
   },
   {
   index: {
   _id: 3
   }
   },
   {
   location: 'POINT (491.4722 5237.1667)',
   city: 'Amsterdam',
   name: 'Nederlands Scheepvaartmuseum'
   },
   {
   index: {
   _id: 4
   }
   },
   {
   location: 'POINT (440.5200 5122.2900)',
   city: 'Antwerp',
   name: 'Letterenhuis'
   },
   {
   index: {
   _id: 5
   }
   },
   {
   location: 'POINT (233.6389 4886.1111)',
   city: 'Paris',
   name: 'Musée du Louvre'
   },
   {
   index: {
   _id: 6
   }
   },
   {
   location: 'POINT (232.7000 4886.0000)',
   city: 'Paris',
   name: "Musée d'Orsay"
   }
  ]
)
puts response
response = client.search(
  index: 'museums',
  size: 0,
  body: {
   query: {
   match: {
   name: 'musée'
   }
   },
   aggregations: {
   viewport: {
   cartesian_bounds: {
   field: 'location'
   }
   }
   }
  }
)
puts response

Js

const response = await client.indices.create({
  index: "museums",
  mappings: {
   properties: {
   location: {
   type: "point",
   },
   },
  },
});
console.log(response);
const response1 = await client.bulk({
  index: "museums",
  refresh: "true",
  operations: [
   {
   index: {
   _id: 1,
   },
   },
   {
   location: "POINT (491.2350 5237.4081)",
   city: "Amsterdam",
   name: "NEMO Science Museum",
   },
   {
   index: {
   _id: 2,
   },
   },
   {
   location: "POINT (490.1618 5236.9219)",
   city: "Amsterdam",
   name: "Museum Het Rembrandthuis",
   },
   {
   index: {
   _id: 3,
   },
   },
   {
   location: "POINT (491.4722 5237.1667)",
   city: "Amsterdam",
   name: "Nederlands Scheepvaartmuseum",
   },
   {
   index: {
   _id: 4,
   },
   },
   {
   location: "POINT (440.5200 5122.2900)",
   city: "Antwerp",
   name: "Letterenhuis",
   },
   {
   index: {
   _id: 5,
   },
   },
   {
   location: "POINT (233.6389 4886.1111)",
   city: "Paris",
   name: "Musée du Louvre",
   },
   {
   index: {
   _id: 6,
   },
   },
   {
   location: "POINT (232.7000 4886.0000)",
   city: "Paris",
   name: "Musée d'Orsay",
   },
  ],
});
console.log(response1);
const response2 = await client.search({
  index: "museums",
  size: 0,
  query: {
   match: {
   name: "musée",
   },
  },
  aggs: {
   viewport: {
   cartesian_bounds: {
   field: "location",
   },
   },
  },
});
console.log(response2);

Console

PUT /museums
{
  "mappings": {
   "properties": {
   "location": {
   "type": "point"
   }
   }
  }
}
POST /museums/_bulk?refresh
{"index":{"_id":1}}
{"location": "POINT (491.2350 5237.4081)", "city": "Amsterdam", "name": "NEMO Science Museum"}
{"index":{"_id":2}}
{"location": "POINT (490.1618 5236.9219)", "city": "Amsterdam", "name": "Museum Het Rembrandthuis"}
{"index":{"_id":3}}
{"location": "POINT (491.4722 5237.1667)", "city": "Amsterdam", "name": "Nederlands Scheepvaartmuseum"}
{"index":{"_id":4}}
{"location": "POINT (440.5200 5122.2900)", "city": "Antwerp", "name": "Letterenhuis"}
{"index":{"_id":5}}
{"location": "POINT (233.6389 4886.1111)", "city": "Paris", "name": "Musée du Louvre"}
{"index":{"_id":6}}
{"location": "POINT (232.7000 4886.0000)", "city": "Paris", "name": "Musée d'Orsay"}
POST /museums/_search?size=0
{
  "query": {
   "match": { "name": "musée" }
  },
  "aggs": {
   "viewport": {
   "cartesian_bounds": {
   "field": "location"
   }
   }
  }
}


	`cartesian_bounds`集約は、境界を取得するために使用するフィールドを指定します。これはPointまたはShapeタイプでなければなりません。

geo_bounds集約の場合とは異なり、wrap_longitudeを設定するオプションはありません。これは、デカルト空間がユークリッドであり、自身に戻ることがないためです。したがって、境界は常に最小x値が最大x値以下になります。

上記の集約は、名前が「musée」と一致するすべてのドキュメントの位置フィールドの境界ボックスを計算する方法を示しています。

上記の集約に対する応答:

Console-Result

{
  ...
  "aggregations": {
   "viewport": {
   "bounds": {
   "top_left": {
   "x": 232.6999969482422,
   "y": 4886.111328125
   },
   "bottom_right": {
   "x": 233.63890075683594,
   "y": 4886.0
   }
   }
   }
  }
}

Cartesian Bounds Aggregation on shape fields

デカルト境界集約は、cartesian_shapeフィールドでもサポートされています。

例:

Python

resp = client.indices.create(
   index="places",
   mappings={
   "properties": {
   "geometry": {
   "type": "shape"
   }
   }
   },
)
print(resp)
resp1 = client.bulk(
   index="places",
   refresh=True,
   operations=[
   {
   "index": {
   "_id": 1
   }
   },
   {
   "name": "NEMO Science Museum",
   "geometry": "POINT(491.2350 5237.4081)"
   },
   {
   "index": {
   "_id": 2
   }
   },
   {
   "name": "Sportpark De Weeren",
   "geometry": {
   "type": "Polygon",
   "coordinates": [
   [
   [
                            496.5305328369141,
                            5239.347642069457
   ],
   [
                            496.6979026794433,
                            5239.172175893484
   ],
   [
                            496.9425201416015,
                            5239.238958618537
   ],
   [
                            496.7944622039794,
                            5239.420969150824
   ],
   [
                            496.5305328369141,
                            5239.347642069457
   ]
   ]
   ]
   }
   }
   ],
)
print(resp1)
resp2 = client.search(
   index="places",
   size="0",
   aggs={
   "viewport": {
   "cartesian_bounds": {
   "field": "geometry"
   }
   }
   },
)
print(resp2)

Ruby

response = client.indices.create(
  index: 'places',
  body: {
   mappings: {
   properties: {
   geometry: {
   type: 'shape'
   }
   }
   }
  }
)
puts response
response = client.bulk(
  index: 'places',
  refresh: true,
  body: [
   {
   index: {
   _id: 1
   }
   },
   {
   name: 'NEMO Science Museum',
   geometry: 'POINT(491.2350 5237.4081)'
   },
   {
   index: {
   _id: 2
   }
   },
   {
   name: 'Sportpark De Weeren',
   geometry: {
   type: 'Polygon',
   coordinates: [
   [
   [
              496.5305328369141,
              5239.347642069457
   ],
   [
              496.6979026794433,
              5239.172175893484
   ],
   [
              496.9425201416015,
              5239.238958618537
   ],
   [
              496.7944622039794,
              5239.420969150824
   ],
   [
              496.5305328369141,
              5239.347642069457
   ]
   ]
   ]
   }
   }
  ]
)
puts response
response = client.search(
  index: 'places',
  size: 0,
  body: {
   aggregations: {
   viewport: {
   cartesian_bounds: {
   field: 'geometry'
   }
   }
   }
  }
)
puts response

Js

const response = await client.indices.create({
  index: "places",
  mappings: {
   properties: {
   geometry: {
   type: "shape",
   },
   },
  },
});
console.log(response);
const response1 = await client.bulk({
  index: "places",
  refresh: "true",
  operations: [
   {
   index: {
   _id: 1,
   },
   },
   {
   name: "NEMO Science Museum",
   geometry: "POINT(491.2350 5237.4081)",
   },
   {
   index: {
   _id: 2,
   },
   },
   {
   name: "Sportpark De Weeren",
   geometry: {
   type: "Polygon",
   coordinates: [
   [
   [496.5305328369141, 5239.347642069457],
   [496.6979026794433, 5239.172175893484],
   [496.9425201416015, 5239.238958618537],
   [496.7944622039794, 5239.420969150824],
   [496.5305328369141, 5239.347642069457],
   ],
   ],
   },
   },
  ],
});
console.log(response1);
const response2 = await client.search({
  index: "places",
  size: 0,
  aggs: {
   viewport: {
   cartesian_bounds: {
   field: "geometry",
   },
   },
  },
});
console.log(response2);

Console

PUT /places
{
  "mappings": {
   "properties": {
   "geometry": {
   "type": "shape"
   }
   }
  }
}
POST /places/_bulk?refresh
{"index":{"_id":1}}
{"name": "NEMO Science Museum", "geometry": "POINT(491.2350 5237.4081)" }
{"index":{"_id":2}}
{"name": "Sportpark De Weeren", "geometry": { "type": "Polygon", "coordinates": [ [ [ 496.5305328369141, 5239.347642069457 ], [ 496.6979026794433, 5239.1721758934835 ], [ 496.9425201416015, 5239.238958618537 ], [ 496.7944622039794, 5239.420969150824 ], [ 496.5305328369141, 5239.347642069457 ] ] ] } }
POST /places/_search?size=0
{
  "aggs": {
   "viewport": {
   "cartesian_bounds": {
   "field": "geometry"
   }
   }
  }
}

Console-Result

{
  ...
  "aggregations": {
   "viewport": {
   "bounds": {
   "top_left": {
   "x": 491.2349853515625,
   "y": 5239.4208984375
   },
   "bottom_right": {
   "x": 496.9425048828125,
   "y": 5237.408203125
   }
   }
   }
  }
}