# How to enable geo\_point or geo\_shape in csv data to linestring

**URL:** https://discuss.elastic.co/t/how-to-enable-geo-point-or-geo-shape-in-csv-data-to-linestring/278120
**Category:** Elasticsearch
**Created:** [July 8, 2021, 1:48am UTC](https://discuss.elastic.co/t/how-to-enable-geo-point-or-geo-shape-in-csv-data-to-linestring/278120 "2021-07-08T01:48:30Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![yuhw1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuhw1/32/91312_2.png) [@yuhw1](https://discuss.elastic.co/u/yuhw1)
#### Post date: [July 8, 2021, 1:48am UTC](https://discuss.elastic.co/t/how-to-enable-geo-point-or-geo-shape-in-csv-data-to-linestring/278120/1 "2021-07-08T01:48:30Z")

</div>

I am trying to draw a line by extracting the location and timestamp data from the geo\_point or geo\_shape index where the csv file is uploaded. But it keeps failing, and the aggregations are not applied. So, I am asking if there is a way to extract two items and draw a 'location' line in map(Kibana) according to the 'timestamp'.  
my Elasicsearch license is 'basic'  
Below is the error code and index format.

```auto
{
  "error" : {
    "root_cause" : [
      {
        "type" : "security_exception",
        "reason" : "current license is non-compliant for [SPATIAL_GEO_LINE]",
        "license.expired.feature" : "SPATIAL_GEO_LINE"
      }
    ],
    "type" : "security_exception",
    "reason" : "current license is non-compliant for [SPATIAL_GEO_LINE]",
    "license.expired.feature" : "SPATIAL_GEO_LINE"
  },
  "status" : 403
}

```

```auto
{
        "_index" : "gps_se4",
        "_type" : "_doc",
        "_id" : "m-kkdXoB1Kp5W5HUXw5W",
        "_score" : 1.0,
        "_source" : {
          "FloorCode" : 1,
          "IsSuspicious" : 0,
          "lon" : 126.955349061,
          "CreateDate" : "2020-03-09 09:14:20.943",
          "@timestamp" : "2020-03-09T09:14:20.910+09:00",
          "X" : 684.0573108321,
          "Y" : 1126.8392964661,
          "CalculationDate" : "2020-03-09 09:14:20.910",
          "TagCode" : 40003,
          "location" : "37.5847676941,126.955349061",
          "Id" : 3,
          "lat" : 37.5847676941
        }
      },
      {
        "_index" : "gps_se4",
        "_type" : "_doc",
        "_id" : "nOkkdXoB1Kp5W5HUXw5W",
        "_score" : 1.0,
        "_source" : {
          "FloorCode" : 1,
          "IsSuspicious" : 0,
          "lon" : 126.9558666352,
          "CreateDate" : "2020-03-09 09:14:21.967",
          "@timestamp" : "2020-03-09T09:14:21.940+09:00",
          "X" : 732.7000668183,
          "Y" : 1151.6227001975,
          "CalculationDate" : "2020-03-09 09:14:21.940",
          "TagCode" : 40003,
          "location" : "37.5850000642,126.9558666352",
          "Id" : 4,
          "lat" : 37.5850000642
        }
      },

```

....

Sorry for my poor English and I appreciate your help.

---

<div class="post-metadata">

### Author: ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)
#### Post date: [July 8, 2021, 11:07am UTC](https://discuss.elastic.co/t/how-to-enable-geo-point-or-geo-shape-in-csv-data-to-linestring/278120/2 "2021-07-08T11:07:53Z")

</div>

Hey,

so this `geo_line` aggregation requires a gold license, see [Subscriptions | Elastic Stack Products & Support | Elastic](https://www.elastic.co/subscriptions).

--Alex

---

<div class="post-metadata">

### Author: ![yuhw1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuhw1/32/91312_2.png) [@yuhw1](https://discuss.elastic.co/u/yuhw1)
#### Post date: [July 9, 2021, 12:07am UTC](https://discuss.elastic.co/t/how-to-enable-geo-point-or-geo-shape-in-csv-data-to-linestring/278120/3 "2021-07-09T00:07:22Z")

</div>

Thanks for help!! I solve it using python code.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 6, 2021, 12:07am UTC](https://discuss.elastic.co/t/how-to-enable-geo-point-or-geo-shape-in-csv-data-to-linestring/278120/4 "2021-08-06T00:07:31Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
