# Create Virtual Index, data type Point

**URL:** <https://community.siren.io/t/create-virtual-index-data-type-point/246>\
**Category:** Siren Platform/Investigate Tech Support Community\
**Created:** [May 15, 2020, 5:48am UTC](https://community.siren.io/t/create-virtual-index-data-type-point/246 "2020-05-15T05:48:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Farhan\_Shahrul](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/farhan_shahrul/32/148_2.png) [@Farhan\_Shahrul](https://community.siren.io/u/Farhan_Shahrul)\
**Post date:** [May 15, 2020, 5:48am UTC](https://community.siren.io/t/create-virtual-index-data-type-point/246/1 "2020-05-15T05:48:02Z")

</div>

Hi Siren,

We have created a new column in my database and set the data type as ‘point’. When we want to do Virtual Index, the new column doesnt reflect the field with ‘point’ data type in the Data Model.

FYI, we use Siren 10.4 and ES 6.8.6.

---

<div class="post-metadata">

**Author:** ![Manu\_Agarwal](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/manu_agarwal/32/120_2.png) [@Manu\_Agarwal](https://community.siren.io/u/Manu_Agarwal)\
**Post date:** [May 15, 2020, 9:27am UTC](https://community.siren.io/t/create-virtual-index-data-type-point/246/2 "2020-05-15T09:27:27Z")

</div>

Hi Farhan,

Point is not supported here is the link of the compatible types:

[https://docs.support.siren.io/siren-federate-user-guide/19.0/siren-federate/connecting-to-remote.html#\_type\_conversion](https://docs.support.siren.io/siren-federate-user-guide/19.0/siren-federate/connecting-to-remote.html#_type_conversion)

If you just pass the lat and long as string and then pick the geo\_point type in the reflection job it will convert them accordingly.

Regards  
Manu

---

<div class="post-metadata">

**Author:** ![jccq](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/jccq/32/12_2.png) [@jccq](https://community.siren.io/u/jccq)\
**Post date:** [May 19, 2020, 6:08am UTC](https://community.siren.io/t/create-virtual-index-data-type-point/246/4 "2020-05-19T06:08:04Z")

</div>

Farhan hi.  
If you managed to see a X Y coordinate in your Siren records (e.g. simply connecting latitude/longitude coordinates ) then you can see those points on the Graph Map mode by using a the “Time/Location set lens”

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/siren/original/1X/06c680d888087d178a7a470a356b1dc9bd814c68.png)

this allows you to chose the fields and uses it for the map (or time). In theory also the regular “Enhanced Tilemap Component” (the other component that SIren has for mapping) would be possible with virtual indexes but the implementation is not there yet.

Let us knowprivately if its very important for you and we can discuss prioritization.

Another way to have everything work now would anyway be to activate reflection for that virtual index. This creates an Elasticsearch index with that data and during the reflection you can create a geopoint from any X/Y - which in turn you can extract in your SQL query (using the ingestion pipeline option which you have in the reflection UI) . All would then work nicely in this case.

---

<div class="post-metadata">

**Author:** ![Farhan\_Shahrul](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/farhan_shahrul/32/148_2.png) [@Farhan\_Shahrul](https://community.siren.io/u/Farhan_Shahrul)\
**Post date:** [May 19, 2020, 1:44pm UTC](https://community.siren.io/t/create-virtual-index-data-type-point/246/5 "2020-05-19T13:44:55Z")

</div>

Understood the steps clearly. Thanks for the explanation.