Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

omerunsal
New Contributor

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

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

scr2.jpg

9 Replies
Employee
Employee

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

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

omerunsal
New Contributor

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

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 Aq2_2.jpg

q2_1.jpgq2.jpg

Employee
Employee

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

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

omerunsal
New Contributor

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

Hi

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

Can you send a screen video about this case?q3.jpgq3_1.jpg

Employee
Employee

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

Hi Ömer,

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

2017-09-20 13_37_48-Qlik Sense Desktop.png

Thanks,

Patric

omerunsal
New Contributor

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

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.

raulfdz_a10
New Contributor

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

did you resolve this issue ?

Employee
Employee

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

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

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

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?

Community Browser