topic Re: How to add from SDO_Geometry (GIS) data in Oracle? in GeoAnalytics

How to add from SDO_Geometry (GIS) data in Oracle?

Anonymous — Wed, 20 Sep 2017 06:54:24 GMT

How to add from SDO_Geometry (GIS) data in Oracle?

I investigated following link but shape field can not added to QlikSense.

Connect to Database in GeoAnalytics Plus « bi.idevio.com

Re: How to add from SDO_Geometry (GIS) data in Oracle?

Patric_Nordstrom — Wed, 20 Sep 2017 10:31:12 GMT

Hi Ömer,

You need to specify a select statement, and retrieve the shape field as WKT.

Something like this: SELECT NAME, SDO_UTIL.TO_WKTGEOMETRY(GEOM) AS point FROM NEW_TEST;

Oracle - Converting SDO_GEOMETRY to WKT? - Stack Overflow

Thanks,

Patric Nordström

Qlik

Re: How to add from SDO_Geometry (GIS) data in Oracle?

Anonymous — Wed, 20 Sep 2017 11:02:48 GMT

Hi Patric,

Firstly, why can not I add data from db with odbc connection? GeoQlik was doing this.

I tried your sql statement and result is negative. Sql script working in db but QlikSense did not fetch data.

sql: SELECT A.ADINUMARASI, MDSYS.SDO_UTIL.TO_WKTGEOMETRY(A.SHAPE) AS polygon FROM SDEDATA.QMAHALLE A

Re: How to add from SDO_Geometry (GIS) data in Oracle?

Patric_Nordstrom — Wed, 20 Sep 2017 11:10:56 GMT

Hi,

You can fetch the WKT with odbc if you prefer and then do the QGA "Load" from a loaded table instead.

However going directly to the database is probably more effective.

In your case the "Geometry field" is called "polygon" if I read your select statement correctly.

Thanks,

Patric

Re: How to add from SDO_Geometry (GIS) data in Oracle?

Anonymous — Wed, 20 Sep 2017 11:27:34 GMT

I tried to polygon option in geometry field, but result is negative.

Can you send a screen video about this case?

Re: How to add from SDO_Geometry (GIS) data in Oracle?

Patric_Nordstrom — Wed, 20 Sep 2017 11:38:28 GMT

Hi Ömer,

Sorry for being unclear,your geometry field name is "polygon" not "SHAPE".

Thanks,

Patric

Re: How to add from SDO_Geometry (GIS) data in Oracle?

Anonymous — Wed, 20 Sep 2017 11:56:51 GMT

Mr. Nordström,

Result is negative.

Do you have any Geographic Information System Specialist in your company? I would recommend having a GIS specialist staff.

Re: How to add from SDO_Geometry (GIS) data in Oracle?

Anonymous — Mon, 03 Dec 2018 19:41:49 GMT

did you resolve this issue ?

Re: How to add from SDO_Geometry (GIS) data in Oracle?

Patric_Nordstrom — Tue, 04 Dec 2018 07:46:57 GMT

Hi, yes but please note that Oracle outputs WKT in a varchar which is capped to 4000 chrs. Thanks, Patric

Re: How to add from SDO_Geometry (GIS) data in Oracle?

Anonymous — Wed, 05 Dec 2018 18:04:20 GMT

do you have a screenshot of the configuration of the connection with the query to Oracle ?

And what is the disadvantage could have the character limit of Oracle?