Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Patric_Nordstrom
Employee
Employee

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

Anonymous
Not applicable
Author

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

Patric_Nordstrom
Employee
Employee

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

Anonymous
Not applicable
Author

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

Patric_Nordstrom
Employee
Employee

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

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

did you resolve this issue ?

Patric_Nordstrom
Employee
Employee

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

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?