topic Re: How to convert Point Geometry to X Y? in Talend Studio

How to convert Point Geometry to X Y?

Anonymous — Sat, 16 Nov 2024 08:37:55 GMT

Hi,

Our data contains spatial information. The location is of the type Geometry (Point Geometry). Now we want to use this location data to visualize the data in a BI tool. However the BI tool needs the location data in Lattitude Longitude format. How can we convert the Point geometry tot Lat/Long?

We have the Talend Spatial plugin installed, but we can't find this in the documentation for this plugin.

Anyone out there who knows how to do this?

Thnx!

Remco

Re: How to convert Point Geometry to X Y?

manodwhb — Wed, 14 Mar 2018 08:07:19 GMT

what is the type of your source database? for example ,if it is Orcale,convert in source side

Re: How to convert Point Geometry to X Y?

Anonymous — Wed, 14 Mar 2018 08:12:07 GMT

hi,can you please provide me some sample data and desired output?

Re: How to convert Point Geometry to X Y?

manodwhb — Wed, 14 Mar 2018 08:16:41 GMT

please find below links.

https://stackoverflow.com/questions/30908013/how-to-get-lat-and-long-from-sdo-geometry-in-oracle

https://docs.oracle.com/database/121/SPATL/sdo_util-from_gml311geometry.htm#SPATL1231