不能在Elasticsearch 5和Kibana 5中使用GeoJSON

Question

我无法在Elasticsearch中索引GeoJSON数据并用它们创建平铺地图。

-->将GeoJSON发送到ES：

curl -XPUT "http://localhost:9200/datas/data/3617" -d 
'{
    "geometry": {
        "coordinates": [
            7.040691666666667,
            43.626736111111114
        ],
        "type": "Point"
    },
    "properties": {
        "createdAt": {
            "$date": "2016-04-06T15:40:42.402Z"
        },
        "device": "000-0002",
        "ind": 0,
        "timestamp": {
            "$date": "2016-04-06T16:40:41.000Z"
        }
    },
    "type": "Feature"
}'

curl-xget“http://localhost:9200/datas/data/_mapping”

{
  "datas": {
    "mappings": {
      "data": {
        "properties": {
          "geometry": {
            "properties": {
              "coordinates": {
                "type": "float"
              },
              "type": {
                "type": "text",
                "fields": {
                  "keyword": {
                    "type": "keyword",
                    "ignore_above": 256
                  }
                }
              }
            }
          },
          "properties": {
            "properties": {
              "createdAt": {
                "properties": {
                  "$date": {
                    "type": "date"
                  }
                }
              },
              "device": {
                "type": "text",
                "fields": {
                  "keyword": {
                    "type": "keyword",
                    "ignore_above": 256
                  }
                }
              },
              "ind": {
                "type": "long"
              },
              "timestamp": {
                "properties": {
                  "$date": {
                    "type": "date"
                  }
                }
              }
            }
          },
          "type": {
            "type": "text",
            "fields": {
              "keyword": {
                "type": "keyword",
                "ignore_above": 256
              }
            }
          }
        }
      }
    }
  }
}

curl -XPUT "http://localhost:9200/datas/_mapping/data" -d '{
    "data": {
       "properties": {
          "geometry": {
             "type": "geo_shape"
          }
       }
    }
  }'

=>{“已确认”：true}

$ curl -XGET "http://localhost:9200/datas/_mapping/data"

=>{“datas”：{“mappings”：{“data”：{“properties”：{“geometry”：{“type”：“geo_shape”}}}}}}}

curl -XPUT "http://localhost:9200/datas/data/3617" -d 
'{
    "geometry": {
        "coordinates": [
            7.040691666666667,
            43.626736111111114
        ],
        "type": "Point"
    },
}'

=>{“_index”：“datas”,“_type”：“data”,“_id”：“3617”,“_version”：1,“_shards”：{“total”：2,“successed”：1,“failed”：0},“created”：true}

在映射中将geo_shape替换为geo_point时，插入示例数据时出现以下错误：

curl -XPUT "http://localhost:9200/datas/data/3617" -d 
'{
    "geometry": {
        "coordinates": [
            7.040691666666667,
            43.626736111111114
        ],
        "type": "Point"
    },
}'

{"error":{"root_cause":[{"type":"parse_exception","reason":"field must be either [lat], [lon] or [geohash]"}],"type":"mapper_parsing_exception","reason":"failed to parse","caused_by":{"type":"parse_exception","reason":"field must be either [lat], [lon] or [geohash]"}},"status":400}

Answer 1

ES不直接摄取GeoJSON，相反，您需要将其转换为适当的geo_shape，在您的示例中，它将是一个点。

首先，您需要创建一个索引和一个映射来接受geo_shape字段，如下所示：

curl -XPUT "http://localhost:9200/datas" -d '{
  "mappings": {
    "data": {
       "properties": {
          "location": {
             "type": "geo_shape"
          }
       }
    }
  }
}'

然后您可以像这样索引您的GeoJSON点：

curl -XPUT "http://localhost:9200/datas/data/3617" -d '{
    "location" : {
        "type" : "point",
        "coordinates" : [7.040691666666667, 43.626736111111114]
    }
}'

curl -XPUT "http://localhost:9200/datas" -d '{
  "mappings": {
    "data": {
       "properties": {
          "location": {
             "type": "geo_point",
             "geohash_prefix": true
          }
       }
    }
  }
}'

curl -XPUT "http://localhost:9200/datas/data/3617" -d '{
    "location" : {
        "lat": 43.626736111111114,
        "lon": 7.040691666666667
    }
}'