Skip to main content
Question

Loading data to elastic search


boubcher
Contributor
Forum|alt.badge.img+11

we have a simple workspace MSsql spatial reader and elastic search writer, but we are having this error, attached text file

Any idea

6 replies

mark2atsafe
Safer
Forum|alt.badge.img+45
  • Safer
  • October 17, 2017
What's the error? I only see two workspace files attached.

 


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • October 17, 2017

Forum|alt.badge.img+2
  • October 17, 2017

ElasticSearch coordinates are always stored in LL-WGS84. If spatial data in a different coordinate system enters the ElasticSearch writer, then FME will try and reproject the data to LL84. In this case, it looks like the SQL Server reader is not returning a recognized coordinate system for the dbo.Parcels_View table. Use FME Data Inspector to view the dbo.Parcels_View table and confirm the source coordinate system. You might have to explicitly set the coordinate system on the SQL Server reader.


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • October 22, 2017

@Mark

Thanks we fix the problem of the coordinate as you recomanded , but we are still unable to display the polygone on Kibana Dashborad

take a look at the print screens

https://qsnapnet.com/snaps/jb0alvm930kep14

https://qsnapnet.com/snaps/9nwed91dp7ujtt9

All snaps: https://qsnapnet.com/folders/v2r8vs0btwhr529


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • October 25, 2017

@MarkAtSafe

Any idea ?

 


Forum|alt.badge.img+2
  • October 30, 2017
boubcher wrote:

@Mark

Thanks we fix the problem of the coordinate as you recomanded , but we are still unable to display the polygone on Kibana Dashborad

take a look at the print screens

https://qsnapnet.com/snaps/jb0alvm930kep14

https://qsnapnet.com/snaps/9nwed91dp7ujtt9

All snaps: https://qsnapnet.com/folders/v2r8vs0btwhr529

@boubcher It looks like Kibana does not support geo_shape. I found this request for them to add support. There seems to be several requests for this here and here . You could add your thoughts to one of these discussions.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings