Re: How to add from SDO_Geometry (GIS) data in Ora... - Qlik Community

Anonymous · ‎2017-09-20

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

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

Patric_Nordstrom · ‎2017-09-20

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;

Thanks,

Patric Nordström

Qlik

Anonymous · ‎2017-09-20

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

Patric_Nordstrom · ‎2017-09-20

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 · ‎2017-09-20

Hi

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

Can you send a screen video about this case?

Patric_Nordstrom · ‎2017-09-20

Hi Ömer,

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

Thanks,

Patric

Anonymous · ‎2017-09-20

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 · ‎2018-12-03

did you resolve this issue ?

Patric_Nordstrom · ‎2018-12-04

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

Anonymous · ‎2018-12-05

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?